ACDOCC - Consolidation Journal
Consolidation Journal information is stored in SAP table ACDOCC.
It is part of development package FINS_RTC_COMM in software component FIN-RTC. This development package consists of objects that can be grouped under "Real-Time Consolidation: Common Reusable Objects".
It is part of development package FINS_RTC_COMM in software component FIN-RTC. This development package consists of objects that can be grouped under "Real-Time Consolidation: Common Reusable Objects".
Fields for table ACDOCC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
RCLNT | Client | X | MANDT | CLNT | 6 | |
MODEL | Model | X | RTC_CON_MODEL | CHAR | 12 | |
RYEAR | Fiscal year | X | RYEAR | NUMC | 8 | |
BELNR | Document Number of an Accounting Document | X | BELNR_D | CHAR | 20 | |
DOCLN | Line Item | X | RTC_DOCLN10 | INT4 | 4 | |
DELFLG | Transaction marked for deletion? | RTC_DEL_FLAG | CHAR | 2 | ||
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
USNAM | User Name | USNAM | CHAR | 24 | ||
.INCLUDE | RTC_S_ACDOCC | 0 | ||||
RLDNR | Real-Time Consolidation Ledger | RTC_RLDNR | CHAR | 4 | ||
MODEL_VER | Model Version Number | RTC_VERN | CHAR | 12 | ||
VERID | Version ID | RTC_VERID | CHAR | 10 | ||
RBUKRS | Company Code | BUKRS | CHAR | 8 | ||
PBUKRS | Company Code of Partner | PBUKRS | CHAR | 8 | * | |
RCOMP | Company | RCOMP_D | CHAR | 12 | * | |
RVERS | Variant | RTC_RVERS | CHAR | 6 | * | |
BPC_CATG | Plan Category | FCOM_CATEGORY | CHAR | 20 | * | |
RTC_CATG | Real-Time Consolidation Data Category | RTC_DCAT | CHAR | 20 | ||
KTOPL | Group Chart of Accounts | RTC_KKTPL | CHAR | 8 | * | |
RACCT | Group Account Number | BILKT | CHAR | 20 | * | |
PR_UUID | Data Submit Request UUID | RTC_PR_UUID | RAW | 16 | ||
PKOKRS | Partner Controlling Area | RTC_PKOKRS | CHAR | 8 | * | |
PLEVL | Real-Time Consolidation Posting Level | RTC_PLEVEL | CHAR | 4 | ||
.INCLUDE | ACDOC_SI_GL_ACCAS | 0 | ||||
RCNTR | Cost Center | KOSTL | CHAR | 20 | CSKS | |
PRCTR | Profit Center | PRCTR | CHAR | 20 | CEPC | |
RFAREA | Functional Area | FKBER | CHAR | 32 | TFKB | |
RBUSA | Business Area | GSBER | CHAR | 8 | TGSB | |
KOKRS | Controlling Area | KOKRS | CHAR | 8 | TKA01 | |
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 20 | FAGL_SEGM | |
SCNTR | Sender cost center | SKOST | CHAR | 20 | CSKS | |
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 20 | CEPC | |
SFAREA | Partner Functional Area | SFKBER | CHAR | 32 | TFKB | |
SBUSA | Trading partner's business area | PARGB | CHAR | 8 | TGSB | |
RASSC | Company ID of Trading Partner | RASSC | CHAR | 12 | T880 | |
PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 20 | FAGL_SEGM | |
.INCLUDE | RTC_S_ACDOC_SI_00 | 0 | ||||
RMVCT | Transaction type | RMVCT | CHAR | 6 | T856 | |
AUDIT_TRA | Audit Trail | RTC_AUDIT_TRAIL | CHAR | 40 | ||
BTTYPE | Business Transaction Type | RTC_BTTYPE | CHAR | 8 | ||
DOCAUTO | Line Item: Automatic Posting | RTC_DOCAUTO | NUMC | 2 | ||
REF_BELNR | Reference Accounting Document Number | RTC_REF_BELNR | CHAR | 20 | ||
REF_DOCLN | Reference Line Item | RTC_REF_DOCLN | INT4 | 4 | ||
.INCLUDE | CURR_KEYS | RTC_S_ACDOC_SI_CURRKEYS | 0 | |||
RWCUR | Transaction Currency | FINS_CURRW | CUKY | 10 | * | |
RHCUR | Company Code Currency | FINS_CURRH | CUKY | 10 | * | |
RKCUR | Global Currency | FINS_CURRK | CUKY | 10 | * | |
RCO_OCUR | CO Object Currency | FINS_CO_OCUR | CUKY | 10 | * | |
CONS_CUR | Group Currency | RTC_CURR | CUKY | 10 | * | |
.INCLUDE | UNIT_OF_MEASURES | ACDOC_SI_UNIT_OF_MEASURES | 0 | |||
RUNIT | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
RVUNIT | Unit of Measure for Valuation Quantity | RVUNIT | UNIT | 6 | T006 | |
RRUNIT | Unit of Measure for Reference Quantity | RRUNIT | UNIT | 6 | T006 | |
RMSL_TYPE | Quantity Type Code of the Reference Quantity | FINS_RMSL_QTY_TYPE_CODE | CHAR | 2 | ||
RIUNIT | Unit of Measure for Inventory Quantity | FINS_RIUNIT | UNIT | 6 | T006 | |
QUNIT1 | Additional Unit of Measure 1 | FCO_QUNIT1 | UNIT | 6 | T006 | |
QUNIT2 | Additional Unit of Measure 2 | FCO_QUNIT2 | UNIT | 6 | T006 | |
QUNIT3 | Additional Unit of Measure 3 | FCO_QUNIT3 | UNIT | 6 | T006 | |
CO_MEINH | Unit of Measure for CO Valuation Quantity | FCO_MEINH | UNIT | 6 | * | |
.INCLUDE | RTC_S_ACDOC_SI_VALUE_DATA | 0 | ||||
WSL | Amount in Transaction Currency | FINS_VWCUR12 | CURR | 12 | ||
HSL | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 12 | ||
KSL | Amount in Global Currency | FINS_VKCUR12 | CURR | 12 | ||
CONS_SL | Amount in Group Currency | RTC_CUR_AMT | CURR | 12 | ||
MSL | Quantity | QUAN1_12 | QUAN | 12 | ||
MFSL | Fixed quantity | QUAN1_12_FIX | QUAN | 12 | ||
VMSL | Valuation quantity | VQUAN1_12 | QUAN | 12 | ||
VMFSL | Fixed valuation quantity | VQUAN1_12_FIX | QUAN | 12 | ||
RMSL | Reference quantity | RQUAN1_12 | QUAN | 12 | ||
QUANT1 | Additional Quantity 1 | FCO_QUAN1_L | QUAN | 12 | ||
QUANT2 | Additional Quantity 2 | FCO_QUAN2_L | QUAN | 12 | ||
QUANT3 | Additional Quantity 3 | FCO_QUAN3_L | QUAN | 12 | ||
.INCLUDE | RTC_S_ACDOC_SI_FIX | 0 | ||||
DRCRK | Debit/Credit Indicator | SHKZG | CHAR | 2 | ||
POPER | Posting period | POPER | NUMC | 6 | ||
PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | * | |
FISCYEARPER | Period/Year | JAHRPER | NUMC | 14 | ||
BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
BLDAT | Document Date in Document | BLDAT | DATS | 16 | ||
BLART | Consolidation Document Type | RTC_BLART | CHAR | 4 | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 6 | ||
BSCHL | Posting Key | BSCHL | CHAR | 4 | * | |
BSTAT | Document Status | RTC_BSTAT | CHAR | 2 | ||
GLACCOUNT_TYPE | Type of a General Ledger Account | GLACCOUNT_TYPE | CHAR | 2 | ||
.INCLUDE | RTC_S_ACDOC_SI_GEN | 0 | ||||
MATNR | Material Number | MATNR | CHAR | 80 | ||
WERKS | Plant | WERKS_D | CHAR | 8 | ||
LIFNR | Account Number of Supplier | LIFNR | CHAR | 20 | ||
KUNNR | Customer Number | KUNNR | CHAR | 20 | ||
.INCLUDE | RTC_S_ACDOC_SI_FI | 0 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 4 | * | |
.INCLUDE | RTC_S_ACDOC_SI_FAA | 0 | ||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 24 | * | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 8 | * | |
ANBWA | Asset Transaction Type | ANBWA | CHAR | 6 | * | |
MOVCAT | Transaction Type Category | FAA_MOVCAT | CHAR | 4 | FAAI_MOVCAT | |
ANLGR | Group Asset | ANLGR | CHAR | 24 | * | |
ANLGR2 | Subnumber of Group Asset | ANLGR2 | CHAR | 8 | * | |
SETTLEMENT_RULE | Distribution Rule Group | BUREG | NUMC | 6 | ||
.INCLUDE | RTC_S_ACDOC_SI_CO | 0 | ||||
PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 48 | ||
PS_PSPID | Project definition | PS_PSPID | CHAR | 48 | ||
.INCLUDE | ACDOC_SI_EXT | 0 | ||||
.INCLUDE | JEI | INCL_EEW_ACDOC | 0 | |||
ACDOC_EEW_DUMMY | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 2 | ||
.INCLUDE | COB | INCL_EEW_COBL | 0 | |||
.INCLUDE | CI_COBL | 0 | ||||
DUMMY_INCL_EEW_COBL | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 2 | ||
.INCLUDE | CI_PRS_CPILS_2 | CI_PRS_CPILS_2 | 0 | |||
.INCLUDE | ACDOC_SI_COPA | 0 | ||||
.INCLUDE | COPA_FIX | ACDOC_SI_COPA_FIX | 0 | |||
FKART | Billing Type | FKART | CHAR | 8 | TVFK | |
VKORG | Sales Organization | VKORG | CHAR | 8 | TVKO | |
VTWEG | Distribution Channel | VTWEG | CHAR | 4 | TVTW | |
SPART | Division | SPART | CHAR | 4 | TSPA | |
MATNR_COPA | Product Sold | FINS_MATNR_PA | CHAR | 80 | MARA | |
MATKL | Product Sold Group | FINS_MATKL_PA | CHAR | 18 | T023 | |
KDGRP | Customer Group | KDGRP | CHAR | 4 | T151 | |
LAND1 | Country/Region Key | LAND1_GP | CHAR | 6 | T005 | |
BRSCH | Industry key | BRSCH | CHAR | 8 | T016 | |
BZIRK | Sales District | BZIRK | CHAR | 12 | T171 | |
KUNRE | Bill-to Party | KUNRE | CHAR | 20 | KNA1 | |
KUNWE | Ship-to Party | KUNWE | CHAR | 20 | KNA1 | |
KONZS | Group key | KONZS | CHAR | 20 | ||
.INCLU-_PA | COPA_EXT | INCL_EEW_ACDOC_COPA | 0 | |||
ACDOC_COPA_EEW_DUMMY_PA | Dummy function in length 1 | DUMMY | CHAR | 2 | ||
.INCLU--AP | APPEND_EEW_ACDOC_COPA | 0 | ||||
BRAN1_PA | Industry code 1 | BRAN1_D | CHAR | 20 | TBRC | |
KVGR1_PA | Customer Group 1 | KVGR1 | CHAR | 6 | TVV1 | |
KVGR2_PA | Customer Group 2 | KVGR2 | CHAR | 6 | TVV2 | |
KVGR3_PA | Customer Group 3 | KVGR3 | CHAR | 6 | TVV3 | |
KVGR4_PA | Customer Group 4 | KVGR4 | CHAR | 6 | TVV4 | |
KVGR5_PA | Customer Group 5 | KVGR5 | CHAR | 6 | TVV5 | |
MVGR1_PA | Material Group 1 | MVGR1 | CHAR | 6 | TVM1 | |
WW001_PA | RKEG_WW001 | NUMC | 16 | PRPS | ||
WW002_PA | RKEG_WW002 | NUMC | 16 | PRPS | ||
.INCLUDE | COPA_MKS_EXT | INCL_EEW_MARKET_SEGMENT_PS | 0 | |||
DUMMY_MRKT_SGMNT_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 2 | ||
.INCLUDE | RTC_S_CONS_DIM_EXT | 0 | ||||
RCONGR1 | Consolidation Group (1) | RTC_CONGR1 | CHAR | 40 | ||
RCONGR2 | Consolidation Group (2) | RTC_CONGR2 | CHAR | 40 | ||
RCONGR3 | Consolidation Group (3) | RTC_CONGR3 | CHAR | 40 | ||
.INCLUDE | RTC_S_CONS_TRANS | 0 | ||||
RTFLG | Translation Indicator for ACDOCC | RTC_TRANS_IND | CHAR | 4 |