Which CDS Views use I_CUSTOMERRETURNENHANCED?

I_CUSTOMERRETURNENHANCED is used by 4 CDS view(s), including: A_CustomerReturn, A_CustomerReturnSimulation, C_CustomerReturnWrkflwInbox, R_CustomerReturnTP.

How many fields does I_CUSTOMERRETURNENHANCED have?

I_CUSTOMERRETURNENHANCED has 69 fields. Key fields: CustomerReturn.

I_CUSTOMERRETURNENHANCED

CDS View

Returns Order Enhanced

I_CUSTOMERRETURNENHANCED is a CDS View in S/4HANA. Returns Order Enhanced. It contains 69 fields. 4 CDS views read from this table.

CDS Views using this table (4)

View	Type	Join	VDM	Description
A_CustomerReturn	view	from	COMPOSITE	Returns Order Header
A_CustomerReturnSimulation	view_entity	from	COMPOSITE	Returns Order Simulation
C_CustomerReturnWrkflwInbox	view	from	CONSUMPTION	Customer Return Workflow Inbox
R_CustomerReturnTP	view_entity	from	TRANSACTIONAL	Returns Order - TP

Fields (69)

Key	Field	CDS Fields	Used in Views
KEY	CustomerReturn	CustomerReturn	2
	_CreatedByUser	_CreatedByUser	1
	_CustomerReturnType	_CustomerReturnType	1
	_CustRetApprovalReason	_CustRetApprovalReason	1
	_DistributionChannel	_DistributionChannel	1
	_HdrGeneralIncompletionStatus	_HdrGeneralIncompletionStatus	1
	_LastChangedByUser	_LastChangedByUser	1
	_OrganizationDivision	_OrganizationDivision	1
	_OverallSDDocumentRejectionSts	_OverallSDDocumentRejectionSts	1
	_OverallSDProcessStatus	_OverallSDProcessStatus	1
	_OverallTotalDeliveryStatus	_OverallTotalDeliveryStatus	1
	_OvrlItmGeneralIncompletionSts	_OvrlItmGeneralIncompletionSts	1
	_ReferenceSDDocumentCategory	_ReferenceSDDocumentCategory	1
	_RetsMgmtProcess	_RetsMgmtProcess	1
	_SalesDocApprovalStatus	_SalesDocApprovalStatus	1
	_SalesGroup	_SalesGroup	1
	_SalesOffice	_SalesOffice	1
	_SalesOrganization	_SalesOrganization	1
	_SDDocumentReason	_SDDocumentReason	1
	_SDPricingProcedure	_SDPricingProcedure	1
	_ShippingCondition	_ShippingCondition	1
	_SoldToParty	_SoldToParty	1
	_TotalCreditCheckStatus	_TotalCreditCheckStatus	1
	_TransactionCurrency	_TransactionCurrency	1
	ControllingArea	ControllingArea	1
	CreatedByUser	CreatedByUser	2
	CreationDate	CreationDate	2
	CreationTime	CreationTime	1
	CustomerPaymentTerms	CustomerPaymentTerms	1
	CustomerPurchaseOrderDate	CustomerPurchaseOrderDate	1
	CustomerPurchaseOrderType	CustomerPurchaseOrderType	1
	CustomerReturnApprovalReason	CustomerReturnApprovalReason	2
	CustomerReturnDate	CustomerReturnDate	1
	CustomerReturnType	CustomerReturnType	2
	DeliveryBlockReason	DeliveryBlockReason	1
	DistributionChannel	DistributionChannel	2
	HeaderBillingBlockReason	HeaderBillingBlockReason	1
	IncotermsClassification	IncotermsClassification	1
	IncotermsLocation1	IncotermsLocation1	1
	IncotermsLocation2	IncotermsLocation2	1
	IncotermsTransferLocation	IncotermsTransferLocation	1
	IncotermsVersion	IncotermsVersion	1
	LastChangeDate	LastChangeDate	2
	LastChangedByUser	LastChangedByUser	1
	OrganizationDivision	OrganizationDivision	2
	OverallSDDocumentRejectionSts	OverallSDDocumentRejectionSts	1
	OverallSDProcessStatus	OverallSDProcessStatus	1
	OverallTotalDeliveryStatus	OverallTotalDeliveryStatus	1
	PaymentMethod	PaymentMethod	1
	PricingDate	PricingDate	1
	PurchaseOrderByCustomer	PurchaseOrderByCustomer	2
	ReferenceSDDocument	ReferenceSDDocument	1
	ReferenceSDDocumentCategory	ReferenceSDDocumentCategory	1
	RequestedDeliveryDate	RequestedDeliveryDate	1
	RetsMgmtLogProcgStatus	RetsMgmtLogProcgStatus	1
	RetsMgmtProcess	RetsMgmtProcess	1
	RetsMgmtProcessingStatus	RetsMgmtProcessingStatus	1
	SalesDistrict	SalesDistrict	1
	SalesDocApprovalStatus	SalesDocApprovalStatus	1
	SalesGroup	SalesGroup	1
	SalesOffice	SalesOffice	1
	SalesOrganization	SalesOrganization	2
	SDDocumentReason	SDDocumentReason	1
	SDPricingProcedure	SDPricingProcedure	1
	ShippingCondition	ShippingCondition	1
	SoldToParty	SoldToParty	2
	TotalCreditCheckStatus	TotalCreditCheckStatus	1
	TotalNetAmount	TotalNetAmount	2
	TransactionCurrency	TransactionCurrency	2

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

