A_CustomerSalesAreaText

DDL: A_CUSTOMERSALESAREATEXT Type: view COMPOSITE
8 Fields 1 Data Sources 1 Associations

Customer Sales Area Text

A_CustomerSalesAreaText is a Composite CDS View that provides data about "Customer Sales Area Text" in SAP S/4HANA. It reads from 1 data source (P_CustomerSalesAreaText) and exposes 8 fields with key fields Customer, SalesOrganization, DistributionChannel, Division, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_CustomerSalesAreaText CustomerSalesAreaText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_CustomerSalesArea _CustomerSalesArea _CustomerSalesArea.Customer = $projection.Customer and _CustomerSalesArea.SalesOrganization = $projection.SalesOrganization and _CustomerSalesArea.DistributionChannel = $projection.DistributionChannel and _CustomerSalesArea.Division = $projection.Division

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Customer Sales Area Text view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ACUSTSALESTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Customer P_CustomerSalesAreaText Customer Sold-to Party
KEY SalesOrganization P_CustomerSalesAreaText SalesOrganization Sales Organization
KEY DistributionChannel P_CustomerSalesAreaText DistributionChannel RefDistCh-Cust/Mat.
KEY Division P_CustomerSalesAreaText Division Internal Division ID
KEY Language P_CustomerSalesAreaText Language Report Text Language
KEY LongTextID LongTextID Text ID
LongText LongText Text Name
_CustomerSalesArea _CustomerSalesArea

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 A_CustomerSalesAreaText.
-- 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 A_CustomerSalesAreaText AS
SELECT
  CustomerSalesAreaText.Customer AS Customer,
  CustomerSalesAreaText.SalesOrganization AS SalesOrganization,
  CustomerSalesAreaText.DistributionChannel AS DistributionChannel,
  CustomerSalesAreaText.Division AS Division,
  CustomerSalesAreaText.Language AS Language,
  LongTextID,
  LongText
FROM P_CustomerSalesAreaText AS CustomerSalesAreaText
LEFT OUTER JOIN A_CustomerSalesArea AS _CustomerSalesArea ON _CustomerSalesArea.Customer = Customer AND _CustomerSalesArea.SalesOrganization = SalesOrganization AND _CustomerSalesArea.DistributionChannel = DistributionChannel AND _CustomerSalesArea.Division = Division  -- association [1..1]
;

Learn More