Fclm_Mmpd_Itall

Purchasing Document Items Including Delivery Cost | view: VFCLMMMPDITALL | Extraction: Not supported | Component: SAP Cash Management

Tables used: EKKO, PRCD_ELEMENTS, EKKO, EKPO, T001, T006

🔑 Keys (5)
💰 Amounts (5)
∑ Quantities (4)
📅 Dates (1)
☰ Categorical (17)
Other (22)
🔗 Relations (31)

Column Name	Description
po_item_cat	null
PurchasingDocument FK	Purchasing Document Number
PurchasingDocumentItem	Item Number of Purchasing Document
ConditionStep	null
ConditionCount	null

Column Name	Description
NetAmount	Net Order Value in PO Currency
EffectiveAmount	Effective value of item
NonDeductibleInputTax	Non-deductible input tax
NetPriceAmount	Net Price in Purchasing Document (in Document Currency)
TargetAmount	Target Value for Outline Agreement in Document Currency

Column Name	Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity	Target Quantity
OrderQuantity	Purchase Order Quantity
📏 Volume unit (VolumeUnit):
ItemVolume	Volume
📏 Unit of Weight (WeightUnit):
ItemNetWeight	Net Weight

Column Name	Description
PurchasingDocumentOrderDate	Purchasing Document Date

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values
IsCompletelyDelivered	"Delivery Completed" Indicator	Show values
IsFinallyInvoiced	Final Invoice Indicator	Show values
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
InvoiceIsExpected	Invoice receipt indicator	Show values
InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification	Show values
EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement (ERS)	Show values
UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed	Show values
PriceIsToBePrinted	Price Printout	Show values
MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment	Show values
PartialInvoiceDistribution	Partial invoice indicator	Show values
PricingDateControl	Price Determination (Pricing) Date Control	Show values
IsStatisticalItem	Item is statistical	Show values
IsReturnsItem	Returns Item	Show values
GoodsReceiptNonValuated	Goods Receipt, Non-Valuated	Show values
PurchasingCompletenessStatus	Purchase order not yet complete	Show values
ValueBasedCommitment	Value-based commitment indicator	Show values

Column Name	Description	Domain name
PurchasingDocumentDeletionCode	Deletion Indicator in Purchasing Document	ELOEK
SupplierMaterialNumber	Material Number Used by Supplier	IDNEX
ManufacturerPartNmbr	Manufacturer Part Number	CHAR40
PurchasingDocumentItemText	Short Text	TEXT40
OrderItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit	UMBSZ
OrderItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit	UMBSN
NetPriceQuantity	Price unit	DEC5
PurchaseRequisition	Purchase Requisition Number	BANFN
OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance	PRZ21
UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance	PRZ21
RequisitionerName	Name of requisitioner/requester	AFNAM
IncotermsTransferLocation	Incoterms (Part 2)	INCO2
InternationalArticleNumber	International Article Number (EAN/UPC)	EAN11
OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit	UMBSZ
OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit	UMBSN
PaymentTerms	Terms of payment key	ZTERM
CashDiscount1Days	Cash (Prompt Payment) Discount Days	ZBDXT
CashDiscount2Days	Cash (Prompt Payment) Discount Days	ZBDXT
NetPaymentDays	Cash (Prompt Payment) Discount Days	ZBDXT
CashDiscount1Percent	Cash discount percentage 1	PRZ23
CashDiscount2Percent	Cash Discount Percentage 2	PRZ23
InvoicePlanNumber	Invoicing plan number	CHAR10