define view I_CustomerReturnEnhanced
  as select from I_CustomerReturn            as CustomerReturn
  left outer join I_AdvncdReturnsMgmtProcess as AdvncdRetsMgmtProcess on AdvncdRetsMgmtProcess.RetsMgmtProcess = CustomerReturn.RetsMgmtProcess

//Association

association [0..*] to I_CustomerReturnItemEnhanced   as _CustomerReturnItem on _CustomerReturnItem.CustomerReturn = $projection.CustomerReturn

{
      //Key

  key CustomerReturn.CustomerReturn,

      //Category

      CustomerReturn.CustomerReturnType,

      //Admin

      CustomerReturn.CreatedByUser,
      CustomerReturn.LastChangedByUser,
      CustomerReturn.CreationDate,
      CustomerReturn.CreationTime,
      CustomerReturn.LastChangeDate,
      CustomerReturn.LastChangeDateTime,
      CustomerReturn.SenderBusinessSystemName,

      //Org

      CustomerReturn.SalesOrganization,
      CustomerReturn.DistributionChannel,
      CustomerReturn.OrganizationDivision,
      CustomerReturn.SalesGroup,
      CustomerReturn.SalesOffice,

      //Sales

      @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_Customer_VH',
                    element: 'Customer' }
       }]
      CustomerReturn.SoldToParty,
      CustomerReturn.CustomerGroup,
      CustomerReturn.AdditionalCustomerGroup1,
      CustomerReturn.AdditionalCustomerGroup2,
      CustomerReturn.AdditionalCustomerGroup3,
      CustomerReturn.AdditionalCustomerGroup4,
      CustomerReturn.AdditionalCustomerGroup5,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CreditControlAreaStdVH',
                     element: 'CreditControlArea' }
        }]
      CustomerReturn.CreditControlArea,
      CustomerReturn.CustomerReturnDate,
      CustomerReturn.ServicesRenderedDate,
      CustomerReturn.SDDocumentReason,
      CustomerReturn.PurchaseOrderByCustomer,
      CustomerReturn.CustomerPurchaseOrderType,
      CustomerReturn.CustomerPurchaseOrderDate,
      CustomerReturn.CustomerPurchaseOrderSuplmnt,
      CustomerReturn.SalesDistrict,

      //Pricing

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CustomerReturn.TotalNetAmount,
      @Semantics.currencyCode: true
      CustomerReturn.TransactionCurrency,
      CustomerReturn.PricingDate,
      CustomerReturn.PriceDetnExchangeRate,
      CustomerReturn.CustomerReturnCondition,
      CustomerReturn.SDPricingProcedure,  
      
      //Shipping

      CustomerReturn.RequestedDeliveryDate,
      CustomerReturn.IncotermsClassification,
      CustomerReturn.IncotermsTransferLocation,
      CustomerReturn.IncotermsLocation1,
      CustomerReturn.IncotermsLocation2,
      CustomerReturn.IncotermsVersion,
      CustomerReturn.DeliveryBlockReason,
      CustomerReturn.ShippingType,
      @ObjectModel.foreignKey.association: '_ShippingCondition'
      CustomerReturn.ShippingCondition, 
      
      //Approval Management

      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_CustRetApprovalReason'
      CustomerReturn.CustomerReturnApprovalReason,

      //Billing

      CustomerReturn.BillingDocumentDate,
      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'I_CompanyCodeStdVH',
                   element: 'CompanyCode' }
      }]
      CustomerReturn.BillingCompanyCode,
      CustomerReturn.HeaderBillingBlockReason,

      //Payment

      CustomerReturn.CustomerPaymentTerms,
      CustomerReturn.PaymentMethod,

      //Accounting

      CustomerReturn.FiscalYear,
      CustomerReturn.FiscalPeriod,
      CustomerReturn.ExchangeRateDate,
      CustomerReturn.ExchangeRateType,
      @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_BusinessAreaStdVH',
                    element: 'BusinessArea' }
       }]
      CustomerReturn.BusinessArea,
      CustomerReturn.CustomerAccountAssignmentGroup,
      @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_BusinessAreaStdVH',
                    element: 'BusinessArea' }
       }]
      CustomerReturn.CostCenterBusinessArea,
      CustomerReturn.CostCenter,
      @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_ControllingAreaStdVH',
                    element: 'ControllingArea' }
       }]
      CustomerReturn.ControllingArea,
      CustomerReturn.OrderID,
      @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_ControllingObjectStdVH',
                    element: 'ControllingObject' }
       }]
      CustomerReturn.ControllingObject,

      //Reference

      CustomerReturn.ReferenceSDDocument,
      CustomerReturn.ReferenceSDDocumentCategory,
      @Analytics.internalName: #LOCAL
      CustomerReturn.AccountingDocExternalReference,
      CustomerReturn.AssignmentReference,
      

      //Advanced Returns Management Process

      CustomerReturn.RetsMgmtProcess,
      AdvncdRetsMgmtProcess.ReturnsDocumentType,
      AdvncdRetsMgmtProcess.ReturnsDocument,

      AdvncdRetsMgmtProcess.RetsMgmtLogProcgStatus,
      AdvncdRetsMgmtProcess.RetsMgmtCompnProcgStatus,
      AdvncdRetsMgmtProcess.RetsMgmtProcessingStatus,
      
      //Status

      CustomerReturn.OverallSDProcessStatus,
      CustomerReturn.OverallSDDocumentRejectionSts,
      CustomerReturn.TotalBlockStatus,
      CustomerReturn.OverallTotalDeliveryStatus,
      CustomerReturn.OverallDeliveryStatus,
      CustomerReturn.OverallDeliveryBlockStatus,
      CustomerReturn.OverallOrdReltdBillgStatus,
      CustomerReturn.OverallBillingBlockStatus,
      CustomerReturn.OverallTotalSDDocRefStatus,
      CustomerReturn.OverallSDDocReferenceStatus,
      CustomerReturn.TotalCreditCheckStatus,
      CustomerReturn.MaxDocValueCreditCheckStatus,
      CustomerReturn.PaymentTermCreditCheckStatus,
      CustomerReturn.FinDocCreditCheckStatus,
      CustomerReturn.ExprtInsurCreditCheckStatus,
      CustomerReturn.PaytAuthsnCreditCheckSts,
      CustomerReturn.CentralCreditCheckStatus,
      CustomerReturn.CentralCreditChkTechErrSts,
      CustomerReturn.HdrGeneralIncompletionStatus,
      CustomerReturn.OverallPricingIncompletionSts,
      CustomerReturn.HeaderDelivIncompletionStatus,
      CustomerReturn.HeaderBillgIncompletionStatus,
      CustomerReturn.OvrlItmGeneralIncompletionSts,
      CustomerReturn.OvrlItmBillingIncompletionSts,
      CustomerReturn.OvrlItmDelivIncompletionSts,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_SalesDocApprovalStatus'
      CustomerReturn.SalesDocApprovalStatus,

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _CustomerReturnItem,
      CustomerReturn._Partner,
      CustomerReturn._StandardPartner,
      CustomerReturn._CustomerReturnType,
      CustomerReturn._CreatedByUser,
      CustomerReturn._LastChangedByUser,
      CustomerReturn._SalesOrganization,
      CustomerReturn._DistributionChannel,
      CustomerReturn._OrganizationDivision,
      CustomerReturn._SalesGroup,
      CustomerReturn._SalesOffice,
      CustomerReturn._SoldToParty,
      CustomerReturn._CustomerGroup,
      CustomerReturn._AdditionalCustomerGroup1,
      CustomerReturn._AdditionalCustomerGroup2,
      CustomerReturn._AdditionalCustomerGroup3,
      CustomerReturn._AdditionalCustomerGroup4,
      CustomerReturn._AdditionalCustomerGroup5,
      CustomerReturn._CreditControlArea,
      CustomerReturn._SDDocumentReason,
      //Todo: _CustomerPurchaseOrderType,

      CustomerReturn._SDPricingProcedure,
      CustomerReturn._SalesDistrict,
      CustomerReturn._TransactionCurrency,
      //Todo:CustomerReturnCondition,

      CustomerReturn._IncotermsClassification,
      CustomerReturn._IncotermsVersion,
      CustomerReturn._DeliveryBlockReason,
      CustomerReturn._CustRetApprovalReason,
      CustomerReturn._BillingCompanyCode,
      CustomerReturn._HeaderBillingBlockReason,
      CustomerReturn._CustomerPaymentTerms,
      //Todo: _PaymentMethod,

      //Tax Classfication

      CustomerReturn.CustomerTaxClassification1,
      CustomerReturn.CustomerTaxClassification2,
      CustomerReturn.CustomerTaxClassification3,
      CustomerReturn.CustomerTaxClassification4,
      CustomerReturn.CustomerTaxClassification5,
      CustomerReturn.CustomerTaxClassification6,
      CustomerReturn.CustomerTaxClassification7,
      CustomerReturn.CustomerTaxClassification8,
      CustomerReturn.CustomerTaxClassification9,
      
      CustomerReturn._ExchangeRateType,
      CustomerReturn._BusinessArea,
      CustomerReturn._CustomerAccountAssgmtGroup,
      CustomerReturn._CostCenterBusinessArea,
      CustomerReturn._CostCenter,
      CustomerReturn._ControllingArea,
      CustomerReturn._ControllingObject,
      //Todo: ReferenceSDDocument,

      CustomerReturn._ReferenceSDDocumentCategory,

      AdvncdRetsMgmtProcess._ReturnsDocumentType,
      AdvncdRetsMgmtProcess._RetsMgmtLogProcgStatus,
      AdvncdRetsMgmtProcess._RetsMgmtCompnProcgStatus,
      AdvncdRetsMgmtProcess._RetsMgmtProcessingStatus,

      CustomerReturn._OverallSDProcessStatus,
      CustomerReturn._OverallSDDocumentRejectionSts,
      CustomerReturn._TotalBlockStatus,
      CustomerReturn._OverallTotalDeliveryStatus,
      CustomerReturn._OverallDeliveryStatus,
      CustomerReturn._OverallDeliveryBlockStatus,
      CustomerReturn._OverallOrdReltdBillgStatus,
      CustomerReturn._OverallBillingBlockStatus,
      CustomerReturn._OverallTotalSDDocRefStatus,
      CustomerReturn._OverallSDDocReferenceStatus,
      CustomerReturn._TotalCreditCheckStatus,
      CustomerReturn._MaxDocValueCreditCheckStatus,
      CustomerReturn._PaymentTermCreditCheckStatus,
      CustomerReturn._FinDocCreditCheckStatus,
      CustomerReturn._ExprtInsurCreditCheckStatus,
      CustomerReturn._PaytAuthsnCreditCheckSts,
      CustomerReturn._CentralCreditCheckStatus,
      CustomerReturn._CentralCreditChkTechErrSts,
      CustomerReturn._HdrGeneralIncompletionStatus,
      CustomerReturn._OverallPricingIncompletionSts,
      CustomerReturn._HeaderDelivIncompletionStatus,
      CustomerReturn._HeaderBillgIncompletionStatus,
      CustomerReturn._OvrlItmGeneralIncompletionSts,
      CustomerReturn._OvrlItmBillingIncompletionSts,
      CustomerReturn._OvrlItmDelivIncompletionSts,
      CustomerReturn._SalesDocApprovalStatus,
      CustomerReturn._ShippingCondition,
      CustomerReturn._RetsMgmtProcess
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADVNCDRETURNSMGMTPROCESS",
"I_CUSTOMERRETURN"
],
"ASSOCIATED":
[
"I_ADDITIONALCUSTOMERGROUP1",
"I_ADDITIONALCUSTOMERGROUP2",
"I_ADDITIONALCUSTOMERGROUP3",
"I_ADDITIONALCUSTOMERGROUP4",
"I_ADDITIONALCUSTOMERGROUP5",
"I_BILLINGBLOCKREASON",
"I_BUSINESSAREA",
"I_CENTRALCREDITCHECKSTATUS",
"I_CENTRALCREDITCHKTECHERRSTS",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECT",
"I_COSTCENTER",
"I_CREDITCONTROLAREA",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERACCOUNTASSGMTGROUP",
"I_CUSTOMERGROUP",
"I_CUSTOMERPAYMENTTERMS",
"I_CUSTOMERRETURNAPPROVALREASON",
"I_CUSTOMERRETURNITEMENHANCED",
"I_DELIVERYBLOCKREASON",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_EXCHANGERATETYPE",
"I_EXPRTINSURCREDITCHECKSTATUS",
"I_FINDOCCREDITCHECKSTATUS",
"I_HDRBILLGINCOMPLETIONSTATUS",
"I_HDRDELIVINCOMPLETIONSTATUS",
"I_HDRGENINCOMPLETIONSTATUS",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_MAXDOCVALUECREDITCHECKSTS",
"I_OVERALLBILLINGBLOCKSTATUS",
"I_OVERALLDELIVERYBLOCKSTATUS",
"I_OVERALLDELIVERYSTATUS",
"I_OVERALLORDRELTDBILLGSTATUS",
"I_OVERALLPRCINCOMPLETIONSTS",
"I_OVERALLSDDOCREFERENCESTATUS",
"I_OVERALLSDDOCUMENTRJCNSTATUS",
"I_OVERALLSDPROCESSSTATUS",
"I_OVERALLTOTALDELIVERYSTATUS",
"I_OVERALLTOTALSDDOCREFSTATUS",
"I_OVRLITMBILLGINCOMPLTNSTS",
"I_OVRLITMDELIVINCOMPLETIONSTS",
"I_OVRLITMGENINCOMPLETIONSTS",
"I_PAYMENTTERMCREDITCHECKSTS",
"I_PAYTAUTHSNCREDITCHECKSTS",
"I_RETSMGMTCOMPNPROCGSTATUS",
"I_RETSMGMTPROCESS",
"I_RETSMGMTPROCGSTATUS",
"I_RETURNSDOCUMENTTYPE",
"I_SALESDISTRICT",
"I_SALESDOCAPPROVALSTATUS",
"I_SALESDOCUMENTPARTNER",
"I_SALESDOCUMENTSTANDARDPARTNER",
"I_SALESDOCUMENTTYPE",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCATEGORY",
"I_SDDOCUMENTREASON",
"I_SHIPPINGCONDITION",
"I_SLSPRICINGPROCEDURE",
"I_TOTALBLOCKSTATUS",
"I_TOTALCREDITCHECKSTATUS",
"I_USER"
],
"BASE":
[
"I_ADVNCDRETURNSMGMTPROCESS",
"I_CUSTOMERRETURN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_CUSTOMERRETURNENHANCED

CDS Views using this table (4)

Fields (69)

Learn More