C_JrnlEntrItmPriorFsclPerd

DDL: C_JRNLENTRITMPRIORFSCLPERD SQL: CFIJEPREVPERIOD Type: view CONSUMPTION Package: FINS_FIS_GRC_APPS
77 Fields 1 Data Sources 2 Associations

Jrnl Entr Item Postd Prior Fiscal Period

C_JrnlEntrItmPriorFsclPerd is a Consumption CDS View that provides data about "Jrnl Entr Item Postd Prior Fiscal Period" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 77 fields with key fields CompanyCode, FiscalYear, JournalEntry, LedgerGLLineItem, Ledger. It has 2 associations to related views. Part of development package FINS_FIS_GRC_APPS.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem I_JournalEntryItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant $projection.FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant and $projection.FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod
[0..1] I_UserContactCard _UserContactCard $projection.AccountingDocCreatedByUser = _UserContactCard.ContactCardID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CFIJEPREVPERIOD view
EndUserText.label Jrnl Entr Item Postd Prior Fiscal Period view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.representativeKey LedgerGLLineItem view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (77)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY JournalEntry AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY Ledger Ledger Ledger
CreationDate CreationDate Time Stamp
PostingDate PostingDate Posting Date for GR
FiscalPeriodEndDate _FiscalYearPeriodForVariant FiscalPeriodEndDate
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
FullName _UserContactCard FullName Name
LedgerFiscalYear LedgerFiscalYear
ChartOfAccounts ChartOfAccounts Node Class
CompanyCodeName _CompanyCode CompanyCodeName Company Name
GLAccount GLAccount General Ledger
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
BusinessTransactionType BusinessTransactionType Bus.transaction
FiscalYearVariant FiscalYearVariant FY Variant
FiscalPeriod FiscalPeriod Tax period
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalPeriodStartDate _FiscalYearPeriodForVariant FiscalPeriodStartDate
IsSpecialPeriod _FiscalYearPeriodForVariant IsSpecialPeriod
DocumentDate DocumentDate Journal Entry Date
LastChangeDateTime LastChangeDateTime Timestamp
BalanceTransactionCurrency BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
DebitCreditCode DebitCreditCode Single-Character Flag
AccountingDocumentType AccountingDocumentType Journal Entry Type
FinancialAccountType FinancialAccountType Fin. Account Type
Supplier Supplier Supplier
Customer Customer Sold-to Party
AccountingDocumentHeaderText _JournalEntry AccountingDocumentHeaderText Doc.Header Text
TransactionCode _JournalEntry TransactionCode Transaction Code
_SourceLedger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_Ledger _Ledger
_LedgerFiscalYear _LedgerFiscalYear
_ChartOfAccounts _ChartOfAccounts
_ChartOfAccountsText _ChartOfAccountsText
_GLAccountInCompanyCode _GLAccountInCompanyCode
_GLAccountTxt _GLAccountTxt
_ControllingArea _ControllingArea
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_BusinessTransactionType _BusinessTransactionType
_BusinessTransactionTypeText _BusinessTransactionTypeText
_FiscalYearVariant _FiscalYearVariant
_FiscalPeriod _FiscalPeriod
_BalanceTransactionCurrency _BalanceTransactionCurrency
_TransactionCurrency _TransactionCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_DebitCreditCode _DebitCreditCode
_DebitCreditCodeText _DebitCreditCodeText
_AccountingDocumentType _AccountingDocumentType
_AccountingDocumentTypeText _AccountingDocumentTypeText
_FinancialAccountType _FinancialAccountType
_FinancialAccountTypeText _FinancialAccountTypeText
_UserContactCard _UserContactCard
_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant
_FiscalPeriodStartDate _FiscalYearPeriodForVariant _FiscalPeriodStartDate
_FiscalPeriodForVariant _FiscalPeriodForVariant
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_Supplier _Supplier
_Customer _Customer

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 C_JrnlEntrItmPriorFsclPerd.
-- 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.
-- SQL view name: CFIJEPREVPERIOD

CREATE VIEW C_JrnlEntrItmPriorFsclPerd AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument AS JournalEntry,
  LedgerGLLineItem,
  Ledger,
  CreationDate,
  PostingDate,
  _FiscalYearPeriodForVariant.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  AccountingDocCreatedByUser,
  _UserContactCard.FullName AS FullName,
  LedgerFiscalYear,
  ChartOfAccounts,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  GLAccount,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  ProfitCenter,
  CostCenter,
  BusinessTransactionType,
  FiscalYearVariant,
  FiscalPeriod,
  FiscalYearPeriod,
  _FiscalYearPeriodForVariant.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  _FiscalYearPeriodForVariant.IsSpecialPeriod AS IsSpecialPeriod,
  DocumentDate,
  LastChangeDateTime,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  DebitCreditCode,
  AccountingDocumentType,
  FinancialAccountType,
  Supplier,
  Customer,
  _JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  _JournalEntry.TransactionCode AS TransactionCode,
  _FiscalYearPeriodForVariant._FiscalPeriodStartDate AS _FiscalPeriodStartDate
FROM I_JournalEntryItem
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant AND FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON AccountingDocCreatedByUser = _UserContactCard.ContactCardID  -- association [0..1]
;

Learn More