P_CO_DIANFrmt1001JrnlEntrOplV4
P_CO_DIANFrmt1001JrnlEntrOplV4 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_CO_DIANFrmt1001JrnlEntrOplV3) and exposes 48 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CO_DIANReportFormat, CO_DIANReportItemType.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_CO_DIANFrmt1001JrnlEntrOplV3 | P_CO_DIANFrmt1001JrnlEntrOplV3 | from |
Parameters (3)
| Name | Type | Default |
|---|---|---|
| P_Ledger | fins_ledger | |
| P_FromPostingDate | fis_budat_from | |
| P_ToPostingDate | fis_budat_to |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.entityBuffer.definitionAllowed | false | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | 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 (48)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | StatryRptgEntity | OperationalView | StatryRptgEntity | Reporting Entity |
| KEY | StatryRptCategory | OperationalView | StatryRptCategory | Report ID |
| KEY | StatryRptRunID | OperationalView | StatryRptRunID | Report Run ID |
| KEY | CO_DIANReportFormat | OperationalView | CO_DIANReportFormat | Report Format |
| KEY | CO_DIANReportItemType | OperationalView | CO_DIANReportItemType | Item Type |
| 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 |
| 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. | |
| CompanyCodeCountry | OperationalView | CompanyCodeCountry | Reporting Ctry/Reg. | |
| SupplierendasSupplier | ||||
| CustomerendasCustomer | ||||
| 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_DIANAmountClassificationGL | OperationalView | CO_DIANAmountClassification | ||
| CO_DIANAmountClassificationVAT | DIANTaxItem | CO_DIANAmountClassification | ||
| ReportingCurrency | OperationalView | ReportingCurrency | Currency | |
| AmountInReportingCurrency | OperationalView | AmountInReportingCurrency | ||
| curr232endasfwste_f05lasTaxAmount | ||||
| _AccountingDocumentType | OperationalView | _AccountingDocumentType | ||
| _ChartOfAccounts | OperationalView | _ChartOfAccounts | ||
| _CompanyCode | OperationalView | _CompanyCode | ||
| _Country | OperationalView | _Country | ||
| _CountryChartOfAccounts | OperationalView | _CountryChartOfAccounts | ||
| _FinancialAccountType | OperationalView | _FinancialAccountType | ||
| _FiscalYear | OperationalView | _FiscalYear | ||
| _JournalEntry | OperationalView | _JournalEntry | ||
| _Ledger | OperationalView | _Ledger | ||
| _PurchasingDocument | OperationalView | _PurchasingDocument | ||
| _PurchasingDocumentItem | OperationalView | _PurchasingDocumentItem | ||
| _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_DIANFrmt1001JrnlEntrOplV4.
-- 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_DIANFrmt1001JrnlEntrOplV4 AS
SELECT
OperationalView.StatryRptgEntity AS StatryRptgEntity,
OperationalView.StatryRptCategory AS StatryRptCategory,
OperationalView.StatryRptRunID AS StatryRptRunID,
OperationalView.CO_DIANReportFormat AS CO_DIANReportFormat,
OperationalView.CO_DIANReportItemType AS CO_DIANReportItemType,
OperationalView.Ledger AS Ledger,
OperationalView.CompanyCode AS CompanyCode,
OperationalView.FiscalYear AS FiscalYear,
OperationalView.AccountingDocument AS AccountingDocument,
OperationalView.AccountingDocumentItem AS AccountingDocumentItem,
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.CompanyCodeCountry AS CompanyCodeCountry,
case when ( BusinessPartnerTaxNumber.Supplier is not null and BusinessPartnerTaxNumber.Supplier <> '' ) then BusinessPartnerTaxNumber.Supplier when OperationalView.OffsettingAccountType = 'K' then OperationalView.OffsettingAccount else OperationalView.Supplier end as Supplier AS SupplierendasSupplier,
case when ( BusinessPartnerTaxNumber.Customer is not null and BusinessPartnerTaxNumber.Customer <> '' ) then BusinessPartnerTaxNumber.Customer when OperationalView.OffsettingAccountType = 'D' then OperationalView.OffsettingAccount else OperationalView.Customer end as Customer AS CustomerendasCustomer,
OperationalView.OffsettingAccountType AS OffsettingAccountType,
OperationalView.OffsettingAccount AS OffsettingAccount,
OperationalView.OplAcctgDocItmCntrySpcfcRef1 AS OplAcctgDocItmCntrySpcfcRef1,
OperationalView.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
OperationalView.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
OperationalView.BusinessPlace AS BusinessPlace,
OperationalView.CO_DIANAmountClassification AS CO_DIANAmountClassificationGL,
DIANTaxItem.CO_DIANAmountClassification AS CO_DIANAmountClassificationVAT,
OperationalView.ReportingCurrency AS ReportingCurrency,
OperationalView.AmountInReportingCurrency AS AmountInReportingCurrency,
cast( case when OperationalView.ReferenceDocumentType <> 'MKPF' and OperationalView.TaxBaseAmount <> 0 and ( DIANTaxItem.CO_DIANAmountClassification is not null and DIANTaxItem.CO_DIANAmountClassification <> '' ) then ( OperationalView.AmountInReportingCurrency - OperationalView.TaxBaseAmount ) else cast( 0 as abap.curr( 23, 2 ) ) end as fwste_f05l ) as TaxAmount AS curr232endasfwste_f05lasTaxAmount,
OperationalView._AccountingDocumentType AS _AccountingDocumentType,
OperationalView._ChartOfAccounts AS _ChartOfAccounts,
OperationalView._CompanyCode AS _CompanyCode,
OperationalView._Country AS _Country,
OperationalView._CountryChartOfAccounts AS _CountryChartOfAccounts,
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._ReportingCurrency AS _ReportingCurrency
FROM P_CO_DIANFrmt1001JrnlEntrOplV3
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA