I_AllocDataFldDesc

DDL: I_ALLOCDATAFLDDESC SQL: ALLOCDATAFLDDESC Type: view BASIC

Allocations Data Field Descriptions

I_AllocDataFldDesc is a Basic CDS View that provides data about "Allocations Data Field Descriptions" in SAP S/4HANA. It reads from 1 data source (t811h) and exposes 24 fields with key fields AllocationType, AllocDataFldDefName.

Data Sources (1)

SourceAliasJoin Type
t811h t811h from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ALLOCDATAFLDDESC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Allocations Data Field Descriptions view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY AllocationType Totals Table
KEY AllocDataFldDefName fname User
AllocAdditionalValue adval Value Add. Fld
AllocFieldGroupTableName addtb1 Table
AllocationDataFieldName1 rc_field1 Field
AllocationDataFieldName2 rc_field2 Field
AllocationDataFieldName3 rc_field3 Field
AllocationDataFieldName4 rc_field4 Field
AllocationDataFieldName5 rc_field5 Field
AllocationDataFieldName6 rc_field6 Field
AllocationDataFieldName7 rc_field7 Field
AllocationDataFieldName8 rc_field8 Field
AllocationDataFieldName9 rc_field9 Field
AllocationDataFieldName10 rc_field10 Field
AllocDataFieldVisibility1 rc_act_field1 RC_ACT
AllocDataFieldVisibility2 rc_act_field2 RC_ACT
AllocDataFieldVisibility3 rc_act_field3 RC_ACT
AllocDataFieldVisibility4 rc_act_field4 RC_ACT
AllocDataFieldVisibility5 rc_act_field5 RC_ACT
AllocDataFieldVisibility6 rc_act_field6 RC_ACT
AllocDataFieldVisibility7 rc_act_field7 RC_ACT
AllocDataFieldVisibility8 rc_act_field8 RC_ACT
AllocDataFieldVisibility9 rc_act_field9 RC_ACT
AllocDataFieldVisibility10 rc_act_field10 RC_ACT

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_AllocDataFldDesc.
-- 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: ALLOCDATAFLDDESC

CREATE VIEW I_AllocDataFldDesc AS
SELECT
  cast(tab as fco_allocation_context preserving type) AS AllocationType,
  fname AS AllocDataFldDefName,
  adval AS AllocAdditionalValue,
  addtb1 AS AllocFieldGroupTableName,
  rc_field1 AS AllocationDataFieldName1,
  rc_field2 AS AllocationDataFieldName2,
  rc_field3 AS AllocationDataFieldName3,
  rc_field4 AS AllocationDataFieldName4,
  rc_field5 AS AllocationDataFieldName5,
  rc_field6 AS AllocationDataFieldName6,
  rc_field7 AS AllocationDataFieldName7,
  rc_field8 AS AllocationDataFieldName8,
  rc_field9 AS AllocationDataFieldName9,
  rc_field10 AS AllocationDataFieldName10,
  rc_act_field1 AS AllocDataFieldVisibility1,
  rc_act_field2 AS AllocDataFieldVisibility2,
  rc_act_field3 AS AllocDataFieldVisibility3,
  rc_act_field4 AS AllocDataFieldVisibility4,
  rc_act_field5 AS AllocDataFieldVisibility5,
  rc_act_field6 AS AllocDataFieldVisibility6,
  rc_act_field7 AS AllocDataFieldVisibility7,
  rc_act_field8 AS AllocDataFieldVisibility8,
  rc_act_field9 AS AllocDataFieldVisibility9,
  rc_act_field10 AS AllocDataFieldVisibility10
FROM t811h
;