What is I_JP_Annex205APBookCube in SAP S/4HANA?

I_JP_Annex205APBookCube is a composite CDS view in SAP S/4HANA. Japan AP Book for Corporate Tax - Cube It contains 50 fields.

Which tables does I_JP_Annex205APBookCube read from?

I_JP_Annex205APBookCube reads data from: P_JP_ANNEX215APBOOK.

What VDM layer is I_JP_Annex205APBookCube?

I_JP_Annex205APBookCube is classified as a Composite view that combines data from multiple basic views.

I_JP_Annex205APBookCube

DDL: I_JP_ANNEX205APBOOKCUBE SQL: IJPANX205CUBE Type: view COMPOSITE Package: GLO_FIN_JP_ANNEX20

50 Fields 1 Data Sources 1 Associations

Japan AP Book for Corporate Tax - Cube

Japan Annex215 AP Book - Cube

I_JP_Annex205APBookCube (Composite)

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

Country or Region-Specific Functions for Finance

I_JP_Annex205APBookCube is a Composite CDS View (Cube) that provides data about "Japan AP Book for Corporate Tax - Cube" in SAP S/4HANA. It reads from 1 data source (P_JP_ANNEX215APBOOK) and exposes 50 fields with key fields Supplier, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 1 association to related views. Part of development package GLO_FIN_JP_ANNEX20.

SAP Help Documentation

Category	Corporate Tax
Data Category	Cube

Purpose
This CDS view retrieves the accounts payable book of Order for Enforcement of the Corporation Tax Act. This CDS view provides the data to answer the following business question: How should accounts payable details be shown and listed as an electronic book for claiming corporate tax as "blue return"? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: BUKRS (Company Code) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment ACCTSPYBLAMTINCCCRCY Account Payable Amt Measure The account payable amount shows value for account type D (Customer). For other account types, it shows 0. NETPRICEQUANTITY Price Unit Measure NETPRICEAMOUNT Net Order Price Measure Net price from purchase order QUANTITY Quantity Measure AMOUNTINTRANSACTIONCURRENCY Amount in Transaction Currency Measure AMOUNTINCOMPANYCODECURRENCY Amount in Company Code Currency Measure ORDERPRICEUNIT Order Price Unit Attribute DOCUMENTCURRENCY Currency Attribute JP_ANNEX205APLEADINGACCTGDOC Leading Acctg Doc No Attribute REFERENCEDOCUMENT Reference Document Attribute PURCHASINGDOCUMENT Purchasing Document Attribute SOURCELEDGER Source Ledger Attribute BASEUNIT Base Unit of Measure Attribute PRODUCT Product Attribute LEDGER Ledger Attribute GLACCOUNT G/L Account Attribute SUPPLIER Supplier Attribute ACCOUNTINGDOCUMENT Journal Entry Attribute REFERENCEDOCUMENTITEM Reference Document Item Attribute CLEARINGDATE Clearing Date Attribute PURCHASINGDOCUMENTITEM Purchasing Doc. Item Attribute DOCUMENTDATE Journal Entry Date Attribute FISCALPERIOD Fiscal Period Attribute COMPANYCODECURRENCY Company Code Currency Attribute TRANSACTIONCURRENCY Transaction Currency Attribute FISCALYEAR Fiscal Year Attribute POSTINGDATE Posting Date Attribute CHARTOFACCOUNTS Chart of Accounts Attribute DEBITCREDITCODE Debit/Credit Code Attribute COMPANYCODE Company Code Attribute DEBITCREDITCODENAME D/C Code Name Attribute ACCOUNTINGDOCUMENTHEADERTEXT Document Header Text Attribute DOCUMENTITEMTEXT Item Text Attribute LEDGERGLLINEITEM Journal Entry Item Attribute ACCOUNTINGDOCUMENTTYPE Journal Entry Type Attribute

Constraints
This analytical cube view shall be interpreted and executed by the analytical infrastructure only. It is not intended to be used outside of this context. For example, it shall not be used in ABAP code for selecting data from it.

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Country or Region-Specific Functions for Finance
Application Component	FI-LOC-FI-JP
Capabilities	Data Provider for Analytical Queries,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Country/Region-Specific Functions for Finance for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view retrieves the books of accounts payable for section (5) in Annex 21 of Order for Enforcement of the Corporation Tax Act.</p> This CDS view provides the data to answer the following business question:<ul> <li> <p>How should accounts payable details be shown and listed as an electronic book for claiming corporate tax as "blue return"?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Public Edition — Explore SAP S/4HANA Cloud Public Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_JP_ANNEX215APBOOK	P_JP_ANNEX215APBOOK	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_AccountingDocument	_Header	`$projection.CompanyCode = _Header.CompanyCode and $projection.FiscalYear = _Header.FiscalYear and $projection.AccountingDocument = _Header.AccountingDocument`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	IJPANX205CUBE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
Analytics.dataExtraction.enabled	false	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
Analytics.internalName	#LOCAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
EndUserText.label	Japan AP Book for Corporate Tax - Cube	view

