I_PURINFORECDPRCGCNDNVALIDITY

CDS View
13 Fields 7 CDS Views

Purch Info Record Cond Validity

I_PURINFORECDPRCGCNDNVALIDITY is a CDS View in S/4HANA. Purch Info Record Cond Validity. It contains 13 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_PurInfoRecdPrcgCndnValidity view from COMPOSITE Pricing Condition Validity
C_PurgInfoRecdCndnMassUpdt view from CONSUMPTION Mass Changes to PIR Pricing Conditions
C_PurInfoRecdPrcgCndn view from CONSUMPTION PIR Pricing Condition Changes
C_PurInfoRecdSupplPrcgCndn view from CONSUMPTION Supplementary PIR Pricing Condition
P_PurgInfoRecdCndnSuplmnt view inner COMPOSITE
P_PurgInfoRecdConditionRecd view inner COMPOSITE
R_PurgInfoRecdPrcgCndnValdtyTP view_entity from TRANSACTIONAL Purchg Info Rec Pricing Cond Validity

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 3
KEY ConditionValidityEndDate ConditionValidityEndDate 3
ConditionApplication ConditionApplication 3
ConditionType ConditionType,PurgPricingConditionType 2
ConditionValidityStartDate ConditionValidityStartDate 3
Material Material 2
MaterialGroup MaterialGroup 2
Plant Plant 4
PurchasingInfoRecord PurchasingInfoRecord 4
PurchasingInfoRecordCategory PurchasingInfoRecordCategory 4
PurchasingOrganization PurchasingOrganization 4
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit 2
Supplier Supplier 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.

-- Purch Info Record Cond Validity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURINFORECDPRCGCNDNVALIDITY (
    CONDITIONRECORD,
    CONDITIONVALIDITYENDDATE,
    CONDITIONAPPLICATION,
    CONDITIONTYPE,
    CONDITIONVALIDITYSTARTDATE,
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGORGANIZATION,
    PURGDOCORDERQUANTITYUNIT,
    SUPPLIER,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONVALIDITYENDDATE)
);

Learn More