C_AllocFieldGroupInformation

DDL: C_ALLOCFIELDGROUPINFORMATION SQL: CALLOCFLGRPINF Type: view CONSUMPTION

Allocation Field Group Information

C_AllocFieldGroupInformation is a Consumption CDS View that provides data about "Allocation Field Group Information" in SAP S/4HANA. It reads from 1 data source (P_AllocFieldGroupInformation) and exposes 26 fields with key fields AllocationType, AllocationPostingType, AllocationActualPlanVariant, AllocationFieldGroup.

Data Sources (1)

SourceAliasJoin Type
P_AllocFieldGroupInformation P_AllocFieldGroupInformation from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CALLOCFLGRPINF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Allocation Field Group Information view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType Table
KEY AllocationPostingType AllocationPostingType Posting Type
KEY AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
KEY AllocationFieldGroup AllocationFieldGroup Var. Portion Type
AllocVariablePortingType AllocVariablePortingType
AllocFldActlPlnVarValue AllocFldActlPlnVarValue
AllocationDataFieldName1 AllocationDataFieldName1
AllocationDataFieldName2 AllocationDataFieldName2
AllocationDataFieldName3 AllocationDataFieldName3
AllocationDataFieldName4 AllocationDataFieldName4
AllocationDataFieldName5 AllocationDataFieldName5
AllocationDataFieldName6 AllocationDataFieldName6
AllocationDataFieldName7 AllocationDataFieldName7
AllocationDataFieldName8 AllocationDataFieldName8
AllocationDataFieldName9 AllocationDataFieldName9
AllocationDataFieldName10 AllocationDataFieldName10
AllocFieldGroupDataFieldKey1 AllocFieldGroupDataFieldKey1
AllocFieldGroupDataFieldKey2 AllocFieldGroupDataFieldKey2
AllocFieldGroupDataFieldKey3 AllocFieldGroupDataFieldKey3
AllocFieldGroupDataFieldKey4 AllocFieldGroupDataFieldKey4
AllocFieldGroupDataFieldKey5 AllocFieldGroupDataFieldKey5
AllocFieldGroupDataFieldKey6 AllocFieldGroupDataFieldKey6
AllocFieldGroupDataFieldKey7 AllocFieldGroupDataFieldKey7
AllocFieldGroupDataFieldKey8 AllocFieldGroupDataFieldKey8
AllocFieldGroupDataFieldKey9 AllocFieldGroupDataFieldKey9
AllocFieldGroupDataFieldKey10 AllocFieldGroupDataFieldKey10

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 C_AllocFieldGroupInformation.
-- 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: CALLOCFLGRPINF

CREATE VIEW C_AllocFieldGroupInformation AS
SELECT
  AllocationType,
  AllocationPostingType,
  AllocationActualPlanVariant,
  AllocationFieldGroup,
  AllocVariablePortingType,
  AllocFldActlPlnVarValue,
  AllocationDataFieldName1,
  AllocationDataFieldName2,
  AllocationDataFieldName3,
  AllocationDataFieldName4,
  AllocationDataFieldName5,
  AllocationDataFieldName6,
  AllocationDataFieldName7,
  AllocationDataFieldName8,
  AllocationDataFieldName9,
  AllocationDataFieldName10,
  AllocFieldGroupDataFieldKey1,
  AllocFieldGroupDataFieldKey2,
  AllocFieldGroupDataFieldKey3,
  AllocFieldGroupDataFieldKey4,
  AllocFieldGroupDataFieldKey5,
  AllocFieldGroupDataFieldKey6,
  AllocFieldGroupDataFieldKey7,
  AllocFieldGroupDataFieldKey8,
  AllocFieldGroupDataFieldKey9,
  AllocFieldGroupDataFieldKey10
FROM P_AllocFieldGroupInformation
;