C_SalesDocWithCustExpdPrice

Sales Doc. w. Customer-Expected Price | view: CSDOCWCUSTEXPPRC | TRAN | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, PRCD_ELEMENTS, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, T685T, MAKT, T685, T685A, VBUV
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Item number of the SD document
PricingDocument Number of the Document Condition
PricingDocumentItem Condition item number
PricingProcedureStep Step Number
PricingProcedureCounter Condition Counter
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
NetPriceAmount Net Price
💲 Currency Key (ConditionCurrency):
CustomerExpectedPrice Customer-Expected Price
CustomerExpectedValue Customer-Expected Value
Column Name Description
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
Column Name Description
CreationDate Date on which the record was created
Column Name Description
SDDocumentCategory SD Document Category Show values
ConditionCategory Condition Category (Examples: Tax, Freight, Price, Cost) Show values
Column Name Description Domain name
PurchaseOrderByCustomer Customer Reference BSTKD
MaterialName Material Description TEXT40
SalesDocumentCondition Number of the Document Condition KNUMV
CreatedByUser Name of Person Responsible for Creating the Object USNAM
NetPriceQuantity Net Pricing Unit KPEIN
ConditionQuantity Customer Pricing Unit KPEIN
ConditionApplication Application KAPPL
ConditionType Condition Type KSCHL
ConditionTypeName Description TEXT30
Master Data Relations Join Conditions
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • C_SALESDOCWITHCUSTEXPDPRICE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SALESDOCWITHCUSTEXPDPRICE.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == TVKOV.MANDT
Material: order item
  • Product Number
  • Client
  • C_SALESDOCWITHCUSTEXPDPRICE.MATERIAL == MARA.MATNR
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == MARA.MANDT
Condition Unit
  • Condition Unit in the Document
  • Condition Unit
  • Client
  • C_SALESDOCWITHCUSTEXPDPRICE.CONDITIONQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCWITHCUSTEXPDPRICE.NETPRICEQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == T006.MANDT
Sales unit
  • Sales unit
  • Client
  • C_SALESDOCWITHCUSTEXPDPRICE.ORDERQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == T006.MANDT
Division in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • Division
  • C_SALESDOCWITHCUSTEXPDPRICE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SALESDOCWITHCUSTEXPDPRICE.SALESORGANIZATION == TVTA.VKORG
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == TVTA.MANDT
  • C_SALESDOCWITHCUSTEXPDPRICE.ORGANIZATIONDIVISION == TVTA.SPART
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_SALESDOCWITHCUSTEXPDPRICE.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == TVAG.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESDOCWITHCUSTEXPDPRICE.SALESDOCUMENTTYPE == TVAK.AUART
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == TVAK.MANDT
Sales group
  • Sales office
  • Client
  • Sales group
  • C_SALESDOCWITHCUSTEXPDPRICE.SALESOFFICE == TVBVK.VKBUR
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == TVBVK.MANDT
  • C_SALESDOCWITHCUSTEXPDPRICE.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESDOCWITHCUSTEXPDPRICE.SALESORGANIZATION == TVKO.VKORG
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_SALESDOCWITHCUSTEXPDPRICE.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == KNA1.MANDT
Target Quantity UoM
  • Target Quantity UoM
  • Client
  • C_SALESDOCWITHCUSTEXPDPRICE.TARGETQUANTITYUNIT == T006.MSEHI
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == T006.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • C_SALESDOCWITHCUSTEXPDPRICE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Distribution Channel
  • Sales Organization
  • Sales office
  • Client
  • Division
  • C_SALESDOCWITHCUSTEXPDPRICE.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_SALESDOCWITHCUSTEXPDPRICE.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESDOCWITHCUSTEXPDPRICE.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESDOCWITHCUSTEXPDPRICE.MANDT == TVKBZ.MANDT
  • C_SALESDOCWITHCUSTEXPDPRICE.ORGANIZATIONDIVISION == TVKBZ.SPART