I_CUSTOMERRETURNITEMENHANCED

@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Returns Order Item Enhanced'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: [ '_CreatedByUser', '_Address', '_DfltAddrRprstn' ]
}
@AbapCatalog: {
  sqlViewName: 'ISDCRITMENHANCED',
  preserveKey: true,
  compiler.compareFilter: true
}
@ObjectModel: {
  representativeKey: 'CustomerReturnItem',
  modelingPattern: #ANALYTICAL_DIMENSION,
  supportedCapabilities: [#ANALYTICAL_DIMENSION,
                          #CDS_MODELING_ASSOCIATION_TARGET,
                          #CDS_MODELING_DATA_SOURCE,
                          #SQL_DATA_SOURCE],
  usageType: {
    dataClass:      #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory:   #XL
   }
}
@Analytics.dataCategory: #DIMENSION
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true

define view I_CustomerReturnItemEnhanced
  as select from           I_CustomerReturnItem           as Item
    left outer to one join I_AdvncdReturnsMgmtProcessItem as AdvncdRetsMgmtProcessItem on  AdvncdRetsMgmtProcessItem.ReturnsDocument     = Item.CustomerReturn
                                                                                       and AdvncdRetsMgmtProcessItem.RetsMgmtProcess     = Item.RetsMgmtProcess
                                                                                       and AdvncdRetsMgmtProcessItem.RetsMgmtProcessItem = Item.CustomerReturnItem

    left outer join        I_AdvncdReturnsMgmtProcessStep as AdvncdRetsMgmtProcessStep on  AdvncdRetsMgmtProcessStep.ReturnsDocument         = Item.CustomerReturn
                                                                                       and AdvncdRetsMgmtProcessStep.RetsMgmtProcess         = Item.RetsMgmtProcess
                                                                                       and AdvncdRetsMgmtProcessStep.RetsMgmtProcessItem     = Item.CustomerReturnItem
                                                                                       and AdvncdRetsMgmtProcessStep.RetsMgmtProcItmQtySplit = '000'
                                                                                       and AdvncdRetsMgmtProcessStep.RetsMgmtProcessStep     = '0001'
                                                                                       and AdvncdRetsMgmtProcessStep.ReturnsDocumentType     = '00' //

    left outer to one join I_CustRetItemWithReleaseStatus  as ItemWithReleaseStatus     on  ItemWithReleaseStatus.CustomerReturn = Item.CustomerReturn
                                                                                       and ItemWithReleaseStatus.CustomerReturnItem = Item.CustomerReturnItem

  //Association

  association [1..1] to I_CustomerReturnEnhanced as _CustomerReturn on _CustomerReturn.CustomerReturn = $projection.CustomerReturn
{
       @Consumption.valueHelpDefinition: [
         { entity: { name:    'I_CustomerReturnStdVH',
                    element: 'CustomerReturn' }
         }]
       @ObjectModel.foreignKey.association: '_CustomerReturn'
  key  Item.CustomerReturn,
  key  Item.CustomerReturnItem,

       Item.CustomerReturnItemUUID,

       //Category

       @ObjectModel.foreignKey.association: '_ItemCategory'
       Item.CustomerReturnItemCategory      as CustomerReturnItemCategory,
       Item.CustomerReturnItemType          as CustomerReturnItemType,
       Item.IsReturnsItem,

       //Admin

       Item.CreatedByUser,
       Item.CreationDate,
       Item.CreationTime,
       Item.LastChangeDate,

       //Org

       Item.Division,

       //Product

       @Consumption.valueHelpDefinition: [
         { entity: { name:    'I_MaterialStdVH',
                     element: 'Material' }
         }]
       @API.element.releaseState: #DEPRECATED
       @API.element.successor: 'Product'
       Item.Material,
       @API.element.releaseState: #DEPRECATED
       @API.element.successor: '_Product'
       Item._Material,

       @Analytics.internalName: #LOCAL
       Item.Product,
       Item._Product,

       @API.element.releaseState: #DEPRECATED
       @API.element.successor: 'ProductGroup'
       Item.MaterialGroup,
       @API.element.releaseState: #DEPRECATED
       @API.element.successor: '_ProductGroup'
       Item._MaterialGroup,

       @Analytics.internalName: #LOCAL
       Item.ProductGroup,
       Item._ProductGroup,

       @Consumption.valueHelpDefinition: [
         { entity: { name:    'I_MaterialStdVH',
                     element: 'Material' }
         }]
       Item.OriginallyRequestedMaterial,
       Item.MaterialByCustomer,
       Item.InternationalArticleNumber,
       Item.Batch,
       Item.ProductHierarchyNode,
       Item.ProductCatalog,
       Item.AdditionalMaterialGroup1,
       Item.AdditionalMaterialGroup2,
       Item.AdditionalMaterialGroup3,
       Item.AdditionalMaterialGroup4,
       Item.AdditionalMaterialGroup5,
       @Analytics.internalName: #LOCAL
       @ObjectModel.foreignKey.association: '_MatlAccountAssignmentGroup'
       Item.MatlAccountAssignmentGroup,
       Item.Plant,
       Item.StorageLocation,
       Item.ProductConfiguration,
       Item.BillOfMaterial,
       Item.BOMExplosionDate,

       //Sales

       Item.CustomerReturnItemText,
       Item.PurchaseOrderByCustomer,
       Item.PurchaseOrderByShipToParty,
       Item.CorrespncExternalReference,
       Item.CorrespncExtRefByShipToParty,
       Item.UnderlyingPurchaseOrderItem,
       Item.UndrlgPurOrdItmByShipToParty,
       @Analytics.internalName: #LOCAL
       @ObjectModel.foreignKey.association: '_CustPurOrdTypeByShipToParty'
       Item.CustPurOrdTypeByShipToParty,
       @Analytics.internalName: #LOCAL
       @ObjectModel.foreignKey.association: '_CustomerPurchaseOrderType'
       Item.CustomerPurchaseOrderType,
       

       @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
       Item.OrderQuantity,
       @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
       Item.ConfdDelivQtyInOrderQtyUnit,
       @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
       Item.TargetDelivQtyInOrderQtyUnit,
       @Semantics.unitOfMeasure: true
       Item.OrderQuantityUnit,

       @Semantics.quantity.unitOfMeasure: 'BaseUnit'
       Item.ConfdDeliveryQtyInBaseUnit,
       //@Semantics.unitOfMeasure: true

       Item.BaseUnit,

       Item.OrderToBaseQuantityDnmntr,
       Item.OrderToBaseQuantityNmrtr,

       @Semantics.quantity.unitOfMeasure: 'RequestedQuantityUnit'
       Item.RequestedQuantity,
       //@Semantics.unitOfMeasure: true

       Item.RequestedQuantityUnit,

       @Semantics.quantity.unitOfMeasure: 'BaseUnit'
       Item.RequestedQuantityInBaseUnit,
       @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
       Item.ItemGrossWeight,
       @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
       Item.ItemNetWeight,
       //@Semantics.unitOfMeasure: true

       Item.ItemWeightUnit,

       @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
       Item.ItemVolume,
       //@Semantics.unitOfMeasure: true

       Item.ItemVolumeUnit,
       Item.ServicesRenderedDate,
       Item.SalesDistrict,
       @Consumption.valueHelpDefinition: [
         { entity: { name:    'I_SalesDealStdVH',
                     element: 'SalesDeal' }
         }]
       Item.SalesDeal,
       Item.CustomerGroup,
       Item.SalesDocumentRjcnReason,

       //Pricing

       @Semantics.amount.currencyCode: 'TransactionCurrency'
       Item.NetAmount,
       Item.PricingDate,
       @Semantics.currencyCode: true
       Item.TransactionCurrency,
       Item.ExchangeRateDate,
       Item.PriceDetnExchangeRate,

       @Semantics.amount.currencyCode: 'TransactionCurrency'
       Item.NetPriceAmount,

       @Semantics.quantity.unitOfMeasure: 'NetPriceQuantityUnit'
       Item.NetPriceQuantity,
       //@Semantics.unitOfMeasure: true

       Item.NetPriceQuantityUnit,

       Item.StatisticalValueControl,
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       Item.TaxAmount,
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       Item.CostAmount,

       @Semantics.amount.currencyCode: 'TransactionCurrency'
       Item.Subtotal1Amount,
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       Item.Subtotal2Amount,
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       Item.Subtotal3Amount,
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       Item.Subtotal4Amount,
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       Item.Subtotal5Amount,
       @Semantics.amount.currencyCode: 'TransactionCurrency'
       Item.Subtotal6Amount,

       //Shipping

       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'I_ShippingPointStdVH',
                      element: 'ShippingPoint' }
         }]
       Item.ShippingPoint,
       Item.ShippingType,
       Item.InventorySpecialStockType,
       Item.DeliveryPriority,
       Item.Route,
       Item.DeliveryDateQuantityIsFixed,
       Item.PartialDeliveryIsAllowed,
       Item.MaxNmbrOfPartialDelivery,
       Item.UnlimitedOverdeliveryIsAllowed,
       Item.OverdelivTolrtdLmtRatioInPct,
       Item.UnderdelivTolrtdLmtRatioInPct,

       @Semantics.quantity.unitOfMeasure: 'BaseUnit'
       Item.MinDeliveryQtyInBaseUnit,
       Item.IncotermsClassification,
       Item.IncotermsTransferLocation,
       Item.IncotermsLocation1,
       Item.IncotermsLocation2,
       Item.IncotermsVersion,
       Item.ItemIsDeliveryRelevant,

       //Billing

       Item.BillingDocumentDate,
       Item.ItemIsBillingRelevant,
       Item.ItemBillingBlockReason,

       //Payment

       Item.CustomerPaymentTerms,
       Item.PaymentMethod,
       
       Item.CustomerPriceGroup,
       Item.MaterialPricingGroup,
       Item.FixedValueDate,

       //Tax Classfication

       Item.ProductTaxClassification1,
       Item.ProductTaxClassification2,
       Item.ProductTaxClassification3,
       Item.ProductTaxClassification4,
       Item.ProductTaxClassification5,
       Item.ProductTaxClassification6,
       Item.ProductTaxClassification7,
       Item.ProductTaxClassification8,
       Item.ProductTaxClassification9,

       //Accounting

       Item.FiscalYear,
       Item.FiscalPeriod,
       Item.CustomerAccountAssignmentGroup,
       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'I_BusinessAreaStdVH',
                      element: 'BusinessArea' }
         }]       
       Item.BusinessArea,
       @Analytics.internalName: #LOCAL
       @ObjectModel.foreignKey.association: '_ProfitCenter'
       Item.ProfitCenter,
       @Analytics.internalName: #LOCAL
       @ObjectModel.foreignKey.association: '_ControllingArea'
       Item.ControllingArea,
       Item.WBSElementInternalID,
       Item.OrderID,
       Item.ControllingObject,
       @API.element.releaseState: #DECOMMISSIONED
       @API.element.successor: 'ProfitabilitySegment_2'
       Item.ProfitabilitySegment,
       Item.ProfitabilitySegment_2,
       Item.OriginSDDocument,
       Item.OriginSDDocumentItem,

       //Reference

       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'I_SalesDocumentStdVH',
                      element: 'SalesDocument' }
         }]
       Item.ReferenceSDDocument,
       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'I_SalesDocumentItemStdVH',
                      element: 'SalesDocumentItem' },
           additionalBinding: [{ localElement: 'ReferenceSDDocument',
                                 element: 'SalesDocument' }]
         }]
       Item.ReferenceSDDocumentItem,
       Item.ReferenceSDDocumentCategory,
       Item.HigherLevelItem,
       Item.BusinessSolutionOrderItem,
       Item.BusSolnOrdItemBundleItem,
      
       //Advanced Returns Management Process

       Item.RetsMgmtProcess,

       //Advanced Returns Management Process Item

       AdvncdRetsMgmtProcessItem.RetsMgmtProcessItem,
       Item.ReturnReason,
       Item.ReturnsRefundExtent,
       Item.RetsMgmtProcessingBlock,

       AdvncdRetsMgmtProcessItem.ReturnsRefundRjcnReason,
       AdvncdRetsMgmtProcessItem.CustRetMatlAuthzn,
       AdvncdRetsMgmtProcessItem.CustomerRetMatlInspResultCode,
       AdvncdRetsMgmtProcessItem.NextFllwUpActivityForMatlInsp,

       AdvncdRetsMgmtProcessItem.RetsMgmtItmLogProcgStatus,
       AdvncdRetsMgmtProcessItem.RetsMgmtItmCompnProcgStatus,
       AdvncdRetsMgmtProcessItem.RetsMgmtItmProcgStatus,
       ItemWithReleaseStatus.CustRetReleaseStatus,

       AdvncdRetsMgmtProcessItem.CRMLogicalSystem,
       AdvncdRetsMgmtProcessItem.CRMObjectUUID,
       AdvncdRetsMgmtProcessItem.CRMObjectID,
       AdvncdRetsMgmtProcessItem.CRMObjectType,

       //Advanced Returns Management Process Step (Return Order)

       AdvncdRetsMgmtProcessStep.RetsMgmtProcItmQtySplit,
       AdvncdRetsMgmtProcessStep.RetsMgmtProcessStep,

       AdvncdRetsMgmtProcessStep.ReturnsDocumentType,
       AdvncdRetsMgmtProcessStep.ReturnsDocument as ReturnsDocument,
       AdvncdRetsMgmtProcessStep.ReturnsDocumentItem,

       AdvncdRetsMgmtProcessStep.ReturnsReferenceDocumentType,
       AdvncdRetsMgmtProcessStep.ReturnsReferenceDocument,
       AdvncdRetsMgmtProcessStep.ReturnsReferenceDocumentItem,

       AdvncdRetsMgmtProcessStep.ReturnsDocumentStatus,
       AdvncdRetsMgmtProcessStep.ReturnsDocumentApprovalStatus,

       AdvncdRetsMgmtProcessStep.RetsMgmtProcItmExectdSequence,
       AdvncdRetsMgmtProcessStep.CustRetItmChainID,

       AdvncdRetsMgmtProcessStep.CustRetItmFollowUpActivity,
       AdvncdRetsMgmtProcessStep.ReturnsMaterialHasBeenReceived,
       AdvncdRetsMgmtProcessStep.NextPlantForFollowUpActivity,
       AdvncdRetsMgmtProcessStep.ReturnsTransshipmentPlant,

       AdvncdRetsMgmtProcessStep.ReturnsRefundType,
       AdvncdRetsMgmtProcessStep.ReturnsRefundProcgMode,
       @Semantics.booleanIndicator:true
       AdvncdRetsMgmtProcessItem.RetsProdValnIsSuspended,
       @Semantics.booleanIndicator:true
       AdvncdRetsMgmtProcessItem.RetsInspIsCrtedAutomly,
       @Semantics.booleanIndicator:true
       AdvncdRetsMgmtProcessItem.RetsProdIsVltdWithRef,
       @Semantics.booleanIndicator:true
       AdvncdRetsMgmtProcessStep.PrelimRefundIsDetermined,

       AdvncdRetsMgmtProcessStep.ReplacementMaterial,
       @Semantics.quantity.unitOfMeasure: 'ReplacementMaterialQtyUnit'
       AdvncdRetsMgmtProcessStep.ReplacementMaterialQuantity,
       //@Semantics.unitOfMeasure: true

       AdvncdRetsMgmtProcessStep.ReplacementMaterialQtyUnit,
       @Semantics.booleanIndicator:true
       AdvncdRetsMgmtProcessStep.ReplacementMaterialIsRequested,
       AdvncdRetsMgmtProcessStep.ReplacementMatlSupplyingPlant,

       AdvncdRetsMgmtProcessStep.Supplier,
       AdvncdRetsMgmtProcessStep.AddressID,
       AdvncdRetsMgmtProcessStep.SupplierRetMatlAuthzn,
       @Semantics.booleanIndicator:true
       AdvncdRetsMgmtProcessStep.SuplrRetMatlAuthznIsRequired,

       AdvncdRetsMgmtProcessStep.RetMatlInspResultCode,
       @Semantics.booleanIndicator: true
       AdvncdRetsMgmtProcessStep.ProductIsInspectedAtCustSite,

       //Status

       Item.SDProcessStatus,
       Item.TotalDeliveryStatus,
       Item.DeliveryStatus,
       Item.DeliveryBlockStatus,
       Item.OrderRelatedBillingStatus,
       Item.BillingBlockStatus,
       Item.ItemGeneralIncompletionStatus,
       Item.ItemBillingIncompletionStatus,
       Item.PricingIncompletionStatus,
       Item.ItemDeliveryIncompletionStatus,
       Item.SDDocumentRejectionStatus,
       Item.TotalSDDocReferenceStatus,

       @ObjectModel.association.type: [#TO_COMPOSITION_PARENT,
                                      #TO_COMPOSITION_ROOT]
       _CustomerReturn,
       @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
       Item._ScheduleLine,
       Item._Partner,

       Item._ItemCategory,
       Item._HigherLevelItem,
       Item._CreatedByUser,
       Item._Division,

       Item._OriginallyRequestedMaterial,
       Item._ProductHierarchyNode,
       Item._AdditionalMaterialGroup1,
       Item._AdditionalMaterialGroup2,
       Item._AdditionalMaterialGroup3,
       Item._AdditionalMaterialGroup4,
       Item._AdditionalMaterialGroup5,
       Item._Plant,
       Item._StorageLocation,

       Item._OrderQuantityUnit,
       Item._BaseUnit,
       Item._RequestedQuantityUnit,
       Item._ItemWeightUnit,
       Item._ItemVolumeUnit,
       Item._SalesDistrict,
       Item._SalesDeal,
       Item._CustomerGroup,
       Item._SalesDocumentRjcnReason,

       Item._NetPriceQuantityUnit,
       Item._TransactionCurrency,
       Item._StatisticalValueControl,
       Item._ShippingPoint,
       Item._DeliveryPriority,
       Item._IncotermsClassification,
       Item._IncotermsVersion,       
       Item._ItemBillingBlockReason,
       Item._ItemIsBillingRelevant,
       Item._CustomerPaymentTerms,
       Item._CustomerPurchaseOrderType,
       Item._CustPurOrdTypeByShipToParty, 
       // _PaymentMethod,

       Item._CustomerAccountAssgmtGroup,
       Item._BusinessArea,
       Item._WBSElementBasicData_2,
       Item._MatlAccountAssignmentGroup,
       
       Item._ProfitCenter,
       Item._ControllingArea,

       Item._ReferenceSDDocument,
       Item._ReferenceSDDocumentItem,
       Item._ReferenceSDDocumentCategory,
       
       Item._ReturnReason,
       Item._ReturnsRefundExtent,
       AdvncdRetsMgmtProcessStep._ReturnsReferenceDocumentType,
       AdvncdRetsMgmtProcessItem._ReturnsRefundRjcnReason,
       AdvncdRetsMgmtProcessItem._RetsMgmtItmLogProcgStatus,
       AdvncdRetsMgmtProcessItem._RetsMgmtItmCompnProcgStatus,
       AdvncdRetsMgmtProcessItem._RetsMgmtItmProcgStatus,
       AdvncdRetsMgmtProcessStep._ReturnsRefundType,
       AdvncdRetsMgmtProcessStep._ReturnsRefundProcgMode,
       AdvncdRetsMgmtProcessStep._ReplacementMaterialQtyUnit,
       AdvncdRetsMgmtProcessStep._Supplier,
       AdvncdRetsMgmtProcessStep._Address,
       AdvncdRetsMgmtProcessStep._DfltAddrRprstn,
       AdvncdRetsMgmtProcessStep._RetMatlInspResultCode,

       Item._SDProcessStatus,
       Item._TotalDeliveryStatus,
       Item._DeliveryStatus,
       Item._DeliveryBlockStatus,
       Item._OrderRelatedBillingStatus,
       Item._BillingBlockStatus,
       Item._ItemGeneralIncompletionStatus,
       Item._ItemBillingIncompletionStatus,
       Item._PricingIncompletionStatus,
       Item._ItemDelivIncompletionSts,
       Item._SDDocumentRejectionStatus,
       Item._TotalSDDocReferenceStatus
}