I_CUSTOMERRETURNENHANCED
Returns Order Enhanced
I_CUSTOMERRETURNENHANCED is a CDS View in S/4HANA. Returns Order Enhanced. It contains 110 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 (110)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CustomerReturn | CustomerReturn | 2 |
| _CreatedByUser | _CreatedByUser | 1 | |
| _CustomerPaymentTerms | _CustomerPaymentTerms | 1 | |
| _CustomerPurchaseOrderType | _CustomerPurchaseOrderType | 1 | |
| _CustomerReturnType | _CustomerReturnType | 1 | |
| _CustPurOrdTypeByShipToParty | _CustPurOrdTypeByShipToParty | 1 | |
| _CustRetApprovalReason | _CustRetApprovalReason | 1 | |
| _DeliveryBlockReason | _DeliveryBlockReason | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _HdrGeneralIncompletionStatus | _HdrGeneralIncompletionStatus | 1 | |
| _HeaderBillingBlockReason | _HeaderBillingBlockReason | 1 | |
| _IncotermsClassification | _IncotermsClassification | 1 | |
| _IncotermsVersion | _IncotermsVersion | 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 | |
| _SalesDistrict | _SalesDistrict | 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 | |
| AccountingDocExternalReference | AccountingDocExternalReference | 1 | |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 1 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 1 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 1 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 1 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 1 | |
| AssignmentReference | AssignmentReference | 1 | |
| BillingCompanyCode | BillingCompanyCode | 1 | |
| BillingDocumentDate | BillingDocumentDate | 1 | |
| BusinessSolutionOrder | BusinessSolutionOrder | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CorrespncExternalReference | CorrespncExternalReference | 1 | |
| CorrespncExtRefByShipToParty | CorrespncExtRefByShipToParty | 1 | |
| CreatedByUser | CreatedByUser | 2 | |
| CreationDate | CreationDate | 2 | |
| CreationTime | CreationTime | 1 | |
| CustomerAccountAssignmentGroup | CustomerAccountAssignmentGroup | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerPaymentTerms | CustomerPaymentTerms | 1 | |
| CustomerPriceGroup | CustomerPriceGroup | 1 | |
| CustomerPurchaseOrderDate | CustomerPurchaseOrderDate | 1 | |
| CustomerPurchaseOrderType | CustomerPurchaseOrderType | 1 | |
| CustomerReturnApprovalReason | CustomerReturnApprovalReason | 2 | |
| CustomerReturnDate | CustomerReturnDate | 1 | |
| CustomerReturnType | CustomerReturnType | 2 | |
| CustomerTaxClassification1 | CustomerTaxClassification1 | 1 | |
| CustomerTaxClassification2 | CustomerTaxClassification2 | 1 | |
| CustomerTaxClassification3 | CustomerTaxClassification3 | 1 | |
| CustomerTaxClassification4 | CustomerTaxClassification4 | 1 | |
| CustomerTaxClassification5 | CustomerTaxClassification5 | 1 | |
| CustomerTaxClassification6 | CustomerTaxClassification6 | 1 | |
| CustomerTaxClassification7 | CustomerTaxClassification7 | 1 | |
| CustomerTaxClassification8 | CustomerTaxClassification8 | 1 | |
| CustomerTaxClassification9 | CustomerTaxClassification9 | 1 | |
| CustPurOrdTypeByShipToParty | CustPurOrdTypeByShipToParty | 1 | |
| DeliveryBlockReason | DeliveryBlockReason | 1 | |
| DistributionChannel | DistributionChannel | 2 | |
| FixedValueDate | FixedValueDate | 1 | |
| HeaderBillingBlockReason | HeaderBillingBlockReason | 1 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsTransferLocation | IncotermsTransferLocation | 1 | |
| IncotermsVersion | IncotermsVersion | 1 | |
| LastChangeDate | LastChangeDate | 2 | |
| LastChangedByUser | LastChangedByUser | 2 | |
| OrganizationDivision | OrganizationDivision | 2 | |
| OverallSDDocReferenceStatus | OverallSDDocReferenceStatus | 1 | |
| OverallSDDocumentRejectionSts | OverallSDDocumentRejectionSts | 1 | |
| OverallSDProcessStatus | OverallSDProcessStatus | 1 | |
| OverallTotalDeliveryStatus | OverallTotalDeliveryStatus | 1 | |
| PaymentMethod | PaymentMethod | 1 | |
| PriceListType | PriceListType | 1 | |
| PricingDate | PricingDate | 1 | |
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | 2 | |
| PurchaseOrderByShipToParty | PurchaseOrderByShipToParty | 1 | |
| 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 | |
| ServicesRenderedDate | ServicesRenderedDate | 1 | |
| ShippingCondition | ShippingCondition | 1 | |
| ShippingType | ShippingType | 1 | |
| SoldToParty | SoldToParty | 2 | |
| TaxDepartureCountry | TaxDepartureCountry | 1 | |
| TotalCreditCheckStatus | TotalCreditCheckStatus | 1 | |
| TotalNetAmount | TotalNetAmount | 2 | |
| TransactionCurrency | TransactionCurrency | 2 | |
| VATRegistrationCountry | VATRegistrationCountry | 1 |
@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: #XL
}
}
@Analytics.dataCategory: #DIMENSION
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true
define view I_CustomerReturnEnhanced
as select from I_CustomerReturn as CustomerReturn
left outer to one join I_AdvncdReturnsMgmtProcess as AdvncdRetsMgmtProcess on AdvncdRetsMgmtProcess.RetsMgmtProcess = CustomerReturn.RetsMgmtProcess
and AdvncdRetsMgmtProcess.ReturnsDocument = CustomerReturn.CustomerReturn
and AdvncdRetsMgmtProcess.ReturnsDocumentType = '00'
//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,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_CustomerPurchaseOrderType'
CustomerReturn.CustomerPurchaseOrderType,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_CustPurOrdTypeByShipToParty'
CustomerReturn.CustPurOrdTypeByShipToParty,
CustomerReturn.CustomerPurchaseOrderDate,
CustomerReturn.CustomerPurchaseOrderSuplmnt,
CustomerReturn.SalesDistrict,
CustomerReturn.PurchaseOrderByShipToParty,
CustomerReturn.CorrespncExternalReference,
CustomerReturn.CorrespncExtRefByShipToParty,
CustomerReturn.BusinessSolutionOrder,
//Pricing
@Semantics.amount.currencyCode: 'TransactionCurrency'
CustomerReturn.TotalNetAmount,
@Semantics.currencyCode: true
CustomerReturn.TransactionCurrency,
CustomerReturn.PricingDate,
CustomerReturn.PriceDetnExchangeRate,
CustomerReturn.CustomerReturnCondition,
CustomerReturn.SDPricingProcedure,
CustomerReturn.CustomerPriceGroup,
CustomerReturn.PriceListType,
CustomerReturn.TaxDepartureCountry,
CustomerReturn.VATRegistrationCountry,
//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,
CustomerReturn.FixedValueDate,
//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,
CustomerReturn._CustomerPurchaseOrderType,
CustomerReturn._CustPurOrdTypeByShipToParty,
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
}