P_KZ_StRpManageWhldgTaxItemdoc

DDL: P_KZ_STRPMANAGEWHLDGTAXITEMDOC Type: view_entity COMPOSITE Package: GLO_FIN_IS_WHT_KZ
65 Fields 1 Data Sources 1 Associations

Manage Withholding Tax Items View for kazakhstan

P_KZ_StRpManageWhldgTaxItemdoc is a Composite CDS View that provides data about "Manage Withholding Tax Items View for kazakhstan" in SAP S/4HANA. It reads from 1 data source (I_StRpManageWhldgTaxItemC) and exposes 65 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType. It has 1 association to related views. Part of development package GLO_FIN_IS_WHT_KZ.

Data Sources (1)

SourceAliasJoin Type
I_StRpManageWhldgTaxItemC I_StRpManageWhldgTaxItemC from

Parameters (2)

NameTypeDefault
P_WhldgTaxReportingFromDate whtdate
P_WhldgTaxReportingToDate whtdate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_OperationalAcctgDocItem _OperationalAcctgDocItem _OperationalAcctgDocItem.CompanyCode = wht.CompanyCode and _OperationalAcctgDocItem.ClearingJournalEntry = wht.AccountingDocument and _OperationalAcctgDocItem.ClearingJournalEntry <> _OperationalAcctgDocItem.AccountingDocument

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Manage Withholding Tax Items View for kazakhstan view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode wht CompanyCode Receiver Company Code
KEY AccountingDocument wht AccountingDocument Journal Entry
KEY FiscalYear wht FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem wht AccountingDocumentItem Posting View Item
KEY WithholdingTaxType wht WithholdingTaxType WTax Type
WithholdingTaxCode wht WithholdingTaxCode WTax Code
PostingDate wht PostingDate Posting Date for GR
DocumentDate wht DocumentDate Journal Entry Date
WithholdingTaxReportingDate wht WithholdingTaxReportingDate Withholding Tax Reporting Date
OriginalReferenceDocument wht OriginalReferenceDocument Reference Key
CompanyCodeName wht CompanyCodeName Company Name
AccountingDocumentType wht AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName wht AccountingDocumentTypeName
AccountingDocumentHeaderText wht AccountingDocumentHeaderText Doc.Header Text
GLAccount wht GLAccount General Ledger
OfficialWhldgTaxCode wht OfficialWhldgTaxCode
WhldgTaxReferenceText wht WhldgTaxReferenceText
SupplierRecipientType wht SupplierRecipientType
WithholdingTaxIncomeType wht WithholdingTaxIncomeType
BusinessPlace wht BusinessPlace Business place
TaxSection wht TaxSection Tax Section
Country wht Country Venue: Ctry/Reg
Creditor wht Creditor Supplier
Debtor wht Debtor Debtor
Customer wht Customer Sold-to Party
Supplier wht Supplier Supplier
BusinessPartner wht BusinessPartner Issuing Authority
BusinessPartnerNumber wht BusinessPartnerNumber
BusinessPartnerCategory wht BusinessPartnerCategory Partner Cat.
Name wht Name Zone name
BusinessPartnerCountry wht BusinessPartnerCountry BP Ctry/Reg.
ReportingCurrency wht ReportingCurrency Currency
WhldgTaxBaseAmtInCoCodeCrcy wht WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxAmtInCoCodeCrcy wht WhldgTaxAmtInCoCodeCrcy
StatryRptRunStatus wht StatryRptRunStatus
WithholdingTaxTypeName wht WithholdingTaxTypeName
WhldgTaxCodeName wht WhldgTaxCodeName
SenderCompanyCode wht SenderCompanyCode Sender Company Code
SenderAccountingDocument wht SenderAccountingDocument Sender Journal Entry
SenderFiscalYear wht SenderFiscalYear Sender FiscalYr
SenderLogicalSystem wht SenderLogicalSystem Sender Logical System
TransactionTypeDetermination wht TransactionTypeDetermination Transaction Key
ChartOfAccounts wht ChartOfAccounts Node Class
TaxItemIsIncluded wht TaxItemIsIncluded
TotalNumberOfComments wht TotalNumberOfComments
NewWhldgTaxReportingDate wht NewWhldgTaxReportingDate
OldWhldgTaxReportingDate wht OldWhldgTaxReportingDate
LastChangedByUser wht LastChangedByUser User Name
UserDescription wht UserDescription Full Name
ChangedOnLongDateTime wht ChangedOnLongDateTime
IsReversal wht IsReversal Reversal doc.
IsReversed wht IsReversed Reversed?
WhldgTaxRptgDateIsActive wht WhldgTaxRptgDateIsActive
ClearingDate wht ClearingDate Clearing Date
WhldgTaxDocumentType wht WhldgTaxDocumentType 3-Byte field
ItemIsReportingRelevant wht ItemIsReportingRelevant Item Reporting Relv
_AccountingDocumentTypeText wht _AccountingDocumentTypeText
_TransactionTypeStdGLAcct wht _TransactionTypeStdGLAcct
clearingInvoice _OperationalAcctgDocItem AccountingDocument Journal Entry
clearingJounralEntry _OperationalAcctgDocItem ClearingJournalEntry Clrng doc.
InvoiceReference _OperationalAcctgDocItem InvoiceReference Invoice Reference
WithholdingTaxBaseAmount _OperationalAcctgDocItem WithholdingTaxBaseAmount WTax Base Amt
WithholdingTaxAmount _OperationalAcctgDocItem WithholdingTaxAmount Withholding Tax Amt
ReportingYear
NewReportingYear

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_KZ_StRpManageWhldgTaxItemdoc.
-- 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_WhldgTaxReportingFromDate : whtdate, P_WhldgTaxReportingToDate : whtdate

