OIA08

Transparent Table Application Table
33 Fields 1 CDS Views

LIA Document: Item Data

OIA08 is an SAP database table in S/4HANA. LIA Document: Item Data. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_LgclInvtryAdjmtDocItem view_entity from BASIC LIA Document item Data

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY upenum OIA_UPENUM LIA number
KEY mjahr MJAHR Mat. Doc. Year
KEY segnum OIA_SEGNUM LIA doc item
KEY item_type OIA_UPEITM LIA item type
bukrs BUKRS Company Code
exgtyp OIA_EXGTYP Exchange type
exgnum OIA_EXGNUM Exchange no.
werks WERKS_D Plant
matnr MATNR Material
meins OIA_TMEINS LIA trans. UoM
menge OIA_MENGE Quantity
skmeins OIA_SKMNS Stock UoM
skmenge OIA_SKMNG Qty in ST.UoM
bldat BLDAT Document Date
budat BUDAT Posting Date
waers WAERS Currency
pymt OIA_PYMT LIA pyt amt.
zterm DZTERM Pyt Terms
zlspr DZAHLS Payment Block
cvind OIA_CVIND Cust/vend.ind
vkorg VKORG Sales Org.
ekorg EKORG Purchasing Org.
taxcd MWSKZ Tax Code
sgtxt SGTXT Text
negadj OIA_NEGADJ Neg. adjustment
subprod OIA_SUBPRD Sub product no.
oicycle OIA_INVCYC Invoice cycle
oid_extbol OID_EXTBOL Extern.BOL no.
lia_dmbtr OIA_LIA_DMBTR LIA valua
matpst OIA_MATPST Mat.posting
ktosl OIA_KTOSL Process key
_dataaging DATA_TEMPERATURE Data Aging

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.

-- LIA Document: Item Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIA08 (
    MANDT,       -- Client [MANDT]
    UPENUM,      -- LIA number [OIA_UPENUM]
    MJAHR,       -- Mat. Doc. Year [MJAHR]
    SEGNUM,      -- LIA doc item [OIA_SEGNUM]
    ITEM_TYPE,   -- LIA item type [OIA_UPEITM]
    BUKRS,       -- Company Code [BUKRS]
    EXGTYP,      -- Exchange type [OIA_EXGTYP]
    EXGNUM,      -- Exchange no. [OIA_EXGNUM]
    WERKS,       -- Plant [WERKS_D]
    MATNR,       -- Material [MATNR]
    MEINS,       -- LIA trans. UoM [OIA_TMEINS]
    MENGE,       -- Quantity [OIA_MENGE]
    SKMEINS,     -- Stock UoM [OIA_SKMNS]
    SKMENGE,     -- Qty in ST.UoM [OIA_SKMNG]
    BLDAT,       -- Document Date [BLDAT]
    BUDAT,       -- Posting Date [BUDAT]
    WAERS,       -- Currency [WAERS]
    PYMT,        -- LIA pyt amt. [OIA_PYMT]
    ZTERM,       -- Pyt Terms [DZTERM]
    ZLSPR,       -- Payment Block [DZAHLS]
    CVIND,       -- Cust/vend.ind [OIA_CVIND]
    VKORG,       -- Sales Org. [VKORG]
    EKORG,       -- Purchasing Org. [EKORG]
    TAXCD,       -- Tax Code [MWSKZ]
    SGTXT,       -- Text [SGTXT]
    NEGADJ,      -- Neg. adjustment [OIA_NEGADJ]
    SUBPROD,     -- Sub product no. [OIA_SUBPRD]
    OICYCLE,     -- Invoice cycle [OIA_INVCYC]
    OID_EXTBOL,  -- Extern.BOL no. [OID_EXTBOL]
    LIA_DMBTR,   -- LIA valua [OIA_LIA_DMBTR]
    MATPST,      -- Mat.posting [OIA_MATPST]
    KTOSL,       -- Process key [OIA_KTOSL]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, UPENUM, MJAHR, SEGNUM, ITEM_TYPE)
);

Learn More