I_CN_CADEJournalEntryMapping

DDL: I_CN_CADEJOURNALENTRYMAPPING SQL: ICADEJRNLENTRMAP Type: view BASIC
10 Fields 1 Data Sources 4 Associations

CN Journal Entry Mapping for CADE

I_CN_CADEJournalEntryMapping (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Country or Region-Specific Functions for Finance

I_CN_CADEJournalEntryMapping is a Basic CDS View that provides data about "CN Journal Entry Mapping for CADE" in SAP S/4HANA. It reads from 1 data source (cade_jrnlmappg) and exposes 10 fields with key fields CompanyCode, CN_CADENatlStdRelVersion, AccountingDocumentType. It has 4 associations to related views.

SAP Help Documentation

CategoryData Extraction
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business question regarding China Audit Data Extraction (CADE): What is the mapping relationship between a journal entry type in the system and a journal entry type (GB/T), transaction type (GB/T) or document type (GB/T) defined by a user?

Prerequisites
Users who want to run reports using this CDS view must have the authorization to display company codes.

Structure
Measures and attributes Some important attributes are: Company code National standard release version for CADE Journal entry type Journal entry type (GB/T) Journal entry type name Journal entry type name (GB/T) Transaction type (GB/T) Transaction type name (GB/T) Document type (GB/T) Document type name (GB/T)

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCountry or Region-Specific Functions for Finance
Application ComponentFI-LOC-GAI-CN
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageCountry or Region-Specific Functions for Finance for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
cade_jrnlmappg JournalEntryTypeMapping from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_AccountingDocumentTypeText JournalEntryTypeText JournalEntryTypeMapping.blart = JournalEntryTypeText.AccountingDocumentType and JournalEntryTypeText.Language = $session.system_language
[0..1] I_CN_CADEJournalEntryDocType CADEJournalEntryType CADEJournalEntryType.CN_CADEDocumentListType = JournalEntryTypeMapping.cade_jrnl_entr_type_code and CADEJournalEntryType.CompanyCode = JournalEntryTypeMapping.bukrs and CADEJournalEntryType.CN_CADENatlStdRelVersion = JournalEntryTypeMapping.cade_natl_std_rel_ver and CADEJournalEntryType.CN_CADEDocumentTypeUsage = '1'
[0..1] I_CN_CADEJournalEntryDocType CADETranscationType CADETranscationType.CN_CADEDocumentListType = JournalEntryTypeMapping.cade_trans_type_code and CADETranscationType.CompanyCode = JournalEntryTypeMapping.bukrs and CADETranscationType.CN_CADENatlStdRelVersion = JournalEntryTypeMapping.cade_natl_std_rel_ver and CADETranscationType.CN_CADEDocumentTypeUsage = '2'
[0..1] I_CN_CADEJournalEntryDocType CADEDocumentType CADEDocumentType.CN_CADEDocumentListType = JournalEntryTypeMapping.cade_doc_type_code and CADEDocumentType.CompanyCode = JournalEntryTypeMapping.bukrs and CADEDocumentType.CN_CADENatlStdRelVersion = JournalEntryTypeMapping.cade_natl_std_rel_ver and CADEDocumentType.CN_CADEDocumentTypeUsage = '3'

Annotations (12)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ICADEJRNLENTRMAP view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label CN Journal Entry Mapping for CADE view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode cade_jrnlmappg bukrs Company Code
KEY CN_CADENatlStdRelVersion cade_jrnlmappg cade_natl_std_rel_ver National Standard Release Version for CADE
KEY AccountingDocumentType cade_jrnlmappg blart Accounting Document Type
CN_CADEJournalEntryType cade_jrnlmappg cade_jrnl_entr_type_code Journal Entry Type Code for CADE
CN_CADETransactionType cade_jrnlmappg cade_trans_type_code Transaction Type Code for CADE
CN_CADEOriginalPaymentDocument cade_jrnlmappg cade_doc_type_code Document Type Code for CADE
AccountingDocumentTypeName JournalEntryTypeText AccountingDocumentTypeName Accounting Document Type Description
CN_CADEJournalEntryTypeName CADEJournalEntryType CN_CADEDocumentListTypeName Journal Entry Type Description for CADE
CN_CADETransactionTypeName CADETranscationType CN_CADEDocumentListTypeName Journal Entry Type Description for CADE
CN_CADEOriginalPaymentDocType CADEDocumentType CN_CADEDocumentListTypeName Journal Entry Type Description for CADE

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 I_CN_CADEJournalEntryMapping.
-- 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: ICADEJRNLENTRMAP

CREATE VIEW I_CN_CADEJournalEntryMapping AS
SELECT
  JournalEntryTypeMapping.bukrs AS CompanyCode,
  JournalEntryTypeMapping.cade_natl_std_rel_ver AS CN_CADENatlStdRelVersion,
  JournalEntryTypeMapping.blart AS AccountingDocumentType,
  JournalEntryTypeMapping.cade_jrnl_entr_type_code AS CN_CADEJournalEntryType,
  JournalEntryTypeMapping.cade_trans_type_code AS CN_CADETransactionType,
  JournalEntryTypeMapping.cade_doc_type_code AS CN_CADEOriginalPaymentDocument,
  JournalEntryTypeText.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  CADEJournalEntryType.CN_CADEDocumentListTypeName AS CN_CADEJournalEntryTypeName,
  CADETranscationType.CN_CADEDocumentListTypeName AS CN_CADETransactionTypeName,
  CADEDocumentType.CN_CADEDocumentListTypeName AS CN_CADEOriginalPaymentDocType
FROM cade_jrnlmappg AS JournalEntryTypeMapping
LEFT OUTER JOIN I_AccountingDocumentTypeText AS JournalEntryTypeText ON JournalEntryTypeMapping.blart = JournalEntryTypeText.AccountingDocumentType AND JournalEntryTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CN_CADEJournalEntryDocType AS CADEJournalEntryType ON CADEJournalEntryType.CN_CADEDocumentListType = JournalEntryTypeMapping.cade_jrnl_entr_type_code AND CADEJournalEntryType.CompanyCode = JournalEntryTypeMapping.bukrs AND CADEJournalEntryType.CN_CADENatlStdRelVersion = JournalEntryTypeMapping.cade_natl_std_rel_ver AND CADEJournalEntryType.CN_CADEDocumentTypeUsage = '1'  -- association [0..1]
LEFT OUTER JOIN I_CN_CADEJournalEntryDocType AS CADETranscationType ON CADETranscationType.CN_CADEDocumentListType = JournalEntryTypeMapping.cade_trans_type_code AND CADETranscationType.CompanyCode = JournalEntryTypeMapping.bukrs AND CADETranscationType.CN_CADENatlStdRelVersion = JournalEntryTypeMapping.cade_natl_std_rel_ver AND CADETranscationType.CN_CADEDocumentTypeUsage = '2'  -- association [0..1]
LEFT OUTER JOIN I_CN_CADEJournalEntryDocType AS CADEDocumentType ON CADEDocumentType.CN_CADEDocumentListType = JournalEntryTypeMapping.cade_doc_type_code AND CADEDocumentType.CompanyCode = JournalEntryTypeMapping.bukrs AND CADEDocumentType.CN_CADENatlStdRelVersion = JournalEntryTypeMapping.cade_natl_std_rel_ver AND CADEDocumentType.CN_CADEDocumentTypeUsage = '3'  -- association [0..1]
;

Learn More