What is P_USFedRblStatusBasic in SAP S/4HANA?

P_USFedRblStatusBasic is a composite CDS view in SAP S/4HANA. It contains 56 fields.

Which tables does P_USFedRblStatusBasic read from?

P_USFedRblStatusBasic reads data from: I_GLAccountLineItemRawData.

What VDM layer is P_USFedRblStatusBasic?

P_USFedRblStatusBasic is classified as a Composite view that combines data from multiple basic views.

P_USFedRblStatusBasic

DDL: P_USFEDRBLSTATUSBASIC Type: view_entity COMPOSITE

56 Fields 1 Data Sources 2 Associations

P_USFedRblStatusBasic is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemRawData) and exposes 56 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_GLAccountLineItemRawData	I_GLAccountLineItemRawData	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_USFedOplAcctgDocItem	_InvoiceItemReference	`$projection.CompanyCode = _InvoiceItemReference.CompanyCode and $projection.InvoiceReferenceFiscalYear = _InvoiceItemReference.FiscalYear and $projection.InvoiceReference = _InvoiceItemReference.AccountingDocument and $projection.InvoiceItemReference = _InvoiceItemReference.AccountingDocumentItem`
[0..1]	I_USFedOplAcctgDocItem	_AccountingDocumentItem	`$projection.CompanyCode = _AccountingDocumentItem.CompanyCode and $projection.FiscalYear = _AccountingDocumentItem.FiscalYear and $projection.AccountingDocument = _AccountingDocumentItem.AccountingDocument and $projection.AccountingDocumentItem = _AccountingDocumentItem.AccountingDocumentItem`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (56)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger		SourceLedger	Source Ledger
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	LedgerGLLineItem		LedgerGLLineItem	Journal Entry Item
	InvoiceReference	I_GLAccountLineItemRawData	InvoiceReference	Invoice Reference
	InvoiceReferenceFiscalYear	I_GLAccountLineItemRawData	InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
	InvoiceItemReference	I_GLAccountLineItemRawData	InvoiceItemReference	Item
	AccountingDocumentItem	I_GLAccountLineItemRawData	AccountingDocumentItem	Posting View Item
	AccountingDocumentType	I_GLAccountLineItemRawData	AccountingDocumentType	Journal Entry Type
	DocumentDate	I_GLAccountLineItemRawData	DocumentDate	Journal Entry Date
	FinancialAccountType	I_GLAccountLineItemRawData	FinancialAccountType	Fin. Account Type
	DebitCreditCode	I_GLAccountLineItemRawData	DebitCreditCode	Single-Character Flag
	PostingDate	I_GLAccountLineItemRawData	PostingDate	Posting Date for GR
	ChartOfAccounts	I_GLAccountLineItemRawData	ChartOfAccounts	Node Class
	GLAccount	I_GLAccountLineItemRawData	GLAccount	General Ledger
	OffsettingChartOfAccounts	I_GLAccountLineItemRawData	OffsettingChartOfAccounts	Offsetting Chart of Accounts
	OffsettingAccount	I_GLAccountLineItemRawData	OffsettingAccount	Offsetting Acct
	OffsettingAccountType	I_GLAccountLineItemRawData	OffsettingAccountType	Offset Acct Type
	ClearingJournalEntry	I_GLAccountLineItemRawData	ClearingJournalEntry	Clrng doc.
	ClearingJournalEntryFiscalYear	I_GLAccountLineItemRawData	ClearingJournalEntryFiscalYear	Fiscal Year of Clearing Journal Entry
	ClearingItem	_AccountingDocumentItem	ClearingItem	Clearing Item
	IsReversal	I_GLAccountLineItemRawData	IsReversal	Reversal doc.
	IsReversed	I_GLAccountLineItemRawData	IsReversed	Reversed?
	Fund	I_GLAccountLineItemRawData	Fund	Sender Fund
	FinancialManagementArea	I_GLAccountLineItemRawData	FinancialManagementArea	FM Area
	BudgetPeriod	I_GLAccountLineItemRawData	BudgetPeriod	Budget Period
	FundsCenter	I_GLAccountLineItemRawData	FundsCenter	Funds Center
	FunctionalArea	I_GLAccountLineItemRawData	FunctionalArea	Sendr Fctl Area
	FundedProgram	I_GLAccountLineItemRawData	FundedProgram	Funded Program
	Customer	I_GLAccountLineItemRawData	Customer	Sold-to Party
	PartnerCompany	I_GLAccountLineItemRawData	PartnerCompany	Trading Partner
	AmountInCompanyCodeCurrency	I_GLAccountLineItemRawData	AmountInCompanyCodeCurrency	Local Crcy Amt
	CompanyCodeCurrency	I_GLAccountLineItemRawData	CompanyCodeCurrency	Local Currency
	_CompanyCode	I_GLAccountLineItemRawData	_CompanyCode
	_FiscalYear	I_GLAccountLineItemRawData	_FiscalYear
	_Ledger	I_GLAccountLineItemRawData	_Ledger
	_JournalEntry	I_GLAccountLineItemRawData	_JournalEntry
	_AccountingDocumentType	I_GLAccountLineItemRawData	_AccountingDocumentType
	_DebitCreditCode	I_GLAccountLineItemRawData	_DebitCreditCode
	_ChartOfAccounts	I_GLAccountLineItemRawData	_ChartOfAccounts
	_GLAccountInChartOfAccounts	I_GLAccountLineItemRawData	_GLAccountInChartOfAccounts
	_OffsettingChartOfAccounts	I_GLAccountLineItemRawData	_OffsettingChartOfAccounts
	_OffsettingAccount	I_GLAccountLineItemRawData	_OffsettingAccount
	_OffsettingAccountType	I_GLAccountLineItemRawData	_OffsettingAccountType
	_ClearingJournalEntry	I_GLAccountLineItemRawData	_ClearingJournalEntry
	_Fund	I_GLAccountLineItemRawData	_Fund
	_FinancialManagementArea	I_GLAccountLineItemRawData	_FinancialManagementArea
	_BudgetPeriod	I_GLAccountLineItemRawData	_BudgetPeriod
	_FundsCenter	I_GLAccountLineItemRawData	_FundsCenter
	_FunctionalArea	I_GLAccountLineItemRawData	_FunctionalArea
	_FundedProgram	I_GLAccountLineItemRawData	_FundedProgram
	_Customer	I_GLAccountLineItemRawData	_Customer
	_PartnerCompany	I_GLAccountLineItemRawData	_PartnerCompany
	_InvoiceItemReference		_InvoiceItemReference
	_AccountingDocumentItem		_AccountingDocumentItem

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_USFedRblStatusBasic.
-- 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_USFedRblStatusBasic AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  I_GLAccountLineItemRawData.InvoiceReference AS InvoiceReference,
  I_GLAccountLineItemRawData.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  I_GLAccountLineItemRawData.InvoiceItemReference AS InvoiceItemReference,
  I_GLAccountLineItemRawData.AccountingDocumentItem AS AccountingDocumentItem,
  I_GLAccountLineItemRawData.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItemRawData.DocumentDate AS DocumentDate,
  I_GLAccountLineItemRawData.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItemRawData.DebitCreditCode AS DebitCreditCode,
  I_GLAccountLineItemRawData.PostingDate AS PostingDate,
  I_GLAccountLineItemRawData.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItemRawData.GLAccount AS GLAccount,
  I_GLAccountLineItemRawData.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  I_GLAccountLineItemRawData.OffsettingAccount AS OffsettingAccount,
  I_GLAccountLineItemRawData.OffsettingAccountType AS OffsettingAccountType,
  I_GLAccountLineItemRawData.ClearingJournalEntry AS ClearingJournalEntry,
  I_GLAccountLineItemRawData.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  _AccountingDocumentItem.ClearingItem AS ClearingItem,
  I_GLAccountLineItemRawData.IsReversal AS IsReversal,
  I_GLAccountLineItemRawData.IsReversed AS IsReversed,
  I_GLAccountLineItemRawData.Fund AS Fund,
  I_GLAccountLineItemRawData.FinancialManagementArea AS FinancialManagementArea,
  I_GLAccountLineItemRawData.BudgetPeriod AS BudgetPeriod,
  I_GLAccountLineItemRawData.FundsCenter AS FundsCenter,
  I_GLAccountLineItemRawData.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItemRawData.FundedProgram AS FundedProgram,
  I_GLAccountLineItemRawData.Customer AS Customer,
  I_GLAccountLineItemRawData.PartnerCompany AS PartnerCompany,
  I_GLAccountLineItemRawData.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountLineItemRawData.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItemRawData._CompanyCode AS _CompanyCode,
  I_GLAccountLineItemRawData._FiscalYear AS _FiscalYear,
  I_GLAccountLineItemRawData._Ledger AS _Ledger,
  I_GLAccountLineItemRawData._JournalEntry AS _JournalEntry,
  I_GLAccountLineItemRawData._AccountingDocumentType AS _AccountingDocumentType,
  I_GLAccountLineItemRawData._DebitCreditCode AS _DebitCreditCode,
  I_GLAccountLineItemRawData._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountLineItemRawData._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_GLAccountLineItemRawData._OffsettingChartOfAccounts AS _OffsettingChartOfAccounts,
  I_GLAccountLineItemRawData._OffsettingAccount AS _OffsettingAccount,
  I_GLAccountLineItemRawData._OffsettingAccountType AS _OffsettingAccountType,
  I_GLAccountLineItemRawData._ClearingJournalEntry AS _ClearingJournalEntry,
  I_GLAccountLineItemRawData._Fund AS _Fund,
  I_GLAccountLineItemRawData._FinancialManagementArea AS _FinancialManagementArea,
  I_GLAccountLineItemRawData._BudgetPeriod AS _BudgetPeriod,
  I_GLAccountLineItemRawData._FundsCenter AS _FundsCenter,
  I_GLAccountLineItemRawData._FunctionalArea AS _FunctionalArea,
  I_GLAccountLineItemRawData._FundedProgram AS _FundedProgram,
  I_GLAccountLineItemRawData._Customer AS _Customer,
  I_GLAccountLineItemRawData._PartnerCompany AS _PartnerCompany
FROM I_GLAccountLineItemRawData
LEFT OUTER JOIN I_USFedOplAcctgDocItem AS _InvoiceItemReference ON CompanyCode = _InvoiceItemReference.CompanyCode AND InvoiceReferenceFiscalYear = _InvoiceItemReference.FiscalYear AND InvoiceReference = _InvoiceItemReference.AccountingDocument AND InvoiceItemReference = _InvoiceItemReference.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_USFedOplAcctgDocItem AS _AccountingDocumentItem ON CompanyCode = _AccountingDocumentItem.CompanyCode AND FiscalYear = _AccountingDocumentItem.FiscalYear AND AccountingDocument = _AccountingDocumentItem.AccountingDocument AND AccountingDocumentItem = _AccountingDocumentItem.AccountingDocumentItem  -- association [0..1]
;

Depth:

P_USFedRblStatusBasic view_entity

I_GLAccountLineItemRawData view_entity