AD01DLI

Transparent Table Application Table
70 Fields 3 CDS Views

Dynamic items (DI)

AD01DLI is an SAP database table in S/4HANA. Dynamic items (DI). It contains 70 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FINS_REV_REC_DIPCOGS_FOR_DMREQ view inner DIP based COGS for debit memo request
I_RRBDynamicItem view from BASIC RRB Dynamic Items
P_Bpfpdynitem view inner BASIC

Fields (70)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dlinr AD01DLINR DI No.
objnr J_OBJNR Object number
poper AD01PERIOD Period
twaer TWAER Trans. Currency
meinh CO_MEINH Unit of Measure
manual XFELD Checkbox
kstar KSTAR Cost Element
kostl KOSTL Cost Center
lstar LSTAR Activity Type
matnr MATNR Material
stagr STAGR Stat. key fig.
fipos FIPOS Commitment item
wrttp CO_WRTTP Value Type
versn VERSN Version
werks WERKS_D Plant
produ PRODN Product
faktf FAKTF Billing form
bemot BEMOT AcctIndicator
belnr CO_BELNR Document Number
buzei CO_BUZEI Posting Row
docln DOCLN6 G/L Line Item
arbpl ARBPL Work Center
awerk AD01AWERK Plant: Work center
prznr CO_PRZNR Business Process
asnum ASNUM Activity number
pernr HR_PERNR Personnel no.
rsrce CO_RESSOURCE Resource
prs_work_period PRS_WORK_PERIOD Work Period
gsber GSBER Business Area
pargb PARGB Trdg Part.BA
prctr PRCTR Profit Center
pprctr PPRCTR Partner PC
wty_ind WTYSC_WTY_INDICATOR Warranty
ordered_prod CRMT_ORDERED_PROD_DB Product
category_id COMT_CATEGORY_ID Category ID
awsys AWSYS Logical System
serv_agent_id BU_PARTNER Busn. Partner
ref_object_id CRMT_OBJECT_ID_DB Transaction ID
ref_object_item CRMT_ITEM_NO Item
cpd_dliid /CPD/PWS_BILLING_DLIID CPD Billing ID
orig_objnr DPICB_OBJNR Orig. Obj. no.
fplnr FPLNR Bill. Plan No.
fpltr FPLTR Item
bpcat SDBP_BPCAT BillingPlanUCat
billingplanitemusage SDBP_ITEM_USAGE Usage
wbs_billing_elements PS_PSP_PNR WBS Element
work_item_id /CPD/PFP_WORKITEM_ID Work Item ID
serv_org /CPD/PWS_WS_ORG_UNIT_ID Service Org.
overtimecat CATS_OVERTIME_CATEGORY Overtime Category
farea FM_FAREA Functional Area
rgrant_nbr GM_GRANT_NBR Grant
wbs_element PS_POSNR WBS Element
orderid AUFNR Order
funds_ctr FISTL Funds Center
fund BP_GEBER Fund
sponsored_prog GM_SPONSORED_PROG Sponsored Program
sponsored_class GM_SPONSORED_CLASS Sponsored Class
gl_sirid GU_RECID Record number
refdocnr REFBELNR Ref. document
refdocln REFBUZEI6 Reference Item
sgtxt SGTXT Text
gm_valuetype GM_VALUETYPE GM Value Type
assetmaino BF_ANLN1 Asset
assetsubno BF_ANLN2 Sub-number
budget_pd FM_BUDGET_PERIOD Budget Period
dlisrc AD01DLISRC Source
profnr AD01PROFNR DIP Profile
timestmp RKE_HZSTMP Time created
soitext SGTXT Text

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.

