I_BdgtEntrItemSubdivisionBasic

DDL: I_BDGTENTRITEMSUBDIVISIONBASIC SQL: IFMBDGTSUBDI Type: view BASIC
21 Fields 1 Data Sources

Subdivision item for Budget Entry Doc

I_BdgtEntrItemSubdivisionBasic is a Basic CDS View that provides data about "Subdivision item for Budget Entry Doc" in SAP S/4HANA. It reads from 1 data source (fmbcssubdivfmbl) and exposes 21 fields with key fields FinancialManagementArea, BudgetDocumentYear, BudgetEntryDocument, BudgetEntryDocumentItem.

Data Sources (1)

SourceAliasJoin Type
fmbcssubdivfmbl fmbcssubdivfmbl from

Annotations (10)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Subdivision item for Budget Entry Doc view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IFMBDGTSUBDI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea fm_area FM Area
KEY BudgetDocumentYear docyear Ref. Doc. Year
KEY BudgetEntryDocument docnr Well doc.no.
KEY BudgetEntryDocumentItem docln Matching Document Line Item
FunctionalAreaSubdivisionID functionalareasubdivisionid Farea Subdivision ID
FunctionalArea1Subdivision functionalarea1subdivision FN Substring 1
FunctionalArea2Subdivision functionalarea2subdivision FN Substring 2
FunctionalArea3Subdivision functionalarea3subdivision FN Substring 3
CommitmentItemSubdivisionID commitmentitemsubdivisionid CItem Subdiv. ID
CommitmentItem1Subdivision commitmentitem1subdivision CI Substring 1
CommitmentItem2Subdivision commitmentitem2subdivision CI Substring 2
CommitmentItem3Subdivision commitmentitem3subdivision CI Substring 3
CommitmentItem4Subdivision commitmentitem4subdivision CI Substring 4
CommitmentItem5Subdivision commitmentitem5subdivision CI Substring 5
FundsSubdivisionID fundssubdivisionid Fund Subdivision ID
Funds1Subdivision funds1subdivision FD Substring 1
Funds2Subdivision funds2subdivision FD Substring 2
FundsCenterSubdivisionID fundscentersubdivisionid Fctr Subdiv. ID
FundsCenter1Subdivision fundscenter1subdivision FC Substring 1
FundsCenter2Subdivision fundscenter2subdivision FC Substring 2
FundsCenter3Subdivision fundscenter3subdivision FC Substring 3

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_BdgtEntrItemSubdivisionBasic.
-- 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: IFMBDGTSUBDI

CREATE VIEW I_BdgtEntrItemSubdivisionBasic AS
SELECT
  fm_area AS FinancialManagementArea,
  docyear AS BudgetDocumentYear,
  docnr AS BudgetEntryDocument,
  docln AS BudgetEntryDocumentItem,
  FunctionalAreaSubdivisionID,
  FunctionalArea1Subdivision,
  FunctionalArea2Subdivision,
  FunctionalArea3Subdivision,
  CommitmentItemSubdivisionID,
  CommitmentItem1Subdivision,
  CommitmentItem2Subdivision,
  CommitmentItem3Subdivision,
  CommitmentItem4Subdivision,
  CommitmentItem5Subdivision,
  FundsSubdivisionID,
  Funds1Subdivision,
  Funds2Subdivision,
  FundsCenterSubdivisionID,
  FundsCenter1Subdivision,
  FundsCenter2Subdivision,
  FundsCenter3Subdivision
FROM fmbcssubdivfmbl
;

Learn More