C_SalesDocumentByObjectStatus

Sales Documents by Object Status | view: CSLSDOCBYOBJSTS | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDA
Column Name Description
SalesDocument Sales Document
SalesDocumentItem Item number of the SD document
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
RequestedDeliveryDate Requested Delivery Date
Column Name Description
SDDocumentCategory SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
SystemStatusName Concatenated System Status Name for Sales Document CONCAT_SYS_STATUS_NAME
UserStatusName Concatenated User Status Name for Sales Document CONCAT_USER_STATUS_NAME
SystemStatusShortName Concatenated System Status Short Name for Sales Document CONCAT_SYS_STATUS_SHORT_NAME
UserStatusShortName Concatenated User Status Short Name for Sales Document CONCAT_USER_STATUS_SHORT_NAME
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurchaseOrderByCustomer Customer Reference BSTKD
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SALESDOCUMENTBYOBJECTSTATUS.MANDT == TVKOV.MANDT
  • C_SALESDOCUMENTBYOBJECTSTATUS.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESDOCUMENTBYOBJECTSTATUS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Material: order item
  • Client
  • Product Number
  • C_SALESDOCUMENTBYOBJECTSTATUS.MANDT == MARA.MANDT
  • C_SALESDOCUMENTBYOBJECTSTATUS.MATERIAL == MARA.MATNR
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • C_SALESDOCUMENTBYOBJECTSTATUS.MANDT == TVTA.MANDT
  • C_SALESDOCUMENTBYOBJECTSTATUS.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESDOCUMENTBYOBJECTSTATUS.SALESORGANIZATION == TVTA.VKORG
  • C_SALESDOCUMENTBYOBJECTSTATUS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESDOCUMENTBYOBJECTSTATUS.SALESDOCUMENTTYPE == TVAK.AUART
  • C_SALESDOCUMENTBYOBJECTSTATUS.MANDT == TVAK.MANDT
Sales group
  • Client
  • Sales group
  • Sales office
  • C_SALESDOCUMENTBYOBJECTSTATUS.MANDT == TVBVK.MANDT
  • C_SALESDOCUMENTBYOBJECTSTATUS.SALESGROUP == TVBVK.VKGRP
  • C_SALESDOCUMENTBYOBJECTSTATUS.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • C_SALESDOCUMENTBYOBJECTSTATUS.MANDT == TVKO.MANDT
  • C_SALESDOCUMENTBYOBJECTSTATUS.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • C_SALESDOCUMENTBYOBJECTSTATUS.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESDOCUMENTBYOBJECTSTATUS.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Sales Organization
  • Distribution Channel
  • C_SALESDOCUMENTBYOBJECTSTATUS.MANDT == TVKBZ.MANDT
  • C_SALESDOCUMENTBYOBJECTSTATUS.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SALESDOCUMENTBYOBJECTSTATUS.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESDOCUMENTBYOBJECTSTATUS.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESDOCUMENTBYOBJECTSTATUS.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG