Sunday, May 19, 2024

SAP Table ACDOCP_DATA – Staging Area for Plan data in Internal Format

ACDOCP_DATA is a standard SAP table in SAP ECC (or) S/4HANA which stores Staging Area for Plan data in Internal Format data. There are total 215 fields in ACDOCP_DATA table.This blog post provides key technical details of SAP table ACDOCP_DATA, including its availability across SAP S/4HANA versions and the list of CDS views for ACDOCP_DATA table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Financial Planning Document (FINS_ACDOC_PLANNING)
Technical Component Planning (CO-OM-CCA-B)

SAP ACDOCP_DATA Table Fields

The following is the list of fields that are available in SAP ACDOCP_DATA table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
TRANSACTIONID UUID in X form (binary) SYSUUID_X SYSUUID RAW (16)
DATAPAKID Data packet number RSDATAPID NUM6 NUMC (6)
RECORD Data record number RSARECORD RSNUMRECORD INT4 (10)
RYEAR General Ledger Fiscal Year GJAHR_POS GJAHR NUMC (4)
RLDNR Ledger in General Ledger Accounting FINS_LEDGER FINS_LEDGER CHAR (2)
RACCT Account Number RACCT SAKNR CHAR (10)
RBUKRS Company Code BUKRS BUKRS CHAR (4)
AWTYP Reference procedure AWTYP AWTYP CHAR (5)
USNAM User Name USNAM XUBNAME CHAR (12)
CATEGORY Plan Category FCOM_CATEGORY FCOM_CATEGORY FCOMC_CATEGORY CHAR (10)
KPRICE Price in Global Currency FINS_PLAN_KPRICE WERTV12 CURR (23)
HPRICE Price in Company Code Currency FINS_PLAN_HPRICE WERTV12 CURR (23)
WPRICE Price in Transaction Currency FINS_PLAN_WPRICE WERTV12 CURR (23)
RMVCT Transaction type RMVCT RMVCT T856 CHAR (3)
BTTYPE Business Transaction Type FINS_BTTYPE FINS_BTTYPE FINSC_BTTYPE CHAR (4)
AWORG Reference Organizational Units AWORG AWORG CHAR (10)
AWREF Reference document number AWREF AWREF CHAR (10)
RWCUR Transaction Currency FINS_CURRW WAERS * CUKY (5)
RHCUR Company Code Currency FINS_CURRH WAERS * CUKY (5)
RKCUR Global Currency FINS_CURRK WAERS * CUKY (5)
ROCUR Freely Defined Currency 1 FINS_CURR1 WAERS * CUKY (5)
RVCUR Freely Defined Currency 2 FINS_CURR2 WAERS * CUKY (5)
RBCUR Freely Defined Currency 3 FINS_CURR3 WAERS * CUKY (5)
RCCUR Freely Defined Currency 4 FINS_CURR4 WAERS * CUKY (5)
RDCUR Freely Defined Currency 5 FINS_CURR5 WAERS * CUKY (5)
RECUR Freely Defined Currency 6 FINS_CURR6 WAERS * CUKY (5)
RFCUR Freely Defined Currency 7 FINS_CURR7 WAERS * CUKY (5)
RGCUR Freely Defined Currency 8 FINS_CURR8 WAERS * CUKY (5)
RCO_OCUR CO Object Currency FINS_CO_OCUR WAERS * CUKY (5)
RVUNIT Unit of Measure for Valuation Quantity RVUNIT MEINS * UNIT (3)
RRUNIT Unit of Measure for Reference Quantity RRUNIT MEINS * UNIT (3)
RCNTR Cost Center KOSTL KOSTL CSKS CHAR (10)
PRCTR Profit Center PRCTR PRCTR CEPC CHAR (10)
RFAREA Functional Area FKBER FKBER TFKB CHAR (16)
RBUSA Business Area GSBER GSBER TGSB CHAR (4)
KOKRS Controlling Area KOKRS CACCD TKA01 CHAR (4)
SEGMENT Segment for Segmental Reporting FB_SEGMENT FB_SEGMENT FAGL_SEGM CHAR (10)
SCNTR Sender cost center SKOST KOSTL CSKS CHAR (10)
PPRCTR Partner Profit Center PPRCTR PRCTR CEPC CHAR (10)
SFAREA Partner Functional Area SFKBER FKBER TFKB CHAR (16)
SBUSA Trading partner’s business area PARGB GSBER TGSB CHAR (4)
RASSC Company ID of Trading Partner RASSC RCOMP T880 CHAR (6)
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT FB_SEGMENT FAGL_SEGM CHAR (10)
WSL Amount in Transaction Currency FINS_VWCUR12 WERTV12 CURR (23)
HSL Amount in Company Code Currency FINS_VHCUR12 WERTV12 CURR (23)
KSL Amount in Global Currency FINS_VKCUR12 WERTV12 CURR (23)
OSL Amount in Freely Defined Currency 1 FINS_VOCUR12 WERTV12 CURR (23)
VSL Amount in Freely Defined Currency 2 FINS_VVCUR12 WERTV12 CURR (23)
BSL Amount in Freely Defined Currency 3 FINS_VBCUR12 WERTV12 CURR (23)
CSL Amount in Freely Defined Currency 4 FINS_VCCUR12 WERTV12 CURR (23)
DSL Amount in Freely Defined Currency 5 FINS_VDCUR12 WERTV12 CURR (23)
ESL Amount in Freely Defined Currency 6 FINS_VECUR12 WERTV12 CURR (23)
FSL Amount in Freely Defined Currency 7 FINS_VFCUR12 WERTV12 CURR (23)
GSL Amount in Freely Defined Currency 8 FINS_VGCUR12 WERTV12 CURR (23)
CO_OSL Amount in CO Object Currency FINS_VCO_OCUR12 WERTV12 CURR (23)
HFSL Fixed Amount in Company Code Currency FINS_VHCUR12_FIX WERTV12 CURR (23)
KFSL Fixed Amount in Global Currency FINS_VGCUR12_FIX WERTV12 CURR (23)
VMSL Valuation quantity VQUAN1_12 MENGV12 QUAN (23)
RMSL Reference quantity RQUAN1_12 MENGV12 QUAN (23)
POPER Posting period POPER POPER NUMC (3)
BUDAT Posting Date in the Document BUDAT DATUM DATS (8)
PERIV Fiscal Year Variant PERIV PERIV * CHAR (2)
FISCYEARPER Period/Year JAHRPER JAHRPER NUMC (7)
KTOPL Chart of Accounts KTOPL KTOPL T004 CHAR (4)
SLALITTYPE Subledger-Specific Line Item Type SLALITTYPE SLALITTYPE FINSTS_SLALITTY NUMC (5)
KDAUF Sales Order Number KDAUF VBELN CHAR (10)
KDPOS Item number in Sales Order KDPOS NUM06 NUMC (6)
MATNR Material Number MATNR MATNR MARA CHAR (40)
WERKS Plant WERKS_D WERKS T001W CHAR (4)
KUNNR Customer Number KUNNR KUNNR KNA1 CHAR (10)
SGTXT Item Text SGTXT TEXT50 CHAR (50)
CO_BELKZ CO Debit/Credit Indicator FINS_CO_BELKZ FINS_CO_BELKZ CHAR (1)
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID PS_POSID CHAR (24)
PS_PSPID Project definition PS_PSPID PS_PSPID CHAR (24)
PERNR Personnel Number PERNR_D PERNR NUMC (8)
PBUKRS Company Code of Partner PBUKRS BUKRS * CHAR (4)
UPRCTR Origin Profit Center FINS_ORIGIN_PRCTR PRCTR * CHAR (10)
ACCASTY Object Type J_OBART J_OBART * CHAR (2)
LSTAR Activity Type LSTAR LSTAR * CHAR (6)
AUFNR Order Number AUFNR AUFNR * CHAR (12)
RSRCE Resource CO_RESSOURCE CO_RESSOURCE * CHAR (10)
PAUFNR Partner order number PAR_AUFNR AUFNR * CHAR (12)
PACCASTY Partner Object Type CO_POBART J_OBART * CHAR (2)
PLSTAR Partner activity PAR_LSTAR LSTAR * CHAR (6)
PPS_POSID Partner Work Breakdown Structure Element FCO_PAR_POSID PS_POSID CHAR (24)
PPS_PSPID Partner Project FCO_PAR_PSPID PS_PSPID CHAR (24)
WORK_ITEM_ID Work Item ID /CPD/PFP_WORKITEM_ID /CPD/PFP_WORKITEM_ID CHAR (10)
BEMOT Accounting Indicator BEMOT BEMOT * CHAR (2)
PSKNZ Is Lot Size Independent FCO_PSKNZ XFELD CHAR (1)
LOSGR Lot Size for Product Costing CK_LOSGR MENG13 QUAN (13)
LSUNIT Lot Size Unit of Measure FCOM_LOT_SIZE_UNIT MEINS * UNIT (3)
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PS_POSNR * NUMC (8)
PS_PRJ_PNR Project (internal) PS_INTNR PS_PSPNR * NUMC (8)
PPS_PSP_PNR Partner Work Breakdown Structure Element (internal ID) FCO_PAR_PSP_PNR PS_POSNR * NUMC (8)
PPS_PRJ_PNR Partner Project (internal ID) FCO_PAR_PRJ_PNR PS_PSPNR * NUMC (8)
FKART Billing Type FKART FKART TVFK CHAR (4)
VKORG Sales Organization VKORG VKORG TVKO CHAR (4)
VTWEG Distribution Channel VTWEG VTWEG TVTW CHAR (2)
SPART Division SPART SPART TSPA CHAR (2)
MATNR_COPA Product Sold FINS_MATNR_PA MATNR MARA CHAR (40)
MATKL Product Sold Group FINS_MATKL_PA MATKL T023 CHAR (9)
KDGRP Customer Group KDGRP KDGRP T151 CHAR (2)
LAND1 Country Key LAND1_GP LAND1 T005 CHAR (3)
BRSCH Industry key BRSCH BRSCH T016 CHAR (4)
BZIRK Sales District BZIRK BZIRK T171 CHAR (6)
KUNRE Bill-to party KUNRE KUNNR KNA1 CHAR (10)
KUNWE Ship-to party KUNWE KUNNR KNA1 CHAR (10)
KONZS Group key KONZS KONZS CHAR (10)
ACDOC_COPA_EEW_DUMMY_PA Dummy function in length 1 DUMMY DUMMY CHAR (1)
VKGRP_PA Sales group VKGRP VKGRP TVKGR CHAR (3)
MAABC_PA ABC Indicator MAABC MAABC TMABC CHAR (1)
BONUS_PA Volume rebate group BONUS BONUS TVBO CHAR (2)
VKBUR_PA Sales office VKBUR VKBUR TVBUR CHAR (4)
EFORM_PA Form of manufacture RKEG_EFORM RKEG_EFORM T2513 CHAR (5)
GEBIE_PA Area RKEG_GEBIE RKEG_GEBIE T2538 CHAR (4)
KMVKBU_PA Sales office VKBUR VKBUR TVBUR CHAR (4)
KMVKGR_PA Sales group VKGRP VKGRP TVKGR CHAR (3)
KMBRND_PA Brand RKESKMBRND RKESKMBRND T2249 NUMC (2)
CRMELEM_PA CRM Marketing Element RKECRMELEM PS_POSNR PRPS NUMC (8)
KMKDGR_PA Customer Group KDGRP KDGRP T151 CHAR (2)
KMLAND_PA Country Key LAND1_GP LAND1 T005 CHAR (3)
KMMAKL_PA Material Group MATKL MATKL T023 CHAR (9)
KMVTNR_PA Sales employee VRTNR PERNR NUMC (8)
WWTES_PA Test Partner RKEG_WWTES CHAR10 CHAR (10)
KMHI01_PA Customer hierarchy Level 1 HIEZU01 KUNNR KNA1 CHAR (10)
KMHI02_PA Customer hierarchy Level 2 HIEZU02 KUNNR KNA1 CHAR (10)
KMHI03_PA Customer hierarchy Level 3 HIEZU03 KUNNR KNA1 CHAR (10)
CRMCSTY_PA CRM Cost Element RKECRMCSTY KSTAR * CHAR (10)
KMATYP_PA Aircraft Type RKESKMATYP RKESKMATYP T2209 NUMC (2)
KMDEST_PA Destination RKESKMDEST RKESKMDEST T2211 CHAR (5)
KMFLTN_PA Flight Number RKESKMFLTN RKESKMFLTN T2215 CHAR (6)
KMFLTY_PA Flight Type RKESKMFLTY RKESKMFLTY T2216 CHAR (4)
KMIATA_PA IATA Season RKESKMIATA RKESKMIATA T2207 CHAR (5)
KMLEGS_PA Route Segment RKESKMLEGS RKESKMLEGS T2213 CHAR (7)
KMOPDY_PA Day of Operation RKESKMOPDY RKESKMOPDY T2208 CHAR (2)
KMORIG_PA Departure Location RKESKMORIG RKESKMORIG T2212 CHAR (5)
KMROUT_PA Rotation RKESKMROUT RKESKMROUT T2210 CHAR (5)
KMSTGE_PA Strategic Business Unit RKESKMSTGE RKESKMSTGE T2247 NUMC (2)
KMWNHG_PA Main Material Group RKESKMWNHG RKESKMWNHG T2246 NUMC (2)
KMZONE_PA Zone RKESKMZONE RKESKMZONE T2214 CHAR (5)
PAPH1_PA Prod.hierarchy01-1 RKEG_PAPH1 RKEG_PAPH1 CHAR (5)
PRODH_PA Product hierarchy PRODH_D PRODH T179 CHAR (18)
WWACT_PA Activity RKEG_WWACT RKEG_WWACT T2500 CHAR (2)
WWERM_PA Shipping Point / Receiving Point VSTEL VSTEL TVST CHAR (4)
PAPH2_PA Prod.hierarchy01-2 RKEG_PAPH2 RKEG_PAPH2 CHAR (10)
PAPH3_PA Prod.hierarchy01-3 RKEG_PAPH3 RKEG_PAPH3 CHAR (18)
COLLE_PA Fashion Collection FSH_COLLECTION FSH_COLLECTION FSH_COLLECTIONS CHAR (10)
CRMFIGR_PA CRM Key Figure RKECRMFIGR RKECRMFIGR TKECRMFIGR CHAR (16)
KMCATG_PA Business field RKESKMCATG RKESKMCATG T2248 NUMC (2)
KMNIEL_PA Nielsen ID NIELS NIELS TNLS CHAR (2)
SAISJ_PA Season Year FSH_SAISJ FSH_CJAHR CHAR (4)
SAISO_PA Season FSH_SAISO RFM_SAISO FSH_SEASONS CHAR (10)
ARTNRG_PA Generic Article FSH_ARTNRG MATNR MARA CHAR (40)
MATNR_PA Material Number MATNR MATNR MARA CHAR (40)
PARTNER_PA CO-PA Partner RKEPARTNER RKEPARTNER TKEPARTNER CHAR (10)
REGIO_PA Region (State, Province, County) REGIO REGIO T005S CHAR (3)
WW001_PA BRAND Reporting RKEG_WW001 RKEG_WW001 T2501 CHAR (5)
WW100_PA Country/Region Key LAND1 LAND1 T005 CHAR (3)
WW101_PA Country/Region Key LAND1 LAND1 T005 CHAR (3)
WWBU1_PA Test Business Unit RKEG_WWBU1 RKEG_WWBU1 T2508 CHAR (10)
FIKRS Financial Management Area FIKRS FIKRS FM01 CHAR (4)
RFUND Fund BP_GEBER BP_GEBER FMFINCODE CHAR (10)
RGRANT_NBR Grant GM_GRANT_NBR GM_GRANT_NBR GMGR CHAR (20)
RBUDGET_PD Budget Period FM_BUDGET_PERIOD FM_BUDGET_PERIOD FMBUDGETPD CHAR (10)
BUDGET_PROCESS Budget Process Type BUDGET_PROCESS BUDGET_PROCESS BUDGET_D_PROCESS CHAR (4)
BUDGET_SUBCATEGORY Budget Type (Subcategory) BUDGET_SUBCATEGORY BUDGET_SUBCATEGORY BDGT_D_SUBCATEG CHAR (8)
ARBID Object ID of the resource CR_OBJID CR_OBJID CRID NUMC (8)
VORNR Operation/Activity Number VORNR VORNR CHAR (4)
AUFPS Order item number CO_POSNR CO_POSNR NUMC (4)
UVORN Suboperation UVORN VORNR CHAR (4)
EQUNR Equipment Number EQUNR EQUNR EQUI CHAR (18)
TPLNR Functional Location TPLNR TPLNR IFLOT CHAR (30)
ISTRU Assembly ISTRU MATNR MARA CHAR (40)
ILART Maintenance activity type ILA ILART T353I CHAR (3)
PLKNZ Maintenance order planning indicator AUF_PLKNZ AUF_PLKNZ CHAR (1)
ARTPR Priority Type ARTPR ARTPR T356A CHAR (2)
PRIOK Priority PRIOK PRIOK T356 CHAR (1)
MAUFNR Number of Superior Order MAUFNR AUFNR AUFK CHAR (12)
MATKL_MM Material Group FINS_MATKL_MM MATKL T023 CHAR (9)
PAUFPS Partner Order Item Number FCO_PAR_AUFPS CO_POSNR NUMC (4)
RSNUM Number of reservation/dependent requirements RSNUM RSNUM RESB NUMC (10)
RSPOS Item Number of Reservation / Dependent Requirements RSPOS RSPOS RESB NUMC (4)
RSART Record type RSART RSART RESB CHAR (1)
PACKNO Package number PACKNO PACKNO ESLL NUMC (10)
INTROW Line Number NUMZEILE INTROW ESLL NUMC (10)
AFABE Depreciation Area Real or Derived AFABER AFABE IFIDEPRAREALDGR NUMC (2)
ANLN1 Main Asset Number ANLN1 ANLN1 IFIMASTFIXASSET CHAR (12)
ANLN2 Asset Subnumber ANLN2 ANLN2 IFIXASSET CHAR (4)
MOVCAT Transaction Type Category FAA_MOVCAT FAA_MOVCAT FAAI_MOVCAT CHAR (2)
ANLKL Asset Class ANLKL ANLKL IFIASSETCL CHAR (8)
STAGR Statistical key figure STAGR STAGR TKA03 CHAR (6)
MSL Quantity QUAN1_12 MENGV12 QUAN (23)
RUNIT Statistical Key Figure Quantity Unit FIS_SEINH MEINS * UNIT (3)
OBJNR Controlling Object FIS_OBJNR J_OBJNR ONR00 CHAR (22)
SCOPE Object Class SCOPE_CV SCOPE_CV CHAR (2)
AUTYP Order category AUFTYP AUFTYP NUMC (2)
NPLNR Network Number for Account Assignment NPLNR AUFNR AUFK CHAR (12)
NPLNR_VORGN Network activity NPVRG VORNR CHAR (4)
KSTRG Cost Object KSTRG KSTRG CKPH CHAR (12)
CREATED_AT Created at FINS_PLAN_CREATED_AT TZNTSTMPS DEC (15)
ACTIVITY_UNIT Activity Unit FCO_ACTIVITY_UNIT MEINS * UNIT (3)
WFPRICE Fixed Price in Transaction Currency FINS_PLAN_WFPRICE WERTV12 CURR (23)
WVPRICE Variable Price in Transaction Currency FINS_PLAN_WVPRICE WERTV12 CURR (23)
VNAME Joint venture JV_NAME JV_NAME T8JV CHAR (6)
EGRUP Equity group JV_EGROUP JV_EGROUP T8JF CHAR (3)
RECID Recovery Indicator JV_RECIND JV_RECIND T8JJ CHAR (2)
PRODPER Production Month (Date to find period and year) JV_PRODPER JV_PRODPER DATS (8)
SWENR Business Entity Number REBDBENO REBDBENO IREBUSENTITYCT CHAR (8)
SGENR Number of Building REBDBUNO REBDBUNO IREBUILDINGCT CHAR (8)
SGRNR Number of Land REBDPRNO REBDPRNO IREPROPERTYCT CHAR (8)
SMENR Number of Rental Object REBDRONO REBDRONO IRERENTOBJECTCT CHAR (8)
RECNNR Contract Number RECNNUMBER RECNNUMBER IRECONTRACTCT CHAR (13)
SNKSL Service Charge Key RESCSCKEY RESCSCKEY IRESETTLUNITCT CHAR (4)
SEMPSL Settlement Unit RESCSUID RESCSUID IRESETTLUNITCT CHAR (5)
DABRZ Reference date for settlement DABRBEZ DDAT DATS (8)

Availability

The SAP table ACDOCP_DATA is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ACDOCP_DATA table

The following is the list of ACDOCP_DATA CDS views, which can also be used instead of ACDOCP_DATA table based on your business requirements.

CDS View CDS View Type Description
A_FINPLANITEMSTAGINGAREA BASIC Financial Planning Item Staging Area
I_FINPLANNINGUPLOADITEM BASIC Financial Planning upload Items
C_FINPLANCOSTRATESTAGINGAREA CONSUMPTION Financial Plan Cost Rate Staging Area
C_FINPLANNINGUPLOADITEM CONSUMPTION C-View for basic view I_FinPlanningUploadItem
E_FINPLANITEMSTAGINGAREA EXTENSION Include view for Financial Planning Item Staging Area
E_FINPLANNINGUPLOADITEM EXTENSION Extension view for I_FinPlanningUploadItem