-- Dynamic items (DI)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AD01DLI (
    MANDT,                 -- Client [MANDT]
    DLINR,                 -- DI No. [AD01DLINR]
    OBJNR,                 -- Object number [J_OBJNR]
    POPER,                 -- Period [AD01PERIOD]
    TWAER,                 -- Trans. Currency [TWAER]
    MEINH,                 -- Unit of Measure [CO_MEINH]
    MANUAL,                -- Checkbox [XFELD]
    KSTAR,                 -- Cost Element [KSTAR]
    KOSTL,                 -- Cost Center [KOSTL]
    LSTAR,                 -- Activity Type [LSTAR]
    MATNR,                 -- Material [MATNR]
    STAGR,                 -- Stat. key fig. [STAGR]
    FIPOS,                 -- Commitment item [FIPOS]
    WRTTP,                 -- Value Type [CO_WRTTP]
    VERSN,                 -- Version [VERSN]
    WERKS,                 -- Plant [WERKS_D]
    PRODU,                 -- Product [PRODN]
    FAKTF,                 -- Billing form [FAKTF]
    BEMOT,                 -- AcctIndicator [BEMOT]
    BELNR,                 -- Document Number [CO_BELNR]
    BUZEI,                 -- Posting Row [CO_BUZEI]
    DOCLN,                 -- G/L Line Item [DOCLN6]
    ARBPL,                 -- Work Center [ARBPL]
    AWERK,                 -- Plant: Work center [AD01AWERK]
    PRZNR,                 -- Business Process [CO_PRZNR]
    ASNUM,                 -- Activity number [ASNUM]
    PERNR,                 -- Personnel no. [HR_PERNR]
    RSRCE,                 -- Resource [CO_RESSOURCE]
    PRS_WORK_PERIOD,       -- Work Period [PRS_WORK_PERIOD]
    GSBER,                 -- Business Area [GSBER]
    PARGB,                 -- Trdg Part.BA [PARGB]
    PRCTR,                 -- Profit Center [PRCTR]
    PPRCTR,                -- Partner PC [PPRCTR]
    WTY_IND,               -- Warranty [WTYSC_WTY_INDICATOR]
    ORDERED_PROD,          -- Product [CRMT_ORDERED_PROD_DB]
    CATEGORY_ID,           -- Category ID [COMT_CATEGORY_ID]
    AWSYS,                 -- Logical System [AWSYS]
    SERV_AGENT_ID,         -- Busn. Partner [BU_PARTNER]
    REF_OBJECT_ID,         -- Transaction ID [CRMT_OBJECT_ID_DB]
    REF_OBJECT_ITEM,       -- Item [CRMT_ITEM_NO]
    CPD_DLIID,             -- CPD Billing ID [/CPD/PWS_BILLING_DLIID]
    ORIG_OBJNR,            -- Orig. Obj. no. [DPICB_OBJNR]
    FPLNR,                 -- Bill. Plan No. [FPLNR]
    FPLTR,                 -- Item [FPLTR]
    BPCAT,                 -- BillingPlanUCat [SDBP_BPCAT]
    BILLINGPLANITEMUSAGE,  -- Usage [SDBP_ITEM_USAGE]
    WBS_BILLING_ELEMENTS,  -- WBS Element [PS_PSP_PNR]
    WORK_ITEM_ID,          -- Work Item ID [/CPD/PFP_WORKITEM_ID]
    SERV_ORG,              -- Service Org. [/CPD/PWS_WS_ORG_UNIT_ID]
    OVERTIMECAT,           -- Overtime Category [CATS_OVERTIME_CATEGORY]
    FAREA,                 -- Functional Area [FM_FAREA]
    RGRANT_NBR,            -- Grant [GM_GRANT_NBR]
    WBS_ELEMENT,           -- WBS Element [PS_POSNR]
    ORDERID,               -- Order [AUFNR]
    FUNDS_CTR,             -- Funds Center [FISTL]
    FUND,                  -- Fund [BP_GEBER]
    SPONSORED_PROG,        -- Sponsored Program [GM_SPONSORED_PROG]
    SPONSORED_CLASS,       -- Sponsored Class [GM_SPONSORED_CLASS]
    GL_SIRID,              -- Record number [GU_RECID]
    REFDOCNR,              -- Ref. document [REFBELNR]
    REFDOCLN,              -- Reference Item [REFBUZEI6]
    SGTXT,                 -- Text [SGTXT]
    GM_VALUETYPE,          -- GM Value Type [GM_VALUETYPE]
    ASSETMAINO,            -- Asset [BF_ANLN1]
    ASSETSUBNO,            -- Sub-number [BF_ANLN2]
    BUDGET_PD,             -- Budget Period [FM_BUDGET_PERIOD]
    DLISRC,                -- Source [AD01DLISRC]
    PROFNR,                -- DIP Profile [AD01PROFNR]
    TIMESTMP,              -- Time created [RKE_HZSTMP]
    SOITEXT,               -- Text [SGTXT]
    PRIMARY KEY (MANDT, DLINR)
);

Learn More