C_NL_SAFTJournalItemBP

DDL: C_NL_SAFTJOURNALITEMBP Type: view_entity CONSUMPTION
23 Fields 6 Data Sources

Audit File NL Journal Item BP

C_NL_SAFTJournalItemBP is a Consumption CDS View that provides data about "Audit File NL Journal Item BP" in SAP S/4HANA. It reads from 6 data sources and exposes 23 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem, Ledger.

Data Sources (6)

SourceAliasJoin Type
I_BusinessPartner BP inner
I_BusinessPartner BP inner
I_CustomerToBusinessPartner CustToBP inner
I_JournalEntryItem JournalLineItem from
I_JournalEntryItem JournalLineItem union
I_SupplierToBusinessPartner SupToBP inner

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label Audit File NL Journal Item BP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntryItem CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntryItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntryItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_JournalEntryItem LedgerGLLineItem Journal Entry Item
KEY Ledger I_JournalEntryItem Ledger Ledger
BusinessPartner I_BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerType
_CompanyCode I_JournalEntryItem _CompanyCode
_JournalEntry I_JournalEntryItem _JournalEntry
_FiscalYear I_JournalEntryItem _FiscalYear
_Ledger I_JournalEntryItem _Ledger
CompanyCodeasCompanyCode
KEY FiscalYear I_JournalEntryItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntryItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_JournalEntryItem LedgerGLLineItem Journal Entry Item
KEY Ledger I_JournalEntryItem Ledger Ledger
BusinessPartner I_BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerType
_CompanyCode I_JournalEntryItem _CompanyCode
_JournalEntry I_JournalEntryItem _JournalEntry
_FiscalYear I_JournalEntryItem _FiscalYear
_Ledger I_JournalEntryItem _Ledger
_CurrentDefaultAddress I_BusinessPartner _CurrentDefaultAddress

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_NL_SAFTJournalItemBP.
-- 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 C_NL_SAFTJournalItemBP AS
SELECT
  JournalLineItem.CompanyCode AS CompanyCode,
  JournalLineItem.FiscalYear AS FiscalYear,
  JournalLineItem.AccountingDocument AS AccountingDocument,
  JournalLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalLineItem.Ledger AS Ledger,
  BP.BusinessPartner AS BusinessPartner,
  cast('0001' as abap.char( 4 )) AS BusinessPartnerType,
  JournalLineItem._CompanyCode AS _CompanyCode,
  JournalLineItem._JournalEntry AS _JournalEntry,
  JournalLineItem._FiscalYear AS _FiscalYear,
  JournalLineItem._Ledger AS _Ledger,
  BP._CurrentDefaultAddress AS CompanyCodeasCompanyCode,
  BP._CurrentDefaultAddress AS _CurrentDefaultAddress
FROM I_JournalEntryItem AS JournalLineItem
INNER JOIN I_CustomerToBusinessPartner AS CustToBP ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusinessPartner AS BP ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierToBusinessPartner AS SupToBP ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_JournalEntryItem
;

Learn More