OIJBRD

Transparent Table Application Table
38 Fields 1 CDS Views

OIL-TSW: Rundown table for Batch

OIJBRD is an SAP database table in S/4HANA. OIL-TSW: Rundown table for Batch. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_TSWRundownBatch view_entity from BASIC Rundown table for Batch

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tsyst OIJ_TSYST Trans system
KEY locid OIJ_LOCID Location ID
KEY matnr MATNR Material
KEY charg OIJ_CHARG Batch / Val.
KEY datum OIJ_RDDAT SP item date
plann OIJ_PLANN Planned inv.
base OIJ_BASE Base invent.
rprod OIJ_RPROD Production qty.
rmrp OIJ_RMRP Prop.Receipts
rwhif OIJ_RWHIF "What if" rec
rdoc OIJ_RDOC Doc.qty.receipt
rsched OIJ_RSCHED Scheduled rec.
ract OIJ_RACT Actual rec.
imrp OIJ_IMRP Prop.issues
iwhif OIJ_IWHIF What-if issues
idoc OIJ_IDOC Doc.qty.issues
isched OIJ_ISCHED Scheduled iss.
iact OIJ_IACT Actual iss.
ifcast OIJ_IFCAST Forecast rack
icorr OIJ_ICORR Correct. rack
iract OIJ_IRACT Act. rack iss.
worklist OIJ_WORKLT Worklist indic.
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By
bloind OIJ_BLOIND Blocking ind.
delind OIJ_DELIND Deletion ind.
tktselect OIJ_TKTSELECT Flag to Select Tkt
phy_inv OIJ_PHY_INV Physical inv.
mifcast OIJ_MIFCAST Forecast rack
rvp OIJ_RVP RVP
uncomm OIJ_UNCOMM Uncomm. inventory
apodp OIJ_APODP Dem.Plan.Bulk forec.
iprod OIJ_IPROD Inverse Prod

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.

-- OIL-TSW: Rundown table for Batch
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJBRD (
    MANDT,      -- Client [MANDT]
    TSYST,      -- Trans system [OIJ_TSYST]
    LOCID,      -- Location ID [OIJ_LOCID]
    MATNR,      -- Material [MATNR]
    CHARG,      -- Batch / Val. [OIJ_CHARG]
    DATUM,      -- SP item date [OIJ_RDDAT]
    PLANN,      -- Planned inv. [OIJ_PLANN]
    BASE,       -- Base invent. [OIJ_BASE]
    RPROD,      -- Production qty. [OIJ_RPROD]
    RMRP,       -- Prop.Receipts [OIJ_RMRP]
    RWHIF,      -- "What if" rec [OIJ_RWHIF]
    RDOC,       -- Doc.qty.receipt [OIJ_RDOC]
    RSCHED,     -- Scheduled rec. [OIJ_RSCHED]
    RACT,       -- Actual rec. [OIJ_RACT]
    IMRP,       -- Prop.issues [OIJ_IMRP]
    IWHIF,      -- What-if issues [OIJ_IWHIF]
    IDOC,       -- Doc.qty.issues [OIJ_IDOC]
    ISCHED,     -- Scheduled iss. [OIJ_ISCHED]
    IACT,       -- Actual iss. [OIJ_IACT]
    IFCAST,     -- Forecast rack [OIJ_IFCAST]
    ICORR,      -- Correct. rack [OIJ_ICORR]
    IRACT,      -- Act. rack iss. [OIJ_IRACT]
    WORKLIST,   -- Worklist indic. [OIJ_WORKLT]
    ERDAT,      -- Created On [ERDAT]
    ERZEIT,     -- Created [OI0_ERTIM]
    ERNAM,      -- Created By [ERNAM]
    AEDAT,      -- Changed On [AEDAT]
    AEZEIT,     -- Changed [OI0_AETIM]
    AENAM,      -- Changed By [AENAM]
    BLOIND,     -- Blocking ind. [OIJ_BLOIND]
    DELIND,     -- Deletion ind. [OIJ_DELIND]
    TKTSELECT,  -- Flag to Select Tkt [OIJ_TKTSELECT]
    PHY_INV,    -- Physical inv. [OIJ_PHY_INV]
    MIFCAST,    -- Forecast rack [OIJ_MIFCAST]
    RVP,        -- RVP [OIJ_RVP]
    UNCOMM,     -- Uncomm. inventory [OIJ_UNCOMM]
    APODP,      -- Dem.Plan.Bulk forec. [OIJ_APODP]
    IPROD,      -- Inverse Prod [OIJ_IPROD]
    PRIMARY KEY (MANDT, TSYST, LOCID, MATNR, CHARG, DATUM)
);

Learn More