P_ActlCostSplittingAssgmtText

DDL: P_ACTLCOSTSPLITTINGASSGMTTEXT Type: view_entity BASIC Package: FINS_CO_UTIL_EXC

Actl Cost Splitting Assgmt Text

P_ActlCostSplittingAssgmtText is a Basic CDS View that provides data about "Actl Cost Splitting Assgmt Text" in SAP S/4HANA. It reads from 1 data source (tsc0e) and exposes 6 fields with key fields StructureType, SplittingStructure, SplittingAssignment, Language. It has 1 association to related views. Part of development package FINS_CO_UTIL_EXC.

Data Sources (1)

SourceAliasJoin Type
tsc0e tsc0e from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.dataCategory #TEXT view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
ObjectModel.representativeKey SplittingAssignment view
VDM.viewType #BASIC view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY StructureType sctyp Structure Type
KEY SplittingStructure scnam Structure Name
KEY SplittingAssignment sczuo Assignment
KEY Language langu Primary lang.
SplittingAssignmentText ztext Text
_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 P_ActlCostSplittingAssgmtText.
-- 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 P_ActlCostSplittingAssgmtText AS
SELECT
  sctyp AS StructureType,
  scnam AS SplittingStructure,
  sczuo AS SplittingAssignment,
  langu AS Language,
  ztext AS SplittingAssignmentText
FROM tsc0e
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;