I_LastMileVisitListOrgVH

DDL: I_LASTMILEVISITLISTORGVH SQL: ILMDVLIORGVH Type: view COMPOSITE
2 Fields 1 Associations

LMD - Visit List Organization Value Help

I_LastMileVisitListOrgVH is a Composite CDS View that provides data about "LMD - Visit List Organization Value Help" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SalesOrganizationText _Text $projection.SalesOrganization = _Text.SalesOrganization and _Text.Language = $session.system_language

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ILMDVLIORGVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey SalesOrganization view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label LMD - Visit List Organization Value Help view
Metadata.ignorePropagatedAnnotations true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization SalesOrganization Sales Organization
SalesOrganizationName _Text SalesOrganizationName Sales Organization Description

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_LastMileVisitListOrgVH.
-- 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: ILMDVLIORGVH

CREATE VIEW I_LastMileVisitListOrgVH AS
SELECT
  SalesOrganization,
  _Text.SalesOrganizationName AS SalesOrganizationName
LEFT OUTER JOIN I_SalesOrganizationText AS _Text ON SalesOrganization = _Text.SalesOrganization AND _Text.Language = $session.system_language  -- association [0..1]
;

Learn More