C_JP_Annex205APBookQuery

DDL: C_JP_ANNEX205APBOOKQUERY SQL: CJPANX205QUERY Type: view CONSUMPTION
34 Fields 1 Data Sources

Japan Annex215 AP Book - Query

C_JP_Annex205APBookQuery (Consumption)

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

C_JP_Annex205APBookQuery is a Consumption CDS View that provides data about "Japan Annex215 AP Book - Query" in SAP S/4HANA. It reads from 1 data source (I_JP_Annex205APBookCube) and exposes 34 fields with key fields Supplier, SourceLedger, CompanyCode, FiscalYear, JP_Annex205APLeadingAcctgDoc.

SAP Help Documentation

CategoryAnnex 21 Books in Corporate Tax
StatusReleased
Corresponding DataSource2CCJPANX205QUERY
Purpose
This CDS view retrieves the books of accounts payable for section (5) in Annex 21 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 the following authorization objects assigned: F_BKPF_BUK (Accounting Document: Authorization for Company Codes)

Structure
Fields used for filtering The main filters are as follows: Mandatory filters: CompanyCode FiscalYear Ledger FiscalPeriod Optional filters: Supplier PostingDate Further important fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment SUPPLIER Supplier Number Attribute - ACCOUNTINGDOCUMENT Journal Entry Attribute - POSTINGDATE Posting Date Attribute - PRODUCT Product Number Attribute - QUANTITY Quantity Measure - NETPRICEAMOUNT Net Price Measure Net amount divided by billing quantity ACCTSRBLAMTINCCCRCY Account Receivable Amount Measure -

Constraints
This analytical query 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

StateC1
Line of BusinessCountry or Region-Specific Functions for Finance
Application ComponentFI-LOC-FI-JP
CapabilitiesAnalytical Query
PackageCountry or Region-Specific Functions for Finance for SAP S/4HANA Cloud Private 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

Data Sources (1)

SourceAliasJoin Type
I_JP_Annex205APBookCube I_JP_Annex205APBookCube from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CJPANX205QUERY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Japan Annex215 AP Book - Query view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY JP_Annex205APLeadingAcctgDoc JP_Annex205APLeadingAcctgDoc Japan Annex21(5) Leading Accounting Document Number
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem General Ledger Journal Entry Line Item
KEY Ledger Ledger Ledger in General Ledger Accounting
FiscalPeriod FiscalPeriod Fiscal Period
PostingDate PostingDate Posting Date for GR
AccountingDocumentType AccountingDocumentType Journal Entry Type
DocumentDate DocumentDate Journal Entry Date
ClearingDate ClearingDate Clearing Date
AccountingDocumentHeaderText AccountingDocumentHeaderText Document Header Text
DocumentItemText DocumentItemText Item Text
ChartOfAccounts ChartOfAccounts Chart of Accounts
GLAccount GLAccount General Ledger
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Document Item
DebitCreditCode DebitCreditCode Single-Character Flag
ReferenceDocument ReferenceDocument Reference Doc. Number
ReferenceDocumentItem ReferenceDocumentItem Reference Document Item
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Amount in Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Company Code Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Amount in Company Code Currency
AcctsPyblAmtInCCCrcy AcctsPyblAmtInCCCrcy Increase (Decrease) in Accounts Payable (Net)
Product Product Product Number
BaseUnit BaseUnit Base Unit of Measure
Quantity Quantity Quantity of Japan Annex21
DocumentCurrency DocumentCurrency Document Currency
OrderPriceUnit OrderPriceUnit Order Price Unit (Purchasing)
NetPriceQuantity NetPriceQuantity Net price quantity
NetPriceAmount NetPriceAmount Net Price in Purchasing Document (in Document Currency)

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_JP_Annex205APBookQuery.
-- 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: CJPANX205QUERY

CREATE VIEW C_JP_Annex205APBookQuery AS
SELECT
  Supplier,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  JP_Annex205APLeadingAcctgDoc,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  FiscalPeriod,
  PostingDate,
  AccountingDocumentType,
  DocumentDate,
  ClearingDate,
  AccountingDocumentHeaderText,
  DocumentItemText,
  ChartOfAccounts,
  GLAccount,
  PurchasingDocument,
  PurchasingDocumentItem,
  DebitCreditCode,
  ReferenceDocument,
  ReferenceDocumentItem,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  AcctsPyblAmtInCCCrcy,
  Product,
  BaseUnit,
  Quantity,
  DocumentCurrency,
  OrderPriceUnit,
  NetPriceQuantity,
  NetPriceAmount
FROM I_JP_Annex205APBookCube
;

Learn More