PPS_PO_PRTN_D

Transparent Table Application Table
39 Fields 1 CDS Views

Draft table for entity R_PPS_PURCHASEORDERPARTNERTP

PPS_PO_PRTN_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCHASEORDERPARTNERTP. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurOrdPrtnDrft view_entity from BASIC Purchase Order Partner - Draft

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchaseorder EBELN Purchasing Doc.
KEY partnerfunction PARVW_UNV Partner Funct.
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
suppliersubrange LTSNR Suppl. Subrange
plant WERKS_D Plant
purchasingorganization EKORG Purchasing Org.
partnercounter PARZA Partner counter
createdbyuser ERNAM Created By
creationdate ERDAT Created On
purchasingdocumentpartnertype NRART Partner Type
supplier LIFNR Supplier
supplierhierarchycategory HITYP_LH Hierarchy Cat.
suppliercontact PARNR Contact Person
personworkagreement PERNR_D Personnel No.
employmentinternalid PERNR_D Personnel No.
defaultpartner DEFPA Default Partner
partnerfunctionforedit PARVW_UNV Partner Funct.
partnerfunctionname VTXTK Name
purchasingdocumentpartner MM_PUR_PARTNER Partner
purchasingdocumentpartnername MM_PUR_PARTNERNAME Partner Name
streetname AD_STREET Street
housenumber AD_HSNM1 House Number
postalcode AD_PSTCD1 Postal Code
cityname AD_CITY1 City
country LAND1 Country/Reg.
countycode AD_CNTYNUM County code
region REGIO Region
phonenumber AD_TLNMBR1 Telephone
faxnumber AD_FXNMBR1 Fax
emailaddress AD_SMTPADR E-Mail Address
ppsfieldchangeindicatorbinary PPS_E_CONTROL_FLAG Control
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field 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_PURCHASEORDERPARTNERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PO_PRTN_D (
    MANDT,                          -- Client [MANDT]
    PURCHASEORDER,                  -- Purchasing Doc. [EBELN]
    PARTNERFUNCTION,                -- Partner Funct. [PARVW_UNV]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    SUPPLIERSUBRANGE,               -- Suppl. Subrange [LTSNR]
    PLANT,                          -- Plant [WERKS_D]
    PURCHASINGORGANIZATION,         -- Purchasing Org. [EKORG]
    PARTNERCOUNTER,                 -- Partner counter [PARZA]
    CREATEDBYUSER,                  -- Created By [ERNAM]
    CREATIONDATE,                   -- Created On [ERDAT]
    PURCHASINGDOCUMENTPARTNERTYPE,  -- Partner Type [NRART]
    SUPPLIER,                       -- Supplier [LIFNR]
    SUPPLIERHIERARCHYCATEGORY,      -- Hierarchy Cat. [HITYP_LH]
    SUPPLIERCONTACT,                -- Contact Person [PARNR]
    PERSONWORKAGREEMENT,            -- Personnel No. [PERNR_D]
    EMPLOYMENTINTERNALID,           -- Personnel No. [PERNR_D]
    DEFAULTPARTNER,                 -- Default Partner [DEFPA]
    PARTNERFUNCTIONFOREDIT,         -- Partner Funct. [PARVW_UNV]
    PARTNERFUNCTIONNAME,            -- Name [VTXTK]
    PURCHASINGDOCUMENTPARTNER,      -- Partner [MM_PUR_PARTNER]
    PURCHASINGDOCUMENTPARTNERNAME,  -- Partner Name [MM_PUR_PARTNERNAME]
    STREETNAME,                     -- Street [AD_STREET]
    HOUSENUMBER,                    -- House Number [AD_HSNM1]
    POSTALCODE,                     -- Postal Code [AD_PSTCD1]
    CITYNAME,                       -- City [AD_CITY1]
    COUNTRY,                        -- Country/Reg. [LAND1]
    COUNTYCODE,                     -- County code [AD_CNTYNUM]
    REGION,                         -- Region [REGIO]
    PHONENUMBER,                    -- Telephone [AD_TLNMBR1]
    FAXNUMBER,                      -- Fax [AD_FXNMBR1]
    EMAILADDRESS,                   -- E-Mail Address [AD_SMTPADR]
    PPSFIELDCHANGEINDICATORBINARY,  -- Control [PPS_E_CONTROL_FLAG]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PURCHASEORDER, PARTNERFUNCTION, DRAFTUUID)
);

Learn More