I_MAINTAINEDORDTYPEPERSLSORG

CDS View

Maintained Order Types per Sales Org

I_MAINTAINEDORDTYPEPERSLSORG is a CDS View in S/4HANA. Maintained Order Types per Sales Org. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllwdOrdTypPerSlsOrg view from COMPOSITE Allowed Order Types per Sales Org
I_AllwdOrdTypPerSlsOrg view union COMPOSITE Allowed Order Types per Sales Org

Fields (4)

KeyField CDS FieldsUsed in Views
KEY DistributionChannel DistributionChannel 1
KEY Division Division 1
KEY SalesDocumentType SalesDocumentType 1
KEY SalesOrganization SalesOrganization 1 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED

@AbapCatalog: {
  sqlViewName: 'IMNTNDORDTYP',
  preserveKey: true,
  compiler.compareFilter: true,
  buffering: {
    type: #FULL,
    status: #ACTIVE
  }
}

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

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

define view I_MaintainedOrdTypePerSlsOrg 
as select from tvakz

  // 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 vkorg as SalesOrganization,
  
      @ObjectModel.foreignKey.association: '_DistributionChannel'
  key vtweg as DistributionChannel,
  
      @ObjectModel.foreignKey.association:'_Division'
  key spart as Division,
  
      @ObjectModel.foreignKey.association:'_SalesDocumentType'
  key auart as SalesDocumentType,
  
      _SalesOrganization,
      _DistributionChannel,
      _SalesDocumentType,
      _Division
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVAKZ"
],
"ASSOCIATED":
[
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESDOCUMENTTYPE",
"I_SALESORGANIZATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More