P_DuplicateSalesDocumentGrpg

Grouping Criteria for Duplicate Sales Documents | view: PSDDPLSLSDOCGRPG | Extraction: Not supported | Component: Sales
Tables used: VBKDVEDAVBAK
Column Name Description
DuplicateSalesDocumentGroup null
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order 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
Column Name Description Domain name
NumberOfDuplicateSlsDocuments null
PurchaseOrderByCustomer Customer Reference BSTKD
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • P_DUPLICATESALESDOCUMENTGRPG.MANDT == TVKOV.MANDT
  • P_DUPLICATESALESDOCUMENTGRPG.SALESORGANIZATION == TVKOV.VKORG
  • P_DUPLICATESALESDOCUMENTGRPG.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Division
  • Client
  • Sales Organization
  • Distribution Channel
  • P_DUPLICATESALESDOCUMENTGRPG.ORGANIZATIONDIVISION == TVTA.SPART
  • P_DUPLICATESALESDOCUMENTGRPG.MANDT == TVTA.MANDT
  • P_DUPLICATESALESDOCUMENTGRPG.SALESORGANIZATION == TVTA.VKORG
  • P_DUPLICATESALESDOCUMENTGRPG.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Order type in order header
  • Sales Document Type
  • Client
  • P_DUPLICATESALESDOCUMENTGRPG.SALESDOCUMENTTYPE == TVAK.AUART
  • P_DUPLICATESALESDOCUMENTGRPG.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • P_DUPLICATESALESDOCUMENTGRPG.MANDT == TVKO.MANDT
  • P_DUPLICATESALESDOCUMENTGRPG.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • P_DUPLICATESALESDOCUMENTGRPG.SOLDTOPARTY == KNA1.KUNNR
  • P_DUPLICATESALESDOCUMENTGRPG.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • P_DUPLICATESALESDOCUMENTGRPG.MANDT == TCURC.MANDT
  • P_DUPLICATESALESDOCUMENTGRPG.TRANSACTIONCURRENCY == TCURC.WAERS