P_CNTRLPURCONTRVALIDITY

CDS View
4 Fields 1 CDS Views

View for calculating validity status

P_CNTRLPURCONTRVALIDITY is a CDS View in S/4HANA. View for calculating validity status. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CntrlPurContrValidityStatus view from COMPOSITE Central Purchase Contract Validity Stat

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CentralPurchaseContract CentralPurchaseContract 1
ActivePurchasingDocument ActivePurchasingDocument 1
CntrlPurContrValidity CntrlPurContrValidity 1
CntrlPurContrValidityStatus CntrlPurContrValidityStatus 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.

-- View for calculating validity status
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CNTRLPURCONTRVALIDITY (
    CENTRALPURCHASECONTRACT,
    ACTIVEPURCHASINGDOCUMENT,
    CNTRLPURCONTRVALIDITY,
    CNTRLPURCONTRVALIDITYSTATUS,
    PRIMARY KEY (CENTRALPURCHASECONTRACT)
);

Learn More