PMRP_SOS_INPUT

Transparent Table Application Table
15 Fields 4 CDS Views

pMRP Source of Supply Input

PMRP_SOS_INPUT is an SAP database table in S/4HANA. pMRP Source of Supply Input. It contains 15 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
DDL_PMRP_Prod_Rel view left_outer
DDL_PMRP_Prod_Rel view inner
DDL_PMRP_SoS_Flat view left_outer
I_PMRPSourceOfSupplyInput view from BASIC A Source Of Supply Input in pMRP

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY reference_id PMRP_REFERENCE_ID Reference Data
KEY sos_id PMRP_SOS_ID Source of Supply ID
KEY sos_item_id PMRP_SOS_ITEM_ID SoS Item ID
valid_from DATUV Valid From
valid_to DATUB to
input_product MATNR Material
input_plant WERKS_D Plant
input_mrparea BERID MRP Area
input_category PMRP_ORDER_CATEGORY Order Category
input_quantity KMPMG Quantity
input_uom KMPME Component UoM
offset_cal_days PMRP_OFFSET_CAL_DAYS Offset in Cal Days
offset_work_days PMRP_OFFSET_WORK_DAYS Work Days
is_cycle REKRI Recursive

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.

-- pMRP Source of Supply Input
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_SOS_INPUT (
    MANDT,             -- Client [MANDT]
    REFERENCE_ID,      -- Reference Data [PMRP_REFERENCE_ID]
    SOS_ID,            -- Source of Supply ID [PMRP_SOS_ID]
    SOS_ITEM_ID,       -- SoS Item ID [PMRP_SOS_ITEM_ID]
    VALID_FROM,        -- Valid From [DATUV]
    VALID_TO,          -- to [DATUB]
    INPUT_PRODUCT,     -- Material [MATNR]
    INPUT_PLANT,       -- Plant [WERKS_D]
    INPUT_MRPAREA,     -- MRP Area [BERID]
    INPUT_CATEGORY,    -- Order Category [PMRP_ORDER_CATEGORY]
    INPUT_QUANTITY,    -- Quantity [KMPMG]
    INPUT_UOM,         -- Component UoM [KMPME]
    OFFSET_CAL_DAYS,   -- Offset in Cal Days [PMRP_OFFSET_CAL_DAYS]
    OFFSET_WORK_DAYS,  -- Work Days [PMRP_OFFSET_WORK_DAYS]
    IS_CYCLE,          -- Recursive [REKRI]
    PRIMARY KEY (MANDT, REFERENCE_ID, SOS_ID, SOS_ITEM_ID)
);

Learn More