C_InfoRecordManageSosAll_Text

Info Record Manage SoS All Text | view: CIRMNGALLTXT | Extraction: Not supported | Component: Vendor-Material Relationships and Conditions
Tables used: EINA_EINE_DEINA_EINE_DMARAT023T001WEINAT024EEINELFA1USR21USR21
Column Name Description
Guid null
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
Column Name Description
AvailabilityStartDate Available (Deliverable) From
AvailabilityEndDate Available (Deliverable) Until
PriceValidityEndDate Price Valid Until
Column Name Description
PurchasingInfoRecordCategory 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
IsRelevantForAutomSrcg Relevant for Automatic Sourcing Show values
Column Name Description Domain name
PurchasingInfoRecord Number of purchasing info record INFNR
SupplierName Name of Supplier TEXT80
EditState null
MaterialGroup null
PurchasingInfoRecordDesc Short Text for Purchasing Info Record TEXT40
PurchasingOrganizationName Purchasing Organization Name TEXT20
PlantName Plant Name TEXT30
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
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
CreatedByUser User Name UNAME
CreatedByUserFullName Description of the Technical User Account SUIDTECHDESC
CreationDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
IsActiveEntity null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_INFORECORDMANAGESOSALL_TEXT.BASEUNIT == T006.MSEHI
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == T006.MANDT
Currency Key
  • Client
  • Currency Key
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == TCURC.MANDT
  • C_INFORECORDMANAGESOSALL_TEXT.CURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_INFORECORDMANAGESOSALL_TEXT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == TINC.MANDT
Material Number
  • Client
  • Material Number
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == MARA.MANDT
  • C_INFORECORDMANAGESOSALL_TEXT.MATERIAL == MARA.MATNR
Plant
  • Plant
  • Client
  • C_INFORECORDMANAGESOSALL_TEXT.PLANT == T001W.WERKS
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == T001W.MANDT
Prior Supplier
  • Prior Supplier
  • Client
  • C_INFORECORDMANAGESOSALL_TEXT.PRIORSUPPLIER == LFA1.LIFNR
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == LFA1.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • C_INFORECORDMANAGESOSALL_TEXT.PURCHASEORDERPRICEUNIT == T006.MSEHI
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == T006.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_INFORECORDMANAGESOSALL_TEXT.PURCHASINGGROUP == T024.EKGRP
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_INFORECORDMANAGESOSALL_TEXT.PURCHASINGORGANIZATION == T024E.EKORG
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == T024E.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_INFORECORDMANAGESOSALL_TEXT.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == T006.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • C_INFORECORDMANAGESOSALL_TEXT.SUPPLIER == LFA1.LIFNR
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == LFA1.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • C_INFORECORDMANAGESOSALL_TEXT.TAXCODE == T007A.MWSKZ
  • C_INFORECORDMANAGESOSALL_TEXT.[column in domain "KALSM_D"] == T007A.KALSM
  • C_INFORECORDMANAGESOSALL_TEXT.MANDT == T007A.MANDT