I_PURINFCNDPERIOD

CDS View
19 Fields 5 CDS Views

CONDITONS VALIDITY

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

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_PurInfCndPeriodWithDraft view from TRANSACTIONAL Conditions Records Validity with Draft
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_PurInfoRecdPrHist view union_all CONSUMPTION Private View for Purchasing Info Record Price History

Fields (19)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 2
KEY ConditionValidityEndDate ConditionValdtyEndDateForEdit,ConditionValidityEndDate 3
KEY Plant Plant 3
KEY PurchasingInfoRecord PurchasingInfoRecord 2
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory 3
KEY PurchasingOrganization PurchasingOrganization 3
BaseUnit BaseUnit 1
ConditionApplication ConditionApplication 1
ConditionCalculationType ConditionCalculationType 1
ConditionIsDeleted ConditionIsDeleted 2
ConditionQuantity ConditionQuantity 1
ConditionQuantityUnit ConditionQuantityUnit 2
ConditionRateValue ConditionRateValue 2
ConditionRateValueUnit ConditionRateValueUnit 2
ConditionSequentialNumber ConditionSequentialNumber 1
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr 1
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr 1
ConditionType ConditionType 2
ConditionValidityStartDate ConditionValidityStartDate 2

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,
    BASEUNIT,
    CONDITIONAPPLICATION,
    CONDITIONCALCULATIONTYPE,
    CONDITIONISDELETED,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRATEVALUEUNIT,
    CONDITIONSEQUENTIALNUMBER,
    CONDITIONTOBASEQTYDNMNTR,
    CONDITIONTOBASEQTYNMRTR,
    CONDITIONTYPE,
    CONDITIONVALIDITYSTARTDATE,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONVALIDITYENDDATE, PLANT, PURCHASINGINFORECORD, PURCHASINGINFORECORDCATEGORY, PURCHASINGORGANIZATION)
);

Learn More