C_EG_StRpTaxItemWithPricing

DDL: C_EG_STRPTAXITEMWITHPRICING SQL: CEGSRTXITMPRI Type: view CONSUMPTION
92 Fields 2 Data Sources

Egypt Tax items with pricing fields

C_EG_StRpTaxItemWithPricing is a Consumption CDS View that provides data about "Egypt Tax items with pricing fields" in SAP S/4HANA. It reads from 2 data sources (C_EG_StRpBillingItem, I_StRpTaxItemWithRefAcctgDoc) and exposes 92 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, TaxItem.

Data Sources (2)

SourceAliasJoin Type
C_EG_StRpBillingItem C_EG_StRpBillingItem left_outer
I_StRpTaxItemWithRefAcctgDoc I_StRpTaxItemWithRefAcctgDoc from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CEGSRTXITMPRI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label Egypt Tax items with pricing fields view

Fields (92)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpTaxItemWithRefAcctgDoc CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpTaxItemWithRefAcctgDoc AccountingDocument Journal Entry
KEY FiscalYear I_StRpTaxItemWithRefAcctgDoc FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_StRpTaxItemWithRefAcctgDoc AccountingDocumentItem Posting View Item
KEY TaxItem I_StRpTaxItemWithRefAcctgDoc TaxItem Tax Item
KEY BillingDocumentItem C_EG_StRpBillingItem BillingDocumentItem Item
KEY PricingDocument C_EG_StRpBillingItem PricingDocument Document Condition
KEY PricingDocumentItem C_EG_StRpBillingItem PricingDocumentItem Item
KEY PricingProcedureStep C_EG_StRpBillingItem PricingProcedureStep Step Number
KEY PricingProcedureCounter C_EG_StRpBillingItem PricingProcedureCounter Pricing Procedure Counter
KEY AccountKeyForGLAccount C_EG_StRpBillingItem AccountKeyForGLAccount Account Key
KEY TaxCode I_StRpTaxItemWithRefAcctgDoc TaxCode Tax Code
KEY TransactionTypeDetermination I_StRpTaxItemWithRefAcctgDoc TransactionTypeDetermination Transaction Key
DebitCreditCode I_StRpTaxItemWithRefAcctgDoc DebitCreditCode Single-Character Flag
TaxRate I_StRpTaxItemWithRefAcctgDoc TaxRate Tax Rate
GLAccount I_StRpTaxItemWithRefAcctgDoc GLAccount General Ledger
TaxItemGroup I_StRpTaxItemWithRefAcctgDoc TaxItemGroup Tax doc. item number
BusinessPlace I_StRpTaxItemWithRefAcctgDoc BusinessPlace Business place
TaxJurisdiction I_StRpTaxItemWithRefAcctgDoc TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction I_StRpTaxItemWithRefAcctgDoc LowestLevelTaxJurisdiction Jurisdict. Code
AccountingDocumentType I_StRpTaxItemWithRefAcctgDoc AccountingDocumentType Journal Entry Type
ReferenceDocumentType I_StRpTaxItemWithRefAcctgDoc ReferenceDocumentType Reference Document Type
ReverseDocument I_StRpTaxItemWithRefAcctgDoc ReverseDocument Reversed With
ReverseDocumentFiscalYear I_StRpTaxItemWithRefAcctgDoc ReverseDocumentFiscalYear Year
DocumentReferenceID I_StRpTaxItemWithRefAcctgDoc DocumentReferenceID Reference
ConditionType I_StRpTaxItemWithRefAcctgDoc ConditionType Condition type
Ledger I_StRpTaxItemWithRefAcctgDoc Ledger Ledger
LedgerGroup I_StRpTaxItemWithRefAcctgDoc LedgerGroup Ledger Group
PostingDate I_StRpTaxItemWithRefAcctgDoc PostingDate Posting Date for GR
DocumentDate I_StRpTaxItemWithRefAcctgDoc DocumentDate Journal Entry Date
TaxReportingDate I_StRpTaxItemWithRefAcctgDoc TaxReportingDate Tax Reporting Date
FiscalPeriod I_StRpTaxItemWithRefAcctgDoc FiscalPeriod Tax period
ExchangeRate I_StRpTaxItemWithRefAcctgDoc ExchangeRate Exchange rate
IsReversal I_StRpTaxItemWithRefAcctgDoc IsReversal Reversal doc.
IsReversed I_StRpTaxItemWithRefAcctgDoc IsReversed Reversed?
AccountingDocumentHeaderText I_StRpTaxItemWithRefAcctgDoc AccountingDocumentHeaderText Doc.Header Text
CompanyCodeCountry I_StRpTaxItemWithRefAcctgDoc CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry I_StRpTaxItemWithRefAcctgDoc ReportingCountry
TaxReturnCountry I_StRpTaxItemWithRefAcctgDoc TaxReturnCountry Reporting C/R
ReportingDate I_StRpTaxItemWithRefAcctgDoc ReportingDate
CompanyCodeCurrency
CountryCurrency I_StRpTaxItemWithRefAcctgDoc CountryCurrency Currency
DocumentCurrency
ReportingCurrency I_StRpTaxItemWithRefAcctgDoc ReportingCurrency Currency
AdditionalCurrency1 I_StRpTaxItemWithRefAcctgDoc AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_StRpTaxItemWithRefAcctgDoc AdditionalCurrency2 Local curr. 3
TaxBaseAmountInRptgCrcy I_StRpTaxItemWithRefAcctgDoc TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy I_StRpTaxItemWithRefAcctgDoc TaxAmountInRptgCrcy Tax Rept. Crcy
TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy
TaxBaseAmountInTransCrcy
TaxAmount
TaxBaseAmountInCountryCrcy I_StRpTaxItemWithRefAcctgDoc TaxBaseAmountInCountryCrcy Base Amount
TaxAmountInCountryCrcy I_StRpTaxItemWithRefAcctgDoc TaxAmountInCountryCrcy Tax Rept. Crcy
TaxBaseAmtInAdditionalCrcy1 I_StRpTaxItemWithRefAcctgDoc TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 I_StRpTaxItemWithRefAcctgDoc TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInAdditionalCurrency1 I_StRpTaxItemWithRefAcctgDoc TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 I_StRpTaxItemWithRefAcctgDoc TaxAmountInAdditionalCurrency2 LC 3 Tax
TaxType I_StRpTaxItemWithRefAcctgDoc TaxType Tax Type
TaxCalculationProcedure I_StRpTaxItemWithRefAcctgDoc TaxCalculationProcedure Tax Procedure
TargetTaxCode I_StRpTaxItemWithRefAcctgDoc TargetTaxCode
EUTaxClassification I_StRpTaxItemWithRefAcctgDoc EUTaxClassification
TaxNumber1 I_StRpTaxItemWithRefAcctgDoc TaxNumber1 VAT Reg. No.
TaxNumber2 I_StRpTaxItemWithRefAcctgDoc TaxNumber2 Tax Number 2
TaxNumber3 I_StRpTaxItemWithRefAcctgDoc TaxNumber3
BusinessPartner I_StRpTaxItemWithRefAcctgDoc BusinessPartner Issuing Authority
BusinessPartnerName I_StRpTaxItemWithRefAcctgDoc BusinessPartnerName Extracted Customer Name
CustomerSupplierAddress I_StRpTaxItemWithRefAcctgDoc CustomerSupplierAddress
TaxIsNotDeductible I_StRpTaxItemWithRefAcctgDoc TaxIsNotDeductible Non-Deductible
SupplierAccountGroup I_StRpTaxItemWithRefAcctgDoc SupplierAccountGroup Account group
MiniOneStopShopTxRptgCntry I_StRpTaxItemWithRefAcctgDoc MiniOneStopShopTxRptgCntry
ReferenceDocumentNumber I_StRpTaxItemWithRefAcctgDoc ReferenceDocumentNumber
ReferenceDocumentFiscalYear I_StRpTaxItemWithRefAcctgDoc ReferenceDocumentFiscalYear Year Cur.Period
BillingDocument I_StRpTaxItemWithRefAcctgDoc BillingDocument SD Document
ReferenceSDDocument I_StRpTaxItemWithRefAcctgDoc ReferenceSDDocument Reference Doc.
RefAccountingDocument I_StRpTaxItemWithRefAcctgDoc RefAccountingDocument Document Number
RefAccountingDocumentPostgDate I_StRpTaxItemWithRefAcctgDoc RefAccountingDocumentPostgDate
BillingQuantityUnit C_EG_StRpBillingItem BillingQuantityUnit Sales Unit
BillingQuantity C_EG_StRpBillingItem BillingQuantity Invoiced Qty
FinancialAccountType FinancialAccountType Fin. Account Type
TaxCountry TaxCountry Tax Ctry/Reg.
_ReportingCurrency _ReportingCurrency
_AccountingDocument _AccountingDocument
_GLAccount _GLAccount
_TaxJurisdiction _TaxJurisdiction
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem
_ReceivablesPayablesItem _ReceivablesPayablesItem
_TaxReceivablesPayablesItem _TaxReceivablesPayablesItem
_TaxTypeText _TaxTypeText
_TaxCodeText _TaxCodeText
_ReportedItemsLog _ReportedItemsLog
_BillingQuantityUnit C_EG_StRpBillingItem _BillingQuantityUnit

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_StRpTaxItemWithPricing.
-- 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: CEGSRTXITMPRI

CREATE VIEW C_EG_StRpTaxItemWithPricing AS
SELECT
  I_StRpTaxItemWithRefAcctgDoc.CompanyCode AS CompanyCode,
  I_StRpTaxItemWithRefAcctgDoc.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemWithRefAcctgDoc.FiscalYear AS FiscalYear,
  I_StRpTaxItemWithRefAcctgDoc.AccountingDocumentItem AS AccountingDocumentItem,
  I_StRpTaxItemWithRefAcctgDoc.TaxItem AS TaxItem,
  C_EG_StRpBillingItem.BillingDocumentItem AS BillingDocumentItem,
  C_EG_StRpBillingItem.PricingDocument AS PricingDocument,
  C_EG_StRpBillingItem.PricingDocumentItem AS PricingDocumentItem,
  C_EG_StRpBillingItem.PricingProcedureStep AS PricingProcedureStep,
  C_EG_StRpBillingItem.PricingProcedureCounter AS PricingProcedureCounter,
  C_EG_StRpBillingItem.AccountKeyForGLAccount AS AccountKeyForGLAccount,
  I_StRpTaxItemWithRefAcctgDoc.TaxCode AS TaxCode,
  I_StRpTaxItemWithRefAcctgDoc.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItemWithRefAcctgDoc.DebitCreditCode AS DebitCreditCode,
  I_StRpTaxItemWithRefAcctgDoc.TaxRate AS TaxRate,
  I_StRpTaxItemWithRefAcctgDoc.GLAccount AS GLAccount,
  I_StRpTaxItemWithRefAcctgDoc.TaxItemGroup AS TaxItemGroup,
  I_StRpTaxItemWithRefAcctgDoc.BusinessPlace AS BusinessPlace,
  I_StRpTaxItemWithRefAcctgDoc.TaxJurisdiction AS TaxJurisdiction,
  I_StRpTaxItemWithRefAcctgDoc.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  I_StRpTaxItemWithRefAcctgDoc.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxItemWithRefAcctgDoc.ReferenceDocumentType AS ReferenceDocumentType,
  I_StRpTaxItemWithRefAcctgDoc.ReverseDocument AS ReverseDocument,
  I_StRpTaxItemWithRefAcctgDoc.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_StRpTaxItemWithRefAcctgDoc.DocumentReferenceID AS DocumentReferenceID,
  I_StRpTaxItemWithRefAcctgDoc.ConditionType AS ConditionType,
  I_StRpTaxItemWithRefAcctgDoc.Ledger AS Ledger,
  I_StRpTaxItemWithRefAcctgDoc.LedgerGroup AS LedgerGroup,
  I_StRpTaxItemWithRefAcctgDoc.PostingDate AS PostingDate,
  I_StRpTaxItemWithRefAcctgDoc.DocumentDate AS DocumentDate,
  I_StRpTaxItemWithRefAcctgDoc.TaxReportingDate AS TaxReportingDate,
  I_StRpTaxItemWithRefAcctgDoc.FiscalPeriod AS FiscalPeriod,
  I_StRpTaxItemWithRefAcctgDoc.ExchangeRate AS ExchangeRate,
  I_StRpTaxItemWithRefAcctgDoc.IsReversal AS IsReversal,
  I_StRpTaxItemWithRefAcctgDoc.IsReversed AS IsReversed,
  I_StRpTaxItemWithRefAcctgDoc.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_StRpTaxItemWithRefAcctgDoc.CompanyCodeCountry AS CompanyCodeCountry,
  I_StRpTaxItemWithRefAcctgDoc.ReportingCountry AS ReportingCountry,
  I_StRpTaxItemWithRefAcctgDoc.TaxReturnCountry AS TaxReturnCountry,
  I_StRpTaxItemWithRefAcctgDoc.ReportingDate AS ReportingDate,
  coalesce( C_EG_StRpBillingItem.CompanyCodeCurrency, I_StRpTaxItemWithRefAcctgDoc.CompanyCodeCurrency) AS CompanyCodeCurrency,
  I_StRpTaxItemWithRefAcctgDoc.CountryCurrency AS CountryCurrency,
  coalesce( C_EG_StRpBillingItem.DocumentCurrency, I_StRpTaxItemWithRefAcctgDoc.DocumentCurrency) AS DocumentCurrency,
  I_StRpTaxItemWithRefAcctgDoc.ReportingCurrency AS ReportingCurrency,
  I_StRpTaxItemWithRefAcctgDoc.AdditionalCurrency1 AS AdditionalCurrency1,
  I_StRpTaxItemWithRefAcctgDoc.AdditionalCurrency2 AS AdditionalCurrency2,
  I_StRpTaxItemWithRefAcctgDoc.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  I_StRpTaxItemWithRefAcctgDoc.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  coalesce(C_EG_StRpBillingItem.TaxBaseAmountInRptgCrcy,I_StRpTaxItemWithRefAcctgDoc.TaxBaseAmountInCoCodeCrcy) AS TaxBaseAmountInCoCodeCrcy,
  coalesce( C_EG_StRpBillingItem.TaxAmountInRptgCrcy,I_StRpTaxItemWithRefAcctgDoc.TaxAmountInCoCodeCrcy) AS TaxAmountInCoCodeCrcy,
  coalesce(C_EG_StRpBillingItem.TaxBaseAmountInTransCrcy,I_StRpTaxItemWithRefAcctgDoc.TaxBaseAmountInTransCrcy) AS TaxBaseAmountInTransCrcy,
  coalesce(C_EG_StRpBillingItem.TaxAmount, I_StRpTaxItemWithRefAcctgDoc.TaxAmount) AS TaxAmount,
  I_StRpTaxItemWithRefAcctgDoc.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  I_StRpTaxItemWithRefAcctgDoc.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  I_StRpTaxItemWithRefAcctgDoc.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  I_StRpTaxItemWithRefAcctgDoc.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  I_StRpTaxItemWithRefAcctgDoc.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  I_StRpTaxItemWithRefAcctgDoc.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  I_StRpTaxItemWithRefAcctgDoc.TaxType AS TaxType,
  I_StRpTaxItemWithRefAcctgDoc.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_StRpTaxItemWithRefAcctgDoc.TargetTaxCode AS TargetTaxCode,
  I_StRpTaxItemWithRefAcctgDoc.EUTaxClassification AS EUTaxClassification,
  I_StRpTaxItemWithRefAcctgDoc.TaxNumber1 AS TaxNumber1,
  I_StRpTaxItemWithRefAcctgDoc.TaxNumber2 AS TaxNumber2,
  I_StRpTaxItemWithRefAcctgDoc.TaxNumber3 AS TaxNumber3,
  I_StRpTaxItemWithRefAcctgDoc.BusinessPartner AS BusinessPartner,
  I_StRpTaxItemWithRefAcctgDoc.BusinessPartnerName AS BusinessPartnerName,
  I_StRpTaxItemWithRefAcctgDoc.CustomerSupplierAddress AS CustomerSupplierAddress,
  I_StRpTaxItemWithRefAcctgDoc.TaxIsNotDeductible AS TaxIsNotDeductible,
  I_StRpTaxItemWithRefAcctgDoc.SupplierAccountGroup AS SupplierAccountGroup,
  I_StRpTaxItemWithRefAcctgDoc.MiniOneStopShopTxRptgCntry AS MiniOneStopShopTxRptgCntry,
  I_StRpTaxItemWithRefAcctgDoc.ReferenceDocumentNumber AS ReferenceDocumentNumber,
  I_StRpTaxItemWithRefAcctgDoc.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  I_StRpTaxItemWithRefAcctgDoc.BillingDocument AS BillingDocument,
  I_StRpTaxItemWithRefAcctgDoc.ReferenceSDDocument AS ReferenceSDDocument,
  I_StRpTaxItemWithRefAcctgDoc.RefAccountingDocument AS RefAccountingDocument,
  I_StRpTaxItemWithRefAcctgDoc.RefAccountingDocumentPostgDate AS RefAccountingDocumentPostgDate,
  C_EG_StRpBillingItem.BillingQuantityUnit AS BillingQuantityUnit,
  C_EG_StRpBillingItem.BillingQuantity AS BillingQuantity,
  FinancialAccountType,
  TaxCountry,
  C_EG_StRpBillingItem._BillingQuantityUnit AS _BillingQuantityUnit
FROM I_StRpTaxItemWithRefAcctgDoc
LEFT OUTER JOIN C_EG_StRpBillingItem ON /* join condition not captured in parsed metadata */
;

Learn More