I_AccrEngnAccrPostingEntryItem

DDL: I_ACCRENGNACCRPOSTINGENTRYITEM Type: view_entity COMPOSITE
269 Fields 4 Data Sources 41 Associations

Accrual Posting Entry Item

I_AccrEngnAccrPostingEntryItem is a Composite CDS View that provides data about "Accrual Posting Entry Item" in SAP S/4HANA. It reads from 4 data sources (I_AccrEngineAccrItemTypeBasic, I_AccrEngineAccrItemTypeBasic, P_AccrEngnAccrPostgAccrItem, P_AccrEngnAccrPostgAccrItem) and exposes 269 fields with key fields SourceLedger, CompanyCode, FiscalYear, JournalEntry, LedgerGLLineItem. It has 41 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_AccrEngineAccrItemTypeBasic _ItemType inner
I_AccrEngineAccrItemTypeBasic _ItemType inner
P_AccrEngnAccrPostgAccrItem P_AccrEngnAccrPostgAccrItem from
P_AccrEngnAccrPostgAccrItem P_AccrEngnAccrPostgAccrItem union_all

Associations (41)

CardinalityTargetAliasCondition
[0..1] P_AccrEngnAccrPostgOffstgItem _OffsettingItem $projection.SourceLedger = _OffsettingItem.SourceLedger and $projection.CompanyCode = _OffsettingItem.CompanyCode and $projection.FiscalYear = _OffsettingItem.FiscalYear and $projection.JournalEntry = _OffsettingItem.JournalEntry and $projection.Ledger = _OffsettingItem.Ledger and $projection.ReferenceDocumentItemGroup = _OffsettingItem.ReferenceDocumentItemGroup and $projection.AccrualReferenceObject = _OffsettingItem.AccrualReferenceObject
[1..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger
[0..1] I_Ledger _SourceLedger $projection.SourceLedger = _SourceLedger.Ledger
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_FiscalYearForCompanyCode _FiscalYear $projection.FiscalYear = _FiscalYear.FiscalYear and $projection.CompanyCode = _FiscalYear.CompanyCode
[1..1] I_AccrEngnAccrTransactionType _AccrTransactionType $projection.AccrualTransactionType = _AccrTransactionType.AccrualTransactionType
[1..1] I_AccrEngineAccrObjectType _AccrObjectType $projection.AccrualEngineAccrualObjectType = _AccrObjectType.AccrualEngineAccrualObjectType
[0..1] I_LogicalSystem _AccrLogicalSystem $projection.AccrualObjectLogicalSystem = _AccrLogicalSystem.LogicalSystem
[0..1] I_AccrEngineAccrItemTypeBasic _AccrItemType $projection.AccrualEngineAccrualObjectType = _AccrItemType.AccrualEngineAccrualObjectType and $projection.AccrualItemType = _AccrItemType.AccrualItemType
[0..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency
[1..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[0..1] I_Currency _GlobalCurrency $projection.GlobalCurrency = _GlobalCurrency.Currency
[1..1] I_FiscalYearVariant _FiscalYearVariant $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
[0..1] I_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant $projection.FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod and $projection.FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant
[0..1] I_FiscalPeriodForVariant _FiscalPeriodForVariant $projection.LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear and $projection.FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod and $projection.FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant
[0..1] I_FiscalYearForVariant _LedgerFiscalYearForVariant $projection.LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear and $projection.FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant
[0..1] I_BusinessTransactionType _BusinessTransactionType $projection.BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType
[0..1] I_SubLedgerAccLineItemType _SubLedgerAccLineItemType $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType
[0..1] I_FunctionalArea _FunctionalArea $projection.FunctionalArea = _FunctionalArea.FunctionalArea
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[0..1] I_BusinessArea _BusinessArea $projection.BusinessArea = _BusinessArea.BusinessArea
[0..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_ChartOfAccounts _OffsettingChartOfAccounts $projection.OffsettingChartOfAccounts = _OffsettingChartOfAccounts.ChartOfAccounts
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[0..1] I_GLAccountInChartOfAccounts _OffstgGLAcctInChartOfAccounts $projection.OffsettingChartOfAccounts = _OffstgGLAcctInChartOfAccounts.ChartOfAccounts and $projection.OffsettingAccount = _OffstgGLAcctInChartOfAccounts.GLAccount
[0..*] I_CostCenter _CostCenter $projection.ControllingArea = _CostCenter.ControllingArea and $projection.costcenter = _CostCenter.CostCenter
[0..1] I_Segment _Segment $projection.segment = _Segment.Segment
[0..*] I_ProfitCenter _ProfitCenter $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.profitcenter = _ProfitCenter.ProfitCenter
[0..1] I_SalesDocument _SalesDocument $projection.salesdocument = _SalesDocument.SalesDocument
[0..1] I_SalesDocumentItem _SalesDocumentItem $projection.salesdocument = _SalesDocumentItem.SalesDocument and $projection.salesdocumentitem = _SalesDocumentItem.SalesDocumentItem
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.wbselementinternalid = _WBSElementBasicData.WBSElementInternalID
[0..1] I_ProjectBasicData _ProjectBasicData $projection.projectinternalid = _ProjectBasicData.ProjectInternalID
[0..1] I_WBSElementByExternalID _WBSElementByExternalID $projection.wbselementexternalid = _WBSElementByExternalID.WBSElementExternalID
[0..1] I_ProjectByExternalID _ProjectByExternalID $projection.projectexternalid = _ProjectByExternalID.ProjectExternalID
[0..1] I_FinancialTransactionType _FinancialTransactionType $projection.FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType
[0..1] I_Order _Order $projection.orderid = _Order.OrderID
[0..1] I_WorkPackage _WorkPackage $projection.workpackage = _WorkPackage.WorkPackage
[0..1] I_SrvcDocByDocumentType _ServiceDocument $projection.servicedocumenttype = _ServiceDocument.ServiceDocumentType and $projection.servicedocument = _ServiceDocument.ServiceDocument
[0..1] I_Customer _Customer $projection.customer = _Customer.Customer
[0..1] I_ServiceDocumentType _ServiceDocumentType $projection.servicedocumenttype = _ServiceDocumentType.ServiceDocumentType

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Accrual Posting Entry Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (269)

KeyFieldSource TableSource FieldDescription
GLAccount
_SourceLedger _SourceLedger
_Ledger _Ledger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_AccrTransactionType _AccrTransactionType
_AccrObjectType _AccrObjectType
_AccrLogicalSystem _AccrLogicalSystem
_AccrItemType _AccrItemType
_TransactionCurrency _TransactionCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_FiscalYearVariant _FiscalYearVariant
_FiscalPeriodForVariant _FiscalPeriodForVariant
_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_BusinessTransactionType _BusinessTransactionType
_SubLedgerAccLineItemType _SubLedgerAccLineItemType
_FunctionalArea _FunctionalArea
_ControllingArea _ControllingArea
_BusinessArea _BusinessArea
_Product _Product
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_OffstgGLAcctInChartOfAccounts _OffstgGLAcctInChartOfAccounts
_OffsettingChartOfAccounts _OffsettingChartOfAccounts
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_Segment _Segment
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_WBSElementBasicData _WBSElementBasicData
_ProjectBasicData _ProjectBasicData
_WBSElementByExternalID _WBSElementByExternalID
_ProjectByExternalID _ProjectByExternalID
_FinancialTransactionType _FinancialTransactionType
_Order _Order
_WorkPackage _WorkPackage
_ServiceDocument _ServiceDocument
_ServiceDocumentType _ServiceDocumentType
SourceLedger Source Ledger
GLAccount
_SourceLedger _SourceLedger
_Ledger _Ledger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_AccrTransactionType _AccrTransactionType
_AccrObjectType _AccrObjectType
_AccrLogicalSystem _AccrLogicalSystem
_AccrItemType _AccrItemType
_TransactionCurrency _TransactionCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_FiscalYearVariant _FiscalYearVariant
_FiscalPeriodForVariant _FiscalPeriodForVariant
_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_BusinessTransactionType _BusinessTransactionType
_SubLedgerAccLineItemType _SubLedgerAccLineItemType
_FunctionalArea _FunctionalArea
_ControllingArea _ControllingArea
_BusinessArea _BusinessArea
_Product _Product
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_OffstgGLAcctInChartOfAccounts _OffstgGLAcctInChartOfAccounts
_OffsettingChartOfAccounts _OffsettingChartOfAccounts
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_Segment _Segment
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_WBSElementBasicData _WBSElementBasicData
_ProjectBasicData _ProjectBasicData
_WBSElementByExternalID _WBSElementByExternalID
_ProjectByExternalID _ProjectByExternalID
_FinancialTransactionType _FinancialTransactionType
_Order _Order
_WorkPackage _WorkPackage
_ServiceDocument _ServiceDocument
_ServiceDocumentType _ServiceDocumentType
_Customer _Customer
KEY SourceLedger P_AccrEngnAccrPostgAccrItem SourceLedger Source Ledger
KEY CompanyCode P_AccrEngnAccrPostgAccrItem CompanyCode Receiver Company Code
KEY FiscalYear P_AccrEngnAccrPostgAccrItem FiscalYear G/L Fiscal Year
KEY JournalEntry P_AccrEngnAccrPostgAccrItem JournalEntry
KEY LedgerGLLineItem P_AccrEngnAccrPostgAccrItem LedgerGLLineItem Journal Entry Item
KEY Ledger P_AccrEngnAccrPostgAccrItem Ledger Ledger
AccrualObjectLogicalSystem P_AccrEngnAccrPostgAccrItem AccrualObjectLogicalSystem Logical System
AccrualEngineAccrualObjectType P_AccrEngnAccrPostgAccrItem AccrualEngineAccrualObjectType Component
AccrualObject P_AccrEngnAccrPostgAccrItem AccrualObject External Reference of Accrual Object
AccrualSubobject P_AccrEngnAccrPostgAccrItem AccrualSubobject External Reference of Accrual Subobject
AccrualItemType P_AccrEngnAccrPostgAccrItem AccrualItemType Accrual Item Type
AccrualReferenceObject P_AccrEngnAccrPostgAccrItem AccrualReferenceObject Acr. Reference ID
AccrualValueDate P_AccrEngnAccrPostgAccrItem AccrualValueDate
AccrualTransactionType P_AccrEngnAccrPostgAccrItem AccrualTransactionType
GLAccountLineItemIsAccrual P_AccrEngnAccrPostgAccrItem GLAccountLineItemIsAccrual
TransactionCurrency P_AccrEngnAccrPostgAccrItem TransactionCurrency Transaction Currency
CompanyCodeCurrency P_AccrEngnAccrPostgAccrItem CompanyCodeCurrency Local Currency
GlobalCurrency P_AccrEngnAccrPostgAccrItem GlobalCurrency GM Billing Element: Global Currency
PostdAccrAmtInTransCurrency P_AccrEngnAccrPostgAccrItem PostdAccrAmtInTransCurrency
PostdAccrAmtInCoCodeCrcy P_AccrEngnAccrPostgAccrItem PostdAccrAmtInCoCodeCrcy
PostdAccrAmtInGlobalCurrency P_AccrEngnAccrPostgAccrItem PostdAccrAmtInGlobalCurrency
FiscalYearVariant P_AccrEngnAccrPostgAccrItem FiscalYearVariant FY Variant
FiscalPeriod P_AccrEngnAccrPostgAccrItem FiscalPeriod Tax period
FiscalYearPeriod P_AccrEngnAccrPostgAccrItem FiscalYearPeriod Period/Year
LedgerFiscalYear P_AccrEngnAccrPostgAccrItem LedgerFiscalYear
PostingDate P_AccrEngnAccrPostgAccrItem PostingDate Posting Date for GR
DocumentDate P_AccrEngnAccrPostgAccrItem DocumentDate Journal Entry Date
ClearingDate P_AccrEngnAccrPostgAccrItem ClearingDate Clearing Date
CreationDate P_AccrEngnAccrPostgAccrItem CreationDate Time Stamp
CreationDateTime P_AccrEngnAccrPostgAccrItem CreationDateTime Timestamp
LastChangeDateTime P_AccrEngnAccrPostgAccrItem LastChangeDateTime Timestamp
AccountingDocCreatedByUser P_AccrEngnAccrPostgAccrItem AccountingDocCreatedByUser User which created overhead document
ReferenceDocumentContext P_AccrEngnAccrPostgAccrItem ReferenceDocumentContext Reference Document Context
FinancialTransactionType P_AccrEngnAccrPostgAccrItem FinancialTransactionType Transact. Type
AccountingDocumentType P_AccrEngnAccrPostgAccrItem AccountingDocumentType Journal Entry Type
BusinessTransactionType P_AccrEngnAccrPostgAccrItem BusinessTransactionType Bus.transaction
SenderCompanyCode P_AccrEngnAccrPostgAccrItem SenderCompanyCode Sender Company Code
AccountingDocumentCategory P_AccrEngnAccrPostgAccrItem AccountingDocumentCategory Journal Entry Category
ReferenceDocumentType P_AccrEngnAccrPostgAccrItem ReferenceDocumentType Reference Document Type
ReferenceDocument P_AccrEngnAccrPostgAccrItem ReferenceDocument Reference Document
IsReversal P_AccrEngnAccrPostgAccrItem IsReversal Reversal doc.
IsReversed P_AccrEngnAccrPostgAccrItem IsReversed Reversed?
ReversalReferenceDocument P_AccrEngnAccrPostgAccrItem ReversalReferenceDocument Reversal Reference Document
SubLedgerAcctLineItemType P_AccrEngnAccrPostgAccrItem SubLedgerAcctLineItemType SLALineItemType
ReferenceDocumentItemGroup P_AccrEngnAccrPostgAccrItem ReferenceDocumentItemGroup Reference Document Item Group
PostingKey P_AccrEngnAccrPostgAccrItem PostingKey Posting Key
FunctionalArea P_AccrEngnAccrPostgAccrItem FunctionalArea Sendr Fctl Area
AlternativeGLAccount P_AccrEngnAccrPostgAccrItem AlternativeGLAccount Group Account
CountryChartOfAccounts P_AccrEngnAccrPostgAccrItem CountryChartOfAccounts Chart of Accts
PurchasingDocument P_AccrEngnAccrPostgAccrItem PurchasingDocument Purchasing Document
PurchasingDocumentItem P_AccrEngnAccrPostgAccrItem PurchasingDocumentItem Purchasing Doc. Item
TaxCode P_AccrEngnAccrPostgAccrItem TaxCode Tax Code
GLAccountType P_AccrEngnAccrPostgAccrItem GLAccountType G/L Account Type
ControllingArea P_AccrEngnAccrPostgAccrItem ControllingArea Controlling Area
FinancialAccountType P_AccrEngnAccrPostgAccrItem FinancialAccountType Fin. Account Type
BusinessProcess P_AccrEngnAccrPostgAccrItem BusinessProcess Business Process
IsOpenItemManaged P_AccrEngnAccrPostgAccrItem IsOpenItemManaged Open Item Management
ClearingAccountingDocument P_AccrEngnAccrPostgAccrItem ClearingAccountingDocument Clearing Journal Entry
ClearingDocFiscalYear P_AccrEngnAccrPostgAccrItem ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
DocumentItemText P_AccrEngnAccrPostgAccrItem DocumentItemText Text
BusinessArea P_AccrEngnAccrPostgAccrItem BusinessArea Business Area
Product P_AccrEngnAccrPostgAccrItem Product Product Sold
Plant P_AccrEngnAccrPostgAccrItem Plant Valuation Area
ChartOfAccounts P_AccrEngnAccrPostgAccrItem ChartOfAccounts Node Class
OffsettingAccount P_AccrEngnAccrPostgAccrItem OffsettingAccount Offsetting Acct
OffsettingChartOfAccounts P_AccrEngnAccrPostgAccrItem OffsettingChartOfAccounts Offsetting Chart of Accounts
PredecessorReferenceDocType P_AccrEngnAccrPostgAccrItem PredecessorReferenceDocType Predecessor Reference Document Type
PredecessorReferenceDocCntxt P_AccrEngnAccrPostgAccrItem PredecessorReferenceDocCntxt Predecessor Reference Document Context
PredecessorReferenceDocument P_AccrEngnAccrPostgAccrItem PredecessorReferenceDocument Predecessor Reference Document
PredecessorReferenceDocItem P_AccrEngnAccrPostgAccrItem PredecessorReferenceDocItem Prec. Ref. Doc. Item
KEY CompanyCode P_AccrEngnAccrPostgAccrItem CompanyCode Receiver Company Code
KEY FiscalYear P_AccrEngnAccrPostgAccrItem FiscalYear G/L Fiscal Year
KEY JournalEntry P_AccrEngnAccrPostgAccrItem JournalEntry
KEY LedgerGLLineItem P_AccrEngnAccrPostgAccrItem LedgerGLLineItem Journal Entry Item
KEY Ledger P_AccrEngnAccrPostgAccrItem Ledger Ledger
AccrualObjectLogicalSystem P_AccrEngnAccrPostgAccrItem AccrualObjectLogicalSystem Logical System
AccrualEngineAccrualObjectType P_AccrEngnAccrPostgAccrItem AccrualEngineAccrualObjectType Component
AccrualObject P_AccrEngnAccrPostgAccrItem AccrualObject External Reference of Accrual Object
AccrualSubobject P_AccrEngnAccrPostgAccrItem AccrualSubobject External Reference of Accrual Subobject
AccrualItemType P_AccrEngnAccrPostgAccrItem AccrualItemType Accrual Item Type
AccrualReferenceObject P_AccrEngnAccrPostgAccrItem AccrualReferenceObject Acr. Reference ID
AccrualValueDate P_AccrEngnAccrPostgAccrItem AccrualValueDate
AccrualTransactionType P_AccrEngnAccrPostgAccrItem AccrualTransactionType
GLAccountLineItemIsAccrual P_AccrEngnAccrPostgAccrItem GLAccountLineItemIsAccrual
TransactionCurrency P_AccrEngnAccrPostgAccrItem TransactionCurrency Transaction Currency
CompanyCodeCurrency P_AccrEngnAccrPostgAccrItem CompanyCodeCurrency Local Currency
GlobalCurrency P_AccrEngnAccrPostgAccrItem GlobalCurrency GM Billing Element: Global Currency
PostdAccrAmtInTransCurrency P_AccrEngnAccrPostgAccrItem PostdAccrAmtInTransCurrency
PostdAccrAmtInCoCodeCrcy P_AccrEngnAccrPostgAccrItem PostdAccrAmtInCoCodeCrcy
PostdAccrAmtInGlobalCurrency P_AccrEngnAccrPostgAccrItem PostdAccrAmtInGlobalCurrency
FiscalYearVariant P_AccrEngnAccrPostgAccrItem FiscalYearVariant FY Variant
FiscalPeriod P_AccrEngnAccrPostgAccrItem FiscalPeriod Tax period
FiscalYearPeriod P_AccrEngnAccrPostgAccrItem FiscalYearPeriod Period/Year
LedgerFiscalYear P_AccrEngnAccrPostgAccrItem LedgerFiscalYear
PostingDate P_AccrEngnAccrPostgAccrItem PostingDate Posting Date for GR
DocumentDate P_AccrEngnAccrPostgAccrItem DocumentDate Journal Entry Date
ClearingDate P_AccrEngnAccrPostgAccrItem ClearingDate Clearing Date
CreationDate P_AccrEngnAccrPostgAccrItem CreationDate Time Stamp
CreationDateTime P_AccrEngnAccrPostgAccrItem CreationDateTime Timestamp
LastChangeDateTime P_AccrEngnAccrPostgAccrItem LastChangeDateTime Timestamp
AccountingDocCreatedByUser P_AccrEngnAccrPostgAccrItem AccountingDocCreatedByUser User which created overhead document
ReferenceDocumentContext P_AccrEngnAccrPostgAccrItem ReferenceDocumentContext Reference Document Context
FinancialTransactionType P_AccrEngnAccrPostgAccrItem FinancialTransactionType Transact. Type
AccountingDocumentType P_AccrEngnAccrPostgAccrItem AccountingDocumentType Journal Entry Type
BusinessTransactionType P_AccrEngnAccrPostgAccrItem BusinessTransactionType Bus.transaction
SenderCompanyCode P_AccrEngnAccrPostgAccrItem SenderCompanyCode Sender Company Code
AccountingDocumentCategory P_AccrEngnAccrPostgAccrItem AccountingDocumentCategory Journal Entry Category
ReferenceDocumentType P_AccrEngnAccrPostgAccrItem ReferenceDocumentType Reference Document Type
ReferenceDocument P_AccrEngnAccrPostgAccrItem ReferenceDocument Reference Document
IsReversal P_AccrEngnAccrPostgAccrItem IsReversal Reversal doc.
IsReversed P_AccrEngnAccrPostgAccrItem IsReversed Reversed?
ReversalReferenceDocument P_AccrEngnAccrPostgAccrItem ReversalReferenceDocument Reversal Reference Document
SubLedgerAcctLineItemType P_AccrEngnAccrPostgAccrItem SubLedgerAcctLineItemType SLALineItemType
ReferenceDocumentItemGroup P_AccrEngnAccrPostgAccrItem ReferenceDocumentItemGroup Reference Document Item Group
PostingKey P_AccrEngnAccrPostgAccrItem PostingKey Posting Key
FunctionalArea P_AccrEngnAccrPostgAccrItem FunctionalArea Sendr Fctl Area
AlternativeGLAccount P_AccrEngnAccrPostgAccrItem AlternativeGLAccount Group Account
CountryChartOfAccounts P_AccrEngnAccrPostgAccrItem CountryChartOfAccounts Chart of Accts
PurchasingDocument P_AccrEngnAccrPostgAccrItem PurchasingDocument Purchasing Document
PurchasingDocumentItem P_AccrEngnAccrPostgAccrItem PurchasingDocumentItem Purchasing Doc. Item
TaxCode P_AccrEngnAccrPostgAccrItem TaxCode Tax Code
GLAccountType P_AccrEngnAccrPostgAccrItem GLAccountType G/L Account Type
ControllingArea P_AccrEngnAccrPostgAccrItem ControllingArea Controlling Area
FinancialAccountType P_AccrEngnAccrPostgAccrItem FinancialAccountType Fin. Account Type
BusinessProcess P_AccrEngnAccrPostgAccrItem BusinessProcess Business Process
IsOpenItemManaged P_AccrEngnAccrPostgAccrItem IsOpenItemManaged Open Item Management
ClearingAccountingDocument P_AccrEngnAccrPostgAccrItem ClearingAccountingDocument Clearing Journal Entry
ClearingDocFiscalYear P_AccrEngnAccrPostgAccrItem ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
DocumentItemText P_AccrEngnAccrPostgAccrItem DocumentItemText Text
BusinessArea P_AccrEngnAccrPostgAccrItem BusinessArea Business Area
Product P_AccrEngnAccrPostgAccrItem Product Product Sold
Plant P_AccrEngnAccrPostgAccrItem Plant Valuation Area
ChartOfAccounts P_AccrEngnAccrPostgAccrItem ChartOfAccounts Node Class
OffsettingAccount P_AccrEngnAccrPostgAccrItem OffsettingAccount Offsetting Acct
OffsettingChartOfAccounts P_AccrEngnAccrPostgAccrItem OffsettingChartOfAccounts Offsetting Chart of Accounts
PredecessorReferenceDocType P_AccrEngnAccrPostgAccrItem PredecessorReferenceDocType Predecessor Reference Document Type
PredecessorReferenceDocCntxt P_AccrEngnAccrPostgAccrItem PredecessorReferenceDocCntxt Predecessor Reference Document Context
PredecessorReferenceDocument P_AccrEngnAccrPostgAccrItem PredecessorReferenceDocument Predecessor Reference Document
PredecessorReferenceDocItem P_AccrEngnAccrPostgAccrItem PredecessorReferenceDocItem Prec. Ref. Doc. Item
CostCenter _OffsettingItem CostCenter Cost Center
ProfitCenter _OffsettingItem ProfitCenter Profit Center
AccountAssignmentNumber _OffsettingItem AccountAssignmentNumber Account Assgmt No.
AccountAssignment _OffsettingItem AccountAssignment Sender Acct Assgmt
AccountAssignmentType _OffsettingItem AccountAssignmentType Sndr AcctAssgmt Type
SalesOrder _OffsettingItem SalesOrder SD Document
SalesOrderItem _OffsettingItem SalesOrderItem Sales Order Item
SalesDocument _OffsettingItem SalesDocument SD Document
SalesDocumentItem _OffsettingItem SalesDocumentItem Sales Document Item
OrderID _OffsettingItem OrderID Order ID
OrderCategory _OffsettingItem OrderCategory Order Category
WBSElementInternalID _OffsettingItem WBSElementInternalID WBS Internal ID
WBSElementExternalID _OffsettingItem WBSElementExternalID WBS Element External ID
ProjectInternalID _OffsettingItem ProjectInternalID Project Def.
ProjectExternalID _OffsettingItem ProjectExternalID Project def.
WorkPackage _OffsettingItem WorkPackage Plan Item
ProjectNetwork _OffsettingItem ProjectNetwork Order
ServiceDocument _OffsettingItem ServiceDocument Transaction ID
ServiceDocumentType _OffsettingItem ServiceDocumentType Transaction Type
CostObject _OffsettingItem CostObject Cost Object
Segment _OffsettingItem Segment Segment number
Supplier _OffsettingItem Supplier Supplier
Customer _OffsettingItem Customer Sold-to Party
AssignmentReference _OffsettingItem AssignmentReference Assignment Reference
CostCenter _OffsettingItem CostCenter Cost Center
ProfitCenter _OffsettingItem ProfitCenter Profit Center
AccountAssignmentNumber _OffsettingItem AccountAssignmentNumber Account Assgmt No.
AccountAssignment _OffsettingItem AccountAssignment Sender Acct Assgmt
AccountAssignmentType _OffsettingItem AccountAssignmentType Sndr AcctAssgmt Type
SalesOrder _OffsettingItem SalesOrder SD Document
SalesOrderItem _OffsettingItem SalesOrderItem Sales Order Item
SalesDocument _OffsettingItem SalesDocument SD Document
SalesDocumentItem _OffsettingItem SalesDocumentItem Sales Document Item
OrderID _OffsettingItem OrderID Order ID
OrderCategory _OffsettingItem OrderCategory Order Category
WBSElementInternalID _OffsettingItem WBSElementInternalID WBS Internal ID
WBSElementExternalID _OffsettingItem WBSElementExternalID WBS Element External ID
ProjectInternalID _OffsettingItem ProjectInternalID Project Def.
ProjectExternalID _OffsettingItem ProjectExternalID Project def.
WorkPackage _OffsettingItem WorkPackage Plan Item
ProjectNetwork _OffsettingItem ProjectNetwork Order
ServiceDocument _OffsettingItem ServiceDocument Transaction ID
ServiceDocumentType _OffsettingItem ServiceDocumentType Transaction Type
CostObject _OffsettingItem CostObject Cost Object
Segment _OffsettingItem Segment Segment number
Supplier _OffsettingItem Supplier Supplier
Customer _OffsettingItem Customer Sold-to Party
AssignmentReference _OffsettingItem 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 I_AccrEngnAccrPostingEntryItem.
-- 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 I_AccrEngnAccrPostingEntryItem AS
SELECT
  cast( P_AccrEngnAccrPostgAccrItem.GLAccount as ace_accrual_account preserving type ) AS GLAccount,
  P_AccrEngnAccrPostgAccrItem.SourceLedger AS SourceLedger,
  P_AccrEngnAccrPostgAccrItem.CompanyCode AS CompanyCode,
  P_AccrEngnAccrPostgAccrItem.FiscalYear AS FiscalYear,
  P_AccrEngnAccrPostgAccrItem.JournalEntry AS JournalEntry,
  P_AccrEngnAccrPostgAccrItem.LedgerGLLineItem AS LedgerGLLineItem,
  P_AccrEngnAccrPostgAccrItem.Ledger AS Ledger,
  P_AccrEngnAccrPostgAccrItem.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  P_AccrEngnAccrPostgAccrItem.AccrualEngineAccrualObjectType AS AccrualEngineAccrualObjectType,
  P_AccrEngnAccrPostgAccrItem.AccrualObject AS AccrualObject,
  P_AccrEngnAccrPostgAccrItem.AccrualSubobject AS AccrualSubobject,
  P_AccrEngnAccrPostgAccrItem.AccrualItemType AS AccrualItemType,
  P_AccrEngnAccrPostgAccrItem.AccrualReferenceObject AS AccrualReferenceObject,
  P_AccrEngnAccrPostgAccrItem.AccrualValueDate AS AccrualValueDate,
  P_AccrEngnAccrPostgAccrItem.AccrualTransactionType AS AccrualTransactionType,
  P_AccrEngnAccrPostgAccrItem.GLAccountLineItemIsAccrual AS GLAccountLineItemIsAccrual,
  P_AccrEngnAccrPostgAccrItem.TransactionCurrency AS TransactionCurrency,
  P_AccrEngnAccrPostgAccrItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_AccrEngnAccrPostgAccrItem.GlobalCurrency AS GlobalCurrency,
  P_AccrEngnAccrPostgAccrItem.PostdAccrAmtInTransCurrency AS PostdAccrAmtInTransCurrency,
  P_AccrEngnAccrPostgAccrItem.PostdAccrAmtInCoCodeCrcy AS PostdAccrAmtInCoCodeCrcy,
  P_AccrEngnAccrPostgAccrItem.PostdAccrAmtInGlobalCurrency AS PostdAccrAmtInGlobalCurrency,
  P_AccrEngnAccrPostgAccrItem.FiscalYearVariant AS FiscalYearVariant,
  P_AccrEngnAccrPostgAccrItem.FiscalPeriod AS FiscalPeriod,
  P_AccrEngnAccrPostgAccrItem.FiscalYearPeriod AS FiscalYearPeriod,
  P_AccrEngnAccrPostgAccrItem.LedgerFiscalYear AS LedgerFiscalYear,
  P_AccrEngnAccrPostgAccrItem.PostingDate AS PostingDate,
  P_AccrEngnAccrPostgAccrItem.DocumentDate AS DocumentDate,
  P_AccrEngnAccrPostgAccrItem.ClearingDate AS ClearingDate,
  P_AccrEngnAccrPostgAccrItem.CreationDate AS CreationDate,
  P_AccrEngnAccrPostgAccrItem.CreationDateTime AS CreationDateTime,
  P_AccrEngnAccrPostgAccrItem.LastChangeDateTime AS LastChangeDateTime,
  P_AccrEngnAccrPostgAccrItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  P_AccrEngnAccrPostgAccrItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  P_AccrEngnAccrPostgAccrItem.FinancialTransactionType AS FinancialTransactionType,
  P_AccrEngnAccrPostgAccrItem.AccountingDocumentType AS AccountingDocumentType,
  P_AccrEngnAccrPostgAccrItem.BusinessTransactionType AS BusinessTransactionType,
  P_AccrEngnAccrPostgAccrItem.SenderCompanyCode AS SenderCompanyCode,
  P_AccrEngnAccrPostgAccrItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  P_AccrEngnAccrPostgAccrItem.ReferenceDocumentType AS ReferenceDocumentType,
  P_AccrEngnAccrPostgAccrItem.ReferenceDocument AS ReferenceDocument,
  P_AccrEngnAccrPostgAccrItem.IsReversal AS IsReversal,
  P_AccrEngnAccrPostgAccrItem.IsReversed AS IsReversed,
  P_AccrEngnAccrPostgAccrItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  P_AccrEngnAccrPostgAccrItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  P_AccrEngnAccrPostgAccrItem.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  P_AccrEngnAccrPostgAccrItem.PostingKey AS PostingKey,
  P_AccrEngnAccrPostgAccrItem.FunctionalArea AS FunctionalArea,
  P_AccrEngnAccrPostgAccrItem.AlternativeGLAccount AS AlternativeGLAccount,
  P_AccrEngnAccrPostgAccrItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  P_AccrEngnAccrPostgAccrItem.PurchasingDocument AS PurchasingDocument,
  P_AccrEngnAccrPostgAccrItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_AccrEngnAccrPostgAccrItem.TaxCode AS TaxCode,
  P_AccrEngnAccrPostgAccrItem.GLAccountType AS GLAccountType,
  P_AccrEngnAccrPostgAccrItem.ControllingArea AS ControllingArea,
  P_AccrEngnAccrPostgAccrItem.FinancialAccountType AS FinancialAccountType,
  P_AccrEngnAccrPostgAccrItem.BusinessProcess AS BusinessProcess,
  P_AccrEngnAccrPostgAccrItem.IsOpenItemManaged AS IsOpenItemManaged,
  P_AccrEngnAccrPostgAccrItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  P_AccrEngnAccrPostgAccrItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  P_AccrEngnAccrPostgAccrItem.DocumentItemText AS DocumentItemText,
  P_AccrEngnAccrPostgAccrItem.BusinessArea AS BusinessArea,
  P_AccrEngnAccrPostgAccrItem.Product AS Product,
  P_AccrEngnAccrPostgAccrItem.Plant AS Plant,
  P_AccrEngnAccrPostgAccrItem.ChartOfAccounts AS ChartOfAccounts,
  P_AccrEngnAccrPostgAccrItem.OffsettingAccount AS OffsettingAccount,
  P_AccrEngnAccrPostgAccrItem.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  P_AccrEngnAccrPostgAccrItem.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  P_AccrEngnAccrPostgAccrItem.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  P_AccrEngnAccrPostgAccrItem.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  P_AccrEngnAccrPostgAccrItem.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  _OffsettingItem.CostCenter AS CostCenter,
  _OffsettingItem.ProfitCenter AS ProfitCenter,
  _OffsettingItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  _OffsettingItem.AccountAssignment AS AccountAssignment,
  _OffsettingItem.AccountAssignmentType AS AccountAssignmentType,
  _OffsettingItem.SalesOrder AS SalesOrder,
  _OffsettingItem.SalesOrderItem AS SalesOrderItem,
  _OffsettingItem.SalesDocument AS SalesDocument,
  _OffsettingItem.SalesDocumentItem AS SalesDocumentItem,
  _OffsettingItem.OrderID AS OrderID,
  _OffsettingItem.OrderCategory AS OrderCategory,
  _OffsettingItem.WBSElementInternalID AS WBSElementInternalID,
  _OffsettingItem.WBSElementExternalID AS WBSElementExternalID,
  _OffsettingItem.ProjectInternalID AS ProjectInternalID,
  _OffsettingItem.ProjectExternalID AS ProjectExternalID,
  _OffsettingItem.WorkPackage AS WorkPackage,
  _OffsettingItem.ProjectNetwork AS ProjectNetwork,
  _OffsettingItem.ServiceDocument AS ServiceDocument,
  _OffsettingItem.ServiceDocumentType AS ServiceDocumentType,
  _OffsettingItem.CostObject AS CostObject,
  _OffsettingItem.Segment AS Segment,
  _OffsettingItem.Supplier AS Supplier,
  _OffsettingItem.Customer AS Customer,
  _OffsettingItem.AssignmentReference AS AssignmentReference
FROM P_AccrEngnAccrPostgAccrItem
INNER JOIN I_AccrEngineAccrItemTypeBasic AS _ItemType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_AccrEngnAccrPostgOffstgItem AS _OffsettingItem ON SourceLedger = _OffsettingItem.SourceLedger AND CompanyCode = _OffsettingItem.CompanyCode AND FiscalYear = _OffsettingItem.FiscalYear AND JournalEntry = _OffsettingItem.JournalEntry AND Ledger = _OffsettingItem.Ledger AND ReferenceDocumentItemGroup = _OffsettingItem.ReferenceDocumentItemGroup AND AccrualReferenceObject = _OffsettingItem.AccrualReferenceObject  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccrEngnAccrTransactionType AS _AccrTransactionType ON AccrualTransactionType = _AccrTransactionType.AccrualTransactionType  -- association [1..1]
LEFT OUTER JOIN I_AccrEngineAccrObjectType AS _AccrObjectType ON AccrualEngineAccrualObjectType = _AccrObjectType.AccrualEngineAccrualObjectType  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _AccrLogicalSystem ON AccrualObjectLogicalSystem = _AccrLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrItemTypeBasic AS _AccrItemType ON AccrualEngineAccrualObjectType = _AccrItemType.AccrualEngineAccrualObjectType AND AccrualItemType = _AccrItemType.AccrualItemType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod AND FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _LedgerFiscalYearForVariant ON LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear AND FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _OffsettingChartOfAccounts ON OffsettingChartOfAccounts = _OffsettingChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _OffstgGLAcctInChartOfAccounts ON OffsettingChartOfAccounts = _OffstgGLAcctInChartOfAccounts.ChartOfAccounts AND OffsettingAccount = _OffstgGLAcctInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND costcenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_Segment AS _Segment ON segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND profitcenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON salesdocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON salesdocument = _SalesDocumentItem.SalesDocument AND salesdocumentitem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
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]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementByExternalID ON wbselementexternalid = _WBSElementByExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectByExternalID ON projectexternalid = _ProjectByExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON orderid = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON workpackage = _WorkPackage.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceDocument ON servicedocumenttype = _ServiceDocument.ServiceDocumentType AND servicedocument = _ServiceDocument.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON servicedocumenttype = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
-- UNION ALL with additional select branch(es): P_AccrEngnAccrPostgAccrItem
;

Learn More