P_GrantCostAllocSgmt

DDL: P_GRANTCOSTALLOCSGMT Type: view COMPOSITE Package: ODATA_PSM_S4C_GM_WHRUSED_GRANT
40 Fields 1 Data Sources

WUGRANT Cost Allocation Segments

P_GrantCostAllocSgmt is a Composite CDS View that provides data about "WUGRANT Cost Allocation Segments" in SAP S/4HANA. It reads from 1 data source (I_GrantCostAllocSgmt) and exposes 40 fields with key fields GrantWhereUsedObjType, GrantID, AllocationType, AllocationCycle, ValidityStartDate. Part of development package ODATA_PSM_S4C_GM_WHRUSED_GRANT.

Data Sources (1)

SourceAliasJoin Type
I_GrantCostAllocSgmt I_GrantCostAllocSgmt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWUGRANTCAS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label WUGRANT 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 GrantWhereUsedObjType
KEY GrantID GrantID Sender Grant
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
GrantAllocationRole GrantAllocationRole
GrantAllocationGroup GrantAllocationGroup
_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_GrantCostAllocSgmt.
-- 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_GrantCostAllocSgmt AS
SELECT
  cast ('5CAS' as psm_s4c_gm_grant_wu_obj_typ_vh) AS GrantWhereUsedObjType,
  GrantID,
  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,
  GrantAllocationRole,
  GrantAllocationGroup
FROM I_GrantCostAllocSgmt
;

Learn More