P_RefundingQuantity_F1708

DDL: P_REFUNDINGQUANTITY_F1708 SQL: PREFINGQUANF1708 Type: view CONSUMPTION
8 Fields 2 Data Sources 1 Associations 1 Fiori Apps

P_RefundingQuantity_F1708 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentBasic, I_SalesDocumentItemBasic) and exposes 8 fields with key fields CustomerReturn, CustomerReturnItem. It has 1 association to related views. It is used in 1 Fiori application: Manage Customer Returns.

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentBasic CustomerReturn inner
I_SalesDocumentItemBasic CustomerReturnItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_RefundedQuantitySum_F1708 _Refundedquantitysum $projection.CustomerReturn = _Refundedquantitysum.CustomerReturn and $projection.CustomerReturnItem = _Refundedquantitysum.CustomerReturnItem and $projection.SalesOrganization = _Refundedquantitysum.SalesOrganization and $projection.DistributionChannel = _Refundedquantitysum.DistributionChannel and $projection.OrganizationDivision = _Refundedquantitysum.OrganizationDivision and $projection.SalesOffice = _Refundedquantitysum.SalesOffice and $projection.SalesGroup = _Refundedquantitysum.SalesGroup and $projection.SoldToParty = _Refundedquantitysum.SoldToParty

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PREFINGQUANF1708 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view

Fiori Apps (1)

App IDApp NameTypeDescription
F1708 Manage Customer Returns Transactional Manage Customer Returns enables you to create and edit advanced returns. It also allows you to determine refund.

Manage Customer Returns

Business Role: Returns and Refund Clerk

In the Manage Customer Returns app, you can filter returns orders by returns order reason. You can view the returns order reasons in the returns order list.

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn I_SalesDocumentItemBasic SalesDocument SD Document
KEY CustomerReturnItem I_SalesDocumentItemBasic SalesDocumentItem Sales Document Item
SalesOrganization I_SalesDocumentBasic SalesOrganization Sales Organization
DistributionChannel I_SalesDocumentBasic DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_SalesDocumentBasic OrganizationDivision Org. Division
SalesOffice I_SalesDocumentBasic SalesOffice Sales Office
SalesGroup I_SalesDocumentBasic SalesGroup Sales Group
SoldToParty I_SalesDocumentBasic SoldToParty Sold-to Party

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 P_RefundingQuantity_F1708.
-- 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: PREFINGQUANF1708

CREATE VIEW P_RefundingQuantity_F1708 AS
SELECT
  CustomerReturnItem.SalesDocument AS CustomerReturn,
  CustomerReturnItem.SalesDocumentItem AS CustomerReturnItem,
  CustomerReturn.SalesOrganization AS SalesOrganization,
  CustomerReturn.DistributionChannel AS DistributionChannel,
  CustomerReturn.OrganizationDivision AS OrganizationDivision,
  CustomerReturn.SalesOffice AS SalesOffice,
  CustomerReturn.SalesGroup AS SalesGroup,
  CustomerReturn.SoldToParty AS SoldToParty
FROM I_SalesDocumentItemBasic AS CustomerReturnItem
INNER JOIN I_SalesDocumentBasic AS CustomerReturn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RefundedQuantitySum_F1708 AS _Refundedquantitysum ON CustomerReturn = _Refundedquantitysum.CustomerReturn AND CustomerReturnItem = _Refundedquantitysum.CustomerReturnItem AND SalesOrganization = _Refundedquantitysum.SalesOrganization AND DistributionChannel = _Refundedquantitysum.DistributionChannel AND OrganizationDivision = _Refundedquantitysum.OrganizationDivision AND SalesOffice = _Refundedquantitysum.SalesOffice AND SalesGroup = _Refundedquantitysum.SalesGroup AND SoldToParty = _Refundedquantitysum.SoldToParty  -- association [0..1]
;

Learn More