Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Finding document from COPA table

Former Member
0 Likes
7,822

Hi,

I get CO-PA related data through an interface. This data is posted by using BAPI_ACC_DOCUMENT_POST.

When i checked, the table CE4XXXX_ACCT (where XXXX = operating concern) is getting updated with the COPA data. But, from this table i can't see any data refering to the document header.

My question is if we know the COPA record in CE4XXXX_ACCT table, how to identify to which document actually this is related ?

7 REPLIES 7
Read only

Former Member
0 Likes
3,179

check COBK header and COEJ or COEP for line items based on objnr.

Read only

Former Member
0 Likes
3,179

coep/ coej if its account based.

if its cost center based then ce1xxxx_acct / ce2xxxx_acct.

Read only

0 Likes
3,179

I couldn't see any reference to document header details from those tables. Let me make my question clear.

If we know a record in table CE4XXXX_ACCT, is it possible to tell ' <b>To which document (document number or some header detials) does this COPA record belong?'</b>

Read only

Former Member
0 Likes
3,179

ce4****_acct-paobjnr will link to coep-paobjnr

coep-belnr -> cobk-belnr for an operating concern as this might be account based.

Read only

Former Member
0 Likes
3,179

CE4XXXX_ACCT links to CE4XXXX with

CE4XXXX_ACCT - CE4KEY = CE4XXXX-PAOBJNR as _ACCT is for external account assignment.

Read only

0 Likes
3,179

hi,

When i post an Acc Document (along with COPA data) in FI, the document no is updated in BKPF-belnr and BSEG-belnr table fields. And the COPA data is updated in CE4xxxx_ACCT table. But, i dont get any data in any CE4* and CE1* tables.

So there is no question of getting the doc no into COEP-belnr table field !

Any clue how to know the FI document number if we know a record in CE4xxxx_ACCT table ?

Read only

Former Member
0 Likes
3,179

best would be run ke24(actual data) transaction and see if the operating concern is set for account or cost based. Run the report to see if u can check for the data posted in ce4XXXX_acct. In the report select the line and go for FI DETAILS and u can see all the FI, CO and PA documents.

and by the way coep and ce1XXXX are 2 different tables containing details of the operating concern(how it is set) based on account or cost. so u will not see the same document in both the tables.

ce4XXXX_act will have a field which links to ce4xxxx and ce4xxxx will link to ce1xxxx. ce4xxxx_Acct will not directly link to ce1xxxx. If you are not able to link be objnr then check for timestamp and try to link with it.

Hope this helps.