I_AllocationTag

DDL: I_ALLOCATIONTAG SQL: ALLOCTAG Type: view BASIC

OBSOLETE

I_AllocationTag is a Basic CDS View that provides data about "OBSOLETE" in SAP S/4HANA. It reads from 1 data source (allotag) and exposes 10 fields with key field AllocationTagUUID.

Data Sources (1)

SourceAliasJoin Type
allotag allotag from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ALLOCTAG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label OBSOLETE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AllocationTagUUID allocationtaguuid Tag UUID
AllocationTagID allocationtagid Allocation Tags
AllocationTagCreatedByUser
AllocationTagCreationDate
AllocationTagCreationTime
AllocationTagChangedByUser allocationtagchangedbyuser Changed By
AllocationTagLastChangeDate
AllocationTagLastChangeTime
CreationDate
CreationTime

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_AllocationTag.
-- 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: ALLOCTAG

CREATE VIEW I_AllocationTag AS
SELECT
  AllocationTagUUID,
  AllocationTagID,
  cast( 'POTEMKIN' as fco_tag_created_user ) AS AllocationTagCreatedByUser,
  cast( '22222222' as fco_tag_created_date ) AS AllocationTagCreationDate,
  cast( '222222' as fco_tag_created_time ) AS AllocationTagCreationTime,
  AllocationTagChangedByUser,
  cast( '22222222' as fco_tag_changed_date ) AS AllocationTagLastChangeDate,
  cast( '222222' as fco_tag_created_time ) AS AllocationTagLastChangeTime,
  cast( '22222222' as fco_tag_created_date ) AS CreationDate,
  cast( '222222' as fco_tag_created_time ) AS CreationTime
FROM allotag
;