SUP_PCP

Transparent Table Application Table

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)
);