P_WhereUsdPrftCtrSlsOrderItem

Where-User Profit Centers - SO Item | view: PWUPCSOI | TRAN | Extraction: Not supported | Component: Fiori FXU Cost Controlling CO-FIO
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDAT001TKA02TVKOTVAKTVBSTTVBSTTVBSTTVBST
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
Column Name Description
SalesDocumentItemType Item Type Show values
SDDocumentCategory SD Document Category Show values
SDProcessStatus Overall Processing Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
IsSalesOrderCategory SD Document Category Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
ProfitCenter Profit Center PRCTR
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
SalesDocumentItemTypeText Short Text for Fixed Values DDTEXT
SDProcessStatusDesc Status Description TEXT20
DeliveryStatusText Status Description TEXT20
TotalDeliveryStatusDesc Status Description TEXT20
ItemBillingStatusText Status Description TEXT20
Master Data Relations Join Conditions
Controlling Area
  • Client
  • Controlling Area
  • P_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TKA01.MANDT
  • P_WHEREUSDPRFTCTRSLSORDERITEM.CONTROLLINGAREA == TKA01.KOKRS
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • P_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVKOV.MANDT
  • P_WHEREUSDPRFTCTRSLSORDERITEM.SALESORGANIZATION == TVKOV.VKORG
  • P_WHEREUSDPRFTCTRSLSORDERITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • P_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVTA.MANDT
  • P_WHEREUSDPRFTCTRSLSORDERITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • P_WHEREUSDPRFTCTRSLSORDERITEM.SALESORGANIZATION == TVTA.VKORG
  • P_WHEREUSDPRFTCTRSLSORDERITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales document item category
  • Client
  • Sales document item category
  • P_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVPT.MANDT
  • P_WHEREUSDPRFTCTRSLSORDERITEM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Client
  • Sales Document Type
  • P_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVAK.MANDT
  • P_WHEREUSDPRFTCTRSLSORDERITEM.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales group
  • Sales office
  • P_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVBVK.MANDT
  • P_WHEREUSDPRFTCTRSLSORDERITEM.SALESGROUP == TVBVK.VKGRP
  • P_WHEREUSDPRFTCTRSLSORDERITEM.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • P_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVKO.MANDT
  • P_WHEREUSDPRFTCTRSLSORDERITEM.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • P_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == KNA1.MANDT
  • P_WHEREUSDPRFTCTRSLSORDERITEM.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • Client
  • SD Document Currency
  • P_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TCURC.MANDT
  • P_WHEREUSDPRFTCTRSLSORDERITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • Sales office
  • P_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVKBZ.MANDT
  • P_WHEREUSDPRFTCTRSLSORDERITEM.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_WHEREUSDPRFTCTRSLSORDERITEM.SALESORGANIZATION == TVKBZ.VKORG
  • P_WHEREUSDPRFTCTRSLSORDERITEM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_WHEREUSDPRFTCTRSLSORDERITEM.SALESOFFICE == TVKBZ.VKBUR