I_MaintainedOrdTypePerSlsOrg

DDL: I_MAINTAINEDORDTYPEPERSLSORG Type: view BASIC
8 Fields 1 Data Sources 4 Associations

Maintained Order Types per Sales Org

I_MaintainedOrdTypePerSlsOrg (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_MaintainedOrdTypePerSlsOrg is a Basic CDS View that provides data about "Maintained Order Types per Sales Org" in SAP S/4HANA. It reads from 1 data source (tvakz) and exposes 8 fields with key fields SalesOrganization, DistributionChannel, Division, SalesDocumentType. It has 4 associations to related views.

SAP Help Documentation

CategorySales Orders
Purpose
This CDS view shows whether the usage of a sales order type is restricted for a specific sales area (which is defined by a combination of sales organization, distribution channel and division). This CDS view provides the data to answer the following questions: Which sales order types are valid for a specific sales area? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Important fields Important fields in this view include the following: Field Name Description SalesOrganization Sales organization DistributionChannel Distribution channel Division Division SalesDocumentType Sales document type

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentSD-SLS-GF
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view shows whether the usage of a sales order type is restricted for a specific sales area (which is defined by a combination of sales organization, distribution channel and division).</p> This CDS view provides the data to answer the following questions:<ul> <li><p>Which sales order types are valid for a specific sales area?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
tvakz tvakz from

Associations (4)

CardinalityTargetAliasCondition
[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 (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IMNTNDORDTYP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.status #ACTIVE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Maintained Order Types per Sales Org view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization vkorg Sales Organization
KEY DistributionChannel vtweg Distribution Channel
KEY Division spart Source supplier
KEY SalesDocumentType auart Sales Document Type
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_SalesDocumentType _SalesDocumentType
_Division _Division

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_MaintainedOrdTypePerSlsOrg.
-- 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.

CREATE VIEW I_MaintainedOrdTypePerSlsOrg AS
SELECT
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  auart AS SalesDocumentType
FROM tvakz
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
;

Learn More