SUP_PCP

Transparent Table Application Table
13 Fields 2 CDS Views

SUP Permanent Consumed Protection

SUP_PCP is an SAP database table in S/4HANA. SUP Permanent Consumed Protection. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SupProtPermConsumption view_entity from BASIC Supply Protection Perm Consumed Prot
I_SupProtTimeBucketSum view_entity from BASIC Supply Protection Time Bucket Sum

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY uuid SUP_PERM_CONSUMPTION_UUID Perm.Cons.Prot. UUID
timebucketuuid SUP_TIMEBUCKET_UUID Time Bucket UUID
documenttype SUP_DOCUMENT_TYPE Document Type
documentid SUP_DOCUMENT_ID Document ID
documentitemid SUP_DOCUMENT_ITEM_ID Document Item ID
consumedquantity SUP_CONSUMED_QUANTITY Consumed Quantity
consumedquantityunit SUP_CONSUMED_QUANTITY_UNIT Unit for Cons. Prot.
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
delet DELET Scheduling

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.

-- SUP Permanent Consumed Protection
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SUP_PCP (
    CLIENT,                -- Client [MANDT]
    UUID,                  -- Perm.Cons.Prot. UUID [SUP_PERM_CONSUMPTION_UUID]
    TIMEBUCKETUUID,        -- Time Bucket UUID [SUP_TIMEBUCKET_UUID]
    DOCUMENTTYPE,          -- Document Type [SUP_DOCUMENT_TYPE]
    DOCUMENTID,            -- Document ID [SUP_DOCUMENT_ID]
    DOCUMENTITEMID,        -- Document Item ID [SUP_DOCUMENT_ITEM_ID]
    CONSUMEDQUANTITY,      -- Consumed Quantity [SUP_CONSUMED_QUANTITY]
    CONSUMEDQUANTITYUNIT,  -- Unit for Cons. Prot. [SUP_CONSUMED_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]
    DELET,                 -- Scheduling [DELET]
    PRIMARY KEY (CLIENT, UUID)
);

Learn More