I_PURCHASINGINFORECORD

CDS View
38 Fields 32 CDS Views

Purchasing Info Record

I_PURCHASINGINFORECORD is a CDS View in S/4HANA. Purchasing Info Record. It contains 38 fields. 32 CDS views read from this table.

CDS Views using this table (32)

ViewTypeJoinVDMDescription
A_PurchasingInfoRecord view from BASIC Purchasing Info Record
C_MassUpdtPurgInfoRecdVH view from CONSUMPTION
C_MMPurchasingInfoRecordHelp view from CONSUMPTION
C_ProductObjPgPurgInfoRecd view from CONSUMPTION Product Object Page - Purchasing Info Record
C_PurgInfoRecdMassUpdt view from CONSUMPTION Mass Changes to Purchasing Info Records
C_PurgInfoRecordFs view from CONSUMPTION Purchasing Info Record
C_Purordmaintaininfrecvalhelp view from CONSUMPTION Value Help for Inforecord
C_PurOrdRefDocIR view left_outer CONSUMPTION Reference Documents for PO Creation - Inforecord Items
CIC_PURCHASING_INFO_RECORD view_entity from Source of Supply Type B: Purchasing Info Record
CIC_SOS_PUR_INFO_KEY view_entity from Purchasing Info record with source of supply keys
I_ATPSourceOfSupply view_entity union COMPOSITE ATP Source of Supply
I_FldLogsRetServicePurOrdVH view inner COMPOSITE Service PO F4 Help for FL Returns
I_PurchasingInfoRecordApi01 view from BASIC Purchasing Info Record
I_PurchasingInfoRecordStdVH view from COMPOSITE Purchasing Info Record
I_PurgInfoRecdSuplrSubRngeVH view from COMPOSITE Purchasing Info Record Supplier Subrange
I_PurgInfoRecordWithOrgData view from BASIC Info Record with Org Plant Data
I_PurInfoRecdMaterialPrcgCndn view inner BASIC Purch Info Record Material Cond
I_PurInfoRecdNonStkItmPrcgCndn view inner BASIC Purch Info Record Non Stock Item Cond
I_PurInfoRecdOrderUnitPrcgCndn view inner BASIC Purch Info Record Order Unit Cond
I_PurReqnQuickView view left_outer COMPOSITE Purchase Requisition Details
P_AssgblSuplrForProcmtProd view from CONSUMPTION
P_InfoRecdMassUpdtMatlGrp view from CONSUMPTION Material Group calculation
P_InfoRecordLeadTime view from COMPOSITE
P_Inforecordmanagesos view from CONSUMPTION
P_InfoRecordPriceVariance view from CONSUMPTION
P_InfoRecordsPurOrdSpend view from CONSUMPTION Purchase Order Spend from Info Records
P_Purchasingdocument_Fs view union BASIC
P_PurchasingInfoRecMassUpdate view from CONSUMPTION Union of General and Org. Data
P_PurOrdMaintainRefDocumentAll view left_outer CONSUMPTION
P_SupplierByProduct view from COMPOSITE
P_SupplierByProduct view union COMPOSITE
R_PurchasingInfoRecordTP view_entity from TRANSACTIONAL Purchase Info Record

Fields (38)

KeyField CDS FieldsUsed in Views
KEY AvailabilityEndDate AvailableToDate,ValidityEndDate 2
KEY AvailabilityStartDate AvailableFromDate,ValidityStartDate 2
KEY Material ManufacturerMaterial,Material,Product 11
KEY MaterialGroup MaterialGroup,ProductGroup 4
KEY PurchasingInfoRecord PurchasingInfoRecord 11
KEY Supplier Supplier 8
_Material _Material 2
_MaterialGroup _MaterialGroup 1
_Supplier _Supplier 3
BaseUnit BaseUnit 2
CreationDate CreationDate 2
IsDeleted GeneralDataDeleted,IsDeleted 3
IsRegularSupplier IsRegularSupplier,relif 2
Manufacturer Manufacturer 1
NoDaysReminder1 NoDaysReminder1 1
NoDaysReminder2 NoDaysReminder2 1
NoDaysReminder3 NoDaysReminder3 1
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr 4
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr 4
PriorSupplier PriorSupplier 2
ProductPurchasePointsQty ProductPurchasePointsQty 1
ProductPurchasePointsQtyUnit ProductPurchasePointsQtyUnit 1
PurchasingInfoRecordDesc PurchasingDocumentItemText,PurchasingInfoRecordDesc 5
PurgDocOrderQuantityUnit OrderQuantityUnit,OrderUnit,PurchaseOrderQuantityUnit,PurgDocOrderQuantityUnit 6
ReturnAgreement ReturnAgreement 1
SuplrCertOriginClassfctnNumber SuplrCertOriginClassfctnNumber 1
SupplierCertOriginCat SupplierCertOriginCat 1
SupplierCertOriginCountry SupplierCertOriginCountry 1
SupplierCertOriginNumber SupplierCertOriginNumber 1
SupplierCertOriginRegion SupplierCertOriginRegion 1
SupplierCertValidityEndDate SupplierCertValidityEndDate 1
SupplierMaterialGroup SupplierMaterialGroup 2
SupplierMaterialNumber SupplierMaterialNumber 4
SupplierPhoneNumber SupplierPhoneNumber 2
SupplierRespSalesPersonName SalesPerson,SupplierRespSalesPersonName 2
SupplierSubrange SupplierSubrange 2
SupplierSubrangeSortNumber SupplierSubrangeSortNumber 1
VarblPurOrdUnitIsActive vabme,VarblPurOrdUnitIsActive 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.

-- Purchasing Info Record
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASINGINFORECORD (
    AVAILABILITYENDDATE,
    AVAILABILITYSTARTDATE,
    MATERIAL,
    MATERIALGROUP,
    PURCHASINGINFORECORD,
    SUPPLIER,
    _MATERIAL,
    _MATERIALGROUP,
    _SUPPLIER,
    BASEUNIT,
    CREATIONDATE,
    ISDELETED,
    ISREGULARSUPPLIER,
    MANUFACTURER,
    NODAYSREMINDER1,
    NODAYSREMINDER2,
    NODAYSREMINDER3,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    PRIORSUPPLIER,
    PRODUCTPURCHASEPOINTSQTY,
    PRODUCTPURCHASEPOINTSQTYUNIT,
    PURCHASINGINFORECORDDESC,
    PURGDOCORDERQUANTITYUNIT,
    RETURNAGREEMENT,
    SUPLRCERTORIGINCLASSFCTNNUMBER,
    SUPPLIERCERTORIGINCAT,
    SUPPLIERCERTORIGINCOUNTRY,
    SUPPLIERCERTORIGINNUMBER,
    SUPPLIERCERTORIGINREGION,
    SUPPLIERCERTVALIDITYENDDATE,
    SUPPLIERMATERIALGROUP,
    SUPPLIERMATERIALNUMBER,
    SUPPLIERPHONENUMBER,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLIERSUBRANGE,
    SUPPLIERSUBRANGESORTNUMBER,
    VARBLPURORDUNITISACTIVE,
    PRIMARY KEY (AVAILABILITYENDDATE, AVAILABILITYSTARTDATE, MATERIAL, MATERIALGROUP, PURCHASINGINFORECORD, SUPPLIER)
);

Learn More