OIA08_D

Transparent Table Application Table
41 Fields 1 CDS Views

Draft table for entity R_OIL_LGCLINVTRYBALADJMTTP

OIA08_D is an SAP database table in S/4HANA. Draft table for entity R_OIL_LGCLINVTRYBALADJMTTP. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_OIL_LgclInvtryBalAdjmtDraft view_entity from BASIC LIA Document Item Data

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY lgclinvtryadjmtdocumentnumber OIA_UPENUM LIA number
KEY lgclinvtryadjmtdocumentyear MJAHR Mat. Doc. Year
KEY lgclinvtryadjmtdocitemnumber OIA_SEGNUM LIA doc item
KEY lgclinvtryadjmtitmtype OIA_UPEITM LIA item type
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
companycode BUKRS Company Code
exchangeagreementtype OIA_EXGTYP Exchange type
exchangeagreement OIA_EXGNUM Exchange no.
plant WERKS_D Plant
material MATNR Material
unitofmeasure OIA_TMEINS LIA trans. UoM
transacunitofmeasurequantity OIA_MENGE Quantity
stockkeepingunitofmeasure OIA_SKMNS Stock UoM
stockkeepingquantity OIA_SKMNG Qty in ST.UoM
documentdate BLDAT Document Date
postingdate BUDAT Posting Date
currency WAERS Currency
lgclinvtryadjmtpaymentamount OIA_PYMT LIA pyt amt.
paymentterms DZTERM Pyt Terms
paymentblockkey DZAHLS Payment Block
lgclinvtryadjcustsuppposin OIA_CVIND Cust/vend.ind
salesorganization VKORG Sales Org.
purchasingorganization EKORG Purchasing Org.
taxcode MWSKZ Tax Code
invoicecycle OIA_INVCYC Invoice cycle
ladingexternalbill OID_EXTBOL Extern.BOL no.
qtyadjmtvallocamount OIA_LIA_DMBTR LIA valua
ngtvadjmtindforadjmt OIA_NEGADJ Neg. adjustment
exchangeproductnumber OIA_SUBPRD Sub product no.
itemtextlgclinvtryadjmt SGTXT Text
materialpostingrule OIA_MATPST Mat.posting
feeaccountingprocesskey OIA_KTOSL Process key
schedglinedataagingfilterdate DATA_TEMPERATURE Data Aging
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity R_OIL_LGCLINVTRYBALADJMTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIA08_D (
    MANDT,                          -- Client [MANDT]
    LGCLINVTRYADJMTDOCUMENTNUMBER,  -- LIA number [OIA_UPENUM]
    LGCLINVTRYADJMTDOCUMENTYEAR,    -- Mat. Doc. Year [MJAHR]
    LGCLINVTRYADJMTDOCITEMNUMBER,   -- LIA doc item [OIA_SEGNUM]
    LGCLINVTRYADJMTITMTYPE,         -- LIA item type [OIA_UPEITM]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    COMPANYCODE,                    -- Company Code [BUKRS]
    EXCHANGEAGREEMENTTYPE,          -- Exchange type [OIA_EXGTYP]
    EXCHANGEAGREEMENT,              -- Exchange no. [OIA_EXGNUM]
    PLANT,                          -- Plant [WERKS_D]
    MATERIAL,                       -- Material [MATNR]
    UNITOFMEASURE,                  -- LIA trans. UoM [OIA_TMEINS]
    TRANSACUNITOFMEASUREQUANTITY,   -- Quantity [OIA_MENGE]
    STOCKKEEPINGUNITOFMEASURE,      -- Stock UoM [OIA_SKMNS]
    STOCKKEEPINGQUANTITY,           -- Qty in ST.UoM [OIA_SKMNG]
    DOCUMENTDATE,                   -- Document Date [BLDAT]
    POSTINGDATE,                    -- Posting Date [BUDAT]
    CURRENCY,                       -- Currency [WAERS]
    LGCLINVTRYADJMTPAYMENTAMOUNT,   -- LIA pyt amt. [OIA_PYMT]
    PAYMENTTERMS,                   -- Pyt Terms [DZTERM]
    PAYMENTBLOCKKEY,                -- Payment Block [DZAHLS]
    LGCLINVTRYADJCUSTSUPPPOSIN,     -- Cust/vend.ind [OIA_CVIND]
    SALESORGANIZATION,              -- Sales Org. [VKORG]
    PURCHASINGORGANIZATION,         -- Purchasing Org. [EKORG]
    TAXCODE,                        -- Tax Code [MWSKZ]
    INVOICECYCLE,                   -- Invoice cycle [OIA_INVCYC]
    LADINGEXTERNALBILL,             -- Extern.BOL no. [OID_EXTBOL]
    QTYADJMTVALLOCAMOUNT,           -- LIA valua [OIA_LIA_DMBTR]
    NGTVADJMTINDFORADJMT,           -- Neg. adjustment [OIA_NEGADJ]
    EXCHANGEPRODUCTNUMBER,          -- Sub product no. [OIA_SUBPRD]
    ITEMTEXTLGCLINVTRYADJMT,        -- Text [SGTXT]
    MATERIALPOSTINGRULE,            -- Mat.posting [OIA_MATPST]
    FEEACCOUNTINGPROCESSKEY,        -- Process key [OIA_KTOSL]
    SCHEDGLINEDATAAGINGFILTERDATE,  -- Data Aging [DATA_TEMPERATURE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, LGCLINVTRYADJMTDOCUMENTNUMBER, LGCLINVTRYADJMTDOCUMENTYEAR, LGCLINVTRYADJMTDOCITEMNUMBER, LGCLINVTRYADJMTITMTYPE, DRAFTUUID)
);

Learn More