C_DuplicateSalesDocument

Duplicate Sales Documents | view: CSDDPLSLSDOC | TRAN | Extraction: Not supported | Component: Sales
Column Name Description
SalesDocument Sales Document
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
RequestedDeliveryDate Requested Delivery Date
Column Name Description
SDDocumentCategory SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
Column Name Description Domain name
DuplicateSalesDocumentGroup null
NumberOfDuplicateSlsDocuments Number of Duplicate Sales Documents
NumberOfDuplicatesInGroup Number of Duplicate Sales Documents
NumberOfItems Number of Items
SDDocumentCategoryName SD Document Category Description DDTEXT
AddressID Address ADRNR
ShipToPartyAddressID Address ADRNR
PostalCode City postal code CHAR10
CityName City TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurchaseOrderByCustomer Customer Reference BSTKD
SalesOrganizationName Sales Organization Description TEXT20
SalesDocumentRjcnReason Reason for Rejection of Sales Documents ABGRU_VA
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • C_DUPLICATESALESDOCUMENT.MANDT == T005.MANDT
  • C_DUPLICATESALESDOCUMENT.COUNTRY == T005.LAND1
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_DUPLICATESALESDOCUMENT.MANDT == TVKOV.MANDT
  • C_DUPLICATESALESDOCUMENT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_DUPLICATESALESDOCUMENT.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • Division
  • C_DUPLICATESALESDOCUMENT.MANDT == TVTA.MANDT
  • C_DUPLICATESALESDOCUMENT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_DUPLICATESALESDOCUMENT.SALESORGANIZATION == TVTA.VKORG
  • C_DUPLICATESALESDOCUMENT.ORGANIZATIONDIVISION == TVTA.SPART
Order type in order header
  • Client
  • Sales Document Type
  • C_DUPLICATESALESDOCUMENT.MANDT == TVAK.MANDT
  • C_DUPLICATESALESDOCUMENT.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales office
  • Sales group
  • C_DUPLICATESALESDOCUMENT.MANDT == TVBVK.MANDT
  • C_DUPLICATESALESDOCUMENT.SALESOFFICE == TVBVK.VKBUR
  • C_DUPLICATESALESDOCUMENT.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • C_DUPLICATESALESDOCUMENT.MANDT == TVKO.MANDT
  • C_DUPLICATESALESDOCUMENT.SALESORGANIZATION == TVKO.VKORG
Customer - Document Customer
  • Client
  • Sold-to Party
  • Ship-to Party
  • C_DUPLICATESALESDOCUMENT.MANDT == KNA1.MANDT
  • C_DUPLICATESALESDOCUMENT.SOLDTOPARTY == KNA1.KUNNR
  • C_DUPLICATESALESDOCUMENT.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • Ship-to Party
  • C_DUPLICATESALESDOCUMENT.MANDT == KNA1.MANDT
  • C_DUPLICATESALESDOCUMENT.SOLDTOPARTY == KNA1.KUNNR
  • C_DUPLICATESALESDOCUMENT.SHIPTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_DUPLICATESALESDOCUMENT.MANDT == TCURC.MANDT
  • C_DUPLICATESALESDOCUMENT.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales office
  • Distribution Channel
  • Sales Organization
  • Division
  • C_DUPLICATESALESDOCUMENT.MANDT == TVKBZ.MANDT
  • C_DUPLICATESALESDOCUMENT.SALESOFFICE == TVKBZ.VKBUR
  • C_DUPLICATESALESDOCUMENT.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_DUPLICATESALESDOCUMENT.SALESORGANIZATION == TVKBZ.VKORG
  • C_DUPLICATESALESDOCUMENT.ORGANIZATIONDIVISION == TVKBZ.SPART