I_InsurClmOrganization

DDL: I_INSURCLMORGANIZATION SQL: IICLORGUNITBASE Type: view BASIC
9 Fields 1 Data Sources 1 Associations

Basis View für Tabelle HRP1000

I_InsurClmOrganization is a Basic CDS View that provides data about "Basis View für Tabelle HRP1000" in SAP S/4HANA. It reads from 1 data source (hrp1000) and exposes 9 fields with key fields PlanVersion, OrganizationalUnit, OrgUnitValidityStartDate, OrgUnitValidityEndDate, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
hrp1000 hrp1000 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language hrp1000.langu = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IICLORGUNITBASE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Basis View für Tabelle HRP1000 view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey OrganizationalUnit view
Search.searchable true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PlanVersion plvar Plan version
KEY OrganizationalUnit objid Work Center
KEY OrgUnitValidityStartDate begda Valid From
KEY OrgUnitValidityEndDate endda Valid To
KEY Language langu Primary lang.
OrganizationalUnitShortName short Shortened form
OrganizationalUnitName stext Text
ObjectType otype Type of Val.
_Language _Language

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_InsurClmOrganization.
-- 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: IICLORGUNITBASE

CREATE VIEW I_InsurClmOrganization AS
SELECT
  plvar AS PlanVersion,
  objid AS OrganizationalUnit,
  begda AS OrgUnitValidityStartDate,
  endda AS OrgUnitValidityEndDate,
  langu AS Language,
  short AS OrganizationalUnitShortName,
  stext AS OrganizationalUnitName,
  otype AS ObjectType
FROM hrp1000
LEFT OUTER JOIN I_Language AS _Language ON hrp1000.langu = _Language.Language  -- association [0..1]
;

Learn More