C_InfoRecdMassUpdtStruc

PIR Mass Update Structure | view: CPIRSTRUCT | TRAN | Extraction: Not supported | Component: Info Record
Tables used: MARAT023T023TMAKTT001WT024EINAT024EEINELFA1WYT1WYT1T
Column Name Description
FormattedInfoRec null
Column Name Description
💲 Currency Key (Currency):
NetPriceAmount Net Price in Purchasing Info Record
Column Name Description
ProductPurchasePointsQty Number of Points
MinimumPurchaseOrderQuantity Minimum Purchase Order Quantity
StandardPurchaseOrderQuantity Standard Purchase Order Quantity
MaximumOrderQuantity Maximum Purchase Order Quantity
Column Name Description
CreationDate Date on which the record was created
AvailabilityStartDate Available (Deliverable) From
AvailabilityEndDate Available (Deliverable) Until
SupplierCertValidityEndDate Certificate of Origin Valid Until
PriceValidityEndDate Price Valid Until
Column Name Description
IsDeleted Purchasing info: General data flagged for deletion Show values
VarblPurOrdUnitIsActive Variable Purchase Order Unit Active Show values
IsRegularSupplier Regular Supplier Show values
IsMarkedForDeletion Purch. info: Purch. organization data flagged for deletion Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
IsRelevantForAutomSrcg Relevant for Automatic Sourcing Show values
IsEvaluatedRcptSettlmtAllowed No Evaluated Receipt Settlement (ERS) Show values
IsPurOrderAllwdForInbDeliv Create Purchase Order for Delivery Without Reference Show values
IsOrderAcknRqd Order Acknowledgment Requirement Show values
IsRetMatlAuthznRqdBySupplier Supplier RMA Number Required Show values
IsCashDiscountGranted Item Does Not Qualify for Cash Discount Show values
PricingDateControl Price Determination (Pricing) Date Control Show values
Column Name Description Domain name
ActivePurchasingInfoRecord null
ParentNode null
PurchasingInfoRecord Number of purchasing info record INFNR
HierarchyNodeLevel null
MemoLine null
DefectCodeText null
ItemIsSelectedForProcessing null
InternalComment null
PurchasingInfoRecordDesc Short Text for Purchasing Info Record TEXT40
SupplierMaterialNumber Material Number Used by Supplier IDNEX
SupplierRespSalesPersonName Salesperson Responsible in the Event of Queries TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
SupplierMaterialGroup Supplier Material Group CHAR18
Manufacturer Manufacturer LIFNR
NoDaysReminder1 Number of Days for First Reminder/Expediter MAHNT
NoDaysReminder2 Number of Days for Second Reminder/Expediter MAHNT
NoDaysReminder3 Number of Days for Third Reminder/Expediter MAHNT
SupplierCertOriginNumber Certificate Number URZNR
SuplrCertOriginClassfctnNumber Number URZZT
SupplierSubrangeSortNumber Sort Sequence Number NUMC5
PurchasingOrganization Purchasing organization EKORG
PurchasingInfoRecordCategory Purchasing Info Record Category /SAPAPO/CIF_ESOKZ
Plant Plant WERKS
PurchasingGroup Purchasing Group EKGRP
MaterialConditionGroup Condition Group with Supplier CHAR4
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
MaterialPriceUnitQty Price unit DEC5
TaxCode Tax on sales/purchases code MWSKZ
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
IncotermsVersion Incoterms Version INCOV
MinRemainingShelfLife Minimum Remaining Shelf Life DEC4
ShippingInstruction Shipping Instructions EVERS
SupplierConfirmationControlKey Confirmation Control Key BSTAE
MaterialRoundingProfile Rounding Profile RDPRF
MaterialStagingTime Staging Time in Days WRF_PSCD_MST
ProductUnitGroup Unit of Measure Group MEGRU
NumberOfItems null
SupplierName Name of Supplier TEXT80
MaterialName Material Description TEXT40
PurchasingGroupName Purchasing Group Name TEXT18
PlantName Plant Name TEXT30
MaterialGroupName Product Group Description TEXT20
PurchasingOrganizationName Purchasing Organization Name TEXT20
SupplierSubrangeName Description of Supplier Subrange TEXT20
PurchasingInfoRecordTitle Description for Purchasing Info Record Category TEXT20
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • C_INFORECDMASSUPDTSTRUC.MANDT == MARA.MANDT
  • C_INFORECDMASSUPDTSTRUC.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_INFORECDMASSUPDTSTRUC.MANDT == T023.MANDT
  • C_INFORECDMASSUPDTSTRUC.MATERIALGROUP == T023.MATKL
Prior Supplier
  • Client
  • Prior Supplier
  • C_INFORECDMASSUPDTSTRUC.MANDT == LFA1.MANDT
  • C_INFORECDMASSUPDTSTRUC.PRIORSUPPLIER == LFA1.LIFNR
Points Unit
  • Client
  • Points Unit
  • C_INFORECDMASSUPDTSTRUC.MANDT == T006.MANDT
  • C_INFORECDMASSUPDTSTRUC.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
Return Agreement
  • Client
  • Return Agreement
  • C_INFORECDMASSUPDTSTRUC.MANDT == TWRV.MANDT
  • C_INFORECDMASSUPDTSTRUC.RETURNAGREEMENT == TWRV.RUECV
Supplier
  • Client
  • Supplier
  • C_INFORECDMASSUPDTSTRUC.MANDT == LFA1.MANDT
  • C_INFORECDMASSUPDTSTRUC.SUPPLIER == LFA1.LIFNR
Certificate Category
  • Client
  • Certificate Category
  • C_INFORECDMASSUPDTSTRUC.MANDT == T069.MANDT
  • C_INFORECDMASSUPDTSTRUC.SUPPLIERCERTORIGINCAT == T069.URZTP
Country/Region of Issue of Certificate of Origin
  • Client
  • Country/Region of Issue of Certificate of Origin
  • C_INFORECDMASSUPDTSTRUC.MANDT == T005.MANDT
  • C_INFORECDMASSUPDTSTRUC.SUPPLIERCERTORIGINCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Country/Region of Issue of Certificate of Origin
  • Region (State, Province, County)
  • C_INFORECDMASSUPDTSTRUC.MANDT == T005S.MANDT
  • C_INFORECDMASSUPDTSTRUC.SUPPLIERCERTORIGINCOUNTRY == T005S.LAND1
  • C_INFORECDMASSUPDTSTRUC.SUPPLIERCERTORIGINREGION == T005S.BLAND
Supplier Subrange
  • Supplier Subrange
  • Client
  • Supplier
  • C_INFORECDMASSUPDTSTRUC.SUPPLIERSUBRANGE == WYT1.LTSNR
  • C_INFORECDMASSUPDTSTRUC.MANDT == WYT1.MANDT
  • C_INFORECDMASSUPDTSTRUC.SUPPLIER == WYT1.LIFNR