ACDOCC table in SAP ERP (or) S/4HANA stores Consolidation Journal data. There are total 160 fields in ACDOCC table.This blog post provides key technical details of SAP ACDOCC table, including its availability across SAP S/4HANA versions and the list of CDS views for ACDOCC table in SAP.
SAP HANA Table Type | Column Store |
---|---|
Buffering Permission | Buffering not allowed |
Buffering Type | No buffering |
Package | Real-Time Consolidation: Common Reusable Objects (FINS_RTC_COMM) |
Technical Component | Real-Time Consolidation (FIN-RTC) |
SAP ACDOCC Table Fields
Following is the list of fields that are available in SAP ACDOCC table. The primary key fields of the table are RCLNT (Client), MODEL (Model), RYEAR (Fiscal year), BELNR (Accounting Document Number), DOCLN (Line Item).
Field | Description | Data Element | Check Table | Data Type |
---|---|---|---|---|
RCLNT | Client | MANDT | CLNT (3) | |
MODEL | Model | RTC_CON_MODEL | CHAR (6) | |
RYEAR | Fiscal year | RYEAR | NUMC (4) | |
BELNR | Accounting Document Number | BELNR_D | CHAR (10) | |
DOCLN | Line Item | RTC_DOCLN10 | INT4 (10) | |
DELFLG | Transaction marked for deletion? | RTC_DEL_FLAG | CHAR (1) | |
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
USNAM | User Name | USNAM | CHAR (12) | |
RLDNR | Real-Time Consolidation Ledger | RTC_RLDNR | CHAR (2) | |
MODEL_VER | Model Version Number | RTC_VERN | CHAR (6) | |
VERID | Version ID | RTC_VERID | CHAR (5) | |
RBUKRS | Company Code | BUKRS | CHAR (4) | |
PBUKRS | Company Code of Partner | PBUKRS | * | CHAR (4) |
RCOMP | Company | RCOMP_D | * | CHAR (6) |
RVERS | Variant | RTC_RVERS | * | CHAR (3) |
BPC_CATG | Plan Category | FCOM_CATEGORY | * | CHAR (10) |
RTC_CATG | Real-Time Consolidation Data Category | RTC_DCAT | CHAR (10) | |
KTOPL | Group Chart of Accounts | RTC_KKTPL | * | CHAR (4) |
RACCT | Group Account Number | BILKT | * | CHAR (10) |
PR_UUID | Data Submit Request UUID | RTC_PR_UUID | RAW (16) | |
PKOKRS | Partner Controlling Area | RTC_PKOKRS | * | CHAR (4) |
PLEVL | Real-Time Consolidation Posting Level | RTC_PLEVEL | CHAR (2) | |
RCNTR | Cost Center | KOSTL | CSKS | CHAR (10) |
PRCTR | Profit Center | PRCTR | CEPC | CHAR (10) |
RFAREA | Functional Area | FKBER | TFKB | CHAR (16) |
RBUSA | Business Area | GSBER | TGSB | CHAR (4) |
KOKRS | Controlling Area | KOKRS | TKA01 | CHAR (4) |
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | FAGL_SEGM | CHAR (10) |
SCNTR | Sender cost center | SKOST | CSKS | CHAR (10) |
PPRCTR | Partner Profit Center | PPRCTR | CEPC | CHAR (10) |
SFAREA | Partner Functional Area | SFKBER | TFKB | CHAR (16) |
SBUSA | Trading partner’s business area | PARGB | TGSB | CHAR (4) |
RASSC | Company ID of Trading Partner | RASSC | T880 | CHAR (6) |
PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | FAGL_SEGM | CHAR (10) |
RMVCT | Transaction type | RMVCT | T856 | CHAR (3) |
AUDIT_TRA | Audit Trail | RTC_AUDIT_TRAIL | CHAR (20) | |
BTTYPE | Business Transaction Type | RTC_BTTYPE | CHAR (4) | |
DOCAUTO | Line Item: Automatic Posting | RTC_DOCAUTO | NUMC (1) | |
REF_BELNR | Reference Accounting Document Number | RTC_REF_BELNR | CHAR (10) | |
REF_DOCLN | Reference Line Item | RTC_REF_DOCLN | INT4 (10) | |
RWCUR | Transaction Currency | FINS_CURRW | * | CUKY (5) |
RHCUR | Company Code Currency | FINS_CURRH | * | CUKY (5) |
RKCUR | Global Currency | FINS_CURRK | * | CUKY (5) |
RCO_OCUR | CO Object Currency | FINS_CO_OCUR | * | CUKY (5) |
CONS_CUR | Group Currency | RTC_CURR | * | CUKY (5) |
RUNIT | Base Unit of Measure | MEINS | T006 | UNIT (3) |
RVUNIT | Unit of Measure for Valuation Quantity | RVUNIT | T006 | UNIT (3) |
RRUNIT | Unit of Measure for Reference Quantity | RRUNIT | T006 | UNIT (3) |
RMSL_TYPE | Quantity Type Code of the Reference Quantity | FINS_RMSL_QTY_TYPE_CODE | CHAR (1) | |
RIUNIT | Unit of Measure for Inventory Quantity | FINS_RIUNIT | T006 | UNIT (3) |
QUNIT1 | Additional Unit of Measure 1 | FCO_QUNIT1 | T006 | UNIT (3) |
QUNIT2 | Additional Unit of Measure 2 | FCO_QUNIT2 | T006 | UNIT (3) |
QUNIT3 | Additional Unit of Measure 3 | FCO_QUNIT3 | T006 | UNIT (3) |
CO_MEINH | Unit of Measure for CO Valuation Quantity | FCO_MEINH | * | UNIT (3) |
WSL | Amount in Transaction Currency | FINS_VWCUR12 | CURR (23) | |
HSL | Amount in Company Code Currency | FINS_VHCUR12 | CURR (23) | |
KSL | Amount in Global Currency | FINS_VKCUR12 | CURR (23) | |
CONS_SL | Amount in Group Currency | RTC_CUR_AMT | CURR (23) | |
MSL | Quantity | QUAN1_12 | QUAN (23) | |
MFSL | Fixed quantity | QUAN1_12_FIX | QUAN (23) | |
VMSL | Valuation quantity | VQUAN1_12 | QUAN (23) | |
VMFSL | Fixed valuation quantity | VQUAN1_12_FIX | QUAN (23) | |
RMSL | Reference quantity | RQUAN1_12 | QUAN (23) | |
QUANT1 | Additional Quantity 1 | FCO_QUAN1_L | QUAN (23) | |
QUANT2 | Additional Quantity 2 | FCO_QUAN2_L | QUAN (23) | |
QUANT3 | Additional Quantity 3 | FCO_QUAN3_L | QUAN (23) | |
DRCRK | Debit/Credit Indicator | SHKZG | CHAR (1) | |
POPER | Posting period | POPER | NUMC (3) | |
PERIV | Fiscal Year Variant | PERIV | * | CHAR (2) |
FISCYEARPER | Period/Year | JAHRPER | NUMC (7) | |
BUDAT | Posting Date in the Document | BUDAT | DATS (8) | |
BLDAT | Document Date in Document | BLDAT | DATS (8) | |
BLART | Consolidation Document Type | RTC_BLART | CHAR (2) | |
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) | |
BSCHL | Posting Key | BSCHL | * | CHAR (2) |
BSTAT | Document Status | RTC_BSTAT | CHAR (1) | |
GLACCOUNT_TYPE | Type of a General Ledger Account | GLACCOUNT_TYPE | CHAR (1) | |
MATNR | Material Number | MATNR | CHAR (40) | |
WERKS | Plant | WERKS_D | CHAR (4) | |
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
KUNNR | Customer Number | KUNNR | CHAR (10) | |
MWSKZ | Tax on sales/purchases code | MWSKZ | * | CHAR (2) |
ANLN1 | Main Asset Number | ANLN1 | * | CHAR (12) |
ANLN2 | Asset Subnumber | ANLN2 | * | CHAR (4) |
ANBWA | Asset Transaction Type | ANBWA | * | CHAR (3) |
MOVCAT | Transaction Type Category | FAA_MOVCAT | FAAI_MOVCAT | CHAR (2) |
ANLGR | Group Asset | ANLGR | * | CHAR (12) |
ANLGR2 | Subnumber of Group Asset | ANLGR2 | * | CHAR (4) |
SETTLEMENT_RULE | Distribution Rule Group | BUREG | NUMC (3) | |
PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR (24) | |
PS_PSPID | Project definition | PS_PSPID | CHAR (24) | |
FKART | Billing Type | FKART | TVFK | CHAR (4) |
VKORG | Sales Organization | VKORG | TVKO | CHAR (4) |
VTWEG | Distribution Channel | VTWEG | TVTW | CHAR (2) |
SPART | Division | SPART | TSPA | CHAR (2) |
MATNR_COPA | Product Sold | FINS_MATNR_PA | MARA | CHAR (40) |
MATKL | Product Sold Group | FINS_MATKL_PA | T023 | CHAR (9) |
KDGRP | Customer Group | KDGRP | T151 | CHAR (2) |
LAND1 | Country Key | LAND1_GP | T005 | CHAR (3) |
BRSCH | Industry key | BRSCH | T016 | CHAR (4) |
BZIRK | Sales District | BZIRK | T171 | CHAR (6) |
KUNRE | Bill-to party | KUNRE | KNA1 | CHAR (10) |
KUNWE | Ship-to party | KUNWE | KNA1 | CHAR (10) |
KONZS | Group key | KONZS | CHAR (10) | |
ACDOC_COPA_EEW_DUMMY_PA | Dummy function in length 1 | DUMMY | CHAR (1) | |
VKGRP_PA | Sales group | VKGRP | TVKGR | CHAR (3) |
MAABC_PA | ABC Indicator | MAABC | TMABC | CHAR (1) |
BONUS_PA | Volume rebate group | BONUS | TVBO | CHAR (2) |
VKBUR_PA | Sales office | VKBUR | TVBUR | CHAR (4) |
EFORM_PA | Form of manufacture | RKEG_EFORM | T2513 | CHAR (5) |
GEBIE_PA | Area | RKEG_GEBIE | T2538 | CHAR (4) |
KMVKBU_PA | Sales office | VKBUR | TVBUR | CHAR (4) |
KMVKGR_PA | Sales group | VKGRP | TVKGR | CHAR (3) |
KMBRND_PA | Brand | RKESKMBRND | T2249 | NUMC (2) |
CRMELEM_PA | CRM Marketing Element | RKECRMELEM | PRPS | NUMC (8) |
KMKDGR_PA | Customer Group | KDGRP | T151 | CHAR (2) |
KMLAND_PA | Country Key | LAND1_GP | T005 | CHAR (3) |
KMMAKL_PA | Material Group | MATKL | T023 | CHAR (9) |
KMVTNR_PA | Sales employee | VRTNR | NUMC (8) | |
WWTES_PA | Test Partner | RKEG_WWTES | CHAR (10) | |
KMHI01_PA | Customer hierarchy Level 1 | HIEZU01 | KNA1 | CHAR (10) |
KMHI02_PA | Customer hierarchy Level 2 | HIEZU02 | KNA1 | CHAR (10) |
KMHI03_PA | Customer hierarchy Level 3 | HIEZU03 | KNA1 | CHAR (10) |
CRMCSTY_PA | CRM Cost Element | RKECRMCSTY | * | CHAR (10) |
KMATYP_PA | Aircraft Type | RKESKMATYP | T2209 | NUMC (2) |
KMDEST_PA | Destination | RKESKMDEST | T2211 | CHAR (5) |
KMFLTN_PA | Flight Number | RKESKMFLTN | T2215 | CHAR (6) |
KMFLTY_PA | Flight Type | RKESKMFLTY | T2216 | CHAR (4) |
KMIATA_PA | IATA Season | RKESKMIATA | T2207 | CHAR (5) |
KMLEGS_PA | Route Segment | RKESKMLEGS | T2213 | CHAR (7) |
KMOPDY_PA | Day of Operation | RKESKMOPDY | T2208 | CHAR (2) |
KMORIG_PA | Departure Location | RKESKMORIG | T2212 | CHAR (5) |
KMROUT_PA | Rotation | RKESKMROUT | T2210 | CHAR (5) |
KMSTGE_PA | Strategic Business Unit | RKESKMSTGE | T2247 | NUMC (2) |
KMWNHG_PA | Main Material Group | RKESKMWNHG | T2246 | NUMC (2) |
KMZONE_PA | Zone | RKESKMZONE | T2214 | CHAR (5) |
PAPH1_PA | Prod.hierarchy01-1 | RKEG_PAPH1 | CHAR (5) | |
PRODH_PA | Product hierarchy | PRODH_D | T179 | CHAR (18) |
WWACT_PA | Activity | RKEG_WWACT | T2500 | CHAR (2) |
WWERM_PA | Shipping Point / Receiving Point | VSTEL | TVST | CHAR (4) |
PAPH2_PA | Prod.hierarchy01-2 | RKEG_PAPH2 | CHAR (10) | |
PAPH3_PA | Prod.hierarchy01-3 | RKEG_PAPH3 | CHAR (18) | |
COLLE_PA | Fashion Collection | FSH_COLLECTION | FSH_COLLECTIONS | CHAR (10) |
CRMFIGR_PA | CRM Key Figure | RKECRMFIGR | TKECRMFIGR | CHAR (16) |
KMCATG_PA | Business field | RKESKMCATG | T2248 | NUMC (2) |
KMNIEL_PA | Nielsen ID | NIELS | TNLS | CHAR (2) |
SAISJ_PA | Season Year | FSH_SAISJ | CHAR (4) | |
SAISO_PA | Season | FSH_SAISO | FSH_SEASONS | CHAR (10) |
ARTNRG_PA | Generic Article | FSH_ARTNRG | MARA | CHAR (40) |
MATNR_PA | Material Number | MATNR | MARA | CHAR (40) |
PARTNER_PA | CO-PA Partner | RKEPARTNER | TKEPARTNER | CHAR (10) |
REGIO_PA | Region (State, Province, County) | REGIO | T005S | CHAR (3) |
WW001_PA | BRAND Reporting | RKEG_WW001 | T2501 | CHAR (5) |
WW100_PA | Country/Region Key | LAND1 | T005 | CHAR (3) |
WW101_PA | Country/Region Key | LAND1 | T005 | CHAR (3) |
WWBU1_PA | Test Business Unit | RKEG_WWBU1 | T2508 | CHAR (10) |
RCONGR1 | Consolidation Group (1) | RTC_CONGR1 | CHAR (20) | |
RCONGR2 | Consolidation Group (2) | RTC_CONGR2 | CHAR (20) | |
RCONGR3 | Consolidation Group (3) | RTC_CONGR3 | CHAR (20) | |
RTFLG | Translation Indicator for ACDOCC | RTC_TRANS_IND | CHAR (2) |
Availability
ACDOCC table is available in 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 ACDOCC table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.