R_AllocationTagTextTP

DDL: R_ALLOCATIONTAGTEXTTP Type: view_entity TRANSACTIONAL

Allocation Tag - Text

R_AllocationTagTextTP is a Transactional CDS View that provides data about "Allocation Tag - Text" in SAP S/4HANA. It reads from 1 data source (I_AllocationTagText) and exposes 12 fields with key fields Language, AllocationTagUUID.

Data Sources (1)

SourceAliasJoin Type
I_AllocationTagText I_AllocationTagText from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Allocation Tag - Text view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Language I_AllocationTagText Language Report Text Language
KEY AllocationTagUUID I_AllocationTagText AllocationTagUUID Tag UUID
AllocationTagDescription I_AllocationTagText AllocationTagDescription Descript
AllocationTagID I_AllocationTagText AllocationTagID Allocation Tags
AllocationTagCreatedByUser I_AllocationTagText AllocationTagCreatedByUser Created By
CreationDateTime I_AllocationTagText CreationDateTime Timestamp
AllocationTagChangedByUser I_AllocationTagText AllocationTagChangedByUser Changed By
LastChangeDateTime I_AllocationTagText LastChangeDateTime Timestamp
LastChangeDate I_AllocationTagText LastChangeDate Time Stamp
AllocationCreateDate I_AllocationTagText AllocationCreateDate Entered On
_Language I_AllocationTagText _Language
_AllocationTag _AllocationTag

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 R_AllocationTagTextTP.
-- 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 R_AllocationTagTextTP AS
SELECT
  I_AllocationTagText.Language AS Language,
  I_AllocationTagText.AllocationTagUUID AS AllocationTagUUID,
  I_AllocationTagText.AllocationTagDescription AS AllocationTagDescription,
  I_AllocationTagText.AllocationTagID AS AllocationTagID,
  I_AllocationTagText.AllocationTagCreatedByUser AS AllocationTagCreatedByUser,
  I_AllocationTagText.CreationDateTime AS CreationDateTime,
  I_AllocationTagText.AllocationTagChangedByUser AS AllocationTagChangedByUser,
  I_AllocationTagText.LastChangeDateTime AS LastChangeDateTime,
  I_AllocationTagText.LastChangeDate AS LastChangeDate,
  I_AllocationTagText.AllocationCreateDate AS AllocationCreateDate,
  I_AllocationTagText._Language AS _Language
FROM I_AllocationTagText
;