SAP table ARCU_COIT1 (Residence Times for CO Line Items)

SAP table ARCU_COIT1 has 5 primary key fields being MANDT,OBART,SUBOBART,KOKRS,WRTTP_CAT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
OBART Object Type CHAR 2 0 J_OBART_LD
SUBOBART Sub-Object Type (Order Type) CHAR 10 0 SUBOBART
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
WRTTP_CAT Value Type Categories (All, Plan, All Except Plan) NUMC 1 0 WRTTP_CAT
0 All Value Types
1 Planned
2 All Except Planned
RES_PERIO Residence Periods NUMC 3 0 RES_PERIO
WHOLE_YEAR Indicator: Fiscal Year only Complete CHAR 1 0 WHOLE_YEAR
DONT_ARCH Ind.: "Do Not Archive" CHAR 1 0 DONT_ARCH

ARCU_COIT1 foreign key relationships

Table Field Check Table Check Field
0 ARCU_COIT1 KOKRS TKA01 Controlling Areas MANDT
1 ARCU_COIT1 MANDT T000 Clients MANDT