I_PurgInfoRecordWWithDraft

Purchasing Info Rec. with Org Plant Data | view: IINFRECWITHORGWD | Extraction: Not supported | Component: Info Record
Tables used: MARA, EINA, EINE
Column Name Description
Plant FK Plant
PurchasingInfoRecordCategory Purchasing info record category Show values
PurchasingOrganization FK Purchasing organization
PurchasingInfoRecord Number of purchasing info record
Column Name Description
💲 Currency Key (Currency):
NetPriceAmount Net Price in Purchasing Info Record
Column Name Description
📏 Order Price Unit (Purchasing) (PurchaseOrderPriceUnit):
MinimumPurchaseOrderQuantity Minimum Purchase Order Quantity
StandardPurchaseOrderQuantity Standard Purchase Order Quantity
MaximumOrderQuantity Maximum Purchase Order Quantity
ProductPurchasePointsQty Number of Points
Column Name Description
CreationDate Date on which the record was created
AvailabilityStartDate Available (Deliverable) From
AvailabilityEndDate Available (Deliverable) Until
PriceValidityEndDate Price Valid Until
TimeDependentTaxValidFromDate Valid-From Date of the Tax Rate
SupplierCertValidityEndDate Certificate of Origin Valid Until
SupplierQuotationDate Quotation Validity Date
PurchasingDocumentDate Date of Last PO or Sched. Agreement Document in Info Record
ValidityStartDate null
ValidityEndDate null
Column Name Description
PurchasingInfoRecordCategory Purchasing info record category Show values
PurchasingInfoRecordCatForEdit Purchasing info record category Show values
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
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
ShelfLifeExpirationDatePeriod Period Indicator for Shelf Life Expiration Date Show values
IsRelevantForAutomSrcg Checkbox Show values
Column Name Description Domain name
PurchasingInfoRecordForEdit Number of purchasing info record INFNR
MaterialGroup Material Group MATKL
PurchasingInfoRecordDesc Short Text for Purchasing Info Record TEXT40
OrderItemQtyToBaseQtyNmrtr Numerator for Conversion of Order Unit to Base Unit UMBSZ
OrderItemQtyToBaseQtyDnmntr Denominator for Conversion of Order Unit to Base Unit UMBSN
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
CreatedByUser Name of Person Responsible for Creating the Object USNAM
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
MaterialPriceUnitQty Price unit DEC5
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
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
SupplierQuotation Quotation Number ANGNR
MinRemainingShelfLife Minimum Remaining Shelf Life DEC4
MaterialStagingTime Staging Time in Days WRF_PSCD_MST
MaterialConditionGroup Condition Group with Supplier CHAR4
IncotermsLocation2 Incoterms Location 2 INCO_L
SupplierSubrangeSortNumber Sort Sequence Number NUMC5
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
NetPriceQuantityUnit null
TaxCalculationProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
CompanyCode Company Code BUKRS
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_PURGINFORECORDWWITHDRAFT.BASEUNIT == T006.MSEHI
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Client
  • I_PURGINFORECORDWWITHDRAFT.CURRENCY == TCURC.WAERS
  • I_PURGINFORECORDWWITHDRAFT.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_PURGINFORECORDWWITHDRAFT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_PURGINFORECORDWWITHDRAFT.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_PURGINFORECORDWWITHDRAFT.INCOTERMSVERSION == TINCV.INCOV
  • I_PURGINFORECORDWWITHDRAFT.MANDT == TINCV.MANDT
Material Number
  • Material Number
  • Client
  • I_PURGINFORECORDWWITHDRAFT.MATERIAL == MARA.MATNR
  • I_PURGINFORECORDWWITHDRAFT.MANDT == MARA.MANDT
Rounding Profile
  • Rounding Profile
  • ?
  • Client
  • Plant
  • Plant
  • I_PURGINFORECORDWWITHDRAFT.MATERIALROUNDINGPROFILE == RDPR.RDPRF
  • I_PURGINFORECORDWWITHDRAFT.[column in domain "RDZAE"] == RDPR.RDZAE
  • I_PURGINFORECORDWWITHDRAFT.MANDT == RDPR.MANDT
  • I_PURGINFORECORDWWITHDRAFT.PLANT == RDPR.WERKS
  • I_PURGINFORECORDWWITHDRAFT.PLANTFOREDIT == RDPR.WERKS
Plant
  • Client
  • Plant
  • Plant
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T001W.MANDT
  • I_PURGINFORECORDWWITHDRAFT.PLANT == T001W.WERKS
  • I_PURGINFORECORDWWITHDRAFT.PLANTFOREDIT == T001W.WERKS