Master Data Relations	Join Conditions
Account Assignment Category Client Account Assignment Category	`FCLM_MMPD_ITALL.MANDT == T163K.MANDT` `FCLM_MMPD_ITALL.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Base Unit of Measure Base Unit of Measure Client	`FCLM_MMPD_ITALL.BASEUNIT == T006.MSEHI` `FCLM_MMPD_ITALL.MANDT == T006.MANDT`
Company Code Company Code Client	`FCLM_MMPD_ITALL.COMPANYCODE == T001.BUKRS` `FCLM_MMPD_ITALL.MANDT == T001.MANDT`
Currency Key Client Currency Key Currency Key	`FCLM_MMPD_ITALL.MANDT == TCURC.MANDT` `FCLM_MMPD_ITALL.DOCUMENTCURRENCY == TCURC.WAERS` `FCLM_MMPD_ITALL.COMPANYCODECURRENCY == TCURC.WAERS`
Confirmation Control Key Client Confirmation Control Key	`FCLM_MMPD_ITALL.MANDT == T163L.MANDT` `FCLM_MMPD_ITALL.CONFIRMATIONCONTROL == T163L.BSTAE`
Currency Key Client Currency Key Currency Key	`FCLM_MMPD_ITALL.MANDT == TCURC.MANDT` `FCLM_MMPD_ITALL.DOCUMENTCURRENCY == TCURC.WAERS` `FCLM_MMPD_ITALL.COMPANYCODECURRENCY == TCURC.WAERS`
Incoterms (Part 1) Client Incoterms (Part 1)	`FCLM_MMPD_ITALL.MANDT == TINC.MANDT` `FCLM_MMPD_ITALL.INCOTERMSCLASSIFICATION == TINC.INCO1`
Link to Central Address Management Client ? Manual address number in purchasing document item ?	`FCLM_MMPD_ITALL.MANDT == ADRC.CLIENT` `FCLM_MMPD_ITALL.[column in domain "AD_NATION"] == ADRC.NATION` `FCLM_MMPD_ITALL.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER` `FCLM_MMPD_ITALL.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM`
Manufacturer number Client Manufacturer number	`FCLM_MMPD_ITALL.MANDT == LFA1.MANDT` `FCLM_MMPD_ITALL.MANUFACTURER == LFA1.LIFNR`
Material number Client Material number	`FCLM_MMPD_ITALL.MANDT == MARA.MANDT` `FCLM_MMPD_ITALL.MANUFACTURERMATERIAL == MARA.MATNR`
Material Number Client Material Number	`FCLM_MMPD_ITALL.MANDT == MARA.MANDT` `FCLM_MMPD_ITALL.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`FCLM_MMPD_ITALL.MANDT == T023.MANDT` `FCLM_MMPD_ITALL.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Client Order Price Unit (Purchasing)	`FCLM_MMPD_ITALL.MANDT == T006.MANDT` `FCLM_MMPD_ITALL.ORDERPRICEUNIT == T006.MSEHI`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`FCLM_MMPD_ITALL.MANDT == T006.MANDT` `FCLM_MMPD_ITALL.ORDERQUANTITYUNIT == T006.MSEHI`
Plant Client Plant	`FCLM_MMPD_ITALL.MANDT == T001W.MANDT` `FCLM_MMPD_ITALL.PLANT == T001W.WERKS`
Profit Center Purchasing Document Date Client ? Profit Center	`FCLM_MMPD_ITALL.PURCHASINGDOCUMENTORDERDATE == CEPC.DATBI` `FCLM_MMPD_ITALL.MANDT == CEPC.MANDT` `FCLM_MMPD_ITALL.[column in domain "KOKRS"] == CEPC.KOKRS` `FCLM_MMPD_ITALL.PROFITCENTER == CEPC.PRCTR`
Item category in purchasing document Client Item category in purchasing document	`FCLM_MMPD_ITALL.MANDT == T163.MANDT` `FCLM_MMPD_ITALL.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Purchasing Document Type Purchasing Document Category Client Purchasing Document Type	`FCLM_MMPD_ITALL.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `FCLM_MMPD_ITALL.MANDT == T161.MANDT` `FCLM_MMPD_ITALL.PURCHASINGDOCUMENTTYPE == T161.BSART`
Purchasing Group Purchasing Group Client	`FCLM_MMPD_ITALL.PURCHASINGGROUP == T024.EKGRP` `FCLM_MMPD_ITALL.MANDT == T024.MANDT`
Number of purchasing info record Number of purchasing info record Client	`FCLM_MMPD_ITALL.PURCHASINGINFORECORD == EINA.INFNR` `FCLM_MMPD_ITALL.MANDT == EINA.MANDT`
Purchasing organization Client Purchasing organization	`FCLM_MMPD_ITALL.MANDT == T024E.MANDT` `FCLM_MMPD_ITALL.PURCHASINGORGANIZATION == T024E.EKORG`
Number of delivery address Number of delivery address Client ? ?	`FCLM_MMPD_ITALL.REFERENCEDELIVERYADDRESSID == ADRC.ADDRNUMBER` `FCLM_MMPD_ITALL.MANDT == ADRC.CLIENT` `FCLM_MMPD_ITALL.[column in domain "AD_NATION"] == ADRC.NATION` `FCLM_MMPD_ITALL.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM`
Package number Client Package number	`FCLM_MMPD_ITALL.MANDT == ESLH.MANDT` `FCLM_MMPD_ITALL.SERVICEPACKAGE == ESLH.PACKNO`
Storage location Client Storage location Plant	`FCLM_MMPD_ITALL.MANDT == T001L.MANDT` `FCLM_MMPD_ITALL.STORAGELOCATION == T001L.LGORT` `FCLM_MMPD_ITALL.PLANT == T001L.WERKS`
Vendor's account number Client Vendor's account number	`FCLM_MMPD_ITALL.MANDT == LFA1.MANDT` `FCLM_MMPD_ITALL.SUPPLIER == LFA1.LIFNR`
Volume unit Client Volume unit	`FCLM_MMPD_ITALL.MANDT == T006.MANDT` `FCLM_MMPD_ITALL.VOLUMEUNIT == T006.MSEHI`
Unit of Weight Unit of Weight Client	`FCLM_MMPD_ITALL.WEIGHTUNIT == T006.MSEHI` `FCLM_MMPD_ITALL.MANDT == T006.MANDT`