P_JP_STRPWHLDGTAXITEM

DDL: P_JP_STRPWHLDGTAXITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_WHT_JP
14 Fields 1 Data Sources

Private view Japan White Return

P_JP_STRPWHLDGTAXITEM is a Composite CDS View that provides data about "Private view Japan White Return" in SAP S/4HANA. It reads from 1 data source (P_StRpWhldgTaxItemLog) and exposes 14 fields with key fields CompanyCode, AccountingDocument, AccountingDocumentItem, FiscalYear, WithholdingTaxType. Part of development package GLO_FIN_IS_WHT_JP.

Data Sources (1)

SourceAliasJoin Type
P_StRpWhldgTaxItemLog wht from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_StRpWhldgTaxItemLog CompanyCode Receiver Company Code
KEY AccountingDocument P_StRpWhldgTaxItemLog AccountingDocument Journal Entry
KEY AccountingDocumentItem P_StRpWhldgTaxItemLog AccountingDocumentItem Posting View Item
KEY FiscalYear P_StRpWhldgTaxItemLog FiscalYear G/L Fiscal Year
KEY WithholdingTaxType P_StRpWhldgTaxItemLog WithholdingTaxType WTax Type
KEY WithholdingTaxCode P_StRpWhldgTaxItemLog WithholdingTaxCode WTax Code
PostingDate P_StRpWhldgTaxItemLog PostingDate Posting Date for GR
WhldgTaxDocumentType P_StRpWhldgTaxItemLog WhldgTaxDocumentType 3-Byte field
BusinessPartner P_StRpWhldgTaxItemLog BusinessPartner Issuing Authority
ClearingDate P_StRpWhldgTaxItemLog ClearingDate Clearing Date
ReportingCurrency P_StRpWhldgTaxItemLog ReportingCurrency Currency
WhldgTaxBaseAmtInCoCodeCrcy P_StRpWhldgTaxItemLog WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxAmtInCoCodeCrcy P_StRpWhldgTaxItemLog WhldgTaxAmtInCoCodeCrcy
Isonetimeaccount

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_JP_STRPWHLDGTAXITEM.
-- 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 P_JP_STRPWHLDGTAXITEM AS
SELECT
  wht.CompanyCode AS CompanyCode,
  wht.AccountingDocument AS AccountingDocument,
  wht.AccountingDocumentItem AS AccountingDocumentItem,
  wht.FiscalYear AS FiscalYear,
  wht.WithholdingTaxType AS WithholdingTaxType,
  wht.WithholdingTaxCode AS WithholdingTaxCode,
  wht.PostingDate AS PostingDate,
  wht.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  wht.BusinessPartner AS BusinessPartner,
  wht.ClearingDate AS ClearingDate,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  wht.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  wht._Supplier.IsOneTimeAccount AS Isonetimeaccount
FROM P_StRpWhldgTaxItemLog AS wht
;

Learn More