Plant
  • Client
  • Plant
  • Plant
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T001W.MANDT
  • I_PURGINFORECORDWWITHDRAFT.PLANT == T001W.WERKS
  • I_PURGINFORECORDWWITHDRAFT.PLANTFOREDIT == T001W.WERKS
Prior Supplier
  • Prior Supplier
  • Client
  • I_PURGINFORECORDWWITHDRAFT.PRIORSUPPLIER == LFA1.LIFNR
  • I_PURGINFORECORDWWITHDRAFT.MANDT == LFA1.MANDT
Points Unit
  • Client
  • Points Unit
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T006.MANDT
  • I_PURGINFORECORDWWITHDRAFT.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • I_PURGINFORECORDWWITHDRAFT.PURCHASEORDERPRICEUNIT == T006.MSEHI
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T006.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_PURGINFORECORDWWITHDRAFT.PURCHASINGGROUP == T024.EKGRP
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Purchasing organization
  • Client
  • I_PURGINFORECORDWWITHDRAFT.PURCHASINGORGANIZATIONFOREDIT == T024E.EKORG
  • I_PURGINFORECORDWWITHDRAFT.PURCHASINGORGANIZATION == T024E.EKORG
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T024E.MANDT
Purchasing organization
  • Purchasing organization
  • Purchasing organization
  • Client
  • I_PURGINFORECORDWWITHDRAFT.PURCHASINGORGANIZATIONFOREDIT == T024E.EKORG
  • I_PURGINFORECORDWWITHDRAFT.PURCHASINGORGANIZATION == T024E.EKORG
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T024E.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_PURGINFORECORDWWITHDRAFT.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T006.MANDT
Return Agreement
  • Client
  • Return Agreement
  • I_PURGINFORECORDWWITHDRAFT.MANDT == TWRV.MANDT
  • I_PURGINFORECORDWWITHDRAFT.RETURNAGREEMENT == TWRV.RUECV
Shipping Instructions
  • Shipping Instructions
  • Client
  • I_PURGINFORECORDWWITHDRAFT.SHIPPINGINSTRUCTION == T027A.EVERS
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T027A.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_PURGINFORECORDWWITHDRAFT.SUPPLIER == LFA1.LIFNR
  • I_PURGINFORECORDWWITHDRAFT.MANDT == LFA1.MANDT
Certificate Category
  • Certificate Category
  • Client
  • I_PURGINFORECORDWWITHDRAFT.SUPPLIERCERTORIGINCAT == T069.URZTP
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T069.MANDT
Country/Region of Issue of Certificate of Origin
  • Country/Region of Issue of Certificate of Origin
  • Client
  • I_PURGINFORECORDWWITHDRAFT.SUPPLIERCERTORIGINCOUNTRY == T005.LAND1
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region of Issue of Certificate of Origin
  • Region (State, Province, County)
  • Client
  • I_PURGINFORECORDWWITHDRAFT.SUPPLIERCERTORIGINCOUNTRY == T005S.LAND1
  • I_PURGINFORECORDWWITHDRAFT.SUPPLIERCERTORIGINREGION == T005S.BLAND
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T005S.MANDT
Confirmation Control Key
  • Confirmation Control Key
  • Client
  • I_PURGINFORECORDWWITHDRAFT.SUPPLIERCONFIRMATIONCONTROLKEY == T163L.BSTAE
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T163L.MANDT
Supplier Subrange
  • Vendor's account number
  • Supplier Subrange
  • Client
  • I_PURGINFORECORDWWITHDRAFT.SUPPLIER == WYT1.LIFNR
  • I_PURGINFORECORDWWITHDRAFT.SUPPLIERSUBRANGE == WYT1.LTSNR
  • I_PURGINFORECORDWWITHDRAFT.MANDT == WYT1.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • I_PURGINFORECORDWWITHDRAFT.TAXCODE == T007A.MWSKZ
  • I_PURGINFORECORDWWITHDRAFT.[column in domain "KALSM_D"] == T007A.KALSM
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T007A.MANDT
Input help for tax country
  • Tax Reporting Country/Region
  • Client
  • I_PURGINFORECORDWWITHDRAFT.TAXCOUNTRY == T005.LAND1
  • I_PURGINFORECORDWWITHDRAFT.MANDT == T005.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Unit of Measure Group
  • Unit of Measure Group
  • ?
  • Client
  • I_PURGINFORECORDWWITHDRAFT.PRODUCTUNITGROUP == TWMEG.MEGRU
  • I_PURGINFORECORDWWITHDRAFT.[column in domain "LRMEI"] == TWMEG.MEINS
  • I_PURGINFORECORDWWITHDRAFT.MANDT == TWMEG.MANDT