I_MRPPURCHASINGINFORECORD

CDS View
21 Fields 1 CDS Views

Basic InfoRecords for SOS

I_MRPPURCHASINGINFORECORD is a CDS View in S/4HANA. Basic InfoRecords for SOS. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MRPPurchasingInfoRecordMPN view from COMPOSITE InfoRecords with MPN details for SOS

Fields (21)

KeyField CDS FieldsUsed in Views
ActivePurchasingInfoRecord ActivePurchasingInfoRecord 1
GoodsReceiptDuration GoodsReceiptDuration 1
IsRelevantForAutomSrcg IsRelevantForAutomSrcg 1
ManufacturerMaterial ManufacturerMaterial 1
Material Material 1
MaterialMaxLotSizeQuantity MaterialMaxLotSizeQuantity 1
MaterialMinLotSizeQuantity MaterialMinLotSizeQuantity 1
PlannedDeliveryDuration PlannedDeliveryDuration 1
PreferredSupplier PreferredSupplier 1
ProductionVersion ProductionVersion 1
ProductVariantGroup ProductVariantGroup 1
PurchasingGroup PurchasingGroup 1
PurchasingInfoRecordCategory PurchasingInfoRecordCategory 1
PurchasingOrganization PurchasingOrganization 1
PurgDocHasPlant PurgDocHasPlant 1
PurgDocNetPriceAmount PurgDocNetPriceAmount 1
PurgDocNetPriceQuantity PurgDocNetPriceQuantity 1
PurgDocTransactionCurrency PurgDocTransactionCurrency 1
RoundingProfile RoundingProfile 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Basic InfoRecords for SOS
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPPURCHASINGINFORECORD (
    ACTIVEPURCHASINGINFORECORD,
    GOODSRECEIPTDURATION,
    ISRELEVANTFORAUTOMSRCG,
    MANUFACTURERMATERIAL,
    MATERIAL,
    MATERIALMAXLOTSIZEQUANTITY,
    MATERIALMINLOTSIZEQUANTITY,
    PLANNEDDELIVERYDURATION,
    PREFERREDSUPPLIER,
    PRODUCTIONVERSION,
    PRODUCTVARIANTGROUP,
    PURCHASINGGROUP,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGORGANIZATION,
    PURGDOCHASPLANT,
    PURGDOCNETPRICEAMOUNT,
    PURGDOCNETPRICEQUANTITY,
    PURGDOCTRANSACTIONCURRENCY,
    ROUNDINGPROFILE,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE
);

Learn More