I_AllwdCustRetTypePerSlsOrg

DDL: I_ALLWDCUSTRETTYPEPERSLSORG Type: view_entity COMPOSITE

Allowed Return Type Per Sales Org

I_AllwdCustRetTypePerSlsOrg is a Composite CDS View that provides data about "Allowed Return Type Per Sales Org" in SAP S/4HANA. It reads from 2 data sources (I_AllwdOrdTypPerSlsOrg, I_SalesDocumentType) and exposes 8 fields with key fields SalesOrganization, DistributionChannel, Division, SalesDocumentType.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_AllwdOrdTypPerSlsOrg AllowedReturnType from
I_SalesDocumentType SalesDocumentType inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Allowed Return Type Per Sales Org view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization I_AllwdOrdTypPerSlsOrg SalesOrganization
KEY DistributionChannel I_AllwdOrdTypPerSlsOrg DistributionChannel
KEY Division I_AllwdOrdTypPerSlsOrg Division
KEY SalesDocumentType I_AllwdOrdTypPerSlsOrg SalesDocumentType
_SalesOrganization I_AllwdOrdTypPerSlsOrg _SalesOrganization
_DistributionChannel I_AllwdOrdTypPerSlsOrg _DistributionChannel
_Division I_AllwdOrdTypPerSlsOrg _Division
_SalesDocumentType I_AllwdOrdTypPerSlsOrg _SalesDocumentType 
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ObjectModel: {
  usageType:{
    serviceQuality: #B,
    sizeCategory: #S,
    dataClass: #MIXED
  }
}
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Allowed Return Type Per Sales Org'

define view entity I_AllwdCustRetTypePerSlsOrg
  as select from I_AllwdOrdTypPerSlsOrg as AllowedReturnType
  inner join     I_SalesDocumentType    as SalesDocumentType on AllowedReturnType.SalesDocumentType = SalesDocumentType.SalesDocumentType
{

  key AllowedReturnType.SalesOrganization,
  key AllowedReturnType.DistributionChannel,
  key AllowedReturnType.Division,
  key AllowedReturnType.SalesDocumentType,
  
      //Associations

      AllowedReturnType._SalesOrganization,
      AllowedReturnType._DistributionChannel,
      AllowedReturnType._Division,
      AllowedReturnType._SalesDocumentType
}
where SalesDocumentType.RetsMgmtIsActive   = 'X'
  and SalesDocumentType.SDDocumentCategory = 'H'

Learn More