I_SDDocItmReturnedQuantity

DDL: I_SDDOCITMRETURNEDQUANTITY Type: view COMPOSITE
16 Fields 6 Data Sources

Return Quantity Union

I_SDDocItmReturnedQuantity is a Composite CDS View that provides data about "Return Quantity Union" in SAP S/4HANA. It reads from 6 data sources and exposes 16 fields with key fields CustomerReturn, CustomerReturnItem, SalesDocument, SalesDocumentItem, BillingDocument.

Data Sources (6)

SourceAliasJoin Type
I_BillingDocumentItem BillingDocumentItem inner
I_SalesDocumentItemBasic CustomerReturnItem from
I_SalesDocumentItemBasic CustomerReturnItem union_all
I_SalesDocumentBasic SalesDocumentBasic inner
I_SalesDocumentBasic SalesDocumentBasic inner
I_SalesDocumentItemBasic SalesDocumentItem inner

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Return Quantity Union view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDDOCITMRETNQTY view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn I_SalesDocumentItemBasic SalesDocument SD Document
KEY CustomerReturnItem I_SalesDocumentItemBasic SalesDocumentItem Sales Document Item
KEY SalesDocument I_SalesDocumentItemBasic SalesDocument SD Document
KEY SalesDocumentItem I_SalesDocumentItemBasic SalesDocumentItem Sales Document Item
KEY BillingDocument I_BillingDocumentItem BillingDocument SD Document
KEY BillingDocumentItem I_BillingDocumentItem BillingDocumentItem Item
ReferenceSDDocumentCategory I_SalesDocumentItemBasic ReferenceSDDocumentCategory Prec.Doc.Categ.
OrderQuantityUnit I_SalesDocumentItemBasic OrderQuantityUnit Sales Unit
SalesDocumentasCustomerReturn
KEY CustomerReturnItem I_SalesDocumentItemBasic SalesDocumentItem Sales Document Item
KEY SalesDocument I_BillingDocumentItem SalesDocument SD Document
KEY SalesDocumentItem I_BillingDocumentItem SalesDocumentItem Sales Document Item
KEY BillingDocument I_BillingDocumentItem BillingDocument SD Document
KEY BillingDocumentItem I_BillingDocumentItem BillingDocumentItem Item
ReferenceSDDocumentCategory I_SalesDocumentItemBasic ReferenceSDDocumentCategory Prec.Doc.Categ.
OrderQuantityUnit Sales Unit

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 I_SDDocItmReturnedQuantity.
-- 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.

CREATE VIEW I_SDDocItmReturnedQuantity AS
SELECT
  CustomerReturnItem.SalesDocument AS CustomerReturn,
  CustomerReturnItem.SalesDocumentItem AS CustomerReturnItem,
  SalesDocumentItem.SalesDocument AS SalesDocument,
  SalesDocumentItem.SalesDocumentItem AS SalesDocumentItem,
  BillingDocumentItem.BillingDocument AS BillingDocument,
  BillingDocumentItem.BillingDocumentItem AS BillingDocumentItem,
  CustomerReturnItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SalesDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  case when BillingDocumentItem._BillingDocument.SDDocumentCategory = 'N' then DIVISION (CustomerReturnItem.RequestedQuantityInBaseUnit * SalesDocumentItem.OrderToBaseQuantityDnmntr, SalesDocumentItem.OrderToBaseQuantityNmrtr, 3) * -1 else DIVISION (CustomerReturnItem.RequestedQuantityInBaseUnit * SalesDocumentItem.OrderToBaseQuantityDnmntr, SalesDocumentItem.OrderToBaseQuantityNmrtr, 3) end as ReturnedQuantity AS SalesDocumentasCustomerReturn
FROM I_SalesDocumentItemBasic AS CustomerReturnItem
INNER JOIN I_SalesDocumentBasic AS SalesDocumentBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocumentItemBasic AS SalesDocumentItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillingDocumentItem AS BillingDocumentItem ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_SalesDocumentItemBasic
;

Learn More