SAP COPA999 Example Structure for Transferring External Data to CO-PA Table data and field list

COPA999 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Example Structure for Transferring External Data to CO-PA" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_COPA999 TYPE COPA999.

The COPA999 table consists of various fields, each holding specific information or linking keys about Example Structure for Transferring External Data to CO-PA data available in SAP. These include BUMON (Number of periods per seasonal cycle), ALTPERIO (Period/year in alternative period type), VRGAR (Record Type), WADAT (Goods Issue Date)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

COPA999 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP COPA999 structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the COPA999 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUMONNumber of periods per seasonal cycle PERIODEC3PERAN
ALTPERIOPeriod/year in alternative period type JAHRPERALTNUMC7PERI7JAHRPER
VRGARRecord Type RKE_VRGARCHAR1Assigned to domainVRGARVGA
WADATGoods Issue Date WADATDATS8DATUM
FADATInvoice date (date created) FADATDATS8DATUM
KNDNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
ARTNRProduct number ARTNRCHAR18Assigned to domainMATN1MATNRMAT
FKARTBilling Type FKARTCHAR4Assigned to domainFKART
FRWAEForeign currency key FRWAECUKY5Assigned to domainWAERS
KURSFExchange rate KURSFDEC9(5) EXCRTKURSF
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
ABSMG_MEBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
ABSMGSales quantity RKE_ABSMGQUAN13(3) MENGV13
ERLOSRevenue RKE_ERLOSCURR13(2) WERTV7
MRABAQuantity discount RKE_MRABACURR13(2) WERTV7
PRABAPrice reduction RKE_PRABACURR13(2) WERTV7
RABATOther discounts RKE_RABATCURR13(2) WERTV7
AUSFROutgoing freight RKE_AUSFRCURR13(2) WERTV7
VSVPDispatch Packaging RKE_VSVPCURR13(2) WERTV7
VRPRSStock Value RKE2_VRPRSCURR15(2) WERTV8
VWGKAdministration Overhead Costs RKE_VWGKCURR13(2) WERTV7
VTRGKSales Overhead Costs RKE_VTRGKCURR13(2) WERTV7

Key field Non-key field



How do I retrieve data from SAP structure COPA999 using ABAP code?

As COPA999 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on COPA999 as there is no data to select.

How to access SAP table COPA999

Within an ECC or HANA version of SAP you can also view further information about COPA999 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).