I_CashJournalWhldgTaxItem

DDL: I_CASHJOURNALWHLDGTAXITEM SQL: ICASHJNLWHTIT Type: view BASIC
14 Fields 1 Data Sources

View for table TCJ_WTAX_ITEMS

I_CashJournalWhldgTaxItem is a Basic CDS View that provides data about "View for table TCJ_WTAX_ITEMS" in SAP S/4HANA. It reads from 1 data source (tcj_wtax_items) and exposes 14 fields with key fields CompanyCode, CashJournal, FiscalYear, CashJournalDocumentInternalID, CashJournalDocumentItem.

Data Sources (1)

SourceAliasJoin Type
tcj_wtax_items tcj_wtax_items from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICASHJNLWHTIT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View for table TCJ_WTAX_ITEMS view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode comp_code Procuring Comp. Cde
KEY CashJournal cajo_number Cash Journal Number
KEY FiscalYear fisc_year Year
KEY CashJournalDocumentInternalID posting_number Internal doc. number
KEY CashJournalDocumentItem position_number Item
KEY WithholdingTaxType wtaxtype WTax Type
Supplier vendor_no Supplier
WithholdingTaxCode wt_withcd W/Tax Code
WithholdingTaxBaseAmount wt_qsshb W/Tax Base FC
ManuallyEnteredWhldgTaxAmount wt_qbuihb Manual W/Tax in FC
WhldgTaxBaseIsEnteredManually wt_basman W/Tax Base Man.
WhldgTaxIsEnteredManually wt_amnman WTax Amt Ent. Man.
AccountType koart Account type
CustomerSupplierAccount wt_acco Cust./Vend. Acct

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 I_CashJournalWhldgTaxItem.
-- 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: ICASHJNLWHTIT

CREATE VIEW I_CashJournalWhldgTaxItem AS
SELECT
  comp_code AS CompanyCode,
  cajo_number AS CashJournal,
  fisc_year AS FiscalYear,
  posting_number AS CashJournalDocumentInternalID,
  position_number AS CashJournalDocumentItem,
  wtaxtype AS WithholdingTaxType,
  vendor_no AS Supplier,
  wt_withcd AS WithholdingTaxCode,
  wt_qsshb AS WithholdingTaxBaseAmount,
  wt_qbuihb AS ManuallyEnteredWhldgTaxAmount,
  wt_basman AS WhldgTaxBaseIsEnteredManually,
  wt_amnman AS WhldgTaxIsEnteredManually,
  koart AS AccountType,
  wt_acco AS CustomerSupplierAccount
FROM tcj_wtax_items
;

Learn More