C_WhereUsdPrftCtrSlsOrderItem

Where-Used Profit Centers - Sales Order Item | view: CWUPCSOI | 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
SDDocumentCategory SD Document Category Show values
SalesDocumentItemType Item Type 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
Column Name Description Domain name
ProfitCenter Profit Center PRCTR
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SalesDocumentItemTypeText Short Text for Fixed Values DDTEXT
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
SDProcessStatusDesc Status Description TEXT20
DeliveryStatusText Status Description TEXT20
TotalDeliveryStatusDesc Status Description TEXT20
ItemBillingStatusText Status Description TEXT20
Master Data Relations Join Conditions
Controlling Area
  • Controlling Area
  • Client
  • C_WHEREUSDPRFTCTRSLSORDERITEM.CONTROLLINGAREA == TKA01.KOKRS
  • C_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TKA01.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_WHEREUSDPRFTCTRSLSORDERITEM.SALESORGANIZATION == TVKOV.VKORG
  • C_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVKOV.MANDT
  • C_WHEREUSDPRFTCTRSLSORDERITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Sales Organization
  • Division
  • Client
  • Distribution Channel
  • C_WHEREUSDPRFTCTRSLSORDERITEM.SALESORGANIZATION == TVTA.VKORG
  • C_WHEREUSDPRFTCTRSLSORDERITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • C_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVTA.MANDT
  • C_WHEREUSDPRFTCTRSLSORDERITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales document item category
  • Sales document item category
  • Client
  • C_WHEREUSDPRFTCTRSLSORDERITEM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVPT.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_WHEREUSDPRFTCTRSLSORDERITEM.SALESDOCUMENTTYPE == TVAK.AUART
  • C_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVAK.MANDT
Sales group
  • Sales group
  • Client
  • Sales office
  • C_WHEREUSDPRFTCTRSLSORDERITEM.SALESGROUP == TVBVK.VKGRP
  • C_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVBVK.MANDT
  • C_WHEREUSDPRFTCTRSLSORDERITEM.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Sales Organization
  • Client
  • C_WHEREUSDPRFTCTRSLSORDERITEM.SALESORGANIZATION == TVKO.VKORG
  • C_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_WHEREUSDPRFTCTRSLSORDERITEM.SOLDTOPARTY == KNA1.KUNNR
  • C_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == KNA1.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TCURC.MANDT
  • C_WHEREUSDPRFTCTRSLSORDERITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Division
  • Client
  • Sales office
  • Distribution Channel
  • C_WHEREUSDPRFTCTRSLSORDERITEM.SALESORGANIZATION == TVKBZ.VKORG
  • C_WHEREUSDPRFTCTRSLSORDERITEM.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_WHEREUSDPRFTCTRSLSORDERITEM.MANDT == TVKBZ.MANDT
  • C_WHEREUSDPRFTCTRSLSORDERITEM.SALESOFFICE == TVKBZ.VKBUR
  • C_WHEREUSDPRFTCTRSLSORDERITEM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG