I_ACTIVEPURCHASECONTRACT

CDS View

I view for active purchase contract

I_ACTIVEPURCHASECONTRACT is a CDS View in S/4HANA. I view for active purchase contract. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_Activepurchasecontract view from CONSUMPTION Consumption view for active purchase contract

Fields (11)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PurchaseContract 1
DocumentCurrency DocumentCurrency 1
PurchaseContractClassification PurchaseContractClassification 1
PurchaseContractConsumedAmount PurContrConsumedVal 1
PurchaseContractTargetAmount PurchaseContractTargetAmount 1
PurchaseContractType PurchaseContractType 1
PurchasingDocumentTypeName PurchasingDocumentTypeName 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
PurchasingProcessingStatus PurchasingProcessingStatus 1
ReleaseIsNotCompleted ReleaseIsNotCompleted 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.

-- I view for active purchase contract
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACTIVEPURCHASECONTRACT (
    PURCHASECONTRACT,
    DOCUMENTCURRENCY,
    PURCHASECONTRACTCLASSIFICATION,
    PURCHASECONTRACTCONSUMEDAMOUNT,
    PURCHASECONTRACTTARGETAMOUNT,
    PURCHASECONTRACTTYPE,
    PURCHASINGDOCUMENTTYPENAME,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPROCESSINGSTATUS,
    RELEASEISNOTCOMPLETED,
    PRIMARY KEY (PURCHASECONTRACT)
);