I_PURINFCNDPERIOD

CDS View
12 Fields 5 CDS Views

CONDITONS VALIDITY

I_PURINFCNDPERIOD is a CDS View in S/4HANA. CONDITONS VALIDITY. It contains 12 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_PurgInfoRecdPrcCalc view from CONSUMPTION Info Record Price Conversion
P_PurgInfoRecdVarcCalc view from CONSUMPTION Private View for PIR Variance
P_PurgInfoRecdVarcCalc view left_outer CONSUMPTION Private View for PIR Variance
P_PurgInfoRecordMainCndn view_entity from COMPOSITE Purchasing Inforecord Main Condition
P_PurInfoRecdPrHist view union_all CONSUMPTION Private View for Purchasing Info Record Price History

Fields (12)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 1
KEY ConditionValidityEndDate ConditionValidityEndDate 2
KEY Plant Plant 2
KEY PurchasingInfoRecord PurchasingInfoRecord 1
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory 2
KEY PurchasingOrganization PurchasingOrganization 2
ConditionIsDeleted ConditionIsDeleted 1
ConditionQuantityUnit ConditionQuantityUnit 1
ConditionRateValue ConditionRateValue 1
ConditionRateValueUnit ConditionRateValueUnit 1
ConditionType ConditionType 1
ConditionValidityStartDate ConditionValidityStartDate 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.

-- CONDITONS VALIDITY
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURINFCNDPERIOD (
    CONDITIONRECORD,
    CONDITIONVALIDITYENDDATE,
    PLANT,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGORGANIZATION,
    CONDITIONISDELETED,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRATEVALUEUNIT,
    CONDITIONTYPE,
    CONDITIONVALIDITYSTARTDATE,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONVALIDITYENDDATE, PLANT, PURCHASINGINFORECORD, PURCHASINGINFORECORDCATEGORY, PURCHASINGORGANIZATION)
);

Learn More