InfoRec

Proxy for Inforecord (EINA) | view: INFORECROW | TRAN | Extraction: Not supported | Component: Purchasing
Tables used: EINA
Column Name Description
INFNR Number of purchasing info record
Column Name Description
Column Name Description
📏 Points Unit (PUNEI):
ANZPU Number of Points
Column Name Description
ERDAT Date on which the record was created
URZDT Certificate of Origin Valid Until
LIFAB Available (Deliverable) From
LIFBI Available (Deliverable) Until
Column Name Description
LOEKZ Purchasing info: General data flagged for deletion Show values
VABME Variable Purchase Order Unit Active Show values
RELIF Regular Supplier Show values
ISEOPBLOCKED Business Purpose Completed Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
TXZ01 Short Text for Purchasing Info Record TEXT40
SORTL Sort Term for Non-Stock Info Records CHAR10
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
MAHN1 Number of Days for First Reminder/Expediter MAHNT
MAHN2 Number of Days for Second Reminder/Expediter MAHNT
MAHN3 Number of Days for Third Reminder/Expediter MAHNT
URZNR Certificate Number URZNR
URZZT Number URZZT
LTSSF Sort Sequence Number NUMC5
WGLIF Supplier Material Group CHAR18
MFRNR Manufacturer LIFNR
DUMMY_EINA_INCL_EEW_PS Data element for Inforecords extensibility EINA_INCL_EEW
LASTCHANGEDATETIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
Master Data Relations Join Conditions
Prior Supplier
  • Prior Supplier
  • Client
  • INFOREC.KOLIF == LFA1.LIFNR
  • INFOREC.MANDT == LFA1.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • INFOREC.LIFNR == LFA1.LIFNR
  • INFOREC.MANDT == LFA1.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • INFOREC.LMEIN == T006.MSEHI
  • INFOREC.MANDT == T006.MANDT
Supplier Subrange
  • Supplier Subrange
  • Vendor's account number
  • Client
  • INFOREC.LTSNR == WYT1.LTSNR
  • INFOREC.LIFNR == WYT1.LIFNR
  • INFOREC.MANDT == WYT1.MANDT
Material Group
  • Client
  • Material Group
  • INFOREC.MANDT == T023.MANDT
  • INFOREC.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • INFOREC.MATNR == MARA.MATNR
  • INFOREC.MANDT == MARA.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • INFOREC.MANDT == T006.MANDT
  • INFOREC.MEINS == T006.MSEHI
Points Unit
  • Points Unit
  • Client
  • INFOREC.PUNEI == T006.MSEHI
  • INFOREC.MANDT == T006.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Country/Region of Issue of Certificate of Origin
  • Client
  • INFOREC.REGIO == T005S.BLAND
  • INFOREC.URZLA == T005S.LAND1
  • INFOREC.MANDT == T005S.MANDT
Return Agreement
  • Return Agreement
  • Client
  • INFOREC.RUECK == TWRV.RUECV
  • INFOREC.MANDT == TWRV.MANDT
Country/Region of Issue of Certificate of Origin
  • Country/Region of Issue of Certificate of Origin
  • Client
  • INFOREC.URZLA == T005.LAND1
  • INFOREC.MANDT == T005.MANDT
Certificate Category
  • Client
  • Certificate Category
  • INFOREC.MANDT == T069.MANDT
  • INFOREC.URZTP == T069.URZTP