SUP_ROP_SIM_DTLS

Transparent Table Application Table
19 Fields 1 CDS Views

Resolve Overprotections Simulation Details

SUP_ROP_SIM_DTLS is an SAP database table in S/4HANA. Resolve Overprotections Simulation Details. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SupProtRstrcdProdSimlnDet view_entity from BASIC SUP Restricted Product Smltn Details

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY checkresultuuid SUP_ROP_CHECK_RESULT_UUID Check Result UUID
KEY supplyprotectionuuid SUP_OBJECT_UUID UUID
KEY supplyprotectiongroupuuid SUP_CVC_UUID CVC UUID
supprotprotectedquantity SUP_PROTECTED_QUANTITY Protected Quantity
supprotconsumedquantity SUP_CONSUMED_QUANTITY Consumed Quantity
supprotremainingprotectedqty SUP_REMAINING_QUANTITY Remaining Protection
supprotavailablequantity SUP_ROP_AVAILABLE_QUANTITY Available Quantity
supprotrestrictedquantity SUP_RESTRICTED_QUANTITY Restricted Quantity
reductionpercentage SUP_ROP_REDUCTION_PERCENTAGE Reduction Percentage
supprotsmltdprotectedqty SUP_ROP_SIM_PROTECTED_QTY Simulated Protected Quantity
supprotsmltdrmngprotectedqty SUP_ROP_SIM_REMAINING_QTY Simulated Remaining Protection
supprotsmltdavailableqty SUP_ROP_SIM_AVAILABLE_QTY Simulated Available Quantity
supprotsmltdrestrictedqty SUP_ROP_SIM_RESTRICTED_QTY Simulated Restricted Quantity
unitofmeasure SUP_PROTECTED_QUANTITY_UNIT Unit Protected Qty
creationdatetime SUP_CREATION_DATE_TIME Created On / At
createdbyuser VDM_CREATEDBYUSERID Created By
lastchangedatetime SUP_LAST_CHANGE_DATE_TIME Changed On / At
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By

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.

-- Resolve Overprotections Simulation Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SUP_ROP_SIM_DTLS (
    CLIENT,                        -- abap.clnt
    CHECKRESULTUUID,               -- Check Result UUID [SUP_ROP_CHECK_RESULT_UUID]
    SUPPLYPROTECTIONUUID,          -- UUID [SUP_OBJECT_UUID]
    SUPPLYPROTECTIONGROUPUUID,     -- CVC UUID [SUP_CVC_UUID]
    SUPPROTPROTECTEDQUANTITY,      -- Protected Quantity [SUP_PROTECTED_QUANTITY]
    SUPPROTCONSUMEDQUANTITY,       -- Consumed Quantity [SUP_CONSUMED_QUANTITY]
    SUPPROTREMAININGPROTECTEDQTY,  -- Remaining Protection [SUP_REMAINING_QUANTITY]
    SUPPROTAVAILABLEQUANTITY,      -- Available Quantity [SUP_ROP_AVAILABLE_QUANTITY]
    SUPPROTRESTRICTEDQUANTITY,     -- Restricted Quantity [SUP_RESTRICTED_QUANTITY]
    REDUCTIONPERCENTAGE,           -- Reduction Percentage [SUP_ROP_REDUCTION_PERCENTAGE]
    SUPPROTSMLTDPROTECTEDQTY,      -- Simulated Protected Quantity [SUP_ROP_SIM_PROTECTED_QTY]
    SUPPROTSMLTDRMNGPROTECTEDQTY,  -- Simulated Remaining Protection [SUP_ROP_SIM_REMAINING_QTY]
    SUPPROTSMLTDAVAILABLEQTY,      -- Simulated Available Quantity [SUP_ROP_SIM_AVAILABLE_QTY]
    SUPPROTSMLTDRESTRICTEDQTY,     -- Simulated Restricted Quantity [SUP_ROP_SIM_RESTRICTED_QTY]
    UNITOFMEASURE,                 -- Unit Protected Qty [SUP_PROTECTED_QUANTITY_UNIT]
    CREATIONDATETIME,              -- Created On / At [SUP_CREATION_DATE_TIME]
    CREATEDBYUSER,                 -- Created By [VDM_CREATEDBYUSERID]
    LASTCHANGEDATETIME,            -- Changed On / At [SUP_LAST_CHANGE_DATE_TIME]
    LASTCHANGEDBYUSER,             -- Changed By [VDM_LASTCHANGEDBYUSERID]
    PRIMARY KEY (CLIENT, CHECKRESULTUUID, SUPPLYPROTECTIONUUID, SUPPLYPROTECTIONGROUPUUID)
);

Learn More