CIC_SALESAREATEXT

DDL: CIC_SALESAREATEXT Type: view_entity
6 Fields 5 Data Sources

Sales Area

CIC_SALESAREATEXT is a CDS View that provides data about "Sales Area" in SAP S/4HANA. It reads from 5 data sources (CIC_DISTRIBUTIONCHANNELTEXT, CIC_DIVISIONTEXT, CIC_SALESORGANIZATIONTEXT, CIC_LanguageRegion, tvta) and exposes 6 fields with key fields SalesOrganization, DistributionChannel, Division, language.

Data Sources (5)

SourceAliasJoin Type
CIC_DISTRIBUTIONCHANNELTEXT _DistributionChannelText left_outer
CIC_DIVISIONTEXT _DivisionText left_outer
CIC_SALESORGANIZATIONTEXT _SalesOrganizationText left_outer
CIC_LanguageRegion language cross
tvta tvta from

Annotations (5)

NameValueLevelField
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Sales Area view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization tvta vkorg SD Sales Org.
KEY DistributionChannel tvta vtweg RefDistCh-Cust/Mat.
KEY Division tvta spart Source supplier
KEY language CIC_LanguageRegion Language Report Text Language
DivisionNameendasDivisionText
FullDescription

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 CIC_SALESAREATEXT.
-- 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 CIC_SALESAREATEXT AS
SELECT
  tvta.vkorg AS SalesOrganization,
  tvta.vtweg AS DistributionChannel,
  tvta.spart AS Division,
  language.Language AS language,
  case when _DivisionText.DivisionName is null or _DivisionText.DivisionName is initial then tvta.spart else _DivisionText.DivisionName end as DivisionText AS DivisionNameendasDivisionText,
  concat( concat( concat( concat( SalesOrganizationText, '/' ) , DistributionChannelText ) , '/' ), DivisionText ) AS FullDescription
FROM tvta
CROSS JOIN CIC_LanguageRegion AS language
LEFT OUTER JOIN CIC_SALESORGANIZATIONTEXT AS _SalesOrganizationText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CIC_DISTRIBUTIONCHANNELTEXT AS _DistributionChannelText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CIC_DIVISIONTEXT AS _DivisionText ON /* join condition not captured in parsed metadata */
;

Learn More