C_SlsDocFlfllmntAnalyzer

Track Sales Orders | view: CSOFANALYZER | Extraction: Not supported | Component: Sales Analytics
Tables used: BKPF, VBRP, VBRK, LIKP, LIPS, AFKO, AFPO, EKKO, EKPO, EKKN, EKET, EKES, VBKD, VEDA, VBAK, FPLT, VBAP, VBEP, VBFA, BSEG, VBPA, VBPA, EKKO, EKPO, CVI_CUST_CT_LINK, BUT000, T001, TKA02, TKA01, KNA1, CVI_CUST_LINK, AUFK, T000, CVI_VEND_LINK, USR21, PRPS, T001, T014
Column Name Description
SalesDocument Sales Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
TotalGrossAmount Total Amount Incl. Taxes
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
SalesDocumentDate Document Date (Date Received/Sent)
RequestedDeliveryDate Requested Delivery Date
Column Name Description
OverallFulfillmentStatus Sales Order Overall Fulfillment Status Show values
FulfillmentStatusInOrder Sales Order Fulfillment Order Status Show values
FulfillmentStatusInSupply Sales Order Fulfillment Supply Status Show values
FulfillmentStatusInDelivery Sales Order Fulfillment Delivery Status Show values
FulfillmentStatusInTransit Sales Order Fulfillment Transit Status Show values
FulfillmentStatusInInvoice Sales Order Fulfillment Invoice Status Show values
FulfillmentStatusInAccounting Sales Order Fulfillment Accounting Status Show values
FulfillmentProcessPhase Sales Order Fulfillment Process Phase Show values
SDDocumentCategory SD Document Category Show values
SalesDocumentProcessingType SD document indicator Show values
SoldToPartyIsOneTimeAccount Is the sold-to party a one-time account? Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallPurchaseConfStatus Purchasing Confirmation Status (All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
SalesDocApprovalStatus Document Approval Status Show values
OverallChmlCmplncStatus Product Marketability Status (All Items) Show values
OverallDangerousGoodsStatus Dangerous Goods Status (All Items) Show values
OverallSafetyDataSheetStatus Safety Data Sheet Status (All Items) Show values
OverallTrdCmplncEmbargoSts Embargo Status (All Items) Show values
OvrlTrdCmplncSnctndListChkSts Screening Status (All Items) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status (All Items) Show values
Column Name Description Domain name
SemanticObject null
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreatedByUserName User Description SUIDTECHDESC
LastChangedByUser User Who Last Changed the Business Document USNAM
LastChangedByUserName User Description SUIDTECHDESC
SoldToPartyFullName Full Name of Sold-to Party TEXT80
PurchaseOrderByCustomer Customer Reference BSTKD
SalesDocumentRjcnReason Reason for Rejection of Sales Documents ABGRU_VA
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
UserDescription User Description SUIDTECHDESC
Master Data Relations Join Conditions
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SLSDOCFLFLLMNTANALYZER.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SLSDOCFLFLLMNTANALYZER.MANDT == TVLS.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_SLSDOCFLFLLMNTANALYZER.SALESORGANIZATION == TVKOV.VKORG
  • C_SLSDOCFLFLLMNTANALYZER.MANDT == TVKOV.MANDT
  • C_SLSDOCFLFLLMNTANALYZER.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_SLSDOCFLFLLMNTANALYZER.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SLSDOCFLFLLMNTANALYZER.MANDT == TVFS.MANDT
Division in order header
  • Sales Organization
  • Client
  • Division
  • Distribution Channel
  • C_SLSDOCFLFLLMNTANALYZER.SALESORGANIZATION == TVTA.VKORG
  • C_SLSDOCFLFLLMNTANALYZER.MANDT == TVTA.MANDT
  • C_SLSDOCFLFLLMNTANALYZER.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SLSDOCFLFLLMNTANALYZER.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Order type in order header
  • Sales Document Type
  • Client
  • C_SLSDOCFLFLLMNTANALYZER.SALESDOCUMENTTYPE == TVAK.AUART
  • C_SLSDOCFLFLLMNTANALYZER.MANDT == TVAK.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • C_SLSDOCFLFLLMNTANALYZER.SALESOFFICE == TVBVK.VKBUR
  • C_SLSDOCFLFLLMNTANALYZER.SALESGROUP == TVBVK.VKGRP
  • C_SLSDOCFLFLLMNTANALYZER.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_SLSDOCFLFLLMNTANALYZER.SALESORGANIZATION == TVKO.VKORG
  • C_SLSDOCFLFLLMNTANALYZER.MANDT == TVKO.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • C_SLSDOCFLFLLMNTANALYZER.MANDT == KNA1.MANDT
  • C_SLSDOCFLFLLMNTANALYZER.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_SLSDOCFLFLLMNTANALYZER.MANDT == TCURC.MANDT
  • C_SLSDOCFLFLLMNTANALYZER.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Sales Organization
  • Client
  • Division
  • Distribution Channel
  • C_SLSDOCFLFLLMNTANALYZER.SALESOFFICE == TVKBZ.VKBUR
  • C_SLSDOCFLFLLMNTANALYZER.SALESORGANIZATION == TVKBZ.VKORG
  • C_SLSDOCFLFLLMNTANALYZER.MANDT == TVKBZ.MANDT
  • C_SLSDOCFLFLLMNTANALYZER.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SLSDOCFLFLLMNTANALYZER.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG