C_EG_StRpStampTaxItem

DDL: C_EG_STRPSTAMPTAXITEM SQL: CEGSRTISTAMPTX Type: view CONSUMPTION
62 Fields 2 Data Sources

Stamp Tax Item View For Statutory Reporting for Egypt

C_EG_StRpStampTaxItem is a Consumption CDS View that provides data about "Stamp Tax Item View For Statutory Reporting for Egypt" in SAP S/4HANA. It reads from 2 data sources (I_StRpWhldgTaxItem, I_StRpWhldgTaxItem) and exposes 62 fields with key fields ClearingAccountingDocument, FiscalYear, CompanyCode, WithholdingTaxType, StatryRptgEntity.

Data Sources (2)

SourceAliasJoin Type
I_StRpWhldgTaxItem wht2 inner
I_StRpWhldgTaxItem wht2 inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CEGSRTISTAMPTX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Stamp Tax Item View For Statutory Reporting for Egypt view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY ClearingAccountingDocument wht AccountingDocument Journal Entry
KEY FiscalYear wht FiscalYear G/L Fiscal Year
KEY CompanyCode wht CompanyCode Receiver Company Code
KEY WithholdingTaxType wht WithholdingTaxType WTax Type
KEY StatryRptgEntity wht StatryRptgEntity Reporting Entity
KEY StatryRptCategory wht StatryRptCategory Report ID
KEY StatryRptRunID wht StatryRptRunID Report Run ID
KEY AccountingDocument I_StRpWhldgTaxItem AccountingDocument Journal Entry
WithholdingTaxCode wht WithholdingTaxCode WTax Code
WhldgTaxBaseAmtInCoCodeCrcy I_StRpWhldgTaxItem WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxAmtInCoCodeCrcy I_StRpWhldgTaxItem WhldgTaxAmtInCoCodeCrcy
WithholdingTaxPercent I_StRpWhldgTaxItem WithholdingTaxPercent
ItemIsReportingRelevant
BusinessPartnerCountry wht BusinessPartnerCountry BP Ctry/Reg.
BusinessPartner wht BusinessPartner Issuing Authority
FiscalPeriod wht FiscalPeriod Tax period
BusinessPartnerNumber wht BusinessPartnerNumber
FinancialAccountType wht FinancialAccountType Fin. Account Type
CityName wht CityName Name
PostalCode wht PostalCode Postal Code
StreetName wht StreetName Text
Region wht Region Venue Region
DocumentReferenceID wht DocumentReferenceID Reference
DocumentDate wht DocumentDate Journal Entry Date
PostingDate wht PostingDate Posting Date for GR
ReportingDate wht ReportingDate
ReportingCurrency wht ReportingCurrency Currency
SupplierRecipientType wht SupplierRecipientType
Creditor wht Creditor Supplier
Debtor wht Debtor Debtor
_Supplier wht _Supplier
KEY FiscalYear wht FiscalYear G/L Fiscal Year
KEY CompanyCode wht CompanyCode Receiver Company Code
KEY WithholdingTaxType wht WithholdingTaxType WTax Type
KEY StatryRptgEntity wht StatryRptgEntity Reporting Entity
KEY StatryRptCategory wht StatryRptCategory Report ID
KEY StatryRptRunID wht StatryRptRunID Report Run ID
KEY AccountingDocument I_StRpWhldgTaxItem AccountingDocument Journal Entry
WithholdingTaxCode wht WithholdingTaxCode WTax Code
WhldgTaxBaseAmtInCoCodeCrcy wht WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxAmtInCoCodeCrcy wht WhldgTaxAmtInCoCodeCrcy
WithholdingTaxPercent wht WithholdingTaxPercent
ItemIsReportingRelevant
BusinessPartnerCountry wht BusinessPartnerCountry BP Ctry/Reg.
BusinessPartner wht BusinessPartner Issuing Authority
FiscalPeriod wht FiscalPeriod Tax period
BusinessPartnerNumber wht BusinessPartnerNumber
FinancialAccountType wht FinancialAccountType Fin. Account Type
CityName wht CityName Name
PostalCode wht PostalCode Postal Code
StreetName wht StreetName Text
Region wht Region Venue Region
DocumentReferenceID wht DocumentReferenceID Reference
DocumentDate wht DocumentDate Journal Entry Date
PostingDate wht PostingDate Posting Date for GR
ReportingDate wht ReportingDate
ReportingCurrency wht ReportingCurrency Currency
SupplierRecipientType wht SupplierRecipientType
Creditor wht Creditor Supplier
Debtor wht Debtor Debtor
_Supplier wht _Supplier
_Customer wht _Customer

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 C_EG_StRpStampTaxItem.
-- 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: CEGSRTISTAMPTX

CREATE VIEW C_EG_StRpStampTaxItem AS
SELECT
  wht.AccountingDocument AS ClearingAccountingDocument,
  wht.FiscalYear AS FiscalYear,
  wht.CompanyCode AS CompanyCode,
  wht.WithholdingTaxType AS WithholdingTaxType,
  wht.StatryRptgEntity AS StatryRptgEntity,
  wht.StatryRptCategory AS StatryRptCategory,
  wht.StatryRptRunID AS StatryRptRunID,
  wht2.AccountingDocument AS AccountingDocument,
  wht.WithholdingTaxCode AS WithholdingTaxCode,
  wht2.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  wht2.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  wht2.WithholdingTaxPercent AS WithholdingTaxPercent,
  ' ' AS ItemIsReportingRelevant,
  wht.BusinessPartnerCountry AS BusinessPartnerCountry,
  wht.BusinessPartner AS BusinessPartner,
  wht.FiscalPeriod AS FiscalPeriod,
  wht.BusinessPartnerNumber AS BusinessPartnerNumber,
  wht.FinancialAccountType AS FinancialAccountType,
  wht.CityName AS CityName,
  wht.PostalCode AS PostalCode,
  wht.StreetName AS StreetName,
  wht.Region AS Region,
  wht.DocumentReferenceID AS DocumentReferenceID,
  wht.DocumentDate AS DocumentDate,
  wht.PostingDate AS PostingDate,
  wht.ReportingDate AS ReportingDate,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.SupplierRecipientType AS SupplierRecipientType,
  wht.Creditor AS Creditor,
  wht.Debtor AS Debtor,
  wht._Supplier AS _Supplier,
  wht._Customer AS _Customer
INNER JOIN I_StRpWhldgTaxItem AS wht2 ON /* join condition not captured in parsed metadata */
;

Learn More