I_AllwdOrdTypPerSlsOrg

Q: Which tables does I_AllwdOrdTypPerSlsOrg use?

I_AllwdOrdTypPerSlsOrg reads from 3 data source(s): I_MaintainedOrdTypePerSlsOrg, I_MaintainedOrdTypePerSlsOrg, I_SalesArea.

Q: How many fields does I_AllwdOrdTypPerSlsOrg have?

I_AllwdOrdTypPerSlsOrg has 15 fields. Key fields: SalesOrganization, DistributionChannel, Division, SalesDocumentType, DistributionChannel.

DDL: I_ALLWDORDTYPPERSLSORG Type: view COMPOSITE

Allowed Order Types per Sales Org

I_AllwdOrdTypPerSlsOrg is a Composite CDS View that provides data about "Allowed Order Types per Sales Org" in SAP S/4HANA. It reads from 3 data sources (I_MaintainedOrdTypePerSlsOrg, I_MaintainedOrdTypePerSlsOrg, I_SalesArea) and exposes 15 fields with key fields SalesOrganization, DistributionChannel, Division, SalesDocumentType, DistributionChannel. It has 4 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_MaintainedOrdTypePerSlsOrg	MaintainedOrdTypePerSlsOrg	from
I_MaintainedOrdTypePerSlsOrg	MaintainedOrdTypePerSlsOrg	union
I_SalesArea	SalesArea	inner

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	I_SalesOrganization	_SalesOrganization	`$projection.SalesOrganization = _SalesOrganization.SalesOrganization`
[0..1]	I_DistributionChannel	_DistributionChannel	`$projection.DistributionChannel = _DistributionChannel.DistributionChannel`
[0..1]	I_SalesDocumentType	_SalesDocumentType	`$projection.SalesDocumentType = _SalesDocumentType.SalesDocumentType`
[0..1]	I_Division	_Division	`$projection.Division = _Division.Division`

Annotations (11)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AbapCatalog.sqlViewName	IALLWDORDTYP	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MASTER	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Allowed Order Types per Sales Org	view

Fields (15)

Key	Field	Source Table	Source Field
KEY	SalesOrganization	I_MaintainedOrdTypePerSlsOrg	SalesOrganization
KEY	DistributionChannel	I_MaintainedOrdTypePerSlsOrg	DistributionChannel
KEY	Division	I_MaintainedOrdTypePerSlsOrg	Division
KEY	SalesDocumentType	I_MaintainedOrdTypePerSlsOrg	SalesDocumentType
	_SalesOrganization		_SalesOrganization
	_DistributionChannel		_DistributionChannel
	_SalesDocumentType		_SalesDocumentType
	SalesOrganizationasSalesOrganization
KEY	DistributionChannel	I_SalesArea	DistributionChannel
KEY	Division	I_SalesArea	Division
KEY	SalesDocumentType	I_MaintainedOrdTypePerSlsOrg	SalesDocumentType
	_SalesOrganization		_SalesOrganization
	_DistributionChannel		_DistributionChannel
	_SalesDocumentType		_SalesDocumentType
	_Division		_Division

@ClientHandling.algorithm: #SESSION_VARIABLE 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED

@AbapCatalog: {
  sqlViewName: 'IALLWDORDTYP',
  preserveKey:true,
  compiler.compareFilter: true
}

@ObjectModel: {
  usageType: {
    serviceQuality: #A,
    sizeCategory : #S,
    dataClass: #MASTER
  }, 
  supportedCapabilities: [ #SQL_DATA_SOURCE,
                           #CDS_MODELING_DATA_SOURCE,
                           #CDS_MODELING_ASSOCIATION_TARGET ]
}

@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Allowed Order Types per Sales Org'

define view I_AllwdOrdTypPerSlsOrg
  as select from I_MaintainedOrdTypePerSlsOrg as MaintainedOrdTypePerSlsOrg
  
  // Associations  

  association [0..1] to I_SalesOrganization   as _SalesOrganization   on $projection.SalesOrganization = _SalesOrganization.SalesOrganization
  association [0..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel
  association [0..1] to I_SalesDocumentType   as _SalesDocumentType   on $projection.SalesDocumentType = _SalesDocumentType.SalesDocumentType
  association [0..1] to I_Division            as _Division            on $projection.Division = _Division.Division
{
      @ObjectModel.foreignKey.association: '_SalesOrganization'
  key MaintainedOrdTypePerSlsOrg.SalesOrganization as SalesOrganization,
  
      @ObjectModel.foreignKey.association: '_DistributionChannel'
  key MaintainedOrdTypePerSlsOrg.DistributionChannel as DistributionChannel,
  
      @ObjectModel.foreignKey.association:'_Division'
  key MaintainedOrdTypePerSlsOrg.Division as Division,
  
      @ObjectModel.foreignKey.association:'_SalesDocumentType'
  key MaintainedOrdTypePerSlsOrg.SalesDocumentType as SalesDocumentType,
  
      _SalesOrganization,
      _DistributionChannel,
      _SalesDocumentType,
      _Division
}      
 
  union

  select from I_MaintainedOrdTypePerSlsOrg as MaintainedOrdTypePerSlsOrg  
  inner join I_SalesArea as SalesArea on MaintainedOrdTypePerSlsOrg.SalesOrganization   = SalesArea.RefSlsOrgForSlsDocType
                                     and MaintainedOrdTypePerSlsOrg.DistributionChannel = SalesArea.RefDistrChnlForSlsDocType
                                     and MaintainedOrdTypePerSlsOrg.Division            = SalesArea.RefDivisionForSlsDocType            
                  
  // Associations  

  association [0..1] to I_SalesOrganization   as _SalesOrganization   on $projection.SalesOrganization   = _SalesOrganization.SalesOrganization
  association [0..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel
  association [0..1] to I_SalesDocumentType   as _SalesDocumentType   on $projection.SalesDocumentType   = _SalesDocumentType.SalesDocumentType
  association [0..1] to I_Division            as _Division            on $projection.Division            = _Division.Division
{
      @ObjectModel.foreignKey.association: '_SalesOrganization'
  key SalesArea.SalesOrganization as SalesOrganization,
  
      @ObjectModel.foreignKey.association: '_DistributionChannel'
  key SalesArea.DistributionChannel as DistributionChannel,
  
      @ObjectModel.foreignKey.association:'_Division'
  key SalesArea.Division as Division,
  
      @ObjectModel.foreignKey.association:'_SalesDocumentType'
  key MaintainedOrdTypePerSlsOrg.SalesDocumentType as SalesDocumentType,
  
      _SalesOrganization,
      _DistributionChannel,
      _SalesDocumentType,
      _Division
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTAINEDORDTYPEPERSLSORG",
"I_SALESAREA"
],
"ASSOCIATED":
[
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESDOCUMENTTYPE",
"I_SALESORGANIZATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_AllwdOrdTypPerSlsOrg view