OIA12

Transparent Table Application Table
22 Fields 1 CDS Views

Exchange assignment for bulk shipments

OIA12 is an SAP database table in S/4HANA. Exchange assignment for bulk shipments. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_ExchShipmentAssignment view_entity from BASIC Exchange Assignment for bulk shipments

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY shnum OIG_SHNUM Bulk shipment
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY charg CHARG_D Batch
KEY seqnr OIA_SEQNR Sequence.no.
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
asqty OIA_ASQTY Assigned qty.
shuom OIG_SHUOM Shipment UoM
menge MENGE_D Quantity
meins MEINS Base Unit
subitm OIA_SUBITM Sub item no.
seqent OIA_SEQENT Sequent.no.
oiexgnum OIA_EXGNUM Exchange no.
mblnr MBLNR Material Doc.
mjahr MJAHR Mat. Doc. Year
zeile DZEILE Item
lgort LGORT_D Location
exast OIA_EXAST Assignmnt. type
wo_qs OIAWO_QS Without QSched.
_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.

-- Exchange assignment for bulk shipments
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIA12 (
    MANDT,       -- Client [MANDT]
    SHNUM,       -- Bulk shipment [OIG_SHNUM]
    MATNR,       -- Material [MATNR]
    WERKS,       -- Plant [WERKS_D]
    CHARG,       -- Batch [CHARG_D]
    SEQNR,       -- Sequence.no. [OIA_SEQNR]
    EBELN,       -- Purchasing Doc. [EBELN]
    EBELP,       -- Item [EBELP]
    ASQTY,       -- Assigned qty. [OIA_ASQTY]
    SHUOM,       -- Shipment UoM [OIG_SHUOM]
    MENGE,       -- Quantity [MENGE_D]
    MEINS,       -- Base Unit [MEINS]
    SUBITM,      -- Sub item no. [OIA_SUBITM]
    SEQENT,      -- Sequent.no. [OIA_SEQENT]
    OIEXGNUM,    -- Exchange no. [OIA_EXGNUM]
    MBLNR,       -- Material Doc. [MBLNR]
    MJAHR,       -- Mat. Doc. Year [MJAHR]
    ZEILE,       -- Item [DZEILE]
    LGORT,       -- Location [LGORT_D]
    EXAST,       -- Assignmnt. type [OIA_EXAST]
    WO_QS,       -- Without QSched. [OIAWO_QS]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, SHNUM, MATNR, WERKS, CHARG, SEQNR)
);

Learn More