A_CustomerReturnItemSimulation

DDL: A_CUSTOMERRETURNITEMSIMULATION Type: view_entity COMPOSITE
87 Fields 2 Data Sources 3 Associations

Returns Order Item Simulation

A_CustomerReturnItemSimulation is a Composite CDS View that provides data about "Returns Order Item Simulation" in SAP S/4HANA. It reads from 2 data sources (I_CustomerReturnItemEnhanced, I_SalesDocumentBasic) and exposes 87 fields with key fields CustomerReturn, CustomerReturnItem. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CustomerReturnItemEnhanced CustomerReturnItem from
I_SalesDocumentBasic SalesDocumentBasic inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] E_SalesDocumentItemBasic _Extension $projection.CustomerReturn = _Extension.SalesDocument and $projection.CustomerReturnItem = _Extension.SalesDocumentItem
[0..*] A_CustRetItemPartnerSimulation _Partner
[0..*] A_CustRetItemPrcgElmntSimln _PricingElement

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Returns Order Item Simulation view

Fields (87)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn I_CustomerReturnItemEnhanced CustomerReturn
KEY CustomerReturnItem I_CustomerReturnItemEnhanced CustomerReturnItem
HigherLevelItem I_CustomerReturnItemEnhanced HigherLevelItem Higher-Lev.Item
CustomerReturnItemCategory I_CustomerReturnItemEnhanced CustomerReturnItemCategory
CustomerReturnItemText I_CustomerReturnItemEnhanced CustomerReturnItemText
PurchaseOrderByCustomer I_CustomerReturnItemEnhanced PurchaseOrderByCustomer Purchase Order Number
Material I_CustomerReturnItemEnhanced Material Vehicle Model
MaterialByCustomer I_CustomerReturnItemEnhanced MaterialByCustomer Customer Mat.
RequestedQuantity I_CustomerReturnItemEnhanced RequestedQuantity Requested Quantity
RequestedQuantityUnit I_CustomerReturnItemEnhanced RequestedQuantityUnit Requested Quantity Unit
ItemGrossWeight I_CustomerReturnItemEnhanced ItemGrossWeight Gross Weight
ItemNetWeight I_CustomerReturnItemEnhanced ItemNetWeight Net Weight
ItemWeightUnit I_CustomerReturnItemEnhanced ItemWeightUnit Unit of Weight
ItemVolume I_CustomerReturnItemEnhanced ItemVolume Volume
ItemVolumeUnit I_CustomerReturnItemEnhanced ItemVolumeUnit Volume Unit
TransactionCurrency I_CustomerReturnItemEnhanced TransactionCurrency Transaction Currency
NetAmount I_CustomerReturnItemEnhanced NetAmount Stated Amount
PricingDate I_CustomerReturnItemEnhanced PricingDate Pricing Date
MaterialGroup I_CustomerReturnItemEnhanced MaterialGroup Product Group
AdditionalMaterialGroup1 I_CustomerReturnItemEnhanced AdditionalMaterialGroup1 MaterialGroup 1
AdditionalMaterialGroup2 I_CustomerReturnItemEnhanced AdditionalMaterialGroup2 MaterialGroup 2
AdditionalMaterialGroup3 I_CustomerReturnItemEnhanced AdditionalMaterialGroup3 MaterialGroup 3
AdditionalMaterialGroup4 I_CustomerReturnItemEnhanced AdditionalMaterialGroup4 MaterialGroup 4
AdditionalMaterialGroup5 I_CustomerReturnItemEnhanced AdditionalMaterialGroup5 MaterialGroup 5
Subtotal1Amount I_CustomerReturnItemEnhanced Subtotal1Amount Subtotal 1 Amount
Subtotal2Amount I_CustomerReturnItemEnhanced Subtotal2Amount Subtotal 2 Amount
Subtotal3Amount I_CustomerReturnItemEnhanced Subtotal3Amount Subtotal 3 Amount
Subtotal4Amount I_CustomerReturnItemEnhanced Subtotal4Amount Subtotal 4 Amount
Subtotal5Amount I_CustomerReturnItemEnhanced Subtotal5Amount Subtotal 5 Amount
Subtotal6Amount I_CustomerReturnItemEnhanced Subtotal6Amount Subtotal 6 Amount
TaxAmount I_CustomerReturnItemEnhanced TaxAmount Tax Amt in Rptg Crcy
Batch I_CustomerReturnItemEnhanced Batch Lot No.
ProductionPlant I_CustomerReturnItemEnhanced Plant Valuation Area
StorageLocation I_CustomerReturnItemEnhanced StorageLocation StorageLocation
ShippingPoint I_CustomerReturnItemEnhanced ShippingPoint Shipping Point
ShippingType I_CustomerReturnItemEnhanced ShippingType Shipping Type
DeliveryPriority I_CustomerReturnItemEnhanced DeliveryPriority Delivery Prior.
IncotermsClassification I_CustomerReturnItemEnhanced IncotermsClassification Incoterms
IncotermsTransferLocation I_CustomerReturnItemEnhanced IncotermsTransferLocation Incoterms 2
IncotermsLocation1 I_CustomerReturnItemEnhanced IncotermsLocation1 Inco. Location1
IncotermsLocation2 I_CustomerReturnItemEnhanced IncotermsLocation2 Inco. Location2
CustomerPaymentTerms I_CustomerReturnItemEnhanced CustomerPaymentTerms Pyt Terms
ProductTaxClassification1 I_CustomerReturnItemEnhanced ProductTaxClassification1
ProductTaxClassification2 I_CustomerReturnItemEnhanced ProductTaxClassification2
ProductTaxClassification3 I_CustomerReturnItemEnhanced ProductTaxClassification3
ProductTaxClassification4 I_CustomerReturnItemEnhanced ProductTaxClassification4
ProductTaxClassification5 I_CustomerReturnItemEnhanced ProductTaxClassification5
ProductTaxClassification6 I_CustomerReturnItemEnhanced ProductTaxClassification6
ProductTaxClassification7 I_CustomerReturnItemEnhanced ProductTaxClassification7
ProductTaxClassification8 I_CustomerReturnItemEnhanced ProductTaxClassification8
ProductTaxClassification9 I_CustomerReturnItemEnhanced ProductTaxClassification9
SalesDocumentRjcnReason I_CustomerReturnItemEnhanced SalesDocumentRjcnReason RejectionReason
ProfitCenter I_CustomerReturnItemEnhanced ProfitCenter Profit Center
ReturnReason I_CustomerReturnItemEnhanced ReturnReason Return Reason
RetsMgmtProcessingBlock I_CustomerReturnItemEnhanced RetsMgmtProcessingBlock
CustRetItmFollowUpActivity I_CustomerReturnItemEnhanced CustRetItmFollowUpActivity Follow-Up Act.
ReturnsMaterialHasBeenReceived I_CustomerReturnItemEnhanced ReturnsMaterialHasBeenReceived
ReturnsRefundType I_CustomerReturnItemEnhanced ReturnsRefundType
ReturnsRefundProcgMode I_CustomerReturnItemEnhanced ReturnsRefundProcgMode
ReturnsRefundExtent I_CustomerReturnItemEnhanced ReturnsRefundExtent
PrelimRefundIsDetermined I_CustomerReturnItemEnhanced PrelimRefundIsDetermined
ReturnsRefundRjcnReason I_CustomerReturnItemEnhanced ReturnsRefundRjcnReason
ProductionVersion I_CustomerReturnItemEnhanced ProductionVersion Version ID
ReplacementMaterial I_CustomerReturnItemEnhanced ReplacementMaterial
ReplacementMaterialQuantity I_CustomerReturnItemEnhanced ReplacementMaterialQuantity
ReplacementMaterialQtyUnit I_CustomerReturnItemEnhanced ReplacementMaterialQtyUnit
ReplacementMaterialIsRequested I_CustomerReturnItemEnhanced ReplacementMaterialIsRequested
ReplacementMatlSupplyingPlant I_CustomerReturnItemEnhanced ReplacementMatlSupplyingPlant
NextPlantForFollowUpActivity I_CustomerReturnItemEnhanced NextPlantForFollowUpActivity
ReturnsTransshipmentPlant I_CustomerReturnItemEnhanced ReturnsTransshipmentPlant
Supplier I_CustomerReturnItemEnhanced Supplier Supplier
SupplierRetMatlAuthzn I_CustomerReturnItemEnhanced SupplierRetMatlAuthzn
SuplrRetMatlAuthznIsRequired I_CustomerReturnItemEnhanced SuplrRetMatlAuthznIsRequired
CustomerRetMatlInspResultCode I_CustomerReturnItemEnhanced CustomerRetMatlInspResultCode
NextFllwUpActivityForMatlInsp I_CustomerReturnItemEnhanced NextFllwUpActivityForMatlInsp
RetMatlInspResultCode I_CustomerReturnItemEnhanced RetMatlInspResultCode
ProductIsInspectedAtCustSite I_CustomerReturnItemEnhanced ProductIsInspectedAtCustSite
CustRetMatlAuthzn I_CustomerReturnItemEnhanced CustRetMatlAuthzn
ReferenceSDDocument I_CustomerReturnItemEnhanced ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem I_CustomerReturnItemEnhanced ReferenceSDDocumentItem Reference Item
CustomerReturnType I_SalesDocumentBasic SalesDocumentType Sales Doc. Type
OrganizationDivision I_SalesDocumentBasic OrganizationDivision Org. Division
SalesOrganization I_SalesDocumentBasic SalesOrganization Sales Organization
DistributionChannel I_SalesDocumentBasic DistributionChannel RefDistCh-Cust/Mat.
_CustomerReturn _CustomerReturn
_Partner _Partner
_PricingElement _PricingElement

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 A_CustomerReturnItemSimulation.
-- 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 A_CustomerReturnItemSimulation AS
SELECT
  CustomerReturnItem.CustomerReturn AS CustomerReturn,
  CustomerReturnItem.CustomerReturnItem AS CustomerReturnItem,
  CustomerReturnItem.HigherLevelItem AS HigherLevelItem,
  CustomerReturnItem.CustomerReturnItemCategory AS CustomerReturnItemCategory,
  CustomerReturnItem.CustomerReturnItemText AS CustomerReturnItemText,
  CustomerReturnItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CustomerReturnItem.Material AS Material,
  CustomerReturnItem.MaterialByCustomer AS MaterialByCustomer,
  CustomerReturnItem.RequestedQuantity AS RequestedQuantity,
  CustomerReturnItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  CustomerReturnItem.ItemGrossWeight AS ItemGrossWeight,
  CustomerReturnItem.ItemNetWeight AS ItemNetWeight,
  CustomerReturnItem.ItemWeightUnit AS ItemWeightUnit,
  CustomerReturnItem.ItemVolume AS ItemVolume,
  CustomerReturnItem.ItemVolumeUnit AS ItemVolumeUnit,
  CustomerReturnItem.TransactionCurrency AS TransactionCurrency,
  CustomerReturnItem.NetAmount AS NetAmount,
  CustomerReturnItem.PricingDate AS PricingDate,
  CustomerReturnItem.MaterialGroup AS MaterialGroup,
  CustomerReturnItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  CustomerReturnItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  CustomerReturnItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  CustomerReturnItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  CustomerReturnItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  CustomerReturnItem.Subtotal1Amount AS Subtotal1Amount,
  CustomerReturnItem.Subtotal2Amount AS Subtotal2Amount,
  CustomerReturnItem.Subtotal3Amount AS Subtotal3Amount,
  CustomerReturnItem.Subtotal4Amount AS Subtotal4Amount,
  CustomerReturnItem.Subtotal5Amount AS Subtotal5Amount,
  CustomerReturnItem.Subtotal6Amount AS Subtotal6Amount,
  CustomerReturnItem.TaxAmount AS TaxAmount,
  CustomerReturnItem.Batch AS Batch,
  CustomerReturnItem.Plant AS ProductionPlant,
  CustomerReturnItem.StorageLocation AS StorageLocation,
  CustomerReturnItem.ShippingPoint AS ShippingPoint,
  CustomerReturnItem.ShippingType AS ShippingType,
  CustomerReturnItem.DeliveryPriority AS DeliveryPriority,
  CustomerReturnItem.IncotermsClassification AS IncotermsClassification,
  CustomerReturnItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  CustomerReturnItem.IncotermsLocation1 AS IncotermsLocation1,
  CustomerReturnItem.IncotermsLocation2 AS IncotermsLocation2,
  CustomerReturnItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  CustomerReturnItem.ProductTaxClassification1 AS ProductTaxClassification1,
  CustomerReturnItem.ProductTaxClassification2 AS ProductTaxClassification2,
  CustomerReturnItem.ProductTaxClassification3 AS ProductTaxClassification3,
  CustomerReturnItem.ProductTaxClassification4 AS ProductTaxClassification4,
  CustomerReturnItem.ProductTaxClassification5 AS ProductTaxClassification5,
  CustomerReturnItem.ProductTaxClassification6 AS ProductTaxClassification6,
  CustomerReturnItem.ProductTaxClassification7 AS ProductTaxClassification7,
  CustomerReturnItem.ProductTaxClassification8 AS ProductTaxClassification8,
  CustomerReturnItem.ProductTaxClassification9 AS ProductTaxClassification9,
  CustomerReturnItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  CustomerReturnItem.ProfitCenter AS ProfitCenter,
  CustomerReturnItem.ReturnReason AS ReturnReason,
  CustomerReturnItem.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  CustomerReturnItem.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  CustomerReturnItem.ReturnsMaterialHasBeenReceived AS ReturnsMaterialHasBeenReceived,
  CustomerReturnItem.ReturnsRefundType AS ReturnsRefundType,
  CustomerReturnItem.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  CustomerReturnItem.ReturnsRefundExtent AS ReturnsRefundExtent,
  CustomerReturnItem.PrelimRefundIsDetermined AS PrelimRefundIsDetermined,
  CustomerReturnItem.ReturnsRefundRjcnReason AS ReturnsRefundRjcnReason,
  CustomerReturnItem.ProductionVersion AS ProductionVersion,
  CustomerReturnItem.ReplacementMaterial AS ReplacementMaterial,
  CustomerReturnItem.ReplacementMaterialQuantity AS ReplacementMaterialQuantity,
  CustomerReturnItem.ReplacementMaterialQtyUnit AS ReplacementMaterialQtyUnit,
  CustomerReturnItem.ReplacementMaterialIsRequested AS ReplacementMaterialIsRequested,
  CustomerReturnItem.ReplacementMatlSupplyingPlant AS ReplacementMatlSupplyingPlant,
  CustomerReturnItem.NextPlantForFollowUpActivity AS NextPlantForFollowUpActivity,
  CustomerReturnItem.ReturnsTransshipmentPlant AS ReturnsTransshipmentPlant,
  CustomerReturnItem.Supplier AS Supplier,
  CustomerReturnItem.SupplierRetMatlAuthzn AS SupplierRetMatlAuthzn,
  CustomerReturnItem.SuplrRetMatlAuthznIsRequired AS SuplrRetMatlAuthznIsRequired,
  CustomerReturnItem.CustomerRetMatlInspResultCode AS CustomerRetMatlInspResultCode,
  CustomerReturnItem.NextFllwUpActivityForMatlInsp AS NextFllwUpActivityForMatlInsp,
  CustomerReturnItem.RetMatlInspResultCode AS RetMatlInspResultCode,
  CustomerReturnItem.ProductIsInspectedAtCustSite AS ProductIsInspectedAtCustSite,
  CustomerReturnItem.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  CustomerReturnItem.ReferenceSDDocument AS ReferenceSDDocument,
  CustomerReturnItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  SalesDocumentBasic.SalesDocumentType AS CustomerReturnType,
  SalesDocumentBasic.OrganizationDivision AS OrganizationDivision,
  SalesDocumentBasic.SalesOrganization AS SalesOrganization,
  SalesDocumentBasic.DistributionChannel AS DistributionChannel
FROM I_CustomerReturnItemEnhanced AS CustomerReturnItem
INNER JOIN I_SalesDocumentBasic AS SalesDocumentBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON CustomerReturn = _Extension.SalesDocument AND CustomerReturnItem = _Extension.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN A_CustRetItemPartnerSimulation AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_CustRetItemPrcgElmntSimln AS _PricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More