I_SlsOrdRelevanceForTranspMgmt

DDL: I_SLSORDRELEVANCEFORTRANSPMGMT SQL: ISOFORTM Type: view BASIC

Sales Order Relevance for Transport Management

I_SlsOrdRelevanceForTranspMgmt is a Basic CDS View that provides data about "Sales Order Relevance for Transport Management" in SAP S/4HANA. It reads from 2 data sources (tms_c_control, vbak) and exposes 6 fields with key field SalesOrder.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
tms_c_control _TmControl left_outer
vbak vbak from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISOFORTM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Order Relevance for Transport Management view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder vbeln
SlsOrdIsRelevantForTranspMgmt tms_c_control od_to_tm_ind
SalesDocumentType auart
OrganizationDivision spart
SalesOrganization vkorg
DistributionChannel vtweg 
@AbapCatalog.sqlViewName: 'ISOFORTM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Sales Order Relevance for Transport Management'


define view I_SlsOrdRelevanceForTranspMgmt
  as select from    vbak
    left outer join tms_c_control as _TmControl on _TmControl.tm_ctrl_key = vbak.tm_ctrl_key
{
  key vbeln                     as SalesOrder,
      _TmControl.od_to_tm_ind   as SlsOrdIsRelevantForTranspMgmt,
      auart                     as SalesDocumentType,
      spart                     as OrganizationDivision,
      vkorg                     as SalesOrganization,
      vtweg                     as DistributionChannel
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TMS_C_CONTROL",
"VBAK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More