C_BudgetEntryItemForObjP

DDL: C_BUDGETENTRYITEMFOROBJP SQL: CBUDDOCITM4OBJP Type: view CONSUMPTION
53 Fields 1 Data Sources 1 Associations

Budget Entry Document Item Object Page

C_BudgetEntryItemForObjP is a Consumption CDS View that provides data about "Budget Entry Document Item Object Page" in SAP S/4HANA. It reads from 1 data source (I_BudgetEntryDocumentItem) and exposes 53 fields with key fields FinancialManagementArea, BudgetDocumentYear, BudgetEntryDocument, BudgetEntryDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BudgetEntryDocumentItem I_BudgetEntryDocumentItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BudgetCategoryText _BudCatText $projection.BudgetCategory = _BudCatText.BudgetCategory and _BudCatText.Language = $session.system_language and _BudCatText.FinancialManagementArea = I_BudgetEntryDocumentItem.FinancialManagementArea

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CBUDDOCITM4OBJP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Budget Entry Document Item Object Page view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_BudgetEntryDocumentItem FinancialManagementArea FM Area
KEY BudgetDocumentYear I_BudgetEntryDocumentItem BudgetDocumentYear Fiscal Year
KEY BudgetEntryDocument I_BudgetEntryDocumentItem BudgetEntryDocument Document Number
KEY BudgetEntryDocumentItem I_BudgetEntryDocumentItem BudgetEntryDocumentItem
FinMgmtAreaFiscalYear I_BudgetEntryDocumentItem FinMgmtAreaFiscalYear Fiscal Year
InternalBudgetingProcess I_BudgetEntryDocumentItem InternalBudgetingProcess
InternalBudgetingProcessName
BudgetCategory I_BudgetEntryDocumentItem BudgetCategory Plan Category
BudgetCategoryName Budget Category Name
BudgetValueType I_BudgetEntryDocumentItem BudgetValueType BCS Value Type
BudgetType I_BudgetEntryDocumentItem BudgetType
CommitmentItemCategory CommitmentItemCategory
FinancialManagementAreaCrcy Financial Management Area Currency
Fund I_BudgetEntryDocumentItem BudgetedFund Fund
FundName Fund Name
FundExtendedName
CommitmentItem I_BudgetEntryDocumentItem BudgetedCommitmentItem Commitment Item
CommitmentItemName
CommitItemExtendedName
FundsCenter I_BudgetEntryDocumentItem BudgetedFundsCenter Funds Center
FundsCenterName Funds Center Name
FundsCenterExtendedName
BudgetPeriod I_BudgetEntryDocumentItem BudgetedBudgetPeriod Budget Period
BudgetPeriodName
BudgedPeriodExtendedName
FunctionalArea I_BudgetEntryDocumentItem BudgetedFunctionalArea Functional Area
FunctionalAreaName Functional Area Name
FunctionalAreaExtendedName
FundedProgram I_BudgetEntryDocumentItem BudgetedFundedProgram Funded Program
FundedProgramName
FundedProgramExtendedName
GrantID I_BudgetEntryDocumentItem BudgetedGrantID Grant
GrantName
GrantExtendedName
FunctionalAreaSubdivisionID I_BudgetEntryDocumentItem FunctionalAreaSubdivisionID Farea Subdivision ID
FunctionalArea1Subdivision I_BudgetEntryDocumentItem FunctionalArea1Subdivision FN Substring 1
FuncArea1SubdivisionDesc
FunctionalArea2Subdivision I_BudgetEntryDocumentItem FunctionalArea2Subdivision FN Substring 2
FuncArea2SubdivisionDesc
FunctionalArea3Subdivision I_BudgetEntryDocumentItem FunctionalArea3Subdivision FN Substring 3
FuncArea3SubdivisionDesc
BudgetVersion I_BudgetEntryDocumentItem BudgetVersion Version
BudgetEntryDocumentType I_BudgetEntryDocumentItem BudgetEntryDocumentType
CommitmentItemAuthznGrp I_BudgetEntryDocumentItem CommitmentItemAuthznGrp
FundAuthznGrp I_BudgetEntryDocumentItem FundAuthznGrp
FundFinMgmtAreaForAuthzn
FundsCenterAuthznGrp I_BudgetEntryDocumentItem FundsCenterAuthznGrp
FndsCenterFinMgmtAreaForAuthzn
FundedProgramAuthznGrp I_BudgetEntryDocumentItem FundedProgramAuthznGrp
FundedPgmFinMgmtAreaForAuthzn
BudgetPeriodAuthznGrp I_BudgetEntryDocumentItem BudgetPeriodAuthznGrp
GrantAuthznGrp I_BudgetEntryDocumentItem GrantAuthznGrp
FunctionalAreaAuthznGrp I_BudgetEntryDocumentItem FunctionalAreaAuthznGrp

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_BudgetEntryItemForObjP.
-- 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: CBUDDOCITM4OBJP

