I_PURGINFORECORDWITHORGDATA

CDS View
25 Fields 10 CDS Views

Info Record with Org Plant Data

I_PURGINFORECORDWITHORGDATA is a CDS View in S/4HANA. Info Record with Org Plant Data. It contains 25 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_PPS_PurchaseReqnInfoRecordVH view_entity from CONSUMPTION Info record in PurReqn SoS
C_PurchaseReqnInfoRecordVH view from CONSUMPTION Info record value help in PurReqn
ESH_N_PURCHASE_INFO_REC view from
I_SourcesOfSupply view union_all COMPOSITE Sources of Supply
P_DDMaterialSOS view inner CONSUMPTION
P_PurchasingInfoRecMassUpdate view union CONSUMPTION Union of General and Org. Data
P_PurgInfoRecordWithOrgData view from COMPOSITE
P_PurInfoRecdPrHist view from CONSUMPTION Private View for Purchasing Info Record Price History
P_SourceOfSupply view union_all CONSUMPTION Source of Supply
P_SourcesOfSupply view union COMPOSITE

Fields (25)

KeyField CDS FieldsUsed in Views
KEY Material ManufacturerMaterial,Material 4
KEY Plant Plant 4
KEY PurchasingInfoRecord PurchasingInfoRecord,SourceDocument 3
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory,PurInfoRecordCat 3
KEY PurchasingOrganization PurchasingOrganization 5
AvailabilityEndDate AvailabilityEndDate,ValidityEndDate 4
AvailabilityStartDate AvailabilityStartDate,ValidityStartDate 4
CreationDate CreationDate 2
Currency Currency 2
IncotermsClassification IncotermsClassification 1
IsDeleted IsDeleted 1
Manufacturer Manufacturer 1
MaterialGroup MaterialGroup 2
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn 1
NetPriceAmount NetPriceAmount 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 1
PricingDateControl PricingDateControl 1
PriorSupplier PriorSupplier 1
PurchasingGroup PurchasingGroup 3
PurgDocOrderQuantityUnit BaseUnit,OrderQuantityUnit 2
Supplier Supplier 4
SupplierMaterialNumber SupplierMaterialNumber 1
SupplierSubrange SupplierSubrange 1
TaxCode TaxCode 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 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.

-- Info Record with Org Plant Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURGINFORECORDWITHORGDATA (
    MATERIAL,
    PLANT,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGORGANIZATION,
    AVAILABILITYENDDATE,
    AVAILABILITYSTARTDATE,
    CREATIONDATE,
    CURRENCY,
    INCOTERMSCLASSIFICATION,
    ISDELETED,
    MANUFACTURER,
    MATERIALGROUP,
    MATERIALPLANNEDDELIVERYDURN,
    NETPRICEAMOUNT,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PRICINGDATECONTROL,
    PRIORSUPPLIER,
    PURCHASINGGROUP,
    PURGDOCORDERQUANTITYUNIT,
    SUPPLIER,
    SUPPLIERMATERIALNUMBER,
    SUPPLIERSUBRANGE,
    TAXCODE,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    PRIMARY KEY (MATERIAL, PLANT, PURCHASINGINFORECORD, PURCHASINGINFORECORDCATEGORY, PURCHASINGORGANIZATION)
);

Learn More