P_REVNRECGNJOURNALENTRYITEM
P_REVNRECGNJOURNALENTRYITEM is a CDS View in S/4HANA. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_RevnRecgnJournalEntryItem | view | from | CONSUMPTION | Accnt. Items for Inspect Revn. Recg. |
| P_RevnRecgnProjectPeriod | view | from | CONSUMPTION | |
| P_RevnRecgnWBSElementPeriod | view | from | CONSUMPTION |
@AbapCatalog.sqlViewName: 'PIRRJRNENTRITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {
dataClass: #MIXED,
sizeCategory: #L,
serviceQuality: #C
}
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RevnRecgnJournalEntryItem
with parameters
P_Language : sylangu
as select from I_GLAccountLineItem
association [1..1] to I_GLAccountLineItem as _GLAccountLineItem on $projection.Ledger = _GLAccountLineItem.Ledger
and $projection.SourceLedger = _GLAccountLineItem.SourceLedger
and $projection.CompanyCode = _GLAccountLineItem.CompanyCode
and $projection.FiscalYear = _GLAccountLineItem.FiscalYear
and $projection.AccountingDocument = _GLAccountLineItem.AccountingDocument
and $projection.LedgerGLLineItem = _GLAccountLineItem.LedgerGLLineItem
association [0..1] to I_ProfitCenterText as _ProfitCenterText on $projection.ControllingArea = _ProfitCenterText.ControllingArea
and $projection.ProfitCenter = _ProfitCenterText.ProfitCenter
and $projection.PostingDate >= _ProfitCenterText.ValidityStartDate
and $projection.PostingDate <= _ProfitCenterText.ValidityEndDate
association [0..1] to I_CostCenterText as _CostCenterText on $projection.ControllingArea = _CostCenterText.ControllingArea
and $projection.CostCenter = _CostCenterText.CostCenter
and $projection.PostingDate >= _CostCenterText.ValidityStartDate
and $projection.PostingDate <= _CostCenterText.ValidityEndDate
{
key Ledger,
key SourceLedger,
key CompanyCode,
key FiscalYear,
key AccountingDocument,
key LedgerGLLineItem,
ReferenceDocument,
BusinessTransactionType,
cast (
case BusinessTransactionType
when 'TBRR' then 'R' //recognized
else 'A' //actual
end as fco_revn_recgn_postg_type
) as RevnRecgnGLLineItmPostgType,
FiscalPeriod,
FiscalYearPeriod,
GLAccount,
GLAccountType,
DebitCreditCode,
ChartOfAccounts,
Project,
ProjectInternalID,
WBSElement,
WBSElementInternalID,
SalesOrder,
SalesOrderItem,
BalanceTransactionCurrency,
AmountInBalanceTransacCrcy,
TransactionCurrency,
AmountInTransactionCurrency,
CompanyCodeCurrency,
AmountInCompanyCodeCurrency,
GlobalCurrency,
AmountInGlobalCurrency,
ProfitCenter,
_ProfitCenterText[1:Language = :P_Language ].ProfitCenterName,
OriginProfitCenter,
CostCenter,
_CostCenterText[1:Language = :P_Language ].CostCenterName,
CostCtrActivityType,
_CompanyCodeText.CompanyCodeName,
AccountingDocCreatedByUser,
AccountingDocumentType,
DocumentDate,
PostingDate,
CreationDateTime,
AccountingDocumentCategory,
_GLAcctInChartOfAccountsText[1:Language = :P_Language ].GLAccountName,
PartnerWBSElementInternalID,
ControllingArea,
_Ledger,
_SourceLedger,
_CompanyCode,
_FiscalYear,
_JournalEntry,
_GLAccountInChartOfAccounts,
/* For authorization purposes */
_GLAccountLineItem
} where AccountingDocumentCategory <> 'C'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_COSTCENTERTEXT",
"I_GLACCOUNTLINEITEM",
"I_GLACCOUNTTEXT",
"I_PROFITCENTERTEXT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_COSTCENTERTEXT",
"I_FISCALYEARFORCOMPANYCODE",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_GLACCOUNTLINEITEM",
"I_JOURNALENTRY",
"I_LEDGER",
"I_PROFITCENTERTEXT"
],
"BASE":
[
"I_GLACCOUNTLINEITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/