I_PPS_PURCHASECONTRACT

CDS View
18 Fields 3 CDS Views

Purchase order with PPS document types

I_PPS_PURCHASECONTRACT is a CDS View in S/4HANA. Purchase order with PPS document types. It contains 18 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PPS_PurchaseReqnSOSContract view_entity inner COMPOSITE PPS Contracts for PurReqn Assign SOS
I_PPS_PurReqnProcessFlow view_entity inner COMPOSITE Interface for PPS Process Flow
R_PPS_PurContrPendingNovation view_entity from COMPOSITE Purchase Contract Pending for Novation

Fields (18)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PPSPurgDocNumber 1
_Extension _Extension 1
_PurchasingDocumentCategory _PurchasingDocumentCategory 1
CompanyCode CompanyCode 2
DocumentCurrency DocumentCurrency 2
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentName PurchasingDocumentDescription,PurchasingDocumentName 2
PurchasingDocumentOrigin PurchasingDocumentOrigin 1
PurchasingDocumentType PurchaseContractType,PurchasingDocumentType 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
PurgDocChangeRequestStatus PurgDocChangeRequestStatus 1
Supplier Supplier 2
TargetAmount PurchaseContractTargetAmount 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1

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 with PPS document types
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PPS_PURCHASECONTRACT (
    PURCHASECONTRACT,
    _EXTENSION,
    _PURCHASINGDOCUMENTCATEGORY,
    COMPANYCODE,
    DOCUMENTCURRENCY,
    ISENDOFPURPOSEBLOCKED,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTNAME,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGDOCCHANGEREQUESTSTATUS,
    SUPPLIER,
    TARGETAMOUNT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (PURCHASECONTRACT)
);

Learn More