M_V_inforecord

Inforecord | view: CDS_M_INFORECORD | Extraction: Not supported | Component: Source List
Tables used: EINA_EINE_DEINAEINELFA1MAKTMARAT001WT023TT024E
Column Name Description
infnr FK Number of purchasing info record
ekorg FK Purchasing organization
esokz Purchasing info record category Show values
werks FK Plant
Column Name Description
💲 Currency Key (waers):
netpr Net Price in Purchasing Info Record
Column Name Description
minbm Minimum Purchase Order Quantity
norbm Standard Purchase Order Quantity
bstma Maximum Purchase Order Quantity
Column Name Description
lifab Available (Deliverable) From
lifbi Available (Deliverable) Until
prdat Price Valid Until
Column Name Description
esokz Purchasing info record category Show values
loekz_a Purchasing info: General data flagged for deletion Show values
vabme Variable Purchase Order Unit Active Show values
relif Regular Supplier Show values
loekz_e Purch. info: Purch. organization data flagged for deletion Show values
uebtk Unlimited Overdelivery Allowed Show values
webre Indicator: GR-Based Invoice Verification Show values
aut_source Relevant for Automatic Sourcing Show values
Column Name Description Domain name
name1 Name 1 NAME
maktx Material Description TEXT40
ekotx Description of purchasing organization TEXT20
name1_p Name TEXT30
entitystate null
wgbez Material Group Description TEXT20
matkl Material Group MATKL
txz01 Short Text for Purchasing Info Record TEXT40
umrez Numerator for Conversion of Order Unit to Base Unit UMBSZ
umren Denominator for Conversion of Order Unit to Base Unit UMBSN
idnlf Material Number Used by Supplier IDNEX
verkf Salesperson Responsible in the Event of Queries TEXT30
telf1 Supplier's Telephone Number TEXT16
wglif Supplier Material Group CHAR18
ernam Name of Person Responsible for Creating the Object USNAM
aplfz Planned Delivery Time in Days DEC3
uebto Overdelivery Tolerance PRZ21
untto Underdelivery Tolerance PRZ21
peinh Price unit DEC5
bpumz Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
bpumn Denominator for Conv. of Order Price Unit into Order Unit UMBSN
inco2 Incoterms (Part 2) INCO2
Master Data Relations Join Conditions
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • M_V_INFORECORD.MANDT == T006.MANDT
  • M_V_INFORECORD.BPRME == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • M_V_INFORECORD.EKGRP == T024.EKGRP
  • M_V_INFORECORD.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • M_V_INFORECORD.EKORG == T024E.EKORG
  • M_V_INFORECORD.MANDT == T024E.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • M_V_INFORECORD.INCO1 == TINC.INCO1
  • M_V_INFORECORD.MANDT == TINC.MANDT
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • M_V_INFORECORD.MANDT == EINA.MANDT
  • M_V_INFORECORD.INFNR == EINA.INFNR
Prior Supplier
  • Client
  • Prior Supplier
  • M_V_INFORECORD.MANDT == LFA1.MANDT
  • M_V_INFORECORD.KOLIF == LFA1.LIFNR
Vendor's account number
  • Vendor's account number
  • Client
  • M_V_INFORECORD.LIFNR == LFA1.LIFNR
  • M_V_INFORECORD.MANDT == LFA1.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • M_V_INFORECORD.LMEIN == T006.MSEHI
  • M_V_INFORECORD.MANDT == T006.MANDT
Material Number
  • Client
  • Material Number
  • M_V_INFORECORD.MANDT == MARA.MANDT
  • M_V_INFORECORD.MATNR == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • M_V_INFORECORD.MANDT == T006.MANDT
  • M_V_INFORECORD.MEINS == T006.MSEHI
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • M_V_INFORECORD.[column in domain "KALSM_D"] == T007A.KALSM
  • M_V_INFORECORD.MANDT == T007A.MANDT
  • M_V_INFORECORD.MWSKZ == T007A.MWSKZ
Currency Key
  • Client
  • Currency Key
  • M_V_INFORECORD.MANDT == TCURC.MANDT
  • M_V_INFORECORD.WAERS == TCURC.WAERS
Plant
  • Plant
  • Client
  • M_V_INFORECORD.WERKS == T001W.WERKS
  • M_V_INFORECORD.MANDT == T001W.MANDT