I_CustomerReturnImport

DDL: I_CUSTOMERRETURNIMPORT Type: view_entity COMPOSITE Package: VDM_SD_SLS_IMPORT_CRT

Header Fields for Customer Return Import

I_CustomerReturnImport is a Composite CDS View that provides data about "Header Fields for Customer Return Import" in SAP S/4HANA. It reads from 1 data source (I_CustomerReturn) and exposes 54 fields with key field CustomerReturn. It has 4 associations to related views. Part of development package VDM_SD_SLS_IMPORT_CRT.

Data Sources (1)

SourceAliasJoin Type
I_CustomerReturn CustomerReturn from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_CustomerReturnItemImport _Item $projection.CustomerReturn = _Item.CustomerReturn
[1..*] I_CustomerReturnPartner _Partner $projection.CustomerReturn = _Partner.CustomerReturn
[0..*] I_SalesDocumentPricingElement _PricingElement $projection.CustomerReturn = _PricingElement.SalesDocument
[0..1] E_SalesDocumentBasic _Extension CustomerReturn.CustomerReturn = _Extension.SalesDocument

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Header Fields for Customer Return Import view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn CustomerReturn
CustomerReturnType
CustomerReturnDate CustomerReturnDate
SoldToParty SoldToParty
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SalesOffice SalesOffice
SalesGroup SalesGroup
SalesDistrict SalesDistrict
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangedByUser LastChangedByUser
CreationTime CreationTime
LastChangeDate LastChangeDate
PurchaseOrderByCustomer PurchaseOrderByCustomer
CustomerPurchaseOrderType CustomerPurchaseOrderType
CustomerPurchaseOrderDate CustomerPurchaseOrderDate
SDDocumentReason SDDocumentReason
PricingDate PricingDate
RequestedDeliveryDate RequestedDeliveryDate
TotalNetAmount TotalNetAmount
TransactionCurrency TransactionCurrency
HeaderBillingBlockReason HeaderBillingBlockReason
DeliveryBlockReason DeliveryBlockReason
SDPricingProcedure SDPricingProcedure
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
IncotermsVersion IncotermsVersion
CustomerPaymentTerms CustomerPaymentTerms
PaymentMethod PaymentMethod
BillingCompanyCode BillingCompanyCode
CustomerTaxClassification1 CustomerTaxClassification1
CustomerTaxClassification2 CustomerTaxClassification2
CustomerTaxClassification3 CustomerTaxClassification3
CustomerTaxClassification4 CustomerTaxClassification4
CustomerTaxClassification5 CustomerTaxClassification5
CustomerTaxClassification6 CustomerTaxClassification6
CustomerTaxClassification7 CustomerTaxClassification7
CustomerTaxClassification8 CustomerTaxClassification8
CustomerTaxClassification9 CustomerTaxClassification9
AccountingDocExternalReference AccountingDocExternalReference
AssignmentReference AssignmentReference
ShippingType ShippingType
ShippingCondition ShippingCondition
CustomerReturnApprovalReason CustomerReturnApprovalReason
SalesDocApprovalStatus SalesDocApprovalStatus
ReferenceSDDocument ReferenceSDDocument
ReferenceSDDocumentCategory ReferenceSDDocumentCategory
_Item _Item
_Partner _Partner
_PricingElement _PricingElement
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')

@EndUserText.label: 'Header Fields for Customer Return Import'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.compositionRoot: true
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED }

@VDM: {
  lifecycle.contract.type: #PUBLIC_LOCAL_API,
  viewType: #COMPOSITE
}

define view entity I_CustomerReturnImport
  as select from I_CustomerReturn as CustomerReturn

  // Associations

  association [0..*] to I_CustomerReturnItemImport    as _Item           on $projection.CustomerReturn = _Item.CustomerReturn
  association [1..*] to I_CustomerReturnPartner       as _Partner        on $projection.CustomerReturn = _Partner.CustomerReturn
  association [0..*] to I_SalesDocumentPricingElement as _PricingElement on $projection.CustomerReturn = _PricingElement.SalesDocument

  // Extensibility

  association [0..1] to E_SalesDocumentBasic          as _Extension      on CustomerReturn.CustomerReturn = _Extension.SalesDocument

{
  key CustomerReturn,

      cast (CustomerReturnType as msr_returns_order_type preserving type) as CustomerReturnType,
      CustomerReturnDate,

      SoldToParty,
      SalesOrganization,
      DistributionChannel,

      OrganizationDivision,
      SalesOffice,
      SalesGroup,
      SalesDistrict,

      CreationDate,
      CreatedByUser,
      LastChangedByUser,
      CreationTime,
      LastChangeDate,

      PurchaseOrderByCustomer,
      CustomerPurchaseOrderType,
      CustomerPurchaseOrderDate,
      SDDocumentReason,
      PricingDate,
      RequestedDeliveryDate,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalNetAmount,

      TransactionCurrency,
      HeaderBillingBlockReason,
      DeliveryBlockReason,
      SDPricingProcedure,

      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,
      IncotermsVersion,

      CustomerPaymentTerms,
      PaymentMethod,
      BillingCompanyCode,

      CustomerTaxClassification1,
      CustomerTaxClassification2,
      CustomerTaxClassification3,
      CustomerTaxClassification4,
      CustomerTaxClassification5,
      CustomerTaxClassification6,
      CustomerTaxClassification7,
      CustomerTaxClassification8,
      CustomerTaxClassification9,

      AccountingDocExternalReference,
      AssignmentReference,
      ShippingType,
      ShippingCondition,
      CustomerReturnApprovalReason,
      SalesDocApprovalStatus,

      ReferenceSDDocument,
      ReferenceSDDocumentCategory,

      _Item,
      _Partner,
      _PricingElement
}