PPS_POITM_NOTE_D

Transparent Table Application Table

Draft table for entity R_PPS_PURCHASEORDERITEMNOTETP

PPS_POITM_NOTE_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCHASEORDERITEMNOTETP. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurOrdItmNoteDrft view_entity from BASIC Purchase Order Item Note - Draft

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchaseorder vdm_purchaseorder Purchase Order
KEY purchaseorderitem vdm_purchaseorderitem Purchase Order Item
KEY textobjecttype tdid Text ID
KEY language spras Language
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
purchaseorderitemuniqueid purchasingdocumentitemuniqueid Document Item
plainlongtext esh_e_sr_longtext Long Text
ppsfieldchangeindicatorbinary pps_e_control_flag Control
purchaseorderdraftuuid sdraft_uuid Draft Document ID

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.

-- Draft table for entity R_PPS_PURCHASEORDERITEMNOTETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_POITM_NOTE_D (
    MANDT,                          -- Client [mandt]
    PURCHASEORDER,                  -- Purchase Order [vdm_purchaseorder]
    PURCHASEORDERITEM,              -- Purchase Order Item [vdm_purchaseorderitem]
    TEXTOBJECTTYPE,                 -- Text ID [tdid]
    LANGUAGE,                       -- Language [spras]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                -- Draft Document ID [sdraft_uuid]
    PURCHASEORDERITEMUNIQUEID,      -- Document Item [purchasingdocumentitemuniqueid]
    PLAINLONGTEXT,                  -- Long Text [esh_e_sr_longtext]
    PPSFIELDCHANGEINDICATORBINARY,  -- Control [pps_e_control_flag]
    PURCHASEORDERDRAFTUUID,         -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, PURCHASEORDER, PURCHASEORDERITEM, TEXTOBJECTTYPE, LANGUAGE, DRAFTUUID)
);