C_PurchaseOrderItemMassUpdate

Mass Changes to Purchase Orders | view: CPOITMMASSUPDATE | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO, EKPO, EKET, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, BUT000, T001, TKA02, TINC, TINCT, TINCV, TINCVT, MARA, T023, T023T, MAKT, T052, TVZBT, T001W, CMD_PRDTYPE, CMD_PRDTYPE_T, T163B, T161, T161T, T024, T024E, T163, T163Y, T001L, LFA1, T163L, T163M, T161M
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
ScheduleLine Delivery Schedule Line Counter
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value
EffectiveAmount Effective value of item
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
ScheduleLineOrderQuantity Scheduled Quantity
📏 Unit of Weight (WeightUnit):
ItemNetWeight Net Weight
📏 Volume unit (VolumeUnit):
ItemVolume Volume
Column Name Description
ScheduleLineDeliveryDate Item delivery date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
PurchaseOrderDate Purchase Order Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
IsFinallyInvoiced Final Invoice Indicator Show values
PricingDateControl Price Determination (Pricing) Date Control Show values
PriceIsToBePrinted Price Printout Show values
IsReturnsItem Returns Item Show values
WarningFlagIsSet Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
FormattedPurchaseOrderItem Purchase Order Item
PurchaseOrderItemText Short Text
MaterialGroupName Product Group Description TEXT20
MaterialName Material Description TEXT40
SupplierName Name of Supplier TEXT80
NumberOfScheduleLines null
StorageLocationName Storage Location Name TEXT16
PlantName Plant Name TEXT30
PurchasingDocumentStatus null
PurchasingDocumentStatusName Purchasing Document Status Name DDTEXT
CompanyCodeName Name of Company Code or Company TEXT25
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
PurgDocExternalItemCategory Item Category in Purchasing Document
PurgDocItemCategoryName Text for Item Category TEXT20
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
ProductType Product Type Group
Name Product Type Group Description TEXT40
PaymentTerms Terms of Payment Key
PaymentTermsName Description of terms of payment TEXT30
IncotermsClassificationName Description TEXT30
InvoicingPartyName Supplier Full Name TEXT220
ManufacturerName Material Description TEXT40
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment
DistributionKeyText Short Text for Fixed Values DDTEXT
PartialInvoiceDistribution Partial invoice indicator
SupplierConfControlKeyName Confirmation Category: Description TEXT20
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed
IsCompletelyDelivered "Delivery Completed" Indicator
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit
OrderItemQtyToBaseQtyNmrtr Numerator for Conversion of Order Unit to Base Unit
OrderItemQtyToBaseQtyDnmntr Denominator for Conversion of Order Unit to Base Unit
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Days Cash discount days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
EarmarkedFundsDocument Document Number for Earmarked Funds
EarmarkedFundsDocumentItem Earmarked Funds: Document Item
ExchangeRate Exchange Rate
GoodsReceiptIsExpected Goods Receipt Indicator
SupplierFullName Supplier Full Name TEXT220
InvoiceIsExpected Invoice receipt indicator
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification
HeaderIncotermsLoc1 Incoterms Location 1
HeaderIncotermsLoc2 Incoterms Location 2
IncotermsLocation1 Incoterms Location 1
IncotermsLocation2 Incoterms Location 2
IncotermsVersionName Description TEXT30
InternationalArticleNumber International Article Number (EAN/UPC)
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance
EvaldRcptSettlmtIsAllowed Evaluated Receipt Settlement (ERS)
NetPriceQuantity Price Unit
PricingDateControlText Short Text for Fixed Values DDTEXT
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
ServicePerformer Service Performer BU_PARTNER
PersonFullName Full Name TEXT80
SupplierMaterialNumber Material Number Used by Supplier
SupplierPhoneNumber Supplier's Telephone Number
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document
PurDocDeletionCodeName Short Text for Fixed Values DDTEXT
ReleaseDateTime null
InternalComment null
PurchasingDocInclusionList null
PurchasingDocExclusionList null
PurOrdItemsAreSelected null
PurOrdHeadersAreSelected null
PurgDocMassUpdtIsSimulated null
ErrorFlagIsSet null
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T163K.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.BASEUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T006.MANDT
Company Code
  • Company Code
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.COMPANYCODE == T001.BUKRS
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.DOCUMENTCURRENCY == TCURC.WAERS
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_PURCHASEORDERITEMMASSUPDATE.ITEMINCOTERMSCLASSIFICATION == TINC.INCO1
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.INCOTERMSVERSION == TINCV.INCOV
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.INVOICINGPARTY == LFA1.LIFNR
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == LFA1.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_PURCHASEORDERITEMMASSUPDATE.ITEMINCOTERMSCLASSIFICATION == TINC.INCO1
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == TINC.MANDT
Volume unit
  • Volume unit
  • Volume unit
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.ITEMVOLUMEUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.VOLUMEUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T006.MANDT
Unit of Weight
  • Unit of Weight
  • Unit of Weight
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.WEIGHTUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.ITEMWEIGHTUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T006.MANDT
Material number
  • Material number
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.MANUFACTURERMATERIAL == MARA.MATNR
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == MARA.MANDT
Material Number
  • Client
  • Material Number
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == MARA.MANDT
  • C_PURCHASEORDERITEMMASSUPDATE.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.MATERIALGROUP == T023.MATKL
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.ORDERPRICEUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.PLANT == T001W.WERKS
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T001W.MANDT
Profit Center
  • ?
  • Profit Center
  • Purchase Order Date
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_PURCHASEORDERITEMMASSUPDATE.PROFITCENTER == CEPC.PRCTR
  • C_PURCHASEORDERITEMMASSUPDATE.PURCHASEORDERDATE == CEPC.DATBI
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == CEPC.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.PURCHASEORDERITEMCATEGORY == T163.PSTYP
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T163.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T006.MANDT
Purchase Order Type
  • ?
  • Purchase Order Type
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURCHASEORDERITEMMASSUPDATE.PURCHASEORDERTYPE == T161.BSART
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.PURCHASINGGROUP == T024.EKGRP
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.PURCHASINGINFORECORD == EINA.INFNR
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T024E.MANDT
Package number
  • Package number
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.SERVICEPACKAGE == ESLH.PACKNO
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == ESLH.MANDT
Storage Location
  • Plant
  • Storage Location
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.PLANT == T001L.WERKS
  • C_PURCHASEORDERITEMMASSUPDATE.STORAGELOCATION == T001L.LGORT
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T001L.MANDT
Supplier
  • Supplier
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.SUPPLIER == LFA1.LIFNR
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == LFA1.MANDT
Confirmation Control Key
  • Confirmation Control Key
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.SUPPLIERCONFIRMATIONCONTROLKEY == T163L.BSTAE
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T163L.MANDT
Supplier Subrange
  • Supplier Subrange
  • ?
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.SUPPLIERSUBRANGE == WYT1.LTSNR
  • C_PURCHASEORDERITEMMASSUPDATE.[column in domain "LIFNR"] == WYT1.LIFNR
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == WYT1.MANDT
Goods Supplier
  • Goods Supplier
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == LFA1.MANDT
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • C_PURCHASEORDERITEMMASSUPDATE.[column in domain "KALSM_D"] == T007A.KALSM
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T007A.MANDT
  • C_PURCHASEORDERITEMMASSUPDATE.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • Tax Jurisdiction
  • ?
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.TAXJURISDICTION == TTXJ.TXJCD
  • C_PURCHASEORDERITEMMASSUPDATE.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == TTXJ.MANDT
Valuation Type
  • Valuation Type
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.VALUATIONTYPE == T149D.BWTAR
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T149D.MANDT
Volume unit
  • Volume unit
  • Volume unit
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.ITEMVOLUMEUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.VOLUMEUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T006.MANDT
Unit of Weight
  • Unit of Weight
  • Unit of Weight
  • Client
  • C_PURCHASEORDERITEMMASSUPDATE.WEIGHTUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.ITEMWEIGHTUNIT == T006.MSEHI
  • C_PURCHASEORDERITEMMASSUPDATE.MANDT == T006.MANDT