C_SalesOrgVHTemp

DDL: C_SALESORGVHTEMP SQL: CSLSORGVH Type: view CONSUMPTION
8 Fields 3 Associations

Value Help for Sales Organization

C_SalesOrgVHTemp is a Consumption CDS View that provides data about "Value Help for Sales Organization" in SAP S/4HANA. It has 3 associations to related views.

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_SalesOrgTextVHTemp _SalesOrgText $projection.SalesOrganization = _SalesOrgText.SalesOrganization association[0..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel
[0..*] C_Distrchnltextvhtemp _DistrChnlText $projection.DistributionChannel = _DistrChnlText.DistributionChannel association[0..1] to I_Division as _Division on $projection.Division = _Division.Division
[0..*] C_Divisiontextvhtemp _DivisionText $projection.Division = _DivisionText.Division

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSLSORGVH view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey SalesOrganization view
Search.searchable true view
EndUserText.label Value Help for Sales Organization view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view
AbapCatalog.preserveKey false view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization tvta vkorg SD Sales Org.
KEY DistributionChannel tvta vtwku Distribution Channel
KEY Division tvta spaku Division
_SalesOrgText _SalesOrgText
_DistributionChannel _DistributionChannel
_DistrChnlText _DistrChnlText
_Division _Division
_DivisionText _DivisionText

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 C_SalesOrgVHTemp.
-- 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: CSLSORGVH

CREATE VIEW C_SalesOrgVHTemp AS
SELECT
  tvta.vkorg AS SalesOrganization,
  tvta.vtwku AS DistributionChannel,
  tvta.spaku AS Division
LEFT OUTER JOIN C_SalesOrgTextVHTemp AS _SalesOrgText ON SalesOrganization = _SalesOrgText.SalesOrganization association[0..1] to I_DistributionChannel as _DistributionChannel on DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..*]
LEFT OUTER JOIN C_Distrchnltextvhtemp AS _DistrChnlText ON DistributionChannel = _DistrChnlText.DistributionChannel association[0..1] to I_Division as _Division on Division = _Division.Division  -- association [0..*]
LEFT OUTER JOIN C_Divisiontextvhtemp AS _DivisionText ON Division = _DivisionText.Division  -- association [0..*]
;

Learn More