C_DuplicateSalesDocumentItem

DDL: C_DUPLICATESALESDOCUMENTITEM SQL: CSDDPLSLSDOCITM Type: view CONSUMPTION Package: ODATA_SD_SDOC_DUPLICATE
18 Fields 1 Data Sources

Item of Duplicate Sales Document

C_DuplicateSalesDocumentItem is a Consumption CDS View that provides data about "Item of Duplicate Sales Document" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItem) and exposes 18 fields with key fields SalesDocument, SalesDocumentItem. Part of development package ODATA_SD_SDOC_DUPLICATE.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentItem I_SalesDocumentItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSDDPLSLSDOCITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Item of Duplicate Sales Document view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SalesDocumentItem SalesDocumentItem Sales Document Item
SalesDocumentItemCategory SalesDocumentItemCategory Item Category
SalesDocumentItemType SalesDocumentItemType Item Type
Material Vehicle Model
RequestedQuantity RequestedQuantity Requested Quantity
RequestedQuantityUnit RequestedQuantityUnit Requested Quantity Unit
NetAmount NetAmount Stated Amount
TransactionCurrency TransactionCurrency Transaction Currency
SDDocumentRejectionStatus SDDocumentRejectionStatus Rejection Sts
SalesDocumentRjcnReason SalesDocumentRjcnReason RejectionReason
_SalesDocument _SalesDocument
_ItemCategory _ItemCategory
_Material _Material
_TransactionCurrency _TransactionCurrency
_SDDocumentRejectionStatus _SDDocumentRejectionStatus
_SalesDocumentRjcnReason _SalesDocumentRjcnReason
_RequestedQuantityUnit _RequestedQuantityUnit

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_DuplicateSalesDocumentItem.
-- 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: CSDDPLSLSDOCITM

CREATE VIEW C_DuplicateSalesDocumentItem AS
SELECT
  SalesDocument,
  SalesDocumentItem,
  SalesDocumentItemCategory,
  SalesDocumentItemType,
  cast(Material as productnumber preserving type ) AS Material,
  RequestedQuantity,
  RequestedQuantityUnit,
  NetAmount,
  TransactionCurrency,
  SDDocumentRejectionStatus,
  SalesDocumentRjcnReason
FROM I_SalesDocumentItem
;

Learn More