P_CL_STRPWHLDGTAXITEMLOG

DDL: P_CL_STRPWHLDGTAXITEMLOG Type: view_entity COMPOSITE
29 Fields 1 Data Sources

Private Log View - WTax Chile

P_CL_STRPWHLDGTAXITEMLOG is a Composite CDS View that provides data about "Private Log View - WTax Chile" in SAP S/4HANA. It reads from 1 data source (P_StRpWhldgTaxItemLog) and exposes 29 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType.

Data Sources (1)

SourceAliasJoin Type
P_StRpWhldgTaxItemLog wht from

Parameters (2)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id

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
EndUserText.label Private Log View - WTax Chile view

Fields (29)

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
WithholdingTaxCode P_StRpWhldgTaxItemLog WithholdingTaxCode WTax Code
OfficialWhldgTaxCode P_StRpWhldgTaxItemLog OfficialWhldgTaxCode
Country P_StRpWhldgTaxItemLog Country Venue: Ctry/Reg
Creditor P_StRpWhldgTaxItemLog Creditor Supplier
BusinessPartner P_StRpWhldgTaxItemLog BusinessPartner Issuing Authority
WithholdingTaxReportingDate P_StRpWhldgTaxItemLog WithholdingTaxReportingDate Withholding Tax Reporting Date
PostingDate P_StRpWhldgTaxItemLog PostingDate Posting Date for GR
DocumentDate P_StRpWhldgTaxItemLog DocumentDate Journal Entry Date
ClearingDate P_StRpWhldgTaxItemLog ClearingDate Clearing Date
ClearingJournalEntry P_StRpWhldgTaxItemLog ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear P_StRpWhldgTaxItemLog ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
InvoiceReference P_StRpWhldgTaxItemLog InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear P_StRpWhldgTaxItemLog InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
IsReversed P_StRpWhldgTaxItemLog IsReversed Reversed?
IsReversal P_StRpWhldgTaxItemLog IsReversal Reversal doc.
ReportingCurrency P_StRpWhldgTaxItemLog ReportingCurrency Currency
FinancialAccountType P_StRpWhldgTaxItemLog FinancialAccountType Fin. Account Type
WhldgTaxBaseAmtInCoCodeCrcy P_StRpWhldgTaxItemLog WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxAmtInCoCodeCrcy P_StRpWhldgTaxItemLog WhldgTaxAmtInCoCodeCrcy
WithholdingTaxIncomeType P_StRpWhldgTaxItemLog WithholdingTaxIncomeType
WhldgTaxDocumentType P_StRpWhldgTaxItemLog WhldgTaxDocumentType 3-Byte field
Name P_StRpWhldgTaxItemLog Name Zone name
BusinessPartnerCountry P_StRpWhldgTaxItemLog BusinessPartnerCountry BP Ctry/Reg.
BusinessPartnerCategory

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_CL_STRPWHLDGTAXITEMLOG.
-- 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_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id

CREATE VIEW P_CL_STRPWHLDGTAXITEMLOG AS
SELECT
  wht.CompanyCode AS CompanyCode,
  wht.AccountingDocument AS AccountingDocument,
  wht.FiscalYear AS FiscalYear,
  wht.AccountingDocumentItem AS AccountingDocumentItem,
  wht.WithholdingTaxType AS WithholdingTaxType,
  wht.WithholdingTaxCode AS WithholdingTaxCode,
  wht.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  wht.Country AS Country,
  wht.Creditor AS Creditor,
  wht.BusinessPartner AS BusinessPartner,
  wht.WithholdingTaxReportingDate AS WithholdingTaxReportingDate,
  wht.PostingDate AS PostingDate,
  wht.DocumentDate AS DocumentDate,
  wht.ClearingDate AS ClearingDate,
  wht.ClearingJournalEntry AS ClearingJournalEntry,
  wht.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  wht.InvoiceReference AS InvoiceReference,
  wht.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  wht.IsReversed AS IsReversed,
  wht.IsReversal AS IsReversal,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.FinancialAccountType AS FinancialAccountType,
  wht.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  wht.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  wht.WithholdingTaxIncomeType AS WithholdingTaxIncomeType,
  wht.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  wht.Name AS Name,
  wht.BusinessPartnerCountry AS BusinessPartnerCountry,
  wht._Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory
FROM P_StRpWhldgTaxItemLog AS wht
;

Learn More