P_PurOrdItemCastedAmounts

Purchase Order Items with Casted amounts | view: PPOITEMCASTDAMT | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO, EKPO, MMPUR_ANA_CONF
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
ExpectedOverallLimitAmount null
OverallLimitAmount null
NetPriceAmount null
NetAmount null
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Column Name Description
PurchaseOrderDate Purchase Order Date
CreationDate Creation Date of Purchasing Document
Column Name Description
IsReturnsItem Returns Item Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
InvoiceIsExpected Invoice receipt indicator Show values
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
IsFinallyInvoiced Final Invoice Indicator Show values
IsInfoRecordUpdated Indicator: Update Info Record Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
PurchaseOrderItemText Short Text TEXT40
ProductType Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
PurchaseRequisition Purchase Requisition Number BANFN
RequestForQuotation Identifier for Request for Quotation EBELN
RequestForQuotationItem Item Number for Request for Quotation EBELP
RequirementTracking Requirement Tracking Number CHAR10
NetPriceQuantity Price Unit DEC5
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_PURORDITEMCASTEDAMOUNTS.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T163K.MANDT
Company Code
  • Client
  • Company Code
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T001.MANDT
  • P_PURORDITEMCASTEDAMOUNTS.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • P_PURORDITEMCASTEDAMOUNTS.DOCUMENTCURRENCY == TCURC.WAERS
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == MARA.MANDT
  • P_PURORDITEMCASTEDAMOUNTS.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T023.MANDT
  • P_PURORDITEMCASTEDAMOUNTS.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_PURORDITEMCASTEDAMOUNTS.ORDERPRICEUNIT == T006.MSEHI
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T001W.MANDT
  • P_PURORDITEMCASTEDAMOUNTS.PLANT == T001W.WERKS
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • P_PURORDITEMCASTEDAMOUNTS.PURCHASEORDERITEMCATEGORY == T163.PSTYP
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T163.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T006.MANDT
  • P_PURORDITEMCASTEDAMOUNTS.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • P_PURORDITEMCASTEDAMOUNTS.PURCHASEORDERTYPE == T161.BSART
  • P_PURORDITEMCASTEDAMOUNTS.[column in domain "BSTYP"] == T161.BSTYP
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T024.MANDT
  • P_PURORDITEMCASTEDAMOUNTS.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == EINA.MANDT
  • P_PURORDITEMCASTEDAMOUNTS.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURORDITEMCASTEDAMOUNTS.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T024E.MANDT
Storage Location
  • Storage Location
  • Client
  • Plant
  • P_PURORDITEMCASTEDAMOUNTS.STORAGELOCATION == T001L.LGORT
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T001L.MANDT
  • P_PURORDITEMCASTEDAMOUNTS.PLANT == T001L.WERKS
Supplier
  • Supplier
  • Client
  • P_PURORDITEMCASTEDAMOUNTS.SUPPLIER == LFA1.LIFNR
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • P_PURORDITEMCASTEDAMOUNTS.MANDT == T001W.MANDT
  • P_PURORDITEMCASTEDAMOUNTS.SUPPLYINGPLANT == T001W.WERKS