topic Re: Finding document from COPA table in Application Development and Automation Discussions

Finding document from COPA table

Former Member — Tue, 27 Mar 2007 18:58:42 GMT

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 ?

Re: Finding document from COPA table

Former Member — Tue, 27 Mar 2007 19:16:24 GMT

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

Re: Finding document from COPA table

Former Member — Tue, 27 Mar 2007 19:33:57 GMT

coep/ coej if its account based.

if its cost center based then ce1xxxx_acct / ce2xxxx_acct.

Re: Finding document from COPA table

Former Member — Tue, 27 Mar 2007 20:23:46 GMT

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>

Re: Finding document from COPA table

Former Member — Wed, 28 Mar 2007 09:57:48 GMT

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

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

Re: Finding document from COPA table

Former Member — Wed, 28 Mar 2007 20:48:41 GMT

CE4XXXX_ACCT links to CE4XXXX with

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

Re: Finding document from COPA table

Former Member — Thu, 29 Mar 2007 23:14:05 GMT

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 ?

Re: Finding document from COPA table

Former Member — Fri, 30 Mar 2007 21:59:10 GMT

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.