Relationship between BKPF and CE1xxxx tables

• If the field COPA_AWTYP (Reference Transaction) on the table CE1xxxx is equal to “BKPF”:

• The field RBELN (Reference document number for CO-PA line item) refers to “Accounting Document Number” and field COPA_AWORG (Reference Organizational Units) refers to “Company Code” + “Fiscal Year”:

• The fields BUKRS (Company Code), BELNR (Accounting Document Number) and GJAHR (Fiscal Year) are key fields on the table BKPF:

• If the field COPA_AWTYP (Reference Transaction) on the table CE1xxxx is equal to “VBRK”:

• The field RBELN (Reference document number for CO-PA line item) refers to “Billing Document”:

• With the date from VBRK table you can select the date from BKPF table:

PS: the xxxx from table CE11xxxx means “Operating concern”:

( Database Tables for CO-PA Transaction Data – Profitability Analysis (COPA) – SAP Library )