OIAQB

Transparent Table Application Table
68 Fields 1 CDS Views

Exchange Movements Index

OIAQB is an SAP database table in S/4HANA. Exchange Movements Index. It contains 68 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_ExchangeMovementIndex view_entity from BASIC Exchange Movement Index

Fields (68)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY oiexgptr OIA_EXGPTR Exg.partner
KEY budat BUDAT Posting Date
KEY spmon SPMON Month
KEY sptag SPTAG Date
KEY spwoc SPWOC Week
KEY spbup SPBUP Period
KEY oiexgnum OIA_EXGNUM Exchange no.
KEY oiexgtyp OIA_EXGTYP Exchange type
KEY oimatref OIA_MATREF Mat grp ref.
KEY matnr MATNR Material
KEY oibasprod OIA_SBMAT Base prod.no
KEY werks WERKS_D Plant
KEY mblnr MBLNR Material Doc.
KEY mjahr MJAHR Mat. Doc. Year
KEY zeile OIA_ITEM Item no.
item_type OIA_UPEITM LIA item type
oinetcyc OIA_NETCYC Netting cycle
shkzg SHKZG Debit/Credit
oiastbw XSTBW RevMvmtTypeInd.
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
oivbeln VBELN_VL Delivery
oiposnr POSNR_VL Item
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
clrno OIA_CLRNO Clearng.doc.no.
oipipeval OID_PIPEV Pipel.val.ind.
oic_lifnr LIFNR Supplier
oic_dcityc OIC_DCITYC Dest.city code
oic_dcounc OIC_DCOUNC Dest.county
oic_dregio OIC_DREGIO Dest.region
oic_dland1 OIC_DLAND1 Destin.C/R
oic_ocityc OIC_OCITYC Origin (city)
oic_ocounc OIC_OCOUNC Orig.county
oic_oregio OIC_OREGIO Orig.region
oic_oland1 OIC_OLAND1 Origin
oic_porgin OIC_PORGIN Tax origin
oic_pdestn OIC_PDESTN Tax destin.
oic_ptrip OIC_PTRIP Pipe trip no.
oic_pbatch OIC_PBATCH Pipe batch no.
oic_mot OIC_MOT Mode of transp.
oic_aorgin OIC_AORGIN Altern.origin
oic_adestn OIC_ADESTN Altern.destn.
oic_truckn OIC_TRUCKN Truck no.
oia_baselo OIA_BASELO Base location
clrno1 OIA_CLRNO Clearng.doc.no.
clrno2 OIA_CLRNO Clearng.doc.no.
clrno3 OIA_CLRNO Clearng.doc.no.
clrno4 OIA_CLRNO Clearng.doc.no.
clrno5 OIA_CLRNO Clearng.doc.no.
clrno6 OIA_CLRNO Clearng.doc.no.
clrno7 OIA_CLRNO Clearng.doc.no.
clrno8 OIA_CLRNO Clearng.doc.no.
clrno9 OIA_CLRNO Clearng.doc.no.
pdummy DUMMY Dummy function in length 1
oid_extbol OID_EXTBOL Extern.BOL no.
oid_miscdl OID_MISCDL Miscell.del.no.
nocyc1 OIA_NOCYC Cyc. not used
nocyc2 OIA_NOCYC Cyc. not used
nocyc3 OIA_NOCYC Cyc. not used
nocyc4 OIA_NOCYC Cyc. not used
nocyc5 OIA_NOCYC Cyc. not used
nocyc6 OIA_NOCYC Cyc. not used
nocyc7 OIA_NOCYC Cyc. not used
nocyc8 OIA_NOCYC Cyc. not used
nocyc9 OIA_NOCYC Cyc. not used
_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 Movements Index
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIAQB (
    MANDT,       -- Client [MANDT]
    OIEXGPTR,    -- Exg.partner [OIA_EXGPTR]
    BUDAT,       -- Posting Date [BUDAT]
    SPMON,       -- Month [SPMON]
    SPTAG,       -- Date [SPTAG]
    SPWOC,       -- Week [SPWOC]
    SPBUP,       -- Period [SPBUP]
    OIEXGNUM,    -- Exchange no. [OIA_EXGNUM]
    OIEXGTYP,    -- Exchange type [OIA_EXGTYP]
    OIMATREF,    -- Mat grp ref. [OIA_MATREF]
    MATNR,       -- Material [MATNR]
    OIBASPROD,   -- Base prod.no [OIA_SBMAT]
    WERKS,       -- Plant [WERKS_D]
    MBLNR,       -- Material Doc. [MBLNR]
    MJAHR,       -- Mat. Doc. Year [MJAHR]
    ZEILE,       -- Item no. [OIA_ITEM]
    ITEM_TYPE,   -- LIA item type [OIA_UPEITM]
    OINETCYC,    -- Netting cycle [OIA_NETCYC]
    SHKZG,       -- Debit/Credit [SHKZG]
    OIASTBW,     -- RevMvmtTypeInd. [XSTBW]
    EBELN,       -- Purchasing Doc. [EBELN]
    EBELP,       -- Item [EBELP]
    OIVBELN,     -- Delivery [VBELN_VL]
    OIPOSNR,     -- Item [POSNR_VL]
    KDAUF,       -- Sales Order [KDAUF]
    KDPOS,       -- Sales Ord. Item [KDPOS]
    CLRNO,       -- Clearng.doc.no. [OIA_CLRNO]
    OIPIPEVAL,   -- Pipel.val.ind. [OID_PIPEV]
    OIC_LIFNR,   -- Supplier [LIFNR]
    OIC_DCITYC,  -- Dest.city code [OIC_DCITYC]
    OIC_DCOUNC,  -- Dest.county [OIC_DCOUNC]
    OIC_DREGIO,  -- Dest.region [OIC_DREGIO]
    OIC_DLAND1,  -- Destin.C/R [OIC_DLAND1]
    OIC_OCITYC,  -- Origin (city) [OIC_OCITYC]
    OIC_OCOUNC,  -- Orig.county [OIC_OCOUNC]
    OIC_OREGIO,  -- Orig.region [OIC_OREGIO]
    OIC_OLAND1,  -- Origin [OIC_OLAND1]
    OIC_PORGIN,  -- Tax origin [OIC_PORGIN]
    OIC_PDESTN,  -- Tax destin. [OIC_PDESTN]
    OIC_PTRIP,   -- Pipe trip no. [OIC_PTRIP]
    OIC_PBATCH,  -- Pipe batch no. [OIC_PBATCH]
    OIC_MOT,     -- Mode of transp. [OIC_MOT]
    OIC_AORGIN,  -- Altern.origin [OIC_AORGIN]
    OIC_ADESTN,  -- Altern.destn. [OIC_ADESTN]
    OIC_TRUCKN,  -- Truck no. [OIC_TRUCKN]
    OIA_BASELO,  -- Base location [OIA_BASELO]
    CLRNO1,      -- Clearng.doc.no. [OIA_CLRNO]
    CLRNO2,      -- Clearng.doc.no. [OIA_CLRNO]
    CLRNO3,      -- Clearng.doc.no. [OIA_CLRNO]
    CLRNO4,      -- Clearng.doc.no. [OIA_CLRNO]
    CLRNO5,      -- Clearng.doc.no. [OIA_CLRNO]
    CLRNO6,      -- Clearng.doc.no. [OIA_CLRNO]
    CLRNO7,      -- Clearng.doc.no. [OIA_CLRNO]
    CLRNO8,      -- Clearng.doc.no. [OIA_CLRNO]
    CLRNO9,      -- Clearng.doc.no. [OIA_CLRNO]
    PDUMMY,      -- Dummy function in length 1 [DUMMY]
    OID_EXTBOL,  -- Extern.BOL no. [OID_EXTBOL]
    OID_MISCDL,  -- Miscell.del.no. [OID_MISCDL]
    NOCYC1,      -- Cyc. not used [OIA_NOCYC]
    NOCYC2,      -- Cyc. not used [OIA_NOCYC]
    NOCYC3,      -- Cyc. not used [OIA_NOCYC]
    NOCYC4,      -- Cyc. not used [OIA_NOCYC]
    NOCYC5,      -- Cyc. not used [OIA_NOCYC]
    NOCYC6,      -- Cyc. not used [OIA_NOCYC]
    NOCYC7,      -- Cyc. not used [OIA_NOCYC]
    NOCYC8,      -- Cyc. not used [OIA_NOCYC]
    NOCYC9,      -- Cyc. not used [OIA_NOCYC]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, OIEXGPTR, BUDAT, SPMON, SPTAG, SPWOC, SPBUP, OIEXGNUM, OIEXGTYP, OIMATREF, MATNR, OIBASPROD, WERKS, MBLNR, MJAHR, ZEILE)
);

Learn More