R_PURCHASEORDERPARTNER

CDS View

Purchase Order Partner

R_PURCHASEORDERPARTNER is a CDS View in S/4HANA. Purchase Order Partner. It contains 23 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_PurOrderPartnerFactSheet view from CONSUMPTION Purchase Order Partner Fact Sheet
I_PurchaseOrderPartnerTP view from TRANSACTIONAL Purchase Order Partner - TP
R_PurchaseOrderPartnerTP view_entity from TRANSACTIONAL Purchase Order Partner TP View

Fields (23)

KeyField CDS FieldsUsed in Views
KEY PartnerCounter PartnerCounter 3
KEY PartnerFunction PartnerFunction,PartnerFunctionForEdit 3
KEY Plant Plant 3
KEY PurchaseOrder PurchaseOrder 3
KEY PurchasingOrganization PurchasingOrganization 3
KEY SupplierSubrange SupplierSubrange 3
_PartnerFunction _PartnerFunction 3
_PartnerFunctionText _PartnerFunctionText 3
_PersonWorkAgreement _PersonWorkAgreement 3
_Plant _Plant 3
_PurchaseOrder _PurchaseOrder 1
_PurchasingOrganization _PurchasingOrganization 3
_Supplier _Supplier 3
_SupplierContact _SupplierContact 3
CreatedByUser CreatedByUser 3
CreationDate CreationDate 3
DefaultPartner DefaultPartner 3
EmploymentInternalID EmploymentInternalID 2
PersonWorkAgreement PersonWorkAgreement 3
PurchasingDocumentPartnerType PurchasingDocumentPartnerType 3
Supplier Supplier 3
SupplierContact SupplierContact 3
SupplierHierarchyCategory SupplierHierarchyCategory 3

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.

-- Purchase Order Partner
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PURCHASEORDERPARTNER (
    PARTNERCOUNTER,
    PARTNERFUNCTION,
    PLANT,
    PURCHASEORDER,
    PURCHASINGORGANIZATION,
    SUPPLIERSUBRANGE,
    _PARTNERFUNCTION,
    _PARTNERFUNCTIONTEXT,
    _PERSONWORKAGREEMENT,
    _PLANT,
    _PURCHASEORDER,
    _PURCHASINGORGANIZATION,
    _SUPPLIER,
    _SUPPLIERCONTACT,
    CREATEDBYUSER,
    CREATIONDATE,
    DEFAULTPARTNER,
    EMPLOYMENTINTERNALID,
    PERSONWORKAGREEMENT,
    PURCHASINGDOCUMENTPARTNERTYPE,
    SUPPLIER,
    SUPPLIERCONTACT,
    SUPPLIERHIERARCHYCATEGORY,
    PRIMARY KEY (PARTNERCOUNTER, PARTNERFUNCTION, PLANT, PURCHASEORDER, PURCHASINGORGANIZATION, SUPPLIERSUBRANGE)
);