P_KR_WhldgInhabitanttaxitm

DDL: P_KR_WHLDGINHABITANTTAXITM Type: view_entity COMPOSITE Package: GLO_FIN_IS_WHT_KR
15 Fields 2 Data Sources

Inhaitant tax line details for Korea

P_KR_WhldgInhabitanttaxitm is a Composite CDS View that provides data about "Inhaitant tax line details for Korea" in SAP S/4HANA. It reads from 2 data sources (I_WithholdingTaxType, P_StRpWhldgTaxItemLog) and exposes 15 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType. Part of development package GLO_FIN_IS_WHT_KR.

Data Sources (2)

SourceAliasJoin Type
I_WithholdingTaxType _taxtype inner
P_StRpWhldgTaxItemLog P_StRpWhldgTaxItemLog from

Annotations (8)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_StRpWhldgTaxItemLog CompanyCode Receiver Company Code
KEY AccountingDocument P_StRpWhldgTaxItemLog AccountingDocument Journal Entry
KEY FiscalYear P_StRpWhldgTaxItemLog FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem P_StRpWhldgTaxItemLog AccountingDocumentItem Posting View Item
KEY WithholdingTaxType P_StRpWhldgTaxItemLog WithholdingTaxType WTax Type
KEY WithholdingTaxCode P_StRpWhldgTaxItemLog WithholdingTaxCode WTax Code
ClearingJournalEntry P_StRpWhldgTaxItemLog ClearingJournalEntry Clrng doc.
WhldgTaxDocumentType P_StRpWhldgTaxItemLog WhldgTaxDocumentType 3-Byte field
BusinessPartner P_StRpWhldgTaxItemLog BusinessPartner Issuing Authority
BusinessPlace P_StRpWhldgTaxItemLog BusinessPlace Business place
DependencyNmbrOfWhldgTaxType I_WithholdingTaxType DependencyNmbrOfWhldgTaxType Depend. on Type No.
WithholdingTaxPercent
ReportingCurrency P_StRpWhldgTaxItemLog ReportingCurrency Currency
WhldgTaxBaseAmtInCoCodeCrcy P_StRpWhldgTaxItemLog WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxAmtInCoCodeCrcy P_StRpWhldgTaxItemLog WhldgTaxAmtInCoCodeCrcy

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_KR_WhldgInhabitanttaxitm.
-- 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_KR_WhldgInhabitanttaxitm AS
SELECT
  P_StRpWhldgTaxItemLog.CompanyCode AS CompanyCode,
  P_StRpWhldgTaxItemLog.AccountingDocument AS AccountingDocument,
  P_StRpWhldgTaxItemLog.FiscalYear AS FiscalYear,
  P_StRpWhldgTaxItemLog.AccountingDocumentItem AS AccountingDocumentItem,
  P_StRpWhldgTaxItemLog.WithholdingTaxType AS WithholdingTaxType,
  P_StRpWhldgTaxItemLog.WithholdingTaxCode AS WithholdingTaxCode,
  P_StRpWhldgTaxItemLog.ClearingJournalEntry AS ClearingJournalEntry,
  P_StRpWhldgTaxItemLog.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  P_StRpWhldgTaxItemLog.BusinessPartner AS BusinessPartner,
  P_StRpWhldgTaxItemLog.BusinessPlace AS BusinessPlace,
  _taxtype.DependencyNmbrOfWhldgTaxType AS DependencyNmbrOfWhldgTaxType,
  P_StRpWhldgTaxItemLog._WithholdingTaxCode.WithholdingTaxPercent AS WithholdingTaxPercent,
  P_StRpWhldgTaxItemLog.ReportingCurrency AS ReportingCurrency,
  P_StRpWhldgTaxItemLog.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  P_StRpWhldgTaxItemLog.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy
FROM P_StRpWhldgTaxItemLog
INNER JOIN I_WithholdingTaxType AS _taxtype ON /* join condition not captured in parsed metadata */
;

Learn More