P_BE_StRpNotRptdWhldgTaxItem

DDL: P_BE_STRPNOTRPTDWHLDGTAXITEM Type: view_entity COMPOSITE
18 Fields 1 Data Sources

P_BE_StRpNotRptdWhldgTaxItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_BE_StRpRptdWhldgTaxItem) and exposes 18 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
P_BE_StRpRptdWhldgTaxItem P_BE_StRpRptdWhldgTaxItem left_outer

Parameters (3)

NameTypeDefault
P_ReportingEntity srf_reporting_entity
P_ReportCategory srf_rep_cat_id
P_ReportRun srf_report_run_id

Annotations (3)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #CHECK view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_Be_Strpwhldgtaxitem CompanyCode Receiver Company Code
KEY AccountingDocument I_Be_Strpwhldgtaxitem AccountingDocument Journal Entry
KEY FiscalYear I_Be_Strpwhldgtaxitem FiscalYear G/L Fiscal Year
WithholdingTaxType I_Be_Strpwhldgtaxitem WithholdingTaxType WTax Type
WithholdingTaxCode I_Be_Strpwhldgtaxitem WithholdingTaxCode WTax Code
BusinessPlace I_Be_Strpwhldgtaxitem BusinessPlace Business place
FinancialAccountType I_Be_Strpwhldgtaxitem FinancialAccountType Fin. Account Type
PostingDate I_Be_Strpwhldgtaxitem PostingDate Posting Date for GR
DocumentDate I_Be_Strpwhldgtaxitem DocumentDate Journal Entry Date
ReportingDate I_Be_Strpwhldgtaxitem ReportingDate
TaxNumber1 I_Be_Strpwhldgtaxitem TaxNumber1 VAT Reg. No.
VATRegistration I_Be_Strpwhldgtaxitem VATRegistration VAT Registration No.
CustomerSupplierVATRegn I_Be_Strpwhldgtaxitem CustomerSupplierVATRegn
NaturalPersonVATRegistration I_Be_Strpwhldgtaxitem NaturalPersonVATRegistration
WhldgTaxBeneficiaryType I_Be_Strpwhldgtaxitem WhldgTaxBeneficiaryType
StatryRptgEntity
StatryRptCategory
StatryRptRunID

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_BE_StRpNotRptdWhldgTaxItem.
-- 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.
-- Parameters: P_ReportingEntity : srf_reporting_entity, P_ReportCategory : srf_rep_cat_id, P_ReportRun : srf_report_run_id

CREATE VIEW P_BE_StRpNotRptdWhldgTaxItem AS
SELECT
  I_Be_Strpwhldgtaxitem.CompanyCode AS CompanyCode,
  I_Be_Strpwhldgtaxitem.AccountingDocument AS AccountingDocument,
  I_Be_Strpwhldgtaxitem.FiscalYear AS FiscalYear,
  I_Be_Strpwhldgtaxitem.WithholdingTaxType AS WithholdingTaxType,
  I_Be_Strpwhldgtaxitem.WithholdingTaxCode AS WithholdingTaxCode,
  I_Be_Strpwhldgtaxitem.BusinessPlace AS BusinessPlace,
  I_Be_Strpwhldgtaxitem.FinancialAccountType AS FinancialAccountType,
  I_Be_Strpwhldgtaxitem.PostingDate AS PostingDate,
  I_Be_Strpwhldgtaxitem.DocumentDate AS DocumentDate,
  I_Be_Strpwhldgtaxitem.ReportingDate AS ReportingDate,
  I_Be_Strpwhldgtaxitem.TaxNumber1 AS TaxNumber1,
  I_Be_Strpwhldgtaxitem.VATRegistration AS VATRegistration,
  I_Be_Strpwhldgtaxitem.CustomerSupplierVATRegn AS CustomerSupplierVATRegn,
  I_Be_Strpwhldgtaxitem.NaturalPersonVATRegistration AS NaturalPersonVATRegistration,
  I_Be_Strpwhldgtaxitem.WhldgTaxBeneficiaryType AS WhldgTaxBeneficiaryType,
  $parameters.P_ReportingEntity AS StatryRptgEntity,
  $parameters.P_ReportCategory AS StatryRptCategory,
  $parameters.P_ReportRun AS StatryRptRunID
LEFT OUTER JOIN P_BE_StRpRptdWhldgTaxItem ON /* join condition not captured in parsed metadata */
;

Learn More