I_PURINFORECDPRCGCNDNVALIDITY

CDS View
13 Fields 8 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. 8 CDS views read from this table.

CDS Views using this table (8)

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
I_PurgInfoRecdPriceCondition view_entity from COMPOSITE Purchasing Info Record Pricing Condition
P_PurgInfoRecdCndnSuplmnt view inner COMPOSITE Basic View for Pur Info Rec Pricing Cndn Supplement
P_PurgInfoRecdConditionRecd view inner COMPOSITE Basic View for Purchase Info Rec Cond Rec
R_PurgInfoRecdPrcgCndnValdtyTP view_entity from TRANSACTIONAL Purchg Info Rec Pricing Cond Validity

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 4
KEY ConditionValidityEndDate ConditionValidityEndDate 5
KEY Plant Plant 5
KEY PurchasingInfoRecord PurchasingInfoRecord 5
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory 5
KEY PurchasingOrganization PurchasingOrganization 5
ConditionApplication ConditionApplication 4
ConditionType ConditionType,PurgPricingConditionType 2
ConditionValidityStartDate ConditionValidityStartDate 4
Material Material 3
MaterialGroup MaterialGroup 3
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit 3
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,
    PLANT,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGORGANIZATION,
    CONDITIONAPPLICATION,
    CONDITIONTYPE,
    CONDITIONVALIDITYSTARTDATE,
    MATERIAL,
    MATERIALGROUP,
    PURGDOCORDERQUANTITYUNIT,
    SUPPLIER,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONVALIDITYENDDATE, PLANT, PURCHASINGINFORECORD, PURCHASINGINFORECORDCATEGORY, PURCHASINGORGANIZATION)
);

Learn More