Fields (50)

Key	Field	Source Table	Source Field	Description
KEY	Supplier		Supplier	Supplier
KEY	SourceLedger		SourceLedger	Source Ledger
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	LedgerGLLineItem		LedgerGLLineItem	General Ledger Journal Entry Line Item
KEY	Ledger		Ledger	Ledger in General Ledger Accounting
	PurchasingDocument		PurchasingDocument	Purchasing Document
	JP_Annex205APLeadingAcctgDoc		JP_Annex205APLeadingAcctgDoc	Japan Annex21(5) Leading Accounting Document Number
	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
	FiscalPeriod		FiscalPeriod	Fiscal Period
	PostingDate		PostingDate	Posting Date for GR
	DocumentDate		DocumentDate	Journal Entry Date
	ClearingDate		ClearingDate	Clearing Date
	AccountingDocumentHeaderText	_Header	AccountingDocumentHeaderText	Document Header Text
	DocumentItemText		DocumentItemText	Item Text
	ChartOfAccounts		ChartOfAccounts	Chart of Accounts
	GLAccount		GLAccount	General Ledger
	ReferenceDocument		ReferenceDocument	Reference Doc. Number
	ReferenceDocumentItem		ReferenceDocumentItem	Reference Document Item
	PurchasingDocumentItem		PurchasingDocumentItem	Purchasing Document Item
	Product		Product	Product Sold
	DebitCreditCodeName		DebitCreditCodeName	Debit/Credit Code Name
	DebitCreditCode		DebitCreditCode	Single-Character Flag
	TransactionCurrency		TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency			Amount in Transaction Currency
	CompanyCodeCurrency		CompanyCodeCurrency	Company Code Currency
	AmountInCompanyCodeCurrency			Amount in Company Code Currency
	BaseUnit		BaseUnit	Base Unit of Measure
	Quantity			Quantity of Japan Annex21
	OrderPriceUnit	_PurchasingDocumentItem	OrderPriceUnit	Order Price Unit (Purchasing)
	NetPriceQuantity			Net price quantity
	NetPriceAmount	_PurchasingDocumentItem	NetPriceAmount	Net Price in Purchasing Document (in Document Currency)
	DocumentCurrency	_PurchasingDocumentItem	DocumentCurrency	Document Currency
	_SourceLedger		_SourceLedger
	_CompanyCode		_CompanyCode
	_FiscalYear		_FiscalYear
	_JournalEntry		_JournalEntry
	_Ledger		_Ledger
	_Supplier		_Supplier
	_Product		_Product
	_PurchasingDocument		_PurchasingDocument
	_PurchasingDocumentItem		_PurchasingDocumentItem
	_TransactionCurrency		_TransactionCurrency
	_CompanyCodeCurrency		_CompanyCodeCurrency
	_BaseUnit		_BaseUnit
	_DebitCreditCode		_DebitCreditCode
	_GLAccountInChartOfAccounts		_GLAccountInChartOfAccounts
	_ChartOfAccounts		_ChartOfAccounts
	_AccountingDocumentType		_AccountingDocumentType

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_JP_Annex205APBookCube.
-- 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: IJPANX205CUBE

CREATE VIEW I_JP_Annex205APBookCube AS
SELECT
  Supplier,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  PurchasingDocument,
  JP_Annex205APLeadingAcctgDoc,
  AccountingDocumentType,
  FiscalPeriod,
  PostingDate,
  DocumentDate,
  ClearingDate,
  _Header.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  DocumentItemText,
  ChartOfAccounts,
  GLAccount,
  ReferenceDocument,
  ReferenceDocumentItem,
  PurchasingDocumentItem,
  Product,
  DebitCreditCodeName,
  DebitCreditCode,
  TransactionCurrency,
  cast( AmountInTransactionCurrency as fis_wsl preserving type ) AS AmountInTransactionCurrency,
  CompanyCodeCurrency,
  cast( AmountInCompanyCodeCurrency as fis_hsl preserving type ) AS AmountInCompanyCodeCurrency,
  BaseUnit,
  cast( abs(Quantity) as glo_jp_anx20_quantity preserving type ) AS Quantity,
  _PurchasingDocumentItem.OrderPriceUnit AS OrderPriceUnit,
  cast( _PurchasingDocumentItem.NetPriceQuantity as glo_jp_netpriceqty ) AS NetPriceQuantity,
  _PurchasingDocumentItem.NetPriceAmount AS NetPriceAmount,
  _PurchasingDocumentItem.DocumentCurrency AS DocumentCurrency
FROM P_JP_ANNEX215APBOOK
LEFT OUTER JOIN I_AccountingDocument AS _Header ON CompanyCode = _Header.CompanyCode AND FiscalYear = _Header.FiscalYear AND AccountingDocument = _Header.AccountingDocument  -- association [1..1]
;

Depth:

I_JP_Annex205APBookCube view

P_JP_ANNEX215APBOOK view

C_JP_Annex205APBookQuery view