FINCS_PLN_ACDOCU

Transparent Table Temporary Data
54 Fields 2 CDS Views

Plan Data for ACDOCU

FINCS_PLN_ACDOCU is an SAP database table in S/4HANA. Plan Data for ACDOCU. It contains 54 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CnsldtnGrpJrnlEntryPlngItem view_entity from EXTENSION Group Reporting Plan Data - Extension
I_CnsldtnGrpJrnlEntryPlngItem view_entity from BASIC Group Reporting Plan Staging Data

Fields (54)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY transactionid SYSUUID_X UUID
KEY datapakid RSDATAPID Data packet number
KEY record RSARECORD Data record number
uname SYST_UNAME User Name
timestamp TIMESTAMP Time Stamp
docty FC_DOCTY Document Type
rvers FC_RVERS Version
ryear FC_RYEAR Fiscal year
poper POPER Posting Period
rbunit FINCS_MD_BUNIT Consolidation Unit
rbuptr FINCS_MD_BUPTR Partner Unit
ritclg FC_ITCLG Cons. COA
ritem FC_ITEM FS Item
sityp FC_SITYP Subitem Category
subit FC_SITEM Subitem
kokrs KOKRS CO Area
rcntr KOSTL Cost Center
scntr SKOST Sender Cost Ctr
prctr PRCTR Profit Center
pprctr PPRCTR Partner PC
segment FB_SEGMENT Segment
psegment FB_PSEGMENT Partner Segment
rfarea FKBER Functional Area
sfarea SFKBER Partner FArea
rbusa GSBER Business Area
sbusa PARGB Trdg Part.BA
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 Transact. Type
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
brsch BRSCH Industry
bzirk BZIRK Sales District
kunre KUNRE Bill-to Party
kunwe KUNWE Ship-to Party
rhcur LCURR Local crcy
rkcur GCURR Ledger curr.
rtcur RTCUR Currency
runit MEINS Base Unit
hsl VLCUR12 Local Crcy Amt
ksl VGCUR12 Amnt in GrpCrcy
tsl VTCUR12 Amount in TC
msl FINCS_QUAN Quantity
dummy_cje_incl_eew_ps CFD_DUMMY Dummy

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.

-- Plan Data for ACDOCU
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_PLN_ACDOCU (
    MANDT,                  -- Client [MANDT]
    TRANSACTIONID,          -- UUID [SYSUUID_X]
    DATAPAKID,              -- Data packet number [RSDATAPID]
    RECORD,                 -- Data record number [RSARECORD]
    UNAME,                  -- User Name [SYST_UNAME]
    TIMESTAMP,              -- Time Stamp [TIMESTAMP]
    DOCTY,                  -- Document Type [FC_DOCTY]
    RVERS,                  -- Version [FC_RVERS]
    RYEAR,                  -- Fiscal year [FC_RYEAR]
    POPER,                  -- Posting Period [POPER]
    RBUNIT,                 -- Consolidation Unit [FINCS_MD_BUNIT]
    RBUPTR,                 -- Partner Unit [FINCS_MD_BUPTR]
    RITCLG,                 -- Cons. COA [FC_ITCLG]
    RITEM,                  -- FS Item [FC_ITEM]
    SITYP,                  -- Subitem Category [FC_SITYP]
    SUBIT,                  -- Subitem [FC_SITEM]
    KOKRS,                  -- CO Area [KOKRS]
    RCNTR,                  -- Cost Center [KOSTL]
    SCNTR,                  -- Sender Cost Ctr [SKOST]
    PRCTR,                  -- Profit Center [PRCTR]
    PPRCTR,                 -- Partner PC [PPRCTR]
    SEGMENT,                -- Segment [FB_SEGMENT]
    PSEGMENT,               -- Partner Segment [FB_PSEGMENT]
    RFAREA,                 -- Functional Area [FKBER]
    SFAREA,                 -- Partner FArea [SFKBER]
    RBUSA,                  -- Business Area [GSBER]
    SBUSA,                  -- Trdg Part.BA [PARGB]
    AUFNR,                  -- Order [AUFNR]
    KUNNR,                  -- Customer [KUNNR]
    LIFNR,                  -- Supplier [LIFNR]
    MATNR,                  -- Material [MATNR]
    MATKL_MM,               -- Material Group [FINS_MATKL_MM]
    WERKS,                  -- Plant [WERKS_D]
    RMVCT,                  -- Transact. Type [RMVCT]
    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]
    BRSCH,                  -- Industry [BRSCH]
    BZIRK,                  -- Sales District [BZIRK]
    KUNRE,                  -- Bill-to Party [KUNRE]
    KUNWE,                  -- Ship-to Party [KUNWE]
    RHCUR,                  -- Local crcy [LCURR]
    RKCUR,                  -- Ledger curr. [GCURR]
    RTCUR,                  -- Currency [RTCUR]
    RUNIT,                  -- Base Unit [MEINS]
    HSL,                    -- Local Crcy Amt [VLCUR12]
    KSL,                    -- Amnt in GrpCrcy [VGCUR12]
    TSL,                    -- Amount in TC [VTCUR12]
    MSL,                    -- Quantity [FINCS_QUAN]
    DUMMY_CJE_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, TRANSACTIONID, DATAPAKID, RECORD)
);

Learn More