CREATE VIEW P_KZ_StRpManageWhldgTaxItemdoc 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.PostingDate AS PostingDate,
  wht.DocumentDate AS DocumentDate,
  wht.WithholdingTaxReportingDate AS WithholdingTaxReportingDate,
  wht.OriginalReferenceDocument AS OriginalReferenceDocument,
  wht.CompanyCodeName AS CompanyCodeName,
  wht.AccountingDocumentType AS AccountingDocumentType,
  wht.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  wht.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  wht.GLAccount AS GLAccount,
  wht.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  wht.WhldgTaxReferenceText AS WhldgTaxReferenceText,
  wht.SupplierRecipientType AS SupplierRecipientType,
  wht.WithholdingTaxIncomeType AS WithholdingTaxIncomeType,
  wht.BusinessPlace AS BusinessPlace,
  wht.TaxSection AS TaxSection,
  wht.Country AS Country,
  wht.Creditor AS Creditor,
  wht.Debtor AS Debtor,
  wht.Customer AS Customer,
  wht.Supplier AS Supplier,
  wht.BusinessPartner AS BusinessPartner,
  wht.BusinessPartnerNumber AS BusinessPartnerNumber,
  wht.BusinessPartnerCategory AS BusinessPartnerCategory,
  wht.Name AS Name,
  wht.BusinessPartnerCountry AS BusinessPartnerCountry,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  wht.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  wht.StatryRptRunStatus AS StatryRptRunStatus,
  wht.WithholdingTaxTypeName AS WithholdingTaxTypeName,
  wht.WhldgTaxCodeName AS WhldgTaxCodeName,
  wht.SenderCompanyCode AS SenderCompanyCode,
  wht.SenderAccountingDocument AS SenderAccountingDocument,
  wht.SenderFiscalYear AS SenderFiscalYear,
  wht.SenderLogicalSystem AS SenderLogicalSystem,
  wht.TransactionTypeDetermination AS TransactionTypeDetermination,
  wht.ChartOfAccounts AS ChartOfAccounts,
  wht.TaxItemIsIncluded AS TaxItemIsIncluded,
  wht.TotalNumberOfComments AS TotalNumberOfComments,
  wht.NewWhldgTaxReportingDate AS NewWhldgTaxReportingDate,
  wht.OldWhldgTaxReportingDate AS OldWhldgTaxReportingDate,
  wht.LastChangedByUser AS LastChangedByUser,
  wht.UserDescription AS UserDescription,
  wht.ChangedOnLongDateTime AS ChangedOnLongDateTime,
  wht.IsReversal AS IsReversal,
  wht.IsReversed AS IsReversed,
  wht.WhldgTaxRptgDateIsActive AS WhldgTaxRptgDateIsActive,
  wht.ClearingDate AS ClearingDate,
  wht.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  wht.ItemIsReportingRelevant AS ItemIsReportingRelevant,
  wht._AccountingDocumentTypeText AS _AccountingDocumentTypeText,
  wht._TransactionTypeStdGLAcct AS _TransactionTypeStdGLAcct,
  _OperationalAcctgDocItem.AccountingDocument AS clearingInvoice,
  _OperationalAcctgDocItem.ClearingJournalEntry AS clearingJounralEntry,
  _OperationalAcctgDocItem.InvoiceReference AS InvoiceReference,
  _OperationalAcctgDocItem.WithholdingTaxBaseAmount AS WithholdingTaxBaseAmount,
  _OperationalAcctgDocItem.WithholdingTaxAmount AS WithholdingTaxAmount,
  substring( wht.WithholdingTaxReportingDate, 1, 4) AS ReportingYear,
  substring( wht.NewWhldgTaxReportingDate, 1, 4) AS NewReportingYear
FROM I_StRpManageWhldgTaxItemC
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON _OperationalAcctgDocItem.CompanyCode = wht.CompanyCode AND _OperationalAcctgDocItem.ClearingJournalEntry = wht.AccountingDocument AND _OperationalAcctgDocItem.ClearingJournalEntry <> _OperationalAcctgDocItem.AccountingDocument  -- association [1..1]
;

Learn More