CREATE VIEW C_BudgetEntryItemForObjP AS
SELECT
  I_BudgetEntryDocumentItem.FinancialManagementArea AS FinancialManagementArea,
  I_BudgetEntryDocumentItem.BudgetDocumentYear AS BudgetDocumentYear,
  I_BudgetEntryDocumentItem.BudgetEntryDocument AS BudgetEntryDocument,
  I_BudgetEntryDocumentItem.BudgetEntryDocumentItem AS BudgetEntryDocumentItem,
  I_BudgetEntryDocumentItem.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  I_BudgetEntryDocumentItem.InternalBudgetingProcess AS InternalBudgetingProcess,
  I_BudgetEntryDocumentItem._BudgetingProcess._Text[1:Language=$session.system_language].InternalBudgetingProcessName AS InternalBudgetingProcessName,
  I_BudgetEntryDocumentItem.BudgetCategory AS BudgetCategory,
  _BudCatText._BudgetCategory._Text[1:Language=$session.system_language].BudgetCategoryName AS BudgetCategoryName,
  I_BudgetEntryDocumentItem.BudgetValueType AS BudgetValueType,
  I_BudgetEntryDocumentItem.BudgetType AS BudgetType,
  CommitmentItemCategory,
  I_BudgetEntryDocumentItem._FinMgmtArea.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  I_BudgetEntryDocumentItem.BudgetedFund AS Fund,
  I_BudgetEntryDocumentItem._Fund._Text[1:Language = $session.system_language].FundName AS FundName,
  cast( concat_with_space(_Fund._Text[1:Language = $session.system_language].FundName, concat('(',concat(BudgetedFund,')')), 1) as fmis_fundextendedname preserving type ) AS FundExtendedName,
  I_BudgetEntryDocumentItem.BudgetedCommitmentItem AS CommitmentItem,
  I_BudgetEntryDocumentItem._CommitmentItem._Text[1:Language = $session.system_language].CommitmentItemName AS CommitmentItemName,
  cast( concat_with_space(BudgetedCommitmentItem, _CommitmentItem._Text[1:Language = $session.system_language].CommitmentItemName, 1) as fmis_commititemextendedname preserving type ) AS CommitItemExtendedName,
  I_BudgetEntryDocumentItem.BudgetedFundsCenter AS FundsCenter,
  I_BudgetEntryDocumentItem._FundsCenter._Text[1:Language = $session.system_language].FundsCenterName AS FundsCenterName,
  cast( concat_with_space(BudgetedFundsCenter, _FundsCenter._Text[1:Language = $session.system_language].FundsCenterName, 1) as fmis_fundscenterextendedname preserving type ) AS FundsCenterExtendedName,
  I_BudgetEntryDocumentItem.BudgetedBudgetPeriod AS BudgetPeriod,
  I_BudgetEntryDocumentItem._BudgetPeriod._Text[1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  cast( concat_with_space(BudgetedBudgetPeriod, _BudgetPeriod._Text[1:Language = $session.system_language].BudgetPeriodName, 1) as fmis_budperextendedname preserving type ) AS BudgedPeriodExtendedName,
  I_BudgetEntryDocumentItem.BudgetedFunctionalArea AS FunctionalArea,
  I_BudgetEntryDocumentItem._FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  cast( concat_with_space(BudgetedFunctionalArea, _FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName, 1) as fmis_funcareaextendedname preserving type ) AS FunctionalAreaExtendedName,
  I_BudgetEntryDocumentItem.BudgetedFundedProgram AS FundedProgram,
  I_BudgetEntryDocumentItem._FundedProgram._Text[1:Language = $session.system_language].FundedProgramName AS FundedProgramName,
  cast( concat_with_space(BudgetedFundedProgram, _FundedProgram._Text[1:Language = $session.system_language].FundedProgramName, 1) as fmis_fundedprogextendedname preserving type ) AS FundedProgramExtendedName,
  I_BudgetEntryDocumentItem.BudgetedGrantID AS GrantID,
  I_BudgetEntryDocumentItem._Grant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  cast( concat_with_space(BudgetedGrantID, _Grant._Text[1:Language = $session.system_language].GrantName, 1) as gmis_grant_nbr_extended_name preserving type ) AS GrantExtendedName,
  I_BudgetEntryDocumentItem.FunctionalAreaSubdivisionID AS FunctionalAreaSubdivisionID,
  I_BudgetEntryDocumentItem.FunctionalArea1Subdivision AS FunctionalArea1Subdivision,
  cast( I_BudgetEntryDocumentItem._FuncArea1Subdivision._Text[1:Language = $session.system_language].FuncArea1SubdivisionDesc as fmis_fareasub1_text) AS FuncArea1SubdivisionDesc,
  I_BudgetEntryDocumentItem.FunctionalArea2Subdivision AS FunctionalArea2Subdivision,
  cast( I_BudgetEntryDocumentItem._FuncArea2Subdivision._Text[1:Language = $session.system_language].FuncArea2SubdivisionDesc as fmis_fareasub2_text) AS FuncArea2SubdivisionDesc,
  I_BudgetEntryDocumentItem.FunctionalArea3Subdivision AS FunctionalArea3Subdivision,
  cast( I_BudgetEntryDocumentItem._FuncArea3Subdivision._Text[1:Language = $session.system_language].FuncArea3SubdivisionDesc as fmis_fareasub3_text) AS FuncArea3SubdivisionDesc,
  I_BudgetEntryDocumentItem.BudgetVersion AS BudgetVersion,
  I_BudgetEntryDocumentItem.BudgetEntryDocumentType AS BudgetEntryDocumentType,
  I_BudgetEntryDocumentItem.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  I_BudgetEntryDocumentItem.FundAuthznGrp AS FundAuthznGrp,
  I_BudgetEntryDocumentItem._Fund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  I_BudgetEntryDocumentItem.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  I_BudgetEntryDocumentItem._FundsCenter.FndsCenterFinMgmtAreaForAuthzn AS FndsCenterFinMgmtAreaForAuthzn,
  I_BudgetEntryDocumentItem.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  I_BudgetEntryDocumentItem._FundedProgram.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn,
  I_BudgetEntryDocumentItem.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  I_BudgetEntryDocumentItem.GrantAuthznGrp AS GrantAuthznGrp,
  I_BudgetEntryDocumentItem.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp
FROM I_BudgetEntryDocumentItem
LEFT OUTER JOIN I_BudgetCategoryText AS _BudCatText ON BudgetCategory = _BudCatText.BudgetCategory AND _BudCatText.Language = $session.system_language AND _BudCatText.FinancialManagementArea = I_BudgetEntryDocumentItem.FinancialManagementArea  -- association [0..1]
;

Learn More