C_DuplicateSalesDocGroup

DDL: C_DUPLICATESALESDOCGROUP SQL: CDPLSLSDOCGRP Type: view CONSUMPTION
19 Fields 1 Data Sources

Group of Duplicate Sales Documents

C_DuplicateSalesDocGroup is a Consumption CDS View that provides data about "Group of Duplicate Sales Documents" in SAP S/4HANA. It reads from 1 data source (P_DuplicateSalesDocumentGrpg) and exposes 19 fields with key field DuplicateSalesDocumentGroup.

Data Sources (1)

SourceAliasJoin Type
P_DuplicateSalesDocumentGrpg P_DuplicateSalesDocumentGrpg from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CDPLSLSDOCGRP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Group of Duplicate Sales Documents view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY DuplicateSalesDocumentGroup DuplicateSalesDocumentGroup
NumberOfDuplicateSlsDocuments NumberOfDuplicateSlsDocuments
SDDocumentCategory SDDocumentCategory Document Cat.
_SDDocumentCategory _SDDocumentCategory
SalesDocumentType SalesDocumentType Sales Doc. Type
_SalesDocumentType _SalesDocumentType
SoldToParty SoldToParty Sold-to Party
_SoldToParty _SoldToParty
CreationDate CreationDate Time Stamp
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
_TransactionCurrency _TransactionCurrency
SalesOrganization SalesOrganization Sales Organization
_SalesOrganization _SalesOrganization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
_DistributionChannel _DistributionChannel
OrganizationDivision OrganizationDivision Org. Division
_OrganizationDivision _OrganizationDivision
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_DuplicateSalesDocGroup.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CDPLSLSDOCGRP

CREATE VIEW C_DuplicateSalesDocGroup AS
SELECT
  DuplicateSalesDocumentGroup,
  NumberOfDuplicateSlsDocuments,
  SDDocumentCategory,
  SalesDocumentType,
  SoldToParty,
  CreationDate,
  TotalNetAmount,
  TransactionCurrency,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  PurchaseOrderByCustomer
FROM P_DuplicateSalesDocumentGrpg
;

Learn More