What is P_AccrEngnAccrPostgOffstgItem in SAP S/4HANA?

P_AccrEngnAccrPostgOffstgItem is a basic CDS view in SAP S/4HANA. Accrual Offsetting Posting Item It contains 92 fields.

Which tables does P_AccrEngnAccrPostgOffstgItem read from?

P_AccrEngnAccrPostgOffstgItem reads data from: acesobj_item, tacecomp, I_AccrEngnJournalEntryItem.

What VDM layer is P_AccrEngnAccrPostgOffstgItem?

P_AccrEngnAccrPostgOffstgItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

P_AccrEngnAccrPostgOffstgItem

DDL: P_ACCRENGNACCRPOSTGOFFSTGITEM Type: view_entity BASIC Package: FI_GL_ACCRUALS_REPORTING

92 Fields 3 Data Sources 2 Associations

Accrual Offsetting Posting Item

P_AccrEngnAccrPostgOffstgItem is a Basic CDS View that provides data about "Accrual Offsetting Posting Item" in SAP S/4HANA. It reads from 3 data sources (acesobj_item, tacecomp, I_AccrEngnJournalEntryItem) and exposes 92 fields with key fields SourceLedger, CompanyCode, FiscalYear, JournalEntry, LedgerGLLineItem. It has 2 associations to related views. Part of development package FI_GL_ACCRUALS_REPORTING.

Data Sources (3)

Source	Alias	Join Type
acesobj_item	_AccrSubobjectItem	inner
tacecomp	_Comp	inner
I_AccrEngnJournalEntryItem	I_AccrEngnJournalEntryItem	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_WBSElementBasicData	_WBSElementBasicData	`$projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID`
[0..1]	I_ProjectBasicData	_ProjectBasicData	`$projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.private	true	view
VDM.viewType	#BASIC	view

Fields (92)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger	I_AccrEngnJournalEntryItem	SourceLedger	Source Ledger
KEY	CompanyCode	I_AccrEngnJournalEntryItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_AccrEngnJournalEntryItem	FiscalYear	G/L Fiscal Year
KEY	JournalEntry	I_AccrEngnJournalEntryItem	JournalEntry	Journal Entry
KEY	LedgerGLLineItem	I_AccrEngnJournalEntryItem	LedgerGLLineItem	Journal Entry Item
KEY	Ledger	I_AccrEngnJournalEntryItem	Ledger	Ledger
	AccrualTransactionType
	GLAccountLineItemIsAccrual	I_AccrEngnJournalEntryItem	GLAccountLineItemIsAccrual
	AccrualObjectLogicalSystem	I_AccrEngnJournalEntryItem	AccrualObjectLogicalSystem	Logical System
	AccrualEngineAccrualObjectType
	AccrualObject	I_AccrEngnJournalEntryItem	AccrualObject	External Reference of Accrual Object
	AccrualSubobject	I_AccrEngnJournalEntryItem	AccrualSubobject	External Reference of Accrual Subobject
	AccrualItemType	I_AccrEngnJournalEntryItem	AccrualItemType	Accrual Item Type
	AccrualReferenceObject	I_AccrEngnJournalEntryItem	AccrualReferenceObject	Acr. Reference ID
	AccrualValueDate	I_AccrEngnJournalEntryItem	AccrualValueDate
	TransactionCurrency	I_AccrEngnJournalEntryItem	TransactionCurrency	Transaction Currency
	CompanyCodeCurrency	I_AccrEngnJournalEntryItem	CompanyCodeCurrency	Local Currency
	GlobalCurrency	I_AccrEngnJournalEntryItem	GlobalCurrency	GM Billing Element: Global Currency
	PostdAccrAmtInTransCurrency
	PostdAccrAmtInCoCodeCrcy
	PostdAccrAmtInGlobalCurrency
	FiscalYearVariant	I_AccrEngnJournalEntryItem	FiscalYearVariant	FY Variant
	FiscalPeriod	I_AccrEngnJournalEntryItem	FiscalPeriod	Tax period
	FiscalYearPeriod	I_AccrEngnJournalEntryItem	FiscalYearPeriod	Period/Year
	LedgerFiscalYear	I_AccrEngnJournalEntryItem	LedgerFiscalYear
	PostingDate	I_AccrEngnJournalEntryItem	PostingDate	Posting Date for GR
	DocumentDate	I_AccrEngnJournalEntryItem	DocumentDate	Journal Entry Date
	ClearingDate	I_AccrEngnJournalEntryItem	ClearingDate	Clearing Date
	CreationDate	I_AccrEngnJournalEntryItem	CreationDate	Time Stamp
	CreationDateTime	I_AccrEngnJournalEntryItem	CreationDateTime	Timestamp
	LastChangeDateTime	I_AccrEngnJournalEntryItem	LastChangeDateTime	Timestamp
	AccountingDocCreatedByUser	I_AccrEngnJournalEntryItem	AccountingDocCreatedByUser	User which created overhead document
	ReferenceDocumentContext	I_AccrEngnJournalEntryItem	ReferenceDocumentContext	Reference Document Context
	FinancialTransactionType	I_AccrEngnJournalEntryItem	FinancialTransactionType	Transact. Type
	AccountingDocumentType	I_AccrEngnJournalEntryItem	AccountingDocumentType	Journal Entry Type
	BusinessTransactionType	I_AccrEngnJournalEntryItem	BusinessTransactionType	Bus.transaction
	SenderCompanyCode	I_AccrEngnJournalEntryItem	SenderCompanyCode	Sender Company Code
	AccountingDocumentCategory	I_AccrEngnJournalEntryItem	AccountingDocumentCategory	Journal Entry Category
	ReferenceDocumentType	I_AccrEngnJournalEntryItem	ReferenceDocumentType	Reference Document Type
	ReferenceDocument	I_AccrEngnJournalEntryItem	ReferenceDocument	Reference Document
	IsReversal	I_AccrEngnJournalEntryItem	IsReversal	Reversal doc.
	IsReversed	I_AccrEngnJournalEntryItem	IsReversed	Reversed?
	ReversalReferenceDocument	I_AccrEngnJournalEntryItem	ReversalReferenceDocument	Reversal Reference Document
	GLAccount	I_AccrEngnJournalEntryItem	GLAccount	General Ledger
	ChartOfAccounts	I_AccrEngnJournalEntryItem	ChartOfAccounts	Node Class
	CostCenter	I_AccrEngnJournalEntryItem	CostCenter	Cost Center
	ProfitCenter	I_AccrEngnJournalEntryItem	ProfitCenter	Profit Center
	PostingKey	I_AccrEngnJournalEntryItem	PostingKey	Posting Key
	SubLedgerAcctLineItemType	I_AccrEngnJournalEntryItem	SubLedgerAcctLineItemType	SLALineItemType
	ReferenceDocumentItemGroup	I_AccrEngnJournalEntryItem	ReferenceDocumentItemGroup	Reference Document Item Group
	OffsettingAccount	I_AccrEngnJournalEntryItem	OffsettingAccount	Offsetting Acct
	OffsettingChartOfAccounts	I_AccrEngnJournalEntryItem	OffsettingChartOfAccounts	Offsetting Chart of Accounts
	FunctionalArea	I_AccrEngnJournalEntryItem	FunctionalArea	Sendr Fctl Area
	AlternativeGLAccount	I_AccrEngnJournalEntryItem	AlternativeGLAccount	Group Account
	CountryChartOfAccounts	I_AccrEngnJournalEntryItem	CountryChartOfAccounts	Chart of Accts
	PurchasingDocument	I_AccrEngnJournalEntryItem	PurchasingDocument	Purchasing Document
	PurchasingDocumentItem	I_AccrEngnJournalEntryItem	PurchasingDocumentItem	Purchasing Doc. Item
	Product	I_AccrEngnJournalEntryItem	Product	Product Sold
	Plant	I_AccrEngnJournalEntryItem	Plant	Valuation Area
	TaxCode	I_AccrEngnJournalEntryItem	TaxCode	Tax Code
	IsOpenItemManaged	I_AccrEngnJournalEntryItem	IsOpenItemManaged	Open Item Management
	ClearingAccountingDocument	I_AccrEngnJournalEntryItem	ClearingAccountingDocument	Clearing Journal Entry
	ClearingDocFiscalYear	I_AccrEngnJournalEntryItem	ClearingDocFiscalYear	Fiscal Year of Clearing Journal Entry
	AccountAssignmentNumber	I_AccrEngnJournalEntryItem	AccountAssignmentNumber	Account Assgmt No.
	DocumentItemText	I_AccrEngnJournalEntryItem	DocumentItemText	Text
	AccountAssignment	I_AccrEngnJournalEntryItem	AccountAssignment	Sender Acct Assgmt
	AccountAssignmentType	I_AccrEngnJournalEntryItem	AccountAssignmentType	Sndr AcctAssgmt Type
	SalesOrder	I_AccrEngnJournalEntryItem	SalesOrder	SD Document
	SalesOrderItem	I_AccrEngnJournalEntryItem	SalesOrderItem	Sales Order Item
	SalesDocument	I_AccrEngnJournalEntryItem	SalesDocument	SD Document
	SalesDocumentItem	I_AccrEngnJournalEntryItem	SalesDocumentItem	Sales Document Item
	CostOriginGroup	I_AccrEngnJournalEntryItem	CostOriginGroup	Origin Group
	OrderID	I_AccrEngnJournalEntryItem	OrderID	Order ID
	OrderCategory	I_AccrEngnJournalEntryItem	OrderCategory	Order Category
	WBSElementInternalID	I_AccrEngnJournalEntryItem	WBSElementInternalID	WBS Internal ID
	WBSElementExternalID	_WBSElementBasicData	WBSElementExternalID	WBS Element External ID
	ProjectInternalID	I_AccrEngnJournalEntryItem	ProjectInternalID	Project Def.
	ProjectExternalID	_ProjectBasicData	ProjectExternalID	Project def.
	WorkPackage	I_AccrEngnJournalEntryItem	WorkPackage	Plan Item
	ProjectNetwork	I_AccrEngnJournalEntryItem	ProjectNetwork	Order
	ServiceDocument	I_AccrEngnJournalEntryItem	ServiceDocument	Transaction ID
	ServiceDocumentType	I_AccrEngnJournalEntryItem	ServiceDocumentType	Transaction Type
	BusinessProcess	I_AccrEngnJournalEntryItem	BusinessProcess	Business Process
	CostObject	I_AccrEngnJournalEntryItem	CostObject	Cost Object
	ControllingArea	I_AccrEngnJournalEntryItem	ControllingArea	Controlling Area
	FinancialAccountType	I_AccrEngnJournalEntryItem	FinancialAccountType	Fin. Account Type
	BusinessArea	I_AccrEngnJournalEntryItem	BusinessArea	Business Area
	Segment	I_AccrEngnJournalEntryItem	Segment	Segment number
	Supplier	I_AccrEngnJournalEntryItem	Supplier	Supplier
	Customer	I_AccrEngnJournalEntryItem	Customer	Sold-to Party
	GLAccountType	I_AccrEngnJournalEntryItem	GLAccountType	G/L Account Type
	AssignmentReference	I_AccrEngnJournalEntryItem	AssignmentReference	Assignment Reference

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_AccrEngnAccrPostgOffstgItem.
-- 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_AccrEngnAccrPostgOffstgItem AS
SELECT
  I_AccrEngnJournalEntryItem.SourceLedger AS SourceLedger,
  I_AccrEngnJournalEntryItem.CompanyCode AS CompanyCode,
  I_AccrEngnJournalEntryItem.FiscalYear AS FiscalYear,
  I_AccrEngnJournalEntryItem.JournalEntry AS JournalEntry,
  I_AccrEngnJournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  I_AccrEngnJournalEntryItem.Ledger AS Ledger,
  cast( I_AccrEngnJournalEntryItem.FinancialAccrualTransacType as ace_ttype preserving type ) AS AccrualTransactionType,
  I_AccrEngnJournalEntryItem.GLAccountLineItemIsAccrual AS GLAccountLineItemIsAccrual,
  I_AccrEngnJournalEntryItem.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  cast( I_AccrEngnJournalEntryItem.AccrualObjectType as ace_comp preserving type ) AS AccrualEngineAccrualObjectType,
  I_AccrEngnJournalEntryItem.AccrualObject AS AccrualObject,
  I_AccrEngnJournalEntryItem.AccrualSubobject AS AccrualSubobject,
  I_AccrEngnJournalEntryItem.AccrualItemType AS AccrualItemType,
  I_AccrEngnJournalEntryItem.AccrualReferenceObject AS AccrualReferenceObject,
  I_AccrEngnJournalEntryItem.AccrualValueDate AS AccrualValueDate,
  I_AccrEngnJournalEntryItem.TransactionCurrency AS TransactionCurrency,
  I_AccrEngnJournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_AccrEngnJournalEntryItem.GlobalCurrency AS GlobalCurrency,
  cast( I_AccrEngnJournalEntryItem.AmountInTransactionCurrency as ace_posted_accr_amnt_wcurr preserving type) AS PostdAccrAmtInTransCurrency,
  cast( I_AccrEngnJournalEntryItem.AmountInCompanyCodeCurrency as ace_posted_accr_amnt_hcurr preserving type ) AS PostdAccrAmtInCoCodeCrcy,
  cast( I_AccrEngnJournalEntryItem.AmountInGlobalCurrency as ace_posted_accr_amnt_kcurr preserving type ) AS PostdAccrAmtInGlobalCurrency,
  I_AccrEngnJournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
  I_AccrEngnJournalEntryItem.FiscalPeriod AS FiscalPeriod,
  I_AccrEngnJournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  I_AccrEngnJournalEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
  I_AccrEngnJournalEntryItem.PostingDate AS PostingDate,
  I_AccrEngnJournalEntryItem.DocumentDate AS DocumentDate,
  I_AccrEngnJournalEntryItem.ClearingDate AS ClearingDate,
  I_AccrEngnJournalEntryItem.CreationDate AS CreationDate,
  I_AccrEngnJournalEntryItem.CreationDateTime AS CreationDateTime,
  I_AccrEngnJournalEntryItem.LastChangeDateTime AS LastChangeDateTime,
  I_AccrEngnJournalEntryItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_AccrEngnJournalEntryItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_AccrEngnJournalEntryItem.FinancialTransactionType AS FinancialTransactionType,
  I_AccrEngnJournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  I_AccrEngnJournalEntryItem.BusinessTransactionType AS BusinessTransactionType,
  I_AccrEngnJournalEntryItem.SenderCompanyCode AS SenderCompanyCode,
  I_AccrEngnJournalEntryItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_AccrEngnJournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  I_AccrEngnJournalEntryItem.ReferenceDocument AS ReferenceDocument,
  I_AccrEngnJournalEntryItem.IsReversal AS IsReversal,
  I_AccrEngnJournalEntryItem.IsReversed AS IsReversed,
  I_AccrEngnJournalEntryItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  I_AccrEngnJournalEntryItem.GLAccount AS GLAccount,
  I_AccrEngnJournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  I_AccrEngnJournalEntryItem.CostCenter AS CostCenter,
  I_AccrEngnJournalEntryItem.ProfitCenter AS ProfitCenter,
  I_AccrEngnJournalEntryItem.PostingKey AS PostingKey,
  I_AccrEngnJournalEntryItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  I_AccrEngnJournalEntryItem.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  I_AccrEngnJournalEntryItem.OffsettingAccount AS OffsettingAccount,
  I_AccrEngnJournalEntryItem.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  I_AccrEngnJournalEntryItem.FunctionalArea AS FunctionalArea,
  I_AccrEngnJournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
  I_AccrEngnJournalEntryItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  I_AccrEngnJournalEntryItem.PurchasingDocument AS PurchasingDocument,
  I_AccrEngnJournalEntryItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_AccrEngnJournalEntryItem.Product AS Product,
  I_AccrEngnJournalEntryItem.Plant AS Plant,
  I_AccrEngnJournalEntryItem.TaxCode AS TaxCode,
  I_AccrEngnJournalEntryItem.IsOpenItemManaged AS IsOpenItemManaged,
  I_AccrEngnJournalEntryItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  I_AccrEngnJournalEntryItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  I_AccrEngnJournalEntryItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_AccrEngnJournalEntryItem.DocumentItemText AS DocumentItemText,
  I_AccrEngnJournalEntryItem.AccountAssignment AS AccountAssignment,
  I_AccrEngnJournalEntryItem.AccountAssignmentType AS AccountAssignmentType,
  I_AccrEngnJournalEntryItem.SalesOrder AS SalesOrder,
  I_AccrEngnJournalEntryItem.SalesOrderItem AS SalesOrderItem,
  I_AccrEngnJournalEntryItem.SalesDocument AS SalesDocument,
  I_AccrEngnJournalEntryItem.SalesDocumentItem AS SalesDocumentItem,
  I_AccrEngnJournalEntryItem.CostOriginGroup AS CostOriginGroup,
  I_AccrEngnJournalEntryItem.OrderID AS OrderID,
  I_AccrEngnJournalEntryItem.OrderCategory AS OrderCategory,
  I_AccrEngnJournalEntryItem.WBSElementInternalID AS WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  I_AccrEngnJournalEntryItem.ProjectInternalID AS ProjectInternalID,
  _ProjectBasicData.ProjectExternalID AS ProjectExternalID,
  I_AccrEngnJournalEntryItem.WorkPackage AS WorkPackage,
  I_AccrEngnJournalEntryItem.ProjectNetwork AS ProjectNetwork,
  I_AccrEngnJournalEntryItem.ServiceDocument AS ServiceDocument,
  I_AccrEngnJournalEntryItem.ServiceDocumentType AS ServiceDocumentType,
  I_AccrEngnJournalEntryItem.BusinessProcess AS BusinessProcess,
  I_AccrEngnJournalEntryItem.CostObject AS CostObject,
  I_AccrEngnJournalEntryItem.ControllingArea AS ControllingArea,
  I_AccrEngnJournalEntryItem.FinancialAccountType AS FinancialAccountType,
  I_AccrEngnJournalEntryItem.BusinessArea AS BusinessArea,
  I_AccrEngnJournalEntryItem.Segment AS Segment,
  I_AccrEngnJournalEntryItem.Supplier AS Supplier,
  I_AccrEngnJournalEntryItem.Customer AS Customer,
  I_AccrEngnJournalEntryItem.GLAccountType AS GLAccountType,
  I_AccrEngnJournalEntryItem.AssignmentReference AS AssignmentReference
FROM I_AccrEngnJournalEntryItem
INNER JOIN tacecomp AS _Comp ON /* join condition not captured in parsed metadata */
INNER JOIN acesobj_item AS _AccrSubobjectItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
;

Depth:

P_AccrEngnAccrPostgOffstgItem view_entity