Which tables does C_SetlDocJrnlEntrItmPubSec use?

C_SetlDocJrnlEntrItmPubSec reads from 1 data source(s): I_JournalEntryItem.

C_SetlDocJrnlEntrItmPubSec

Q: How many fields does C_SetlDocJrnlEntrItmPubSec have?

C_SetlDocJrnlEntrItmPubSec has 70 fields. Key fields: SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

DDL: C_SETLDOCJRNLENTRITMPUBSEC SQL: CDCJRNLENTRPS Type: view CONSUMPTION

Journal entry item with public sector fields

C_SetlDocJrnlEntrItmPubSec is a Consumption CDS View that provides data about "Journal entry item with public sector fields" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 70 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It is exposed through 1 OData service (FCO_SETTLEMENT_DOCUMENT).

Data Sources (1)

Source	Alias	Join Type
I_JournalEntryItem	I_JournalEntryItem	from

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	CDCJRNLENTRPS	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Journal entry item with public sector fields	view

OData Services (1)

Service	Binding	Version	Contract	Release
FCO_SETTLEMENT_DOCUMENT	UI_FCO_SETL_DOCUMENT_SRV	V2	C1	NOT_RELEASED

Fields (70)

Key	Field	Source Table	Source Field
KEY	SourceLedger		SourceLedger
KEY	CompanyCode		CompanyCode
KEY	FiscalYear		FiscalYear
KEY	AccountingDocument		AccountingDocument
KEY	LedgerGLLineItem		LedgerGLLineItem
KEY	Ledger		Ledger
KEY	ReferenceDocument		ReferenceDocument
KEY	ReferenceDocumentType		ReferenceDocumentType
	IsLeadingLedger	_Ledger	IsLeadingLedger
	LedgerFiscalYear		LedgerFiscalYear
	FiscalPeriod		FiscalPeriod
	CompanyCodeName	_CompanyCode	CompanyCodeName
	CostCenter		CostCenter
	ProfitCenter		ProfitCenter
	Segment		Segment
	PartnerFunctionalArea		PartnerFunctionalArea
	PartnerFund		PartnerFund
	PartnerBudgetPeriod		PartnerBudgetPeriod
	PartnerGrant		PartnerGrant
	FunctionalArea		FunctionalArea
	Fund		Fund
	BudgetPeriod		BudgetPeriod
	GrantID		GrantID
	BusinessTransactionType		BusinessTransactionType
	DebitCreditCode		DebitCreditCode
	FinancialTransactionType		FinancialTransactionType
	GLAccount		GLAccount
	GLRecordType		GLRecordType
	WBSElement
	BalanceTransactionCurrency		BalanceTransactionCurrency
	TransactionCurrency		TransactionCurrency
	CompanyCodeCurrency		CompanyCodeCurrency
	GlobalCurrency		GlobalCurrency
	FreeDefinedCurrency1		FreeDefinedCurrency1
	FreeDefinedCurrency2		FreeDefinedCurrency2
	FreeDefinedCurrency3		FreeDefinedCurrency3
	FreeDefinedCurrency4		FreeDefinedCurrency4
	FreeDefinedCurrency5		FreeDefinedCurrency5
	FreeDefinedCurrency6		FreeDefinedCurrency6
	FreeDefinedCurrency7		FreeDefinedCurrency7
	FreeDefinedCurrency8		FreeDefinedCurrency8
	ControllingObjectCurrency		ControllingObjectCurrency
	AmountInBalanceTransacCrcy		AmountInBalanceTransacCrcy
	AmountInTransactionCurrency		AmountInTransactionCurrency
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency
	AmountInGlobalCurrency		AmountInGlobalCurrency
	AmountInFreeDefinedCurrency1		AmountInFreeDefinedCurrency1
	AmountInFreeDefinedCurrency2		AmountInFreeDefinedCurrency2
	AmountInFreeDefinedCurrency3		AmountInFreeDefinedCurrency3
	AmountInFreeDefinedCurrency4		AmountInFreeDefinedCurrency4
	AmountInFreeDefinedCurrency5		AmountInFreeDefinedCurrency5
	AmountInFreeDefinedCurrency6		AmountInFreeDefinedCurrency6
	AmountInFreeDefinedCurrency7		AmountInFreeDefinedCurrency7
	AmountInFreeDefinedCurrency8		AmountInFreeDefinedCurrency8
	AmountInFunctionalCurrency		AmountInFunctionalCurrency
	FunctionalCurrency		FunctionalCurrency
	AssetDepreciationArea		AssetDepreciationArea
	MasterFixedAsset		MasterFixedAsset
	FixedAsset		FixedAsset
	AssetValueDate		AssetValueDate
	AssetTransactionType
	AssetAcctTransClassfctn		AssetAcctTransClassfctn
	AssetClass		AssetClass
	SubLedgerAcctLineItemType		SubLedgerAcctLineItemType
	FinancialAccountType		FinancialAccountType
	PartnerMasterFixedAsset		PartnerMasterFixedAsset
	PartnerFixedAsset		PartnerFixedAsset
	ControllingArea		ControllingArea
	FinancialManagementArea		FinancialManagementArea
	ChartOfAccounts		ChartOfAccounts

@AbapCatalog.sqlViewName: 'CDCJRNLENTRPS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Journal entry item with public sector fields'
define view C_SetlDocJrnlEntrItmPubSec
  as select from I_JournalEntryItem
{
  key SourceLedger,
      @UI.lineItem                 : [{ position: 20 }]
      @Consumption.semanticObject  : 'CompanyCode'
      @ObjectModel                 : { text: { element: ['CompanyCodeName'] } }
      @UI.textArrangement          : #TEXT_LAST
  key CompanyCode,
      @UI.lineItem                 : [{ position: 30 }]
      @Semantics.fiscal.year       : true
  key FiscalYear,
      @UI.lineItem                 : [{ position: 40 }]
      @Consumption.semanticObject  : 'AccountingDocument'
  key AccountingDocument,
  key LedgerGLLineItem,
      @UI.lineItem                 : [{ position: 10 }]
  key Ledger,
  key ReferenceDocument,
  key ReferenceDocumentType,
      _Ledger.IsLeadingLedger                                  as IsLeadingLedger,
      LedgerFiscalYear,
      FiscalPeriod,

      _CompanyCode.CompanyCodeName,
      @UI.lineItem                 : [{ position: 60 }]
      CostCenter,
      ProfitCenter,
      Segment,
      @UI.lineItem                 : [{ position: 121 }]
      PartnerFunctionalArea,
      @UI.lineItem                 : [{ position: 122 }]
      PartnerFund,
      @UI.lineItem                 : [{ position: 123 }]
      PartnerBudgetPeriod,
      @UI.lineItem                 : [{ position: 124 }]
      PartnerGrant,
      @UI.lineItem                 : [{ position: 125 }]
      FunctionalArea,
      @UI.lineItem                 : [{ position: 126 }]
      Fund,
      @UI.lineItem                 : [{ position: 127 }]
      BudgetPeriod,
      @UI.lineItem                 : [{ position: 128 }]
      GrantID,
      BusinessTransactionType,
      DebitCreditCode,
      FinancialTransactionType,
      @UI.lineItem                 : [{ position: 50 }]
      @Consumption.semanticObject  : 'GLAccount'
      GLAccount,
      GLRecordType,
      cast(WBSElement as ps_posid_edit)                        as WBSElement,
      @Semantics.currencyCode      : true
      BalanceTransactionCurrency,
      @Semantics.currencyCode      : true
      TransactionCurrency,
      @Semantics.currencyCode      : true
      CompanyCodeCurrency,
      @Semantics.currencyCode      : true
      GlobalCurrency,
      @Semantics.currencyCode      : true
      FreeDefinedCurrency1,
      @Semantics.currencyCode      : true
      FreeDefinedCurrency2,
      @Semantics.currencyCode      : true
      FreeDefinedCurrency3,
      @Semantics.currencyCode      : true
      FreeDefinedCurrency4,
      @Semantics.currencyCode      : true
      FreeDefinedCurrency5,
      @Semantics.currencyCode      : true
      FreeDefinedCurrency6,
      @Semantics.currencyCode      : true
      FreeDefinedCurrency7,
      @Semantics.currencyCode      : true
      FreeDefinedCurrency8,
      @Semantics.currencyCode      : true
      ControllingObjectCurrency,
      @Semantics.amount.currencyCode: 'BalanceTransactionCurrency'
      AmountInBalanceTransacCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @UI.lineItem                 : [{ position: 100 }]
      AmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      @UI.lineItem                 : [{ position: 110 }]
      AmountInCompanyCodeCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      @UI.lineItem                 : [{ position: 120 }]
      AmountInGlobalCurrency,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
      AmountInFreeDefinedCurrency1,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
      AmountInFreeDefinedCurrency2,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
      AmountInFreeDefinedCurrency3,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
      AmountInFreeDefinedCurrency4,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
      AmountInFreeDefinedCurrency5,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
      AmountInFreeDefinedCurrency6,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
      AmountInFreeDefinedCurrency7,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
      AmountInFreeDefinedCurrency8,

      @UI.lineItem                 : [{ position: 130 }]
      @Semantics.amount.currencyCode: 'FunctionalCurrency'
      AmountInFunctionalCurrency,
      @Semantics.currencyCode      : true
      FunctionalCurrency,

      // Asset Accounting fields

      AssetDepreciationArea,
      MasterFixedAsset,
      FixedAsset,
      AssetValueDate,
      cast(AssetTransactionType as fco_asset_transaction_type) as AssetTransactionType,
      AssetAcctTransClassfctn,
      AssetClass,
      SubLedgerAcctLineItemType,
      FinancialAccountType,
      PartnerMasterFixedAsset,
      PartnerFixedAsset,
      @UI.hidden: true
      ControllingArea,
      @UI.hidden: true
      FinancialManagementArea,
      @UI.hidden: true
      ChartOfAccounts
}

where
  SourceLedger = Ledger

Depth:

C_SetlDocJrnlEntrItmPubSec view

I_JournalEntryItem view