P_PurchaseOrderMassUpdate

Mass Update of Purchase Orders | view: PPOMASSUPDATE | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO, EKPO, EKET, ADCP, ADRC, T001, TKA02, T005, TINC, TINCT, MARA, T023, T023T, MAKT, T052, TVZBT, T001W, CMD_PRDTYPE, CMD_PRDTYPE_T, T161, T161T, T024, T024E, T163, T163Y, T001L, LFA1
Column Name Description
FormattedPurDoc null
Column Name Description
NetAmount Net Value in Document Currency
EffectiveAmount Effective value of item
Column Name Description
📏 Base Unit of Measure (PurchaseOrderQuantityUnit):
ExchangeRate null
ItemNetWeight Net weight
ItemVolume Volume
Column Name Description
PurchaseOrderDate Purchase Order Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
PerformancePeriodStartDate Performance start date
PerformancePeriodEndDate End Date for Period of Performance
Column Name Description
PurchasingDocumentOrigin Status of Purchasing Document Show values
PriceIsToBePrinted Price Printout Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
IsFinallyInvoiced Final Invoice Indicator Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
PartialInvoiceDistribution Partial invoice indicator Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
InvoiceIsExpected Invoice receipt indicator Show values
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
PricingDateControl Price Determination (Pricing) Date Control Show values
EvaldRcptSettlmtIsAllowed Evaluated Receipt Settlement (ERS) Show values
IsReturnsItem Returns Item Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
FormattedPurchasingDocItem null
PurchaseOrder Purchase Order Number EBELN
PurchaseOrderItem Item Number of Purchase Order EBELP
ReleaseDateTime null
InternalComment null
MemoLine null
DefectCodeText null
ItemIsSelectedForProcessing null
PurgDocMassUpdtIsSimulated null
NumberOfPurchaseOrderItems Number of Contracts
HierarchyNodeLevel null
ParentNode null
DrillDownState null
NumberOfItems null
Plant Plant WERKS
Material Material Number MATNR
PaymentTerms Terms of Payment Key ZTERM
PaymentTermsName Description of terms of payment TEXT30
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
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
IncotermsClassificationName Description TEXT30
IncotermsTransferLocation Incoterms (Part 2) INCO2
SupplierName Name of Supplier TEXT80
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
HeaderIncotermsLoc1 Header Incoterms Location 1 INCO_L
HeaderIncotermsLoc2 Header Incoterms Location 2 INCO_L
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
ManufacturerMaterial Material number MATNR
StorageLocation Storage Location LGORT
MaterialGroup Material Group MATKL
PurchasingInfoRecord Number of purchasing info record INFNR
SupplierMaterialNumber Material Number Used by Supplier IDNEX
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
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
TaxCode Tax on sales/purchases code MWSKZ
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
ValuationType Valuation Type BWTAR
PurchaseOrderItemCategory Item category in purchasing document PSTYP
PurgDocItemCategoryName Text for Item Category TEXT20
AccountAssignmentCategory Account Assignment Category KNTTP
TaxJurisdiction Tax Jurisdiction TXJCD
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
SupplierConfirmationControlKey Confirmation Control Key BSTAE
ProfitCenter Profit Center PRCTR
ItemIncotermsClassification Incoterms (Part 1) INCO1
ItemIncotermsTransferLocation Incoterms (Part 2) INCO2
SupplierSubrange Supplier Subrange LTSNR
ServicePackage Package number PACKNO
EarmarkedFunds Document Number for Earmarked Funds KBLNR
EarmarkedFundsItem Earmarked Funds: Document Item KBLPOS
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
ServicePerformer Service Performer BU_PARTNER
ProductType Product Type MTART
MaterialName Material Description TEXT40
PurchaseOrderItemText Short Text TEXT40
PlantName Plant Name TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
TaxCalculationProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
PurchasingDocumentStatus null
PurchasingDocumentStatusName Explanatory Short Text DDTEXT
SemanticObject null
StorageLocationName Storage Location Name TEXT16
MaterialGroupName Material Group Description TEXT20
ProductTypeName Product Type Group Description TEXT40
InvoicingPartyName Name of Supplier TEXT80
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_PURCHASEORDERMASSUPDATE.MANDT == T001.MANDT
  • P_PURCHASEORDERMASSUPDATE.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_PURCHASEORDERMASSUPDATE.MANDT == TCURC.MANDT
  • P_PURCHASEORDERMASSUPDATE.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • P_PURCHASEORDERMASSUPDATE.MANDT == TINC.MANDT
  • P_PURCHASEORDERMASSUPDATE.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • P_PURCHASEORDERMASSUPDATE.INCOTERMSVERSION == TINCV.INCOV
  • P_PURCHASEORDERMASSUPDATE.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • P_PURCHASEORDERMASSUPDATE.INVOICINGPARTY == LFA1.LIFNR
  • P_PURCHASEORDERMASSUPDATE.MANDT == LFA1.MANDT
Purchase Order Type
  • ?
  • Client
  • Purchase Order Type
  • P_PURCHASEORDERMASSUPDATE.[column in domain "BSTYP"] == T161.BSTYP
  • P_PURCHASEORDERMASSUPDATE.MANDT == T161.MANDT
  • P_PURCHASEORDERMASSUPDATE.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURCHASEORDERMASSUPDATE.MANDT == T024.MANDT
  • P_PURCHASEORDERMASSUPDATE.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCHASEORDERMASSUPDATE.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCHASEORDERMASSUPDATE.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURCHASEORDERMASSUPDATE.SUPPLIER == LFA1.LIFNR
  • P_PURCHASEORDERMASSUPDATE.MANDT == LFA1.MANDT
Goods Supplier
  • Client
  • Goods Supplier
  • P_PURCHASEORDERMASSUPDATE.MANDT == LFA1.MANDT
  • P_PURCHASEORDERMASSUPDATE.SUPPLYINGSUPPLIER == LFA1.LIFNR