PPS_PO_ITM_PTR_D

Transparent Table Application Table

Draft table for entity R_PPS_PURORDERITEMPARTNERTP

PPS_PO_ITM_PTR_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURORDERITEMPARTNERTP. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurOrdItmPartnerDraft view_entity from BASIC PPS PO Item Partner - Text

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchaseorder EBELN Purchasing Doc.
KEY purchaseorderitem EBELP Item
KEY purchasingorganization EKORG Purchasing Org.
KEY suppliersubrange LTSNR Suppl. Subrange
KEY plant WERKS_D Plant
KEY partnerfunction PARVW_UNV Partner Funct.
KEY partnercounter PARZA Partner counter
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
partnertype NRART Partner Type
supplier LIFNR Supplier
suppliercontact PARNR Contact Person
defaultpartner DEFPA Default Partner
partnerfunctionforedit PARVW_UNV Partner Funct.
purchasingdocumentpartnername MM_PUR_PARTNERNAME Partner Name
purchasingdocumentpartner MM_PUR_PARTNER Partner
ppsfieldchangeindicatorbinary PPS_E_CONTROL_FLAG Control
createdbyuser ERNAM Created By
creationdate ERDAT Created On
purgconfigurableitemnumber EXLIN Hierarchy Number
purchasingdocumenttype ESART Document Type
companycode BUKRS Company Code
material MATNR Material
purchaseorderdraftuuid SDRAFT_UUID Draft Document ID
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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_PURORDERITEMPARTNERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PO_ITM_PTR_D (
    MANDT,                          -- Client [MANDT]
    PURCHASEORDER,                  -- Purchasing Doc. [EBELN]
    PURCHASEORDERITEM,              -- Item [EBELP]
    PURCHASINGORGANIZATION,         -- Purchasing Org. [EKORG]
    SUPPLIERSUBRANGE,               -- Suppl. Subrange [LTSNR]
    PLANT,                          -- Plant [WERKS_D]
    PARTNERFUNCTION,                -- Partner Funct. [PARVW_UNV]
    PARTNERCOUNTER,                 -- Partner counter [PARZA]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    PARTNERTYPE,                    -- Partner Type [NRART]
    SUPPLIER,                       -- Supplier [LIFNR]
    SUPPLIERCONTACT,                -- Contact Person [PARNR]
    DEFAULTPARTNER,                 -- Default Partner [DEFPA]
    PARTNERFUNCTIONFOREDIT,         -- Partner Funct. [PARVW_UNV]
    PURCHASINGDOCUMENTPARTNERNAME,  -- Partner Name [MM_PUR_PARTNERNAME]
    PURCHASINGDOCUMENTPARTNER,      -- Partner [MM_PUR_PARTNER]
    PPSFIELDCHANGEINDICATORBINARY,  -- Control [PPS_E_CONTROL_FLAG]
    CREATEDBYUSER,                  -- Created By [ERNAM]
    CREATIONDATE,                   -- Created On [ERDAT]
    PURGCONFIGURABLEITEMNUMBER,     -- Hierarchy Number [EXLIN]
    PURCHASINGDOCUMENTTYPE,         -- Document Type [ESART]
    COMPANYCODE,                    -- Company Code [BUKRS]
    MATERIAL,                       -- Material [MATNR]
    PURCHASEORDERDRAFTUUID,         -- Draft Document ID [SDRAFT_UUID]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PURCHASEORDER, PURCHASEORDERITEM, PURCHASINGORGANIZATION, SUPPLIERSUBRANGE, PLANT, PARTNERFUNCTION, PARTNERCOUNTER, DRAFTUUID)
);