C_UnlmtdOvrdelivPurOrder

Unlimited Over Delivery Purchase Order | view: CGRCUNLMTDELIVPO | Extraction: Not supported | Component: Information System
Tables used: EKKO, EKPO, T001, TKA02, LFA1
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
GrossAmount Gross order value in PO currency
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
LastChangeDate null
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
EvaldRcptSettlmtIsAllowed Evaluated Receipt Settlement (ERS) Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
IsStatisticalItem Item is statistical Show values
IsReturnsItem Returns Item Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
SupplierName Name of Supplier TEXT80
CreatedByUser User of person who created a purchasing document USNAM
PurchasingDocumentItemText Short Text TEXT40
PurgReleaseSequenceStatus Release State FRGZU
LastChangeDateTime Change Time Stamp TZNTSTMPL
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
RequisitionerName Name of requisitioner/requester AFNAM
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_UNLMTDOVRDELIVPURORDER.MANDT == T001.MANDT
  • C_UNLMTDOVRDELIVPURORDER.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • C_UNLMTDOVRDELIVPURORDER.MANDT == TCURC.MANDT
  • C_UNLMTDOVRDELIVPURORDER.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • C_UNLMTDOVRDELIVPURORDER.MANDT == MARA.MANDT
  • C_UNLMTDOVRDELIVPURORDER.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_UNLMTDOVRDELIVPURORDER.MANDT == T023.MANDT
  • C_UNLMTDOVRDELIVPURORDER.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_UNLMTDOVRDELIVPURORDER.MANDT == T001W.MANDT
  • C_UNLMTDOVRDELIVPURORDER.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_UNLMTDOVRDELIVPURORDER.MANDT == T163.MANDT
  • C_UNLMTDOVRDELIVPURORDER.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • C_UNLMTDOVRDELIVPURORDER.MANDT == T161.MANDT
  • C_UNLMTDOVRDELIVPURORDER.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_UNLMTDOVRDELIVPURORDER.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • C_UNLMTDOVRDELIVPURORDER.PURCHASINGINFORECORD == EINA.INFNR
  • C_UNLMTDOVRDELIVPURORDER.MANDT == EINA.MANDT
Reason for Ordering
  • Client
  • Reason for Ordering
  • C_UNLMTDOVRDELIVPURORDER.MANDT == TBSG.MANDT
  • C_UNLMTDOVRDELIVPURORDER.PURCHASINGORDERREASON == TBSG.BSGRU
Release Strategy
  • Client
  • ?
  • Release Strategy
  • C_UNLMTDOVRDELIVPURORDER.MANDT == T16FS.MANDT
  • C_UNLMTDOVRDELIVPURORDER.[column in domain "FRGGR"] == T16FS.FRGGR
  • C_UNLMTDOVRDELIVPURORDER.PURCHASINGRELEASESTRATEGY == T16FS.FRGSX
Release Indicator: Purchasing Document
  • Release Indicator: Purchasing Document
  • Client
  • C_UNLMTDOVRDELIVPURORDER.RELEASECODE == T16FB.FRGKE
  • C_UNLMTDOVRDELIVPURORDER.MANDT == T16FB.MANDT
Storage Location
  • Client
  • Plant
  • Storage Location
  • C_UNLMTDOVRDELIVPURORDER.MANDT == T001L.MANDT
  • C_UNLMTDOVRDELIVPURORDER.PLANT == T001L.WERKS
  • C_UNLMTDOVRDELIVPURORDER.STORAGELOCATION == T001L.LGORT
Supplier
  • Client
  • Supplier
  • C_UNLMTDOVRDELIVPURORDER.MANDT == LFA1.MANDT
  • C_UNLMTDOVRDELIVPURORDER.SUPPLIER == LFA1.LIFNR