P_CO_DIANFrmt1001JrnlEntrOplV3

DDL: P_CO_DIANFRMT1001JRNLENTROPLV3 Type: view CONSUMPTION Package: GLO_FIN_IS_CO_FORMAT_1001
54 Fields 2 Data Sources

Format 1001 - JE Operational View

P_CO_DIANFrmt1001JrnlEntrOplV3 is a Consumption CDS View that provides data about "Format 1001 - JE Operational View" in SAP S/4HANA. It reads from 2 data sources (P_CO_DIANFrmt1001JrnlEntrOplV2, P_CO_DIANGeneralLedgerAccount) and exposes 54 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, Ledger, CompanyCode. Part of development package GLO_FIN_IS_CO_FORMAT_1001.

Data Sources (2)

SourceAliasJoin Type
P_CO_DIANFrmt1001JrnlEntrOplV2 P_CO_DIANFrmt1001JrnlEntrOplV2 from
P_CO_DIANGeneralLedgerAccount P_CO_DIANGeneralLedgerAccount inner

Parameters (3)

NameTypeDefault
P_Ledger fins_ledger
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to

Annotations (11)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PSRCO1001JEOPLV3 view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Format 1001 - JE Operational View view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XXL view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity OperationalView StatryRptgEntity Reporting Entity
KEY StatryRptCategory OperationalView StatryRptCategory Report ID
KEY StatryRptRunID OperationalView StatryRptRunID Report Run ID
KEY Ledger OperationalView Ledger Ledger
KEY CompanyCode OperationalView CompanyCode Receiver Company Code
KEY FiscalYear OperationalView FiscalYear G/L Fiscal Year
KEY AccountingDocument OperationalView AccountingDocument Journal Entry
KEY AccountingDocumentItem OperationalView AccountingDocumentItem Posting View Item
CO_DIANReportFormat DIANGLAccount CO_DIANReportFormat Report Format
CO_DIANReportItemType DIANGLAccount CO_DIANReportItemType Item Type
AccountingDocumentType OperationalView AccountingDocumentType Journal Entry Type
TaxCode OperationalView TaxCode Tax Code
TransactionTypeDetermination OperationalView TransactionTypeDetermination Transaction Key
ChartOfAccounts OperationalView ChartOfAccounts Node Class
GLAccount OperationalView GLAccount General Ledger
CountryChartOfAccounts OperationalView CountryChartOfAccounts Chart of Accts
AlternativeGLAccount OperationalView AlternativeGLAccount Group Account
PostingDate OperationalView PostingDate Posting Date for GR
FinancialAccountType OperationalView FinancialAccountType Fin. Account Type
PurchasingDocument OperationalView PurchasingDocument Purchasing Document
PurchasingDocumentItem OperationalView PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber OperationalView AccountAssignmentNumber Account Assgmt No.
ReferenceDocumentType OperationalView ReferenceDocumentType Reference Document Type
ReferenceDocumentFiscalYear
ReferenceDocument
CompanyCodeCountry OperationalView CompanyCodeCountry Reporting Ctry/Reg.
TaxCalculationProcedure
Supplier OperationalView Supplier Supplier
Customer OperationalView Customer Sold-to Party
OffsettingAccountType OperationalView OffsettingAccountType Offset Acct Type
OffsettingAccount OperationalView OffsettingAccount Offsetting Acct
OplAcctgDocItmCntrySpcfcRef1 OperationalView OplAcctgDocItmCntrySpcfcRef1 Country/Region Specific Reference 1
Reference1IDByBusinessPartner OperationalView Reference1IDByBusinessPartner Reference Key 1
Reference3IDByBusinessPartner OperationalView Reference3IDByBusinessPartner Reference Key 3
BusinessPlace OperationalView BusinessPlace Business place
CO_DIANAmountClassification DIANGLAccount CO_DIANAmountClassification
ReportingCurrency OperationalView ReportingCurrency Currency
AmountInReportingCurrency OperationalView AmountInReportingCurrency
_AccountingDocumentType OperationalView _AccountingDocumentType
_AlternativeGLAccount OperationalView _AlternativeGLAccount
_ChartOfAccounts OperationalView _ChartOfAccounts
_CompanyCode OperationalView _CompanyCode
_Country OperationalView _Country
_CountryChartOfAccounts OperationalView _CountryChartOfAccounts
_Customer OperationalView _Customer
_FinancialAccountType OperationalView _FinancialAccountType
_FiscalYear OperationalView _FiscalYear
_JournalEntry OperationalView _JournalEntry
_Ledger OperationalView _Ledger
_PurchasingDocument OperationalView _PurchasingDocument
_PurchasingDocumentItem OperationalView _PurchasingDocumentItem
_Supplier OperationalView _Supplier
_ReferenceDocumentType OperationalView _ReferenceDocumentType
_ReportingCurrency OperationalView _ReportingCurrency

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_CO_DIANFrmt1001JrnlEntrOplV3.
-- 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.
-- Parameters: P_Ledger : fins_ledger, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_CO_DIANFrmt1001JrnlEntrOplV3 AS
SELECT
  OperationalView.StatryRptgEntity AS StatryRptgEntity,
  OperationalView.StatryRptCategory AS StatryRptCategory,
  OperationalView.StatryRptRunID AS StatryRptRunID,
  OperationalView.Ledger AS Ledger,
  OperationalView.CompanyCode AS CompanyCode,
  OperationalView.FiscalYear AS FiscalYear,
  OperationalView.AccountingDocument AS AccountingDocument,
  OperationalView.AccountingDocumentItem AS AccountingDocumentItem,
  DIANGLAccount.CO_DIANReportFormat AS CO_DIANReportFormat,
  DIANGLAccount.CO_DIANReportItemType AS CO_DIANReportItemType,
  OperationalView.AccountingDocumentType AS AccountingDocumentType,
  OperationalView.TaxCode AS TaxCode,
  OperationalView.TransactionTypeDetermination AS TransactionTypeDetermination,
  OperationalView.ChartOfAccounts AS ChartOfAccounts,
  OperationalView.GLAccount AS GLAccount,
  OperationalView.CountryChartOfAccounts AS CountryChartOfAccounts,
  OperationalView.AlternativeGLAccount AS AlternativeGLAccount,
  OperationalView.PostingDate AS PostingDate,
  OperationalView.FinancialAccountType AS FinancialAccountType,
  OperationalView.PurchasingDocument AS PurchasingDocument,
  OperationalView.PurchasingDocumentItem AS PurchasingDocumentItem,
  OperationalView.AccountAssignmentNumber AS AccountAssignmentNumber,
  OperationalView.ReferenceDocumentType AS ReferenceDocumentType,
  coalesce( InvoiceReceiptItem.FiscalYear, OperationalView.FiscalYear ) AS ReferenceDocumentFiscalYear,
  coalesce( InvoiceReceiptItem.AccountingDocument, OperationalView.AccountingDocument ) AS ReferenceDocument,
  OperationalView.CompanyCodeCountry AS CompanyCodeCountry,
  OperationalView._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  OperationalView.Supplier AS Supplier,
  OperationalView.Customer AS Customer,
  OperationalView.OffsettingAccountType AS OffsettingAccountType,
  OperationalView.OffsettingAccount AS OffsettingAccount,
  OperationalView.OplAcctgDocItmCntrySpcfcRef1 AS OplAcctgDocItmCntrySpcfcRef1,
  OperationalView.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  OperationalView.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  OperationalView.BusinessPlace AS BusinessPlace,
  DIANGLAccount.CO_DIANAmountClassification AS CO_DIANAmountClassification,
  OperationalView.ReportingCurrency AS ReportingCurrency,
  OperationalView.AmountInReportingCurrency AS AmountInReportingCurrency,
  OperationalView._AccountingDocumentType AS _AccountingDocumentType,
  OperationalView._AlternativeGLAccount AS _AlternativeGLAccount,
  OperationalView._ChartOfAccounts AS _ChartOfAccounts,
  OperationalView._CompanyCode AS _CompanyCode,
  OperationalView._Country AS _Country,
  OperationalView._CountryChartOfAccounts AS _CountryChartOfAccounts,
  OperationalView._Customer AS _Customer,
  OperationalView._FinancialAccountType AS _FinancialAccountType,
  OperationalView._FiscalYear AS _FiscalYear,
  OperationalView._JournalEntry AS _JournalEntry,
  OperationalView._Ledger AS _Ledger,
  OperationalView._PurchasingDocument AS _PurchasingDocument,
  OperationalView._PurchasingDocumentItem AS _PurchasingDocumentItem,
  OperationalView._Supplier AS _Supplier,
  OperationalView._ReferenceDocumentType AS _ReferenceDocumentType,
  OperationalView._ReportingCurrency AS _ReportingCurrency
FROM P_CO_DIANFrmt1001JrnlEntrOplV2
INNER JOIN P_CO_DIANGeneralLedgerAccount ON /* join condition not captured in parsed metadata */
;

Learn More