I_SlsOrdRelevanceForTranspMgmt

DDL: I_SLSORDRELEVANCEFORTRANSPMGMT SQL: ISOFORTM Type: view BASIC Package: VDM_LE_SHP_OBD_COMMON
6 Fields 2 Data Sources

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. Part of development package VDM_LE_SHP_OBD_COMMON.

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 SD Sched. Agmt
SlsOrdIsRelevantForTranspMgmt tms_c_control od_to_tm_ind Outbound Del.
SalesDocumentType auart Sales Doc. Type
OrganizationDivision spart Source supplier
SalesOrganization vkorg SD Sales Org.
DistributionChannel vtweg RefDistCh-Cust/Mat.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SlsOrdRelevanceForTranspMgmt.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISOFORTM

CREATE VIEW I_SlsOrdRelevanceForTranspMgmt AS
SELECT
  vbeln AS SalesOrder,
  _TmControl.od_to_tm_ind AS SlsOrdIsRelevantForTranspMgmt,
  auart AS SalesDocumentType,
  spart AS OrganizationDivision,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel
FROM vbak
LEFT OUTER JOIN tms_c_control AS _TmControl ON /* join condition not captured in parsed metadata */
;

Learn More