C_MassUpdtPurgDocsImpacted

Documents included in simulation job run | view: CDOCSIMPACTED | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO, EKPO, 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
SimulationJobUUID GUID in 'RAW' format
FormattedPurchasingDocItem Purchasing Document Items
Column Name Description
💲 Currency Key (DocumentCurrency):
EffectiveAmount Effective value of item
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Unit of Weight (ItemWeightUnit):
ItemNetWeight Net Weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume
Column Name Description
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
Column Name Description Domain name
PurchasingDocument Purchasing Document Number
PurchasingGroupName Purchasing Group Name TEXT18
SupplierName Name of Supplier TEXT80
CompanyCodeName Name of Company Code or Company TEXT25
CashDiscount1Days Cash discount days 1
CashDiscount2Days Cash discount days 2
NetPaymentDays Net Payment Terms Period
CashDiscount1Percent Cash discount percentage 1
CashDiscount2Percent Cash Discount Percentage 2
ExchangeRate Exchange Rate
SupplierFullName Supplier Full Name TEXT220
HeaderIncotermsLoc1 Incoterms Location 1
HeaderIncotermsLoc2 Incoterms Location 2
IncotermsClassificationName Description TEXT30
IncotermsVersionName Description TEXT30
InvoicingPartyName Supplier Full Name TEXT220
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PurchasingOrganizationName Purchasing Organization Name TEXT20
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
PurchasingDocumentStatus null
PurchasingDocumentStatusName Purchasing Document Status Name DDTEXT
SupplierPhoneNumber Supplier's Telephone Number
PaymentTerms Terms of Payment Key
PaymentTermsName Description of terms of payment TEXT30
PurchasingDocumentItem Item Number of Purchasing Document
SupplierConfControlKeyName Confirmation Category: Description TEXT20
IsCompletelyDelivered "Delivery Completed" Indicator
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit
OrderItemQtyToBaseQtyDnmntr Denominator for Conversion of Order Unit to Base Unit
EarmarkedFundsDocumentItem Earmarked Funds: Document Item
EarmarkedFundsDocument Document Number for Earmarked Funds
EvaldRcptSettlmtIsAllowed Evaluated Receipt Settlement (ERS)
GoodsReceiptIsExpected Goods Receipt Indicator
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification
IncotermsLocation1 Incoterms Location 1
IncotermsLocation2 Incoterms Location 2
InternationalArticleNumber International Article Number (EAN/UPC)
InvoiceIsExpected Invoice receipt indicator
PurchaseOrderItemCategory Item Category in Purchasing Document
PurgDocItemCategoryName Text for Item Category TEXT20
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit
OrderItemQtyToBaseQtyNmrtr Numerator for Conversion of Order Unit to Base Unit
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance
PlantName Plant Name TEXT30
NetPriceQuantity Price Unit DEC5
ProductType Product Type Group
ProductTypeName Product Type Group Description TEXT40
ServicePerformer Service Performer BU_PARTNER
PersonFullName Full Name TEXT80
StorageLocationName Storage Location Name TEXT16
SupplierMaterialNumber Material Number Used by Supplier
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed
PurchaseOrderItemText Short Text
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T163K.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.BASEUNIT == T006.MSEHI
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T006.MANDT
Company Code
  • Company Code
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.COMPANYCODE == T001.BUKRS
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.DOCUMENTCURRENCY == TCURC.WAERS
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_MASSUPDTPURGDOCSIMPACTED.ITEMINCOTERMSCLASSIFICATION == TINC.INCO1
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.INCOTERMSVERSION == TINCV.INCOV
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.INVOICINGPARTY == LFA1.LIFNR
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == LFA1.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_MASSUPDTPURGDOCSIMPACTED.ITEMINCOTERMSCLASSIFICATION == TINC.INCO1
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == TINC.MANDT
Volume unit
  • Client
  • Volume unit
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T006.MANDT
  • C_MASSUPDTPURGDOCSIMPACTED.ITEMVOLUMEUNIT == T006.MSEHI
Unit of Weight
  • Unit of Weight
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.ITEMWEIGHTUNIT == T006.MSEHI
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.MATERIAL == MARA.MATNR
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T023.MANDT
  • C_MASSUPDTPURGDOCSIMPACTED.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T006.MANDT
  • C_MASSUPDTPURGDOCSIMPACTED.ORDERPRICEUNIT == T006.MSEHI
Plant
  • Plant
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.PLANT == T001W.WERKS
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T001W.MANDT
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.PURCHASEORDERTYPE == T161.BSART
  • C_MASSUPDTPURGDOCSIMPACTED.[column in domain "BSTYP"] == T161.BSTYP
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.PURCHASINGGROUP == T024.EKGRP
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T024.MANDT
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == EINA.MANDT
  • C_MASSUPDTPURGDOCSIMPACTED.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Purchasing organization
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.PURCHASINGORGANIZATION == T024E.EKORG
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T024E.MANDT
Package number
  • Package number
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.SERVICEPACKAGE == ESLH.PACKNO
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == ESLH.MANDT
Storage Location
  • Plant
  • Storage Location
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.PLANT == T001L.WERKS
  • C_MASSUPDTPURGDOCSIMPACTED.STORAGELOCATION == T001L.LGORT
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T001L.MANDT
Supplier
  • Supplier
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.SUPPLIER == LFA1.LIFNR
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == LFA1.MANDT
Confirmation Control Key
  • Client
  • Confirmation Control Key
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T163L.MANDT
  • C_MASSUPDTPURGDOCSIMPACTED.SUPPLIERCONFIRMATIONCONTROLKEY == T163L.BSTAE
Supplier Subrange
  • ?
  • Supplier Subrange
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.[column in domain "LIFNR"] == WYT1.LIFNR
  • C_MASSUPDTPURGDOCSIMPACTED.SUPPLIERSUBRANGE == WYT1.LTSNR
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == WYT1.MANDT
Goods Supplier
  • Goods Supplier
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == LFA1.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Client
  • ?
  • C_MASSUPDTPURGDOCSIMPACTED.TAXCODE == T007A.MWSKZ
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T007A.MANDT
  • C_MASSUPDTPURGDOCSIMPACTED.[column in domain "KALSM_D"] == T007A.KALSM
Tax Jurisdiction
  • Tax Jurisdiction
  • Client
  • ?
  • C_MASSUPDTPURGDOCSIMPACTED.TAXJURISDICTION == TTXJ.TXJCD
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == TTXJ.MANDT
  • C_MASSUPDTPURGDOCSIMPACTED.[column in domain "TAX_KALSM"] == TTXJ.KALSM
Valuation Type
  • Valuation Type
  • Client
  • C_MASSUPDTPURGDOCSIMPACTED.VALUATIONTYPE == T149D.BWTAR
  • C_MASSUPDTPURGDOCSIMPACTED.MANDT == T149D.MANDT