I_BOOCharcVersionLongText

DDL: I_BOOCHARCVERSIONLONGTEXT Type: view_entity BASIC
19 Fields 1 Data Sources 6 Associations

Plan Characteristic Long Text

I_BOOCharcVersionLongText is a Basic CDS View that provides data about "Plan Characteristic Long Text" in SAP S/4HANA. It reads from 1 data source (plmkltext) and exposes 19 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BOOOperationInternalID, BOOCharacteristic, BOOCharacteristicVersion. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
plmkltext plmkltext from

Associations (6)

CardinalityTargetAliasCondition
[1] I_BOOCharacteristicVersion _BOOCharcVers $projection.BillOfOperationsType = _BOOCharcVers.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOCharcVers.BillOfOperationsGroup and $projection.BOOOperationInternalID = _BOOCharcVers.BOOOperationInternalID and $projection.BOOCharacteristic = _BOOCharcVers.BOOCharacteristic and $projection.BOOCharacteristicVersion = _BOOCharcVers.BOOCharacteristicVersion
[0..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[0..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup
[0..1] I_BOOOperationInternalID _BOOOperationInternalID $projection.BillOfOperationsType = _BOOOperationInternalID.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOOperationInternalID.BillOfOperationsGroup and $projection.BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID
[0..1] I_BOOCharacteristic _BOOCharacteristic $projection.BillOfOperationsType = _BOOCharacteristic.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOCharacteristic.BillOfOperationsGroup and $projection.BOOOperationInternalID = _BOOCharacteristic.BOOOperationInternalID and $projection.BOOCharacteristic = _BOOCharacteristic.BOOCharacteristic
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Plan Characteristic Long Text view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey LongTextInternalNumber view
Feature QM_RR_LONGTEXT view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType plnty Task List Type
KEY BillOfOperationsGroup plnnr Task List Group
KEY BOOOperationInternalID plnkn Task list node
KEY BOOCharacteristic merknr Characteristic
KEY BOOCharacteristicVersion zaehl Sort pos.
KEY LongTextInternalNumber counter Version
KEY Language langu Primary lang.
LongTextID textid UUID
BOOCharcVersionLongText content Trusted Site Content
LongTextCreatedByUser created_by Version Created By
LongTextCreatedAt created_at Uploaded On
LongTextLastChangedByUser changed_by User Name
LongTextLastChangedAt changed_at Timestamp
_BOOCharacteristic _BOOCharacteristic
_BOOOperationInternalID _BOOOperationInternalID
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType
_BOOCharcVers _BOOCharcVers
_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_BOOCharcVersionLongText.
-- 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 I_BOOCharcVersionLongText AS
SELECT
  plnty AS BillOfOperationsType,
  plnnr AS BillOfOperationsGroup,
  plnkn AS BOOOperationInternalID,
  merknr AS BOOCharacteristic,
  zaehl AS BOOCharacteristicVersion,
  counter AS LongTextInternalNumber,
  langu AS Language,
  textid AS LongTextID,
  content AS BOOCharcVersionLongText,
  created_by AS LongTextCreatedByUser,
  created_at AS LongTextCreatedAt,
  changed_by AS LongTextLastChangedByUser,
  changed_at AS LongTextLastChangedAt
FROM plmkltext
LEFT OUTER JOIN I_BOOCharacteristicVersion AS _BOOCharcVers ON BillOfOperationsType = _BOOCharcVers.BillOfOperationsType AND BillOfOperationsGroup = _BOOCharcVers.BillOfOperationsGroup AND BOOOperationInternalID = _BOOCharcVers.BOOOperationInternalID AND BOOCharacteristic = _BOOCharcVers.BOOCharacteristic AND BOOCharacteristicVersion = _BOOCharcVers.BOOCharacteristicVersion  -- association [1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_BOOOperationInternalID AS _BOOOperationInternalID ON BillOfOperationsType = _BOOOperationInternalID.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationInternalID.BillOfOperationsGroup AND BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_BOOCharacteristic AS _BOOCharacteristic ON BillOfOperationsType = _BOOCharacteristic.BillOfOperationsType AND BillOfOperationsGroup = _BOOCharacteristic.BillOfOperationsGroup AND BOOOperationInternalID = _BOOCharacteristic.BOOOperationInternalID AND BOOCharacteristic = _BOOCharacteristic.BOOCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [1..1]
;

Learn More