C_PurOrdDownPaymentMntr

Monitor Purchase Order Down Payments | view: CMMPOIDPMNTR | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKOEKPOEKETBSEGEKBEEKBEHT163KT163IT001TKA02T175DPT175DP_TEXTMARAT023T023TMAKTT001WT163BT161T161TT024T024ET163T163YLFA1USR21T001T014
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem Item Number of Purchasing Document
Column Name Description
💲 Display Currency (DisplayCurrency):
DownPaymentAmount null
DownPayments null
DownPaymentsRequest null
NetPriceAmount null
NetAmount null
GoodsReceiptAmountInCoCodeCrcy Value of Delivered PO Items
InvoiceReceiptAmount null
StillToBeDeliveredValue Value of PO Items to be Delivered
StillToInvoiceValue Value of PO Items to be Invoiced
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
GoodsReceiptQty null
InvoiceReceiptQty null
StillToBeDeliveredQuantity Quantity to be Delivered
StillToInvoiceQuantity Quantity to be Invoiced
Column Name Description
PurchaseOrderDate Purchase Order Date
DownPaymentDueDate Due Date for Down Payment
Column Name Description
Column Name Description Domain name
FormattedPurchaseOrderItem Purchase Order Item
SupplierName Supplier Name TEXT80
MaterialGroupName Material Group Name TEXT20
MaterialName Material Description
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
PlantName Plant Name TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
AcctAssignmentCategoryName Account Assignment Category Description TEXT20
PurchaseOrderItemText Short Text
PurchaseOrderTypeName Short Description of Purchasing Document Type
PurgDocExternalItemCategory Item Category PSTYP
PurOrdItemCategoryName Item Category Text TEXT20
PurchaseRequisition Purchase Requisition BANFN
DueDateCriticality null
DownPaymentType Down Payment Indicator
DownPaymentTypeName Text for Down Payment Category
DownPaymentPercentageOfTotAmt Down Payment Percentage
PlannedDeliveryDuration null
DeliveryInfoText1 null
NetPriceQuantity Price Unit DEC5
NumberOfPurchaseOrderItems null
PurchasingDocumentStatus null
PurchasingDocumentStatusName null
DownPaymentStatus null
DownPaymentStatusName null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_PURORDDOWNPAYMENTMNTR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_PURORDDOWNPAYMENTMNTR.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • C_PURORDDOWNPAYMENTMNTR.COMPANYCODE == T001.BUKRS
  • C_PURORDDOWNPAYMENTMNTR.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • C_PURORDDOWNPAYMENTMNTR.MANDT == TCURC.MANDT
  • C_PURORDDOWNPAYMENTMNTR.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • C_PURORDDOWNPAYMENTMNTR.MATERIAL == MARA.MATNR
  • C_PURORDDOWNPAYMENTMNTR.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_PURORDDOWNPAYMENTMNTR.MATERIALGROUP == T023.MATKL
  • C_PURORDDOWNPAYMENTMNTR.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • C_PURORDDOWNPAYMENTMNTR.ORDERPRICEUNIT == T006.MSEHI
  • C_PURORDDOWNPAYMENTMNTR.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • C_PURORDDOWNPAYMENTMNTR.PLANT == T001W.WERKS
  • C_PURORDDOWNPAYMENTMNTR.MANDT == T001W.MANDT
Item Category
  • Item Category
  • Client
  • C_PURORDDOWNPAYMENTMNTR.PURCHASEORDERITEMCATEGORY == T163.PSTYP
  • C_PURORDDOWNPAYMENTMNTR.MANDT == T163.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_PURORDDOWNPAYMENTMNTR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • C_PURORDDOWNPAYMENTMNTR.MANDT == T006.MANDT
Order Type (Purchasing)
  • ?
  • Order Type (Purchasing)
  • Client
  • C_PURORDDOWNPAYMENTMNTR.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURORDDOWNPAYMENTMNTR.PURCHASEORDERTYPE == T161.BSART
  • C_PURORDDOWNPAYMENTMNTR.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURORDDOWNPAYMENTMNTR.PURCHASINGGROUP == T024.EKGRP
  • C_PURORDDOWNPAYMENTMNTR.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • C_PURORDDOWNPAYMENTMNTR.PURCHASINGINFORECORD == EINA.INFNR
  • C_PURORDDOWNPAYMENTMNTR.MANDT == EINA.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_PURORDDOWNPAYMENTMNTR.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURORDDOWNPAYMENTMNTR.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PURORDDOWNPAYMENTMNTR.SUPPLIER == LFA1.LIFNR
  • C_PURORDDOWNPAYMENTMNTR.MANDT == LFA1.MANDT