ACDOCU_STAGING
store data that are selected from ACDOCU
ACDOCU_STAGING is an SAP database table in S/4HANA. store data that are selected from ACDOCU. It contains 132 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_CnsldtnPostingRuleLogltem | view_entity | from | COMPOSITE |
Fields (132)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | rclnt | MANDT | Client | |||
| KEY | ryear | GJAHR | Fiscal Year | |||
| KEY | runreference | FINCS_RUNREFERENCE | RunReference | |||
| KEY | runid | FINCS_RUNID | RunID | |||
| KEY | row_number | FINCS_RT_ROW_NUMBER | Source Line | |||
| vsl1 | FINCS_RT_VARIABLE_VALUE | Value | ||||
| vsl2 | FINCS_RT_VARIABLE_VALUE | Value | ||||
| vsl3 | FINCS_RT_VARIABLE_VALUE | Value | ||||
| vsl4 | FINCS_RT_VARIABLE_VALUE | Value | ||||
| vsl5 | FINCS_RT_VARIABLE_VALUE | Value | ||||
| vsl6 | FINCS_RT_VARIABLE_VALUE | Value | ||||
| rrcty | FC_RRCTY | Record Type | ||||
| rvers | FC_RVERS | Version | ||||
| rtcur | RTCUR | Currency | ||||
| rhcur | LCURR | Local crcy | ||||
| rkcur | GCURR | Ledger curr. | ||||
| runit | MEINS | Base Unit | ||||
| poper | POPER | Posting Period | ||||
| fiscyearper | FINCS_FISCYEARPER | Period/Year | ||||
| docct | DOCCT | Document Categ. | ||||
| rcomp | RCOMP_D | Company | ||||
| rbunit | FC_BUNIT | Cons. Unit | ||||
| ritclg | FC_ITCLG | Cons. COA | ||||
| ritem | FC_ITEM | FS Item | ||||
| rbuptr | FC_BUPTR | Partner Unit | ||||
| rcongr | FC_CONGR | Cons. Group | ||||
| robukrs | OBUKR | Orig. CC | ||||
| sityp | FC_SITYP | Subitem Category | ||||
| subit | FC_SITEM | Subitem | ||||
| plevl | FC_PLEVL | Posting Level | ||||
| rpflg | FC_RPFLG | Apportionment | ||||
| rtflg | FC_RTFLG | CT Indicator | ||||
| docty | FC_DOCTY | Document Type | ||||
| yracq | FC_RYACQ | Acquis. Year | ||||
| pracq | RPACQ | Period of Acq. | ||||
| coicu | FC_COICU | Investee Unit | ||||
| uppcu | FC_UPPCU | Investor Unit | ||||
| tsl | VTCUR12 | Amount in TC | ||||
| hsl | VLCUR12 | Local Crcy Amt | ||||
| ksl | VGCUR12 | Amnt in GrpCrcy | ||||
| msl | FINCS_QUAN | Quantity | ||||
| tsl_csign | VTCUR12 | Amount in TC | ||||
| hsl_csign | VLCUR12 | Local Crcy Amt | ||||
| ksl_csign | VGCUR12 | Amnt in GrpCrcy | ||||
| msl_csign | FINCS_QUAN | Quantity | ||||
| sgtxt | SGTXT | Text | ||||
| autom | AUTOM | Auto. ID | ||||
| activ | GLVOR | Bus.transaction | ||||
| bvorg | BVORG | Cross-CC Number | ||||
| budat | BUDAT | Posting Date | ||||
| wsdat | WSDAT | Value Date | ||||
| refdocnr | BELNR_D | Document Number | ||||
| refryear | FC_OYEAR | Original FY | ||||
| refdocln | BUZEI6 | Item | ||||
| refdocct | DOCCT | Document Categ. | ||||
| refactiv | GLVOR | Bus.transaction | ||||
| timestamp | TIMESTAMP | Time Stamp | ||||
| cpudt | CPUDT | Entered On | ||||
| cputm | CPUTM | Entered at | ||||
| bunnr | FINCS_BUNNR | Document Bundle No. | ||||
| coiac | FC_COIAC | C/I Activity | ||||
| coinr | FC_COINR | Activity Number | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| aworg | AWORG | Refer. Org.Unit | ||||
| logsys | LOGSYS | Logical system | ||||
| ktopl | KTOPL | Chart of Accts | ||||
| racct | RACCT | Account Number | ||||
| xblnr | XBLNR1 | Reference | ||||
| zuonr | DZUONR | Assignment | ||||
| rcntr | KOSTL | Cost Center | ||||
| prctr | PRCTR | Profit Center | ||||
| rfarea | FKBER | Functional Area | ||||
| rbusa | GSBER | Business Area | ||||
| kokrs | KOKRS | CO Area | ||||
| segment | FB_SEGMENT | Segment | ||||
| scntr | SKOST | Sender cost ctr | ||||
| pprctr | PPRCTR | Partner PC | ||||
| sfarea | SFKBER | Partner FArea | ||||
| sbusa | PARGB | Trdg Part.BA | ||||
| rassc | RASSC | Trading Partner | ||||
| psegment | FB_PSEGMENT | Partner Segment | ||||
| aufnr | AUFNR | Order | ||||
| kunnr | KUNNR | Customer | ||||
| lifnr | LIFNR | Supplier | ||||
| matnr | MATNR | Material | ||||
| matkl_mm | FINS_MATKL_MM | Material Group | ||||
| werks | WERKS_D | Plant | ||||
| rmvct | RMVCT | Transactn type | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| ps_posid | PS_POSID | WBS Element | ||||
| ps_pspid | PS_PSPID | Project def. | ||||
| fkart | FKART | Billing Type | ||||
| vkorg | VKORG | Sales Org. | ||||
| vtweg | VTWEG | Distr. Channel | ||||
| spart | SPART | Division | ||||
| matnr_copa | FINS_MATNR_PA | Product Sold | ||||
| matkl | FINS_MATKL_PA | Product Sold Group | ||||
| kdgrp | KDGRP | Customer Group | ||||
| land1 | COBL_LAND1_GP | Country/Region | ||||
| brsch | BRSCH | Industry | ||||
| bzirk | BZIRK | Sales District | ||||
| kunre | KUNRE | Bill-to Party | ||||
| kunwe | KUNWE | Ship-to Party | ||||
| konzs | KONZS | Group | ||||
| fs_product_group | FFS_PRODUCT_GROUP | Product Group (FS) | ||||
| branch_id | FFS_BRANCH_ID | Branch (FS) | ||||
| datasource_id | FFS_DATASOURCE_ID | Data Source | ||||
| rfund | BP_GEBER | Fund | ||||
| rgrant_nbr | GM_GRANT_NBR | Grant | ||||
| re_account | FIS_RE_ACCOUNT | Cash Origin Account | ||||
| fikrs | FIKRS | FM Area | ||||
| re_ktopl | FINCS_RE_KTOPL | Cash Origin ChtAccts | ||||
| sfund | BP_P_GEBER | Partner Fund | ||||
| ghgcategory | SUFND_VDM_GHGCATEGORY | GHG Category | ||||
| ghgscope | SUFND_VDM_GHGSCOPE | GHG Scope | ||||
| ghgscp2calcmeth | SUFND_VDM_GHGSCP2CALCMETH | GHG Scp 2 Calc Meth | ||||
| ghgscp2contrinstr | SUFND_VDM_GHGSCP2CONTRINSTR | GHG Scp 2 Cntrctl In | ||||
| susmodeoftransport | SUFND_VDM_SUSMODEOFTRANSPORT | Sust Mode of Transpt | ||||
| ghgdtaqltycharc | SUFND_VDM_GHGDTAQLTYCHARC | GHG Data Qlty Charc | ||||
| ghgenergyclass | SUFND_VDM_GHGENERGYCLASS | GHG Engy Classfctn | ||||
| ghgenergymix | SUFND_VDM_GHGENERGYMIX | GHG Energy Mix | ||||
| ghgengysrcgtype | SUFND_VDM_GHGENGYSRCGTYPE | GHG Engy Srcg Type | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| adhocitem | FINCS_ADHOCITEM | Ad Hoc Item | ||||
| adhocset | FINCS_ADHOCSET | Ad Hoc Set | ||||
| adhocsetitem | FINCS_ADHOCSETITEM | Ad Hoc Set Item | ||||
| rcode | ICA_RCODE | Reason Code | ||||
| orig_type | FINCS_ORIG_TYPE | Origin Type | ||||
| orig_ref | FINCS_ORIG_REF | Origin Ref. | ||||
| dummy_cje_incl_eew_ps | CFD_DUMMY | Dummy | ||||
| rulelogid | FINCS_RT_LOG_ID | Posting Rule Log ID | ||||
| rule_group_id | FINCS_RULGRP_ID | Rule Group |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- store data that are selected from ACDOCU
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACDOCU_STAGING (
RCLNT, -- Client [MANDT]
RYEAR, -- Fiscal Year [GJAHR]
RUNREFERENCE, -- RunReference [FINCS_RUNREFERENCE]
RUNID, -- RunID [FINCS_RUNID]
ROW_NUMBER, -- Source Line [FINCS_RT_ROW_NUMBER]
VSL1, -- Value [FINCS_RT_VARIABLE_VALUE]
VSL2, -- Value [FINCS_RT_VARIABLE_VALUE]
VSL3, -- Value [FINCS_RT_VARIABLE_VALUE]
VSL4, -- Value [FINCS_RT_VARIABLE_VALUE]
VSL5, -- Value [FINCS_RT_VARIABLE_VALUE]
VSL6, -- Value [FINCS_RT_VARIABLE_VALUE]
RRCTY, -- Record Type [FC_RRCTY]
RVERS, -- Version [FC_RVERS]
RTCUR, -- Currency [RTCUR]
RHCUR, -- Local crcy [LCURR]
RKCUR, -- Ledger curr. [GCURR]
RUNIT, -- Base Unit [MEINS]
POPER, -- Posting Period [POPER]
FISCYEARPER, -- Period/Year [FINCS_FISCYEARPER]
DOCCT, -- Document Categ. [DOCCT]
RCOMP, -- Company [RCOMP_D]
RBUNIT, -- Cons. Unit [FC_BUNIT]
RITCLG, -- Cons. COA [FC_ITCLG]
RITEM, -- FS Item [FC_ITEM]
RBUPTR, -- Partner Unit [FC_BUPTR]
RCONGR, -- Cons. Group [FC_CONGR]
ROBUKRS, -- Orig. CC [OBUKR]
SITYP, -- Subitem Category [FC_SITYP]
SUBIT, -- Subitem [FC_SITEM]
PLEVL, -- Posting Level [FC_PLEVL]
RPFLG, -- Apportionment [FC_RPFLG]
RTFLG, -- CT Indicator [FC_RTFLG]
DOCTY, -- Document Type [FC_DOCTY]
YRACQ, -- Acquis. Year [FC_RYACQ]
PRACQ, -- Period of Acq. [RPACQ]
COICU, -- Investee Unit [FC_COICU]
UPPCU, -- Investor Unit [FC_UPPCU]
TSL, -- Amount in TC [VTCUR12]
HSL, -- Local Crcy Amt [VLCUR12]
KSL, -- Amnt in GrpCrcy [VGCUR12]
MSL, -- Quantity [FINCS_QUAN]
TSL_CSIGN, -- Amount in TC [VTCUR12]
HSL_CSIGN, -- Local Crcy Amt [VLCUR12]
KSL_CSIGN, -- Amnt in GrpCrcy [VGCUR12]
MSL_CSIGN, -- Quantity [FINCS_QUAN]
SGTXT, -- Text [SGTXT]
AUTOM, -- Auto. ID [AUTOM]
ACTIV, -- Bus.transaction [GLVOR]
BVORG, -- Cross-CC Number [BVORG]
BUDAT, -- Posting Date [BUDAT]
WSDAT, -- Value Date [WSDAT]
REFDOCNR, -- Document Number [BELNR_D]
REFRYEAR, -- Original FY [FC_OYEAR]
REFDOCLN, -- Item [BUZEI6]
REFDOCCT, -- Document Categ. [DOCCT]
REFACTIV, -- Bus.transaction [GLVOR]
TIMESTAMP, -- Time Stamp [TIMESTAMP]
CPUDT, -- Entered On [CPUDT]
CPUTM, -- Entered at [CPUTM]
BUNNR, -- Document Bundle No. [FINCS_BUNNR]
COIAC, -- C/I Activity [FC_COIAC]
COINR, -- Activity Number [FC_COINR]
AWTYP, -- Ref. procedure [AWTYP]
AWORG, -- Refer. Org.Unit [AWORG]
LOGSYS, -- Logical system [LOGSYS]
KTOPL, -- Chart of Accts [KTOPL]
RACCT, -- Account Number [RACCT]
XBLNR, -- Reference [XBLNR1]
ZUONR, -- Assignment [DZUONR]
RCNTR, -- Cost Center [KOSTL]
PRCTR, -- Profit Center [PRCTR]
RFAREA, -- Functional Area [FKBER]
RBUSA, -- Business Area [GSBER]
KOKRS, -- CO Area [KOKRS]
SEGMENT, -- Segment [FB_SEGMENT]
SCNTR, -- Sender cost ctr [SKOST]
PPRCTR, -- Partner PC [PPRCTR]
SFAREA, -- Partner FArea [SFKBER]
SBUSA, -- Trdg Part.BA [PARGB]
RASSC, -- Trading Partner [RASSC]
PSEGMENT, -- Partner Segment [FB_PSEGMENT]
AUFNR, -- Order [AUFNR]
KUNNR, -- Customer [KUNNR]
LIFNR, -- Supplier [LIFNR]
MATNR, -- Material [MATNR]
MATKL_MM, -- Material Group [FINS_MATKL_MM]
WERKS, -- Plant [WERKS_D]
RMVCT, -- Transactn type [RMVCT]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
PS_POSID, -- WBS Element [PS_POSID]
PS_PSPID, -- Project def. [PS_PSPID]
FKART, -- Billing Type [FKART]
VKORG, -- Sales Org. [VKORG]
VTWEG, -- Distr. Channel [VTWEG]
SPART, -- Division [SPART]
MATNR_COPA, -- Product Sold [FINS_MATNR_PA]
MATKL, -- Product Sold Group [FINS_MATKL_PA]
KDGRP, -- Customer Group [KDGRP]
LAND1, -- Country/Region [COBL_LAND1_GP]
BRSCH, -- Industry [BRSCH]
BZIRK, -- Sales District [BZIRK]
KUNRE, -- Bill-to Party [KUNRE]
KUNWE, -- Ship-to Party [KUNWE]
KONZS, -- Group [KONZS]
FS_PRODUCT_GROUP, -- Product Group (FS) [FFS_PRODUCT_GROUP]
BRANCH_ID, -- Branch (FS) [FFS_BRANCH_ID]
DATASOURCE_ID, -- Data Source [FFS_DATASOURCE_ID]
RFUND, -- Fund [BP_GEBER]
RGRANT_NBR, -- Grant [GM_GRANT_NBR]
RE_ACCOUNT, -- Cash Origin Account [FIS_RE_ACCOUNT]
FIKRS, -- FM Area [FIKRS]
RE_KTOPL, -- Cash Origin ChtAccts [FINCS_RE_KTOPL]
SFUND, -- Partner Fund [BP_P_GEBER]
GHGCATEGORY, -- GHG Category [SUFND_VDM_GHGCATEGORY]
GHGSCOPE, -- GHG Scope [SUFND_VDM_GHGSCOPE]
GHGSCP2CALCMETH, -- GHG Scp 2 Calc Meth [SUFND_VDM_GHGSCP2CALCMETH]
GHGSCP2CONTRINSTR, -- GHG Scp 2 Cntrctl In [SUFND_VDM_GHGSCP2CONTRINSTR]
SUSMODEOFTRANSPORT, -- Sust Mode of Transpt [SUFND_VDM_SUSMODEOFTRANSPORT]
GHGDTAQLTYCHARC, -- GHG Data Qlty Charc [SUFND_VDM_GHGDTAQLTYCHARC]
GHGENERGYCLASS, -- GHG Engy Classfctn [SUFND_VDM_GHGENERGYCLASS]
GHGENERGYMIX, -- GHG Energy Mix [SUFND_VDM_GHGENERGYMIX]
GHGENGYSRCGTYPE, -- GHG Engy Srcg Type [SUFND_VDM_GHGENGYSRCGTYPE]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
ADHOCITEM, -- Ad Hoc Item [FINCS_ADHOCITEM]
ADHOCSET, -- Ad Hoc Set [FINCS_ADHOCSET]
ADHOCSETITEM, -- Ad Hoc Set Item [FINCS_ADHOCSETITEM]
RCODE, -- Reason Code [ICA_RCODE]
ORIG_TYPE, -- Origin Type [FINCS_ORIG_TYPE]
ORIG_REF, -- Origin Ref. [FINCS_ORIG_REF]
DUMMY_CJE_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
RULELOGID, -- Posting Rule Log ID [FINCS_RT_LOG_ID]
RULE_GROUP_ID, -- Rule Group [FINCS_RULGRP_ID]
PRIMARY KEY (RCLNT, RYEAR, RUNREFERENCE, RUNID, ROW_NUMBER)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA