I_PURCHASINGINFORECORD

CDS View
38 Fields 33 CDS Views

Purchasing Info Record

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

CDS Views using this table (33)

ViewTypeJoinVDMDescription
A_PurchasingInfoRecord view from BASIC Purchasing Info Record
C_MassUpdtPurgInfoRecdVH view from CONSUMPTION Info Record Value Help
C_MMPurchasingInfoRecordHelp view from CONSUMPTION Purchasing Info Record Help
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
I_ATPSourceOfSupply view_entity union COMPOSITE ATP Source of Supply
I_FldLogsRetServicePurOrdVH view inner COMPOSITE Service PO F4 Help for FL Returns
I_MRPPurchasingInfoRecord view from COMPOSITE Basic InfoRecords for SOS
I_PurchasingInfoRecordApi01 view from BASIC Purchasing Info Record
I_PurchasingInfoRecordNote view_entity inner BASIC Purchasing Info Record General Notes
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 Assgbl Suplr for Procmt Prod Value Help
P_InfoRecdMassUpdtMatlGrp view from CONSUMPTION Material Group calculation
P_InfoRecordLeadTime view from COMPOSITE Demand Driven Product Lead Time InfoRecord Specific
P_Inforecordmanagesos view from CONSUMPTION EINA EINE combination for Manage Sources of Supply App
P_InfoRecordPriceVariance3 view_entity from CONSUMPTION Info Record Price Variance
P_InfoRecordsPurOrdSpend view from CONSUMPTION Purchase Order Spend from Info Records
P_Purchasingdocument_Fs view union BASIC Private Factsheet - Purchasing Document
P_PurchasingInfoRecMassUpdate view from CONSUMPTION Union of General and Org. Data
P_PurOrdMaintainRefDocumentAll view left_outer CONSUMPTION PO Maintenance: Ref. Doc. for PO Create (Item + Inforecord)
P_SupplierByProduct view from COMPOSITE Supplier by Product (helper)
P_SupplierByProduct view union COMPOSITE Supplier by Product (helper)
R_JP_SubcontrgChrgblCompPr view_entity from TRANSACTIONAL Price List for Chargable Components
R_PurchasingInfoRecordTP view_entity from TRANSACTIONAL Purchase Info Record

Fields (38)

KeyField CDS FieldsUsed in Views
KEY Material ManufacturerMaterial,Material 11
KEY PurchasingInfoRecord ActivePurchasingInfoRecord,PurchasingInfoRecord 11
KEY Supplier PreferredSupplier,Supplier 10
_Material _Material 1
_Supplier _Supplier 3
_SupplierPurchasingOrg _SupplierPurchasingOrg 1
AvailabilityEndDate AvailableToDate 1
AvailabilityStartDate AvailableFromDate,ValidityStartDate 2
BaseUnit BaseUnit 2
CreationDate CreationDate 2
IsDeleted GeneralDataDeleted,IsDeleted 3
IsRegularSupplier IsRegularSupplier,relif 2
Manufacturer Manufacturer 1
MaterialGroup MaterialGroup,ProductVariantGroup 4
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 OrderUnit,PurchaseOrderQuantityUnit,PurgDocOrderQuantityUnit 5
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 1
SupplierSubrangeSortNumber SupplierSubrangeSortNumber 1
VarblPurOrdUnitIsActive vabme,VarblPurOrdUnitIsActive 3

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 (
    MATERIAL,
    PURCHASINGINFORECORD,
    SUPPLIER,
    _MATERIAL,
    _SUPPLIER,
    _SUPPLIERPURCHASINGORG,
    AVAILABILITYENDDATE,
    AVAILABILITYSTARTDATE,
    BASEUNIT,
    CREATIONDATE,
    ISDELETED,
    ISREGULARSUPPLIER,
    MANUFACTURER,
    MATERIALGROUP,
    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 (MATERIAL, PURCHASINGINFORECORD, SUPPLIER)
);

Learn More