P_FuncnlAreaCostAllocSgmt

DDL: P_FUNCNLAREACOSTALLOCSGMT Type: view COMPOSITE
40 Fields 1 Data Sources

WUFAREA Cost Allocation Segments

P_FuncnlAreaCostAllocSgmt is a Composite CDS View that provides data about "WUFAREA Cost Allocation Segments" in SAP S/4HANA. It reads from 1 data source (I_FuncnlAreaCostAllocSgmt) and exposes 40 fields with key fields FuncnlAreaWhereUsedObjType, FunctionalArea, AllocationType, AllocationCycle, ValidityStartDate.

Data Sources (1)

SourceAliasJoin Type
I_FuncnlAreaCostAllocSgmt I_FuncnlAreaCostAllocSgmt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWUFNAREACAS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label WUFAREA Cost Allocation Segments view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY FuncnlAreaWhereUsedObjType
KEY FunctionalArea FunctionalArea Sendr Fctl Area
KEY AllocationType AllocationType Table
KEY AllocationCycle AllocationCycle Cycle
KEY ValidityStartDate ValidityStartDate Validity Start Date
KEY AllocationCycleSegment AllocationCycleSegment Segment Number
KEY AllocationSetType AllocationSetType Type of Set
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber
AllocationCycleName AllocationCycleName Allocation Cycle
AllocationCycleNameText AllocationCycleNameText Cycle Description
Ledger Ledger Ledger
AllocationLastExecutedByUser AllocationLastExecutedByUser
LastChangedByUser LastChangedByUser User Name
AllocationLastExecutedDate AllocationLastExecutedDate
SegmentName SegmentName Segment Name
SegmentNameText SegmentNameText
AllocationSegmentIsLocked AllocationSegmentIsLocked Lock indicator
AllocationFieldGroup AllocationFieldGroup Var. Portion Type
AllocationFieldName AllocationFieldName Field
AllocationSetName AllocationSetName
AllocationFieldMinimumValue AllocationFieldMinimumValue From Value
AllocationFieldMaximumValue AllocationFieldMaximumValue To Value
AllocationSetId AllocationSetId Group ID
AllocKeyFieldIsInitial AllocKeyFieldIsInitial
AllocKeyFieldIsAllValues AllocKeyFieldIsAllValues
ValidityEndDate ValidityEndDate ValidTo
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
AllocationPostingType AllocationPostingType Posting Type
AllocationPostingTypeText _AllocationPostingTypeText AllocationPostingTypeText
AllocationReceiverRuleText _AllocationReceiverRuleText AllocationReceiverRuleText
AllocationSenderRuleText _AllocationSenderRuleText AllocationSenderRuleText
AllocationSenderRule AllocationSenderRule Sender Rule
AllocationReceiverRule AllocationReceiverRule Receiver Rule
FunctionalAreaAllocationRole FunctionalAreaAllocationRole
FunctionalAreaAllocationGroup FunctionalAreaAllocationGroup
_Cycle _Cycle
_Segment _Segment
_AllocationPostingTypeText _AllocationPostingTypeText
_AllocationReceiverRuleText _AllocationReceiverRuleText
_AllocationSenderRuleText _AllocationSenderRuleText

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 P_FuncnlAreaCostAllocSgmt.
-- 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 P_FuncnlAreaCostAllocSgmt AS
SELECT
  cast ('5CAS' as psm_s4c_fm_fnarea_wu_objtypevh) AS FuncnlAreaWhereUsedObjType,
  FunctionalArea,
  AllocationType,
  AllocationCycle,
  ValidityStartDate,
  AllocationCycleSegment,
  AllocationSetType,
  AllocDocumentSequenceNumber,
  AllocationCycleName,
  AllocationCycleNameText,
  Ledger,
  AllocationLastExecutedByUser,
  LastChangedByUser,
  AllocationLastExecutedDate,
  SegmentName,
  SegmentNameText,
  AllocationSegmentIsLocked,
  AllocationFieldGroup,
  AllocationFieldName,
  AllocationSetName,
  AllocationFieldMinimumValue,
  AllocationFieldMaximumValue,
  AllocationSetId,
  AllocKeyFieldIsInitial,
  AllocKeyFieldIsAllValues,
  ValidityEndDate,
  AllocationActualPlanVariant,
  AllocationPostingType,
  _AllocationPostingTypeText.AllocationPostingTypeText AS AllocationPostingTypeText,
  _AllocationReceiverRuleText.AllocationReceiverRuleText AS AllocationReceiverRuleText,
  _AllocationSenderRuleText.AllocationSenderRuleText AS AllocationSenderRuleText,
  AllocationSenderRule,
  AllocationReceiverRule,
  FunctionalAreaAllocationRole,
  FunctionalAreaAllocationGroup
FROM I_FuncnlAreaCostAllocSgmt
;

Learn More