SAP ACDOCP Plan Data Line Items Table

Overview

ACDOCP is a standard SAP S/4HANA table that stores Plan Data Line Items data. There are total 205 fields in the ACDOCP table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ACDOCP belongs to Planning (CO-OM-CCA-B) module and is located in the package Financial Planning Document (FINS_ACDOC_PLANNING).

In addition, following links provide an overview of foreign key relationships, if any, that link ACDOCP to other SAP tables and standard CDS views available based on ACDOCP table in S/4HANA 2020.

Techincal Settings of ACDOCP

Below are technical details of the table ACDOCP

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ACDOCP Fields

The following table gives you an overview of the fields available in ACDOCP

FieldDescriptionData ElementCheck TableData TypeLength
RCLNTClientMANDTCLNT3
REQTSNRequest Transaction Sequence NumberRSPM_REQUEST_TSNNUMC23
DATAPAKIDData packet numberRSDATAPIDNUMC6
RECORDData record numberRSARECORDINT410
RYEARGeneral Ledger Fiscal YearGJAHR_POSNUMC4
RLDNRLedger in General Ledger AccountingFINS_LEDGERFINSC_LEDGERCHAR2
RACCTAccount NumberRACCTSKA1CHAR10
RBUKRSCompany CodeBUKRST001CHAR4
AWTYPReference procedureAWTYPCHAR5
USNAMUser NameUSNAMCHAR12
CATEGORYPlan CategoryFCOM_CATEGORYFCOMC_CATEGORYCHAR10
KPRICEPrice in Global CurrencyFINS_PLAN_KPRICECURR23
HPRICEPrice in Company Code CurrencyFINS_PLAN_HPRICECURR23
WPRICEPrice in Transaction CurrencyFINS_PLAN_WPRICECURR23
RMVCTTransaction typeRMVCTT856CHAR3
BTTYPEBusiness Transaction TypeFINS_BTTYPEFINSC_BTTYPECHAR4
AWORGReference Organizational UnitsAWORGCHAR10
AWREFReference document numberAWREFCHAR10
RWCURTransaction CurrencyFINS_CURRW*CUKY5
RHCURCompany Code CurrencyFINS_CURRH*CUKY5
RKCURGlobal CurrencyFINS_CURRK*CUKY5
ROCURFreely Defined Currency 1FINS_CURR1*CUKY5
RVCURFreely Defined Currency 2FINS_CURR2*CUKY5
RBCURFreely Defined Currency 3FINS_CURR3*CUKY5
RCCURFreely Defined Currency 4FINS_CURR4*CUKY5
RDCURFreely Defined Currency 5FINS_CURR5*CUKY5
RECURFreely Defined Currency 6FINS_CURR6*CUKY5
RFCURFreely Defined Currency 7FINS_CURR7*CUKY5
RGCURFreely Defined Currency 8FINS_CURR8*CUKY5
RCO_OCURCO Object CurrencyFINS_CO_OCUR*CUKY5
RVUNITUnit of Measure for Valuation QuantityRVUNIT*UNIT3
RRUNITUnit of Measure for Reference QuantityRRUNIT*UNIT3
RCNTRCost CenterKOSTLCSKSCHAR10
PRCTRProfit CenterPRCTRCEPCCHAR10
RFAREAFunctional AreaFKBERTFKBCHAR16
RBUSABusiness AreaGSBERTGSBCHAR4
KOKRSControlling AreaKOKRSTKA01CHAR4
SEGMENTSegment for Segmental ReportingFB_SEGMENTFAGL_SEGMCHAR10
SCNTRSender cost centerSKOSTCSKSCHAR10
PPRCTRPartner Profit CenterPPRCTRCEPCCHAR10
SFAREAPartner Functional AreaSFKBERTFKBCHAR16
SBUSATrading partner's business areaPARGBTGSBCHAR4
RASSCCompany ID of Trading PartnerRASSCT880CHAR6
PSEGMENTPartner Segment for Segmental ReportingFB_PSEGMENTFAGL_SEGMCHAR10
WSLAmount in Transaction CurrencyFINS_VWCUR12CURR23
HSLAmount in Company Code CurrencyFINS_VHCUR12CURR23
KSLAmount in Global CurrencyFINS_VKCUR12CURR23
OSLAmount in Freely Defined Currency 1FINS_VOCUR12CURR23
VSLAmount in Freely Defined Currency 2FINS_VVCUR12CURR23
BSLAmount in Freely Defined Currency 3FINS_VBCUR12CURR23
CSLAmount in Freely Defined Currency 4FINS_VCCUR12CURR23
DSLAmount in Freely Defined Currency 5FINS_VDCUR12CURR23
ESLAmount in Freely Defined Currency 6FINS_VECUR12CURR23
FSLAmount in Freely Defined Currency 7FINS_VFCUR12CURR23
GSLAmount in Freely Defined Currency 8FINS_VGCUR12CURR23
CO_OSLAmount in CO Object CurrencyFINS_VCO_OCUR12CURR23
HFSLFixed Amount in Company Code CurrencyFINS_VHCUR12_FIXCURR23
KFSLFixed Amount in Global CurrencyFINS_VGCUR12_FIXCURR23
VMSLValuation quantityVQUAN1_12QUAN23
RMSLReference quantityRQUAN1_12QUAN23
POPERPosting periodPOPERNUMC3
BUDATPosting Date in the DocumentBUDATDATS8
PERIVFiscal Year VariantPERIV*CHAR2
FISCYEARPERPeriod/YearJAHRPERNUMC7
KTOPLChart of AccountsKTOPLT004CHAR4
SLALITTYPESubledger-Specific Line Item TypeSLALITTYPEFINSTS_SLALITTYNUMC5
KDAUFSales Order NumberKDAUFCHAR10
KDPOSItem number in Sales OrderKDPOSNUMC6
MATNRMaterial NumberMATNRMARACHAR40
WERKSPlantWERKS_DT001WCHAR4
KUNNRCustomer NumberKUNNRKNA1CHAR10
SGTXTItem TextSGTXTCHAR50
CO_BELKZCO Debit/Credit IndicatorFINS_CO_BELKZCHAR1
PS_POSIDWork Breakdown Structure Element (WBS Element)PS_POSIDCHAR24
PS_PSPIDProject definitionPS_PSPIDCHAR24
PERNRPersonnel NumberPERNR_DNUMC8
PBUKRSCompany Code of PartnerPBUKRS*CHAR4
UPRCTROrigin Profit CenterFINS_ORIGIN_PRCTR*CHAR10
ACCASTYObject TypeJ_OBART*CHAR2
LSTARActivity TypeLSTAR*CHAR6
AUFNROrder NumberAUFNR*CHAR12
RSRCEResourceCO_RESSOURCE*CHAR10
PAUFNRPartner order numberPAR_AUFNR*CHAR12
PACCASTYPartner Object TypeCO_POBART*CHAR2
PLSTARPartner activityPAR_LSTAR*CHAR6
PPS_POSIDPartner Work Breakdown Structure ElementFCO_PAR_POSIDCHAR24
PPS_PSPIDPartner ProjectFCO_PAR_PSPIDCHAR24
WORK_ITEM_IDWork Item ID/CPD/PFP_WORKITEM_IDCHAR10
BEMOTAccounting IndicatorBEMOT*CHAR2
PSKNZIs Lot Size IndependentFCO_PSKNZCHAR1
LOSGRLot Size for Product CostingCK_LOSGRQUAN13
LSUNITLot Size Unit of MeasureFCOM_LOT_SIZE_UNIT*UNIT3
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNR*NUMC8
PS_PRJ_PNRProject (internal)PS_INTNR*NUMC8
PPS_PSP_PNRPartner Work Breakdown Structure Element (internal ID)FCO_PAR_PSP_PNR*NUMC8
PPS_PRJ_PNRPartner Project (internal ID)FCO_PAR_PRJ_PNR*NUMC8
ZTEST98765ABCDEFG - ChangeZTEST98765CHAR80
ZDIRECTTest 456ZTEST456CHAR2
FKARTBilling TypeFKARTTVFKCHAR4
VKORGSales OrganizationVKORGTVKOCHAR4
VTWEGDistribution ChannelVTWEGTVTWCHAR2
SPARTDivisionSPARTTSPACHAR2
MATNR_COPAProduct SoldFINS_MATNR_PAMARACHAR40
MATKLProduct Sold GroupFINS_MATKL_PAT023CHAR9
KDGRPCustomer GroupKDGRPT151CHAR2
LAND1Country KeyLAND1_GPT005CHAR3
BRSCHIndustry keyBRSCHT016CHAR4
BZIRKSales DistrictBZIRKT171CHAR6
KUNREBill-to partyKUNREKNA1CHAR10
KUNWEShip-to partyKUNWEKNA1CHAR10
KONZSGroup keyKONZSCHAR10
ACDOC_COPA_EEW_DUMMY_PADummy function in length 1DUMMYCHAR1
VKGRP_PASales groupVKGRPTVKGRCHAR3
MAABC_PAABC IndicatorMAABCTMABCCHAR1
BONUS_PAVolume rebate groupBONUSTVBOCHAR2
VKBUR_PASales officeVKBURTVBURCHAR4
EFORM_PAForm of manufactureRKEG_EFORMT2513CHAR5
GEBIE_PAAreaRKEG_GEBIET2538CHAR4
KMVKBU_PASales officeVKBURTVBURCHAR4
KMVKGR_PASales groupVKGRPTVKGRCHAR3
KMBRND_PABrandRKESKMBRNDT2249NUMC2
CRMELEM_PACRM Marketing ElementRKECRMELEMPRPSNUMC8
KMKDGR_PACustomer GroupKDGRPT151CHAR2
KMLAND_PACountry KeyLAND1_GPT005CHAR3
KMMAKL_PAMaterial GroupMATKLT023CHAR9
KMVTNR_PASales employeeVRTNRNUMC8
WWTES_PATest PartnerRKEG_WWTESCHAR10
KMHI01_PACustomer hierarchy Level 1HIEZU01KNA1CHAR10
KMHI02_PACustomer hierarchy Level 2HIEZU02KNA1CHAR10
KMHI03_PACustomer hierarchy Level 3HIEZU03KNA1CHAR10
CRMCSTY_PACRM Cost ElementRKECRMCSTY*CHAR10
KMATYP_PAAircraft TypeRKESKMATYPT2209NUMC2
KMDEST_PADestinationRKESKMDESTT2211CHAR5
KMFLTN_PAFlight NumberRKESKMFLTNT2215CHAR6
KMFLTY_PAFlight TypeRKESKMFLTYT2216CHAR4
KMIATA_PAIATA SeasonRKESKMIATAT2207CHAR5
KMLEGS_PARoute SegmentRKESKMLEGST2213CHAR7
KMOPDY_PADay of OperationRKESKMOPDYT2208CHAR2
KMORIG_PADeparture LocationRKESKMORIGT2212CHAR5
KMROUT_PARotationRKESKMROUTT2210CHAR5
KMSTGE_PAStrategic Business UnitRKESKMSTGET2247NUMC2
KMWNHG_PAMain Material GroupRKESKMWNHGT2246NUMC2
KMZONE_PAZoneRKESKMZONET2214CHAR5
PAPH1_PAProd.hierarchy01-1RKEG_PAPH1CHAR5
PRODH_PAProduct hierarchyPRODH_DT179CHAR18
WWACT_PAActivityRKEG_WWACTT2500CHAR2
WWERM_PAShipping Point / Receiving PointVSTELTVSTCHAR4
PAPH2_PAProd.hierarchy01-2RKEG_PAPH2CHAR10
PAPH3_PAProd.hierarchy01-3RKEG_PAPH3CHAR18
COLLE_PAFashion CollectionFSH_COLLECTIONFSH_COLLECTIONSCHAR10
CRMFIGR_PACRM Key FigureRKECRMFIGRTKECRMFIGRCHAR16
KMCATG_PABusiness fieldRKESKMCATGT2248NUMC2
KMNIEL_PANielsen IDNIELSTNLSCHAR2
SAISJ_PASeason YearFSH_SAISJCHAR4
SAISO_PASeasonFSH_SAISOFSH_SEASONSCHAR10
ARTNRG_PAGeneric ArticleFSH_ARTNRGMARACHAR40
MATNR_PAMaterial NumberMATNRMARACHAR40
PARTNER_PACO-PA PartnerRKEPARTNERTKEPARTNERCHAR10
REGIO_PARegion (State, Province, County)REGIOT005SCHAR3
WW001_PABRAND ReportingRKEG_WW001T2501CHAR5
WW100_PACountry/Region KeyLAND1T005CHAR3
WW101_PACountry/Region KeyLAND1T005CHAR3
WWBU1_PATest Business UnitRKEG_WWBU1T2508CHAR10
FIKRSFinancial Management AreaFIKRSFM01CHAR4
RFUNDFundBP_GEBERFMFINCODECHAR10
RGRANT_NBRGrantGM_GRANT_NBRGMGRCHAR20
RBUDGET_PDBudget PeriodFM_BUDGET_PERIODFMBUDGETPDCHAR10
BUDGET_PROCESSBudget Process TypeBUDGET_PROCESSBUDGET_D_PROCESSCHAR4
BUDGET_SUBCATEGORYBudget Type (Subcategory)BUDGET_SUBCATEGORYBDGT_D_SUBCATEGCHAR8
ARBIDObject ID of the resourceCR_OBJIDCRIDNUMC8
VORNROperation/Activity NumberVORNRCHAR4
AUFPSOrder item numberCO_POSNRNUMC4
UVORNSuboperationUVORNCHAR4
EQUNREquipment NumberEQUNREQUICHAR18
TPLNRFunctional LocationTPLNRIFLOTCHAR30
ISTRUAssemblyISTRUMARACHAR40
ILARTMaintenance activity typeILAT353ICHAR3
PLKNZMaintenance order planning indicatorAUF_PLKNZCHAR1
ARTPRPriority TypeARTPRT356ACHAR2
PRIOKPriorityPRIOKT356CHAR1
MAUFNRNumber of Superior OrderMAUFNRAUFKCHAR12
MATKL_MMMaterial GroupFINS_MATKL_MMT023CHAR9
PAUFPSPartner Order Item NumberFCO_PAR_AUFPSNUMC4
RSNUMNumber of reservation/dependent requirementsRSNUMRESBNUMC10
RSPOSItem Number of Reservation / Dependent RequirementsRSPOSRESBNUMC4
RSARTRecord typeRSARTRESBCHAR1
PACKNOPackage numberPACKNOESLLNUMC10
INTROWLine NumberNUMZEILEESLLNUMC10
AFABEDepreciation Area Real or DerivedAFABERIFIDEPRAREALDGRNUMC2
ANLN1Main Asset NumberANLN1IFIMASTFIXASSETCHAR12
ANLN2Asset SubnumberANLN2IFIXASSETCHAR4
MOVCATTransaction Type CategoryFAA_MOVCATFAAI_MOVCATCHAR2
ANLKLAsset ClassANLKLIFIASSETCLCHAR8
VNAMEJoint ventureJV_NAMET8JVCHAR6
EGRUPEquity groupJV_EGROUPT8JFCHAR3
RECIDRecovery IndicatorJV_RECINDT8JJCHAR2
PRODPERProduction Month (Date to find period and year)JV_PRODPERDATS8
SWENRBusiness Entity NumberREBDBENOIREBUSENTITYCTCHAR8
SGENRNumber of BuildingREBDBUNOIREBUILDINGCTCHAR8
SGRNRNumber of LandREBDPRNOIREPROPERTYCTCHAR8
SMENRNumber of Rental ObjectREBDRONOIRERENTOBJECTCTCHAR8
RECNNRContract NumberRECNNUMBERIRECONTRACTCTCHAR13
SNKSLService Charge KeyRESCSCKEYIRESETTLUNITCTCHAR4
SEMPSLSettlement UnitRESCSUIDIRESETTLUNITCTCHAR5
DABRZReference date for settlementDABRBEZDATS8

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ACDOCP

Table NameFieldCardinalityCheck Table
ACDOCPACCASTY:*
ACDOCPAFABEC: CNIFIDEPRAREALDGR
ACDOCPANLKLC: CNIFIASSETCL
ACDOCPANLN1C: CNIFIMASTFIXASSET
ACDOCPANLN2C: CNIFIXASSET
ACDOCPARBID:CRID
ACDOCPARTNRG_PAC: CNMARA
ACDOCPARTPRC: CNT356A
ACDOCPAUFNR:*
ACDOCPBEMOTC: CN*
ACDOCPBONUS_PAC: CNTVBO
ACDOCPBRSCHC: CNT016
ACDOCPBTTYPEC: CNFINSC_BTTYPE
ACDOCPBUDGET_PROCESSC: CNBUDGET_D_PROCESS
ACDOCPBUDGET_SUBCATEGORYC: CNBDGT_D_SUBCATEG
ACDOCPBZIRKC: CNT171
ACDOCPCATEGORY:FCOMC_CATEGORY
ACDOCPCOLLE_PAC: CNFSH_COLLECTIONS
ACDOCPCRMELEM_PAC: CNPRPS
ACDOCPCRMFIGR_PAC: CNTKECRMFIGR
ACDOCPEFORM_PAC: CNT2513
ACDOCPEGRUPC: CNT8JF
ACDOCPEQUNRC: CNEQUI
ACDOCPFIKRSC: CNFM01
ACDOCPFKARTC: CNTVFK
ACDOCPGEBIE_PAC: CNT2538
ACDOCPILARTC: CNT353I
ACDOCPINTROWC: CNESLL
ACDOCPISTRUC: CNMARA
ACDOCPKDGRPC: CNT151
ACDOCPKMATYP_PAC: CNT2209
ACDOCPKMBRND_PAC: CNT2249
ACDOCPKMCATG_PAC: CNT2248
ACDOCPKMDEST_PAC: CNT2211
ACDOCPKMFLTN_PAC: CNT2215
ACDOCPKMFLTY_PAC: CNT2216
ACDOCPKMHI01_PAC: CNKNA1
ACDOCPKMHI02_PAC: CNKNA1
ACDOCPKMHI03_PAC: CNKNA1
ACDOCPKMIATA_PAC: CNT2207
ACDOCPKMKDGR_PAC: CNT151
ACDOCPKMLAND_PAC: CNT005
ACDOCPKMLEGS_PAC: CNT2213
ACDOCPKMMAKL_PAC: CNT023
ACDOCPKMNIEL_PAC: CNTNLS
ACDOCPKMOPDY_PAC: CNT2208
ACDOCPKMORIG_PAC: CNT2212
ACDOCPKMROUT_PAC: CNT2210
ACDOCPKMSTGE_PAC: CNT2247
ACDOCPKMVKBU_PAC: CNTVBUR
ACDOCPKMVKGR_PAC: CNTVKGR
ACDOCPKMWNHG_PAC: CNT2246
ACDOCPKMZONE_PAC: CNT2214
ACDOCPKOKRS:TKA01
ACDOCPKTOPLC: CNT004
ACDOCPKUNNR:KNA1
ACDOCPKUNREC: CNKNA1
ACDOCPKUNWEC: CNKNA1
ACDOCPLAND1C: CNT005
ACDOCPLSTAR:*
ACDOCPMAABC_PAC: CNTMABC
ACDOCPMATKLC: CNT023
ACDOCPMATKL_MMC: CNT023
ACDOCPMATNR:MARA
ACDOCPMATNR_COPAC: CNMARA
ACDOCPMATNR_PAC: CNMARA
ACDOCPMAUFNRC: CNAUFK
ACDOCPMOVCATC: CNFAAI_MOVCAT
ACDOCPPACCASTY:*
ACDOCPPACKNOC: CNESLL
ACDOCPPARTNER_PAC: CNTKEPARTNER
ACDOCPPAUFNR:*
ACDOCPPBUKRS:*
ACDOCPPLSTAR:*
ACDOCPPPRCTR:CEPC
ACDOCPPPS_PRJ_PNRC: CN*
ACDOCPPRCTR:CEPC
ACDOCPPRIOKC: CNT356
ACDOCPPRODH_PAC: CNT179
ACDOCPPSEGMENT:FAGL_SEGM
ACDOCPPS_PRJ_PNRC: CN*
ACDOCPRACCT:SKA1
ACDOCPRASSC:T880
ACDOCPRBUDGET_PDC: CNFMBUDGETPD
ACDOCPRBUKRS:T001
ACDOCPRBUSA:TGSB
ACDOCPRCNTR:CSKS
ACDOCPRECIDC: CNT8JJ
ACDOCPRECNNRC: CNIRECONTRACTCT
ACDOCPREGIO_PAC: CNT005S
ACDOCPRFAREA:TFKB
ACDOCPRFUNDC: CNFMFINCODE
ACDOCPRGRANT_NBRC: CNGMGR
ACDOCPRLDNR:FINSC_LEDGER
ACDOCPRMVCT:T856
ACDOCPRSARTC: CNRESB
ACDOCPRSNUMC: CNRESB
ACDOCPRSPOSC: CNRESB
ACDOCPRSRCEC: CN*
ACDOCPSAISO_PAC: CNFSH_SEASONS
ACDOCPSBUSA:TGSB
ACDOCPSCNTR:CSKS
ACDOCPSEGMENT:FAGL_SEGM
ACDOCPSEMPSLC: CNIRESETTLUNITCT
ACDOCPSFAREA:TFKB
ACDOCPSGENRC: CNIREBUILDINGCT
ACDOCPSGRNRC: CNIREPROPERTYCT
ACDOCPSLALITTYPEC: CNFINSTS_SLALITTY
ACDOCPSMENRC: CNIRERENTOBJECTCT
ACDOCPSNKSLC: CNIRESETTLUNITCT
ACDOCPSPARTC: CNTSPA
ACDOCPSWENRC: CNIREBUSENTITYCT
ACDOCPTPLNRC: CNIFLOT
ACDOCPUPRCTRC: CN*
ACDOCPVKBUR_PAC: CNTVBUR
ACDOCPVKGRP_PAC: CNTVKGR
ACDOCPVKORGC: CNTVKO
ACDOCPVNAMEC: CNT8JV
ACDOCPVTWEGC: CNTVTW
ACDOCPWERKS:T001W
ACDOCPWW001_PAC: CNT2501
ACDOCPWW100_PAC: CNT005
ACDOCPWW101_PAC: CNT005
ACDOCPWWACT_PAC: CNT2500
ACDOCPWWBU1_PAC: CNT2508
ACDOCPWWERM_PAC: CNTVST
ACDOCPZZBRAND1:ZTBRAND
ACDOCPZZCHECK1:YTESTV1

Other References