C_EG_StRpTaxItmWithGrouping
Egypt specific tax items grouping
C_EG_StRpTaxItmWithGrouping is a Consumption CDS View that provides data about "Egypt specific tax items grouping" in SAP S/4HANA. It reads from 2 data sources (C_EG_StRpTaxItmGrpgWithDocType, I_EG_StRpTaxItemGrouping) and exposes 92 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, TaxItem. Part of development package GLO_FIN_IS_VAT_EG_GEN.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| C_EG_StRpTaxItmGrpgWithDocType | C_EG_StRpTaxItmGrpgWithDocType | from |
| I_EG_StRpTaxItemGrouping | I_EG_StRpTaxItemGrouping | left_outer |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_AdjustmentDocumentIsDerived | glo_derive_adjustment |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CEGSRTXITMGRPG | 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 specific tax items grouping | view |
Fields (92)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | C_EG_StRpTaxItmGrpgWithDocType | CompanyCode | Receiver Company Code |
| KEY | AccountingDocument | C_EG_StRpTaxItmGrpgWithDocType | AccountingDocument | Journal Entry |
| KEY | FiscalYear | C_EG_StRpTaxItmGrpgWithDocType | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocumentItem | C_EG_StRpTaxItmGrpgWithDocType | AccountingDocumentItem | Posting View Item |
| KEY | TaxItem | C_EG_StRpTaxItmGrpgWithDocType | TaxItem | Tax Item |
| KEY | TaxCode | C_EG_StRpTaxItmGrpgWithDocType | TaxCode | Tax Code |
| KEY | TransactionTypeDetermination | C_EG_StRpTaxItmGrpgWithDocType | TransactionTypeDetermination | Transaction Key |
| KEY | TaxBox | C_EG_StRpTaxItmGrpgWithDocType | TaxBox | Tax.Bs.Gp.No. |
| KEY | TaxItemGroupingVersion | C_EG_StRpTaxItmGrpgWithDocType | TaxItemGroupingVersion | Tax Grping Ver. |
| TaxDeclnAmountType | C_EG_StRpTaxItmGrpgWithDocType | TaxDeclnAmountType | ||
| DebitCreditCode | C_EG_StRpTaxItmGrpgWithDocType | DebitCreditCode | Single-Character Flag | |
| TaxRate | C_EG_StRpTaxItmGrpgWithDocType | TaxRate | Tax Rate | |
| GLAccount | C_EG_StRpTaxItmGrpgWithDocType | GLAccount | General Ledger | |
| TaxItemGroup | C_EG_StRpTaxItmGrpgWithDocType | TaxItemGroup | Tax doc. item number | |
| BusinessPlace | C_EG_StRpTaxItmGrpgWithDocType | BusinessPlace | Business place | |
| TaxJurisdiction | C_EG_StRpTaxItmGrpgWithDocType | TaxJurisdiction | Tax Jurisdiction | |
| LowestLevelTaxJurisdiction | C_EG_StRpTaxItmGrpgWithDocType | LowestLevelTaxJurisdiction | Jurisdict. Code | |
| AccountingDocumentType | C_EG_StRpTaxItmGrpgWithDocType | AccountingDocumentType | Journal Entry Type | |
| ReferenceDocumentType | C_EG_StRpTaxItmGrpgWithDocType | ReferenceDocumentType | Reference Document Type | |
| ReverseDocument | C_EG_StRpTaxItmGrpgWithDocType | ReverseDocument | Reversed With | |
| ReverseDocumentFiscalYear | C_EG_StRpTaxItmGrpgWithDocType | ReverseDocumentFiscalYear | Year | |
| DocumentReferenceID | C_EG_StRpTaxItmGrpgWithDocType | DocumentReferenceID | Reference | |
| ConditionType | C_EG_StRpTaxItmGrpgWithDocType | ConditionType | Condition type | |
| Ledger | C_EG_StRpTaxItmGrpgWithDocType | Ledger | Ledger | |
| LedgerGroup | C_EG_StRpTaxItmGrpgWithDocType | LedgerGroup | Ledger Group | |
| PostingDate | C_EG_StRpTaxItmGrpgWithDocType | PostingDate | Posting Date for GR | |
| DocumentDate | C_EG_StRpTaxItmGrpgWithDocType | DocumentDate | Journal Entry Date | |
| TaxReportingDate | C_EG_StRpTaxItmGrpgWithDocType | TaxReportingDate | Tax Reporting Date | |
| FiscalPeriod | C_EG_StRpTaxItmGrpgWithDocType | FiscalPeriod | Tax period | |
| ExchangeRate | C_EG_StRpTaxItmGrpgWithDocType | ExchangeRate | Exchange rate | |
| IsReversal | C_EG_StRpTaxItmGrpgWithDocType | IsReversal | Reversal doc. | |
| IsReversed | C_EG_StRpTaxItmGrpgWithDocType | IsReversed | Reversed? | |
| AccountingDocumentHeaderText | C_EG_StRpTaxItmGrpgWithDocType | AccountingDocumentHeaderText | Doc.Header Text | |
| CompanyCodeCountry | C_EG_StRpTaxItmGrpgWithDocType | CompanyCodeCountry | Reporting Ctry/Reg. | |
| ReportingCountry | C_EG_StRpTaxItmGrpgWithDocType | ReportingCountry | ||
| TaxReturnCountry | C_EG_StRpTaxItmGrpgWithDocType | TaxReturnCountry | Reporting C/R | |
| ReportingDate | C_EG_StRpTaxItmGrpgWithDocType | ReportingDate | ||
| CompanyCodeCurrency | C_EG_StRpTaxItmGrpgWithDocType | CompanyCodeCurrency | Local Currency | |
| CountryCurrency | C_EG_StRpTaxItmGrpgWithDocType | CountryCurrency | Currency | |
| DocumentCurrency | C_EG_StRpTaxItmGrpgWithDocType | DocumentCurrency | Document Currency | |
| ReportingCurrency | C_EG_StRpTaxItmGrpgWithDocType | ReportingCurrency | Currency | |
| AdditionalCurrency1 | C_EG_StRpTaxItmGrpgWithDocType | AdditionalCurrency1 | Local curr. 2 | |
| AdditionalCurrency2 | C_EG_StRpTaxItmGrpgWithDocType | AdditionalCurrency2 | Local curr. 3 | |
| TaxBaseAmountInRptgCrcy | C_EG_StRpTaxItmGrpgWithDocType | TaxBaseAmountInRptgCrcy | Base Amount | |
| TaxAmountInRptgCrcy | C_EG_StRpTaxItmGrpgWithDocType | TaxAmountInRptgCrcy | Tax Rept. Crcy | |
| AmountInReportingCurrency | C_EG_StRpTaxItmGrpgWithDocType | AmountInReportingCurrency | ||
| TaxBaseAmountInCoCodeCrcy | C_EG_StRpTaxItmGrpgWithDocType | TaxBaseAmountInCoCodeCrcy | TxBaseAmt CoCodeCrcy | |
| TaxAmountInCoCodeCrcy | C_EG_StRpTaxItmGrpgWithDocType | TaxAmountInCoCodeCrcy | Tax Amount in Company Code Currency | |
| TaxBaseAmountInTransCrcy | C_EG_StRpTaxItmGrpgWithDocType | TaxBaseAmountInTransCrcy | Value-Added Tax | |
| TaxAmount | C_EG_StRpTaxItmGrpgWithDocType | TaxAmount | Tax Amt in Rptg Crcy | |
| TaxBaseAmountInCountryCrcy | C_EG_StRpTaxItmGrpgWithDocType | TaxBaseAmountInCountryCrcy | Base Amount | |
| TaxAmountInCountryCrcy | C_EG_StRpTaxItmGrpgWithDocType | TaxAmountInCountryCrcy | Tax Rept. Crcy | |
| TaxBaseAmtInAdditionalCrcy1 | C_EG_StRpTaxItmGrpgWithDocType | TaxBaseAmtInAdditionalCrcy1 | LC 2 Base | |
| TaxBaseAmtInAdditionalCrcy2 | C_EG_StRpTaxItmGrpgWithDocType | TaxBaseAmtInAdditionalCrcy2 | LC 3 Base | |
| TaxAmountInAdditionalCurrency1 | C_EG_StRpTaxItmGrpgWithDocType | TaxAmountInAdditionalCurrency1 | LC 2 Tax | |
| TaxAmountInAdditionalCurrency2 | C_EG_StRpTaxItmGrpgWithDocType | TaxAmountInAdditionalCurrency2 | LC 3 Tax | |
| TaxType | C_EG_StRpTaxItmGrpgWithDocType | TaxType | Tax Type | |
| TaxCalculationProcedure | C_EG_StRpTaxItmGrpgWithDocType | TaxCalculationProcedure | Tax Procedure | |
| TargetTaxCode | C_EG_StRpTaxItmGrpgWithDocType | TargetTaxCode | ||
| EUTaxClassification | C_EG_StRpTaxItmGrpgWithDocType | EUTaxClassification | ||
| TaxNumber1 | C_EG_StRpTaxItmGrpgWithDocType | TaxNumber1 | VAT Reg. No. | |
| TaxNumber2 | C_EG_StRpTaxItmGrpgWithDocType | TaxNumber2 | Tax Number 2 | |
| TaxNumber3 | C_EG_StRpTaxItmGrpgWithDocType | TaxNumber3 | ||
| BusinessPartner | C_EG_StRpTaxItmGrpgWithDocType | BusinessPartner | Issuing Authority | |
| BusinessPartnerName | C_EG_StRpTaxItmGrpgWithDocType | BusinessPartnerName | Extracted Customer Name | |
| CustomerSupplierAddress | C_EG_StRpTaxItmGrpgWithDocType | CustomerSupplierAddress | ||
| TaxIsNotDeductible | C_EG_StRpTaxItmGrpgWithDocType | TaxIsNotDeductible | Non-Deductible | |
| SupplierAccountGroup | C_EG_StRpTaxItmGrpgWithDocType | SupplierAccountGroup | Account group | |
| MiniOneStopShopTxRptgCntry | C_EG_StRpTaxItmGrpgWithDocType | MiniOneStopShopTxRptgCntry | ||
| ReferenceDocumentNumber | C_EG_StRpTaxItmGrpgWithDocType | ReferenceDocumentNumber | ||
| ReferenceDocumentFiscalYear | C_EG_StRpTaxItmGrpgWithDocType | ReferenceDocumentFiscalYear | Year Cur.Period | |
| BillingDocument | C_EG_StRpTaxItmGrpgWithDocType | BillingDocument | SD Document | |
| ReferenceSDDocument | C_EG_StRpTaxItmGrpgWithDocType | ReferenceSDDocument | Reference Doc. | |
| RefAccountingDocument | C_EG_StRpTaxItmGrpgWithDocType | RefAccountingDocument | Document Number | |
| RefAccountingDocumentPostgDate | C_EG_StRpTaxItmGrpgWithDocType | RefAccountingDocumentPostgDate | ||
| BillingQuantityUnit | C_EG_StRpTaxItmGrpgWithDocType | BillingQuantityUnit | Sales Unit | |
| BillingQuantity | C_EG_StRpTaxItmGrpgWithDocType | BillingQuantity | Invoiced Qty | |
| AdjustmentDocumentIsDerived | AdjustmentDocumentIsDerived | |||
| AccountingDocumentNumberRange | AccountingDocumentNumberRange | |||
| TaxCountry | TaxCountry | Tax Ctry/Reg. | ||
| FinancialAccountType | FinancialAccountType | Fin. Account Type | ||
| _ReportingCurrency | _ReportingCurrency | |||
| _AccountingDocument | _AccountingDocument | |||
| _GLAccount | _GLAccount | |||
| _TaxJurisdiction | _TaxJurisdiction | |||
| _DebtorCreditorRblsPyblsItem | _DebtorCreditorRblsPyblsItem | |||
| _ReceivablesPayablesItem | _ReceivablesPayablesItem | |||
| _TaxReceivablesPayablesItem | _TaxReceivablesPayablesItem | |||
| _TaxTypeText | _TaxTypeText | |||
| _TaxCodeText | _TaxCodeText | |||
| _ReportedItemsLog | _ReportedItemsLog | |||
| _BillingQuantityUnit | _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_StRpTaxItmWithGrouping.
-- 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: CEGSRTXITMGRPG
-- Parameters: P_AdjustmentDocumentIsDerived : glo_derive_adjustment
CREATE VIEW C_EG_StRpTaxItmWithGrouping AS
SELECT
C_EG_StRpTaxItmGrpgWithDocType.CompanyCode AS CompanyCode,
C_EG_StRpTaxItmGrpgWithDocType.AccountingDocument AS AccountingDocument,
C_EG_StRpTaxItmGrpgWithDocType.FiscalYear AS FiscalYear,
C_EG_StRpTaxItmGrpgWithDocType.AccountingDocumentItem AS AccountingDocumentItem,
C_EG_StRpTaxItmGrpgWithDocType.TaxItem AS TaxItem,
C_EG_StRpTaxItmGrpgWithDocType.TaxCode AS TaxCode,
C_EG_StRpTaxItmGrpgWithDocType.TransactionTypeDetermination AS TransactionTypeDetermination,
C_EG_StRpTaxItmGrpgWithDocType.TaxBox AS TaxBox,
C_EG_StRpTaxItmGrpgWithDocType.TaxItemGroupingVersion AS TaxItemGroupingVersion,
C_EG_StRpTaxItmGrpgWithDocType.TaxDeclnAmountType AS TaxDeclnAmountType,
C_EG_StRpTaxItmGrpgWithDocType.DebitCreditCode AS DebitCreditCode,
C_EG_StRpTaxItmGrpgWithDocType.TaxRate AS TaxRate,
C_EG_StRpTaxItmGrpgWithDocType.GLAccount AS GLAccount,
C_EG_StRpTaxItmGrpgWithDocType.TaxItemGroup AS TaxItemGroup,
C_EG_StRpTaxItmGrpgWithDocType.BusinessPlace AS BusinessPlace,
C_EG_StRpTaxItmGrpgWithDocType.TaxJurisdiction AS TaxJurisdiction,
C_EG_StRpTaxItmGrpgWithDocType.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
C_EG_StRpTaxItmGrpgWithDocType.AccountingDocumentType AS AccountingDocumentType,
C_EG_StRpTaxItmGrpgWithDocType.ReferenceDocumentType AS ReferenceDocumentType,
C_EG_StRpTaxItmGrpgWithDocType.ReverseDocument AS ReverseDocument,
C_EG_StRpTaxItmGrpgWithDocType.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
C_EG_StRpTaxItmGrpgWithDocType.DocumentReferenceID AS DocumentReferenceID,
C_EG_StRpTaxItmGrpgWithDocType.ConditionType AS ConditionType,
C_EG_StRpTaxItmGrpgWithDocType.Ledger AS Ledger,
C_EG_StRpTaxItmGrpgWithDocType.LedgerGroup AS LedgerGroup,
C_EG_StRpTaxItmGrpgWithDocType.PostingDate AS PostingDate,
C_EG_StRpTaxItmGrpgWithDocType.DocumentDate AS DocumentDate,
C_EG_StRpTaxItmGrpgWithDocType.TaxReportingDate AS TaxReportingDate,
C_EG_StRpTaxItmGrpgWithDocType.FiscalPeriod AS FiscalPeriod,
C_EG_StRpTaxItmGrpgWithDocType.ExchangeRate AS ExchangeRate,
C_EG_StRpTaxItmGrpgWithDocType.IsReversal AS IsReversal,
C_EG_StRpTaxItmGrpgWithDocType.IsReversed AS IsReversed,
C_EG_StRpTaxItmGrpgWithDocType.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
C_EG_StRpTaxItmGrpgWithDocType.CompanyCodeCountry AS CompanyCodeCountry,
C_EG_StRpTaxItmGrpgWithDocType.ReportingCountry AS ReportingCountry,
C_EG_StRpTaxItmGrpgWithDocType.TaxReturnCountry AS TaxReturnCountry,
C_EG_StRpTaxItmGrpgWithDocType.ReportingDate AS ReportingDate,
C_EG_StRpTaxItmGrpgWithDocType.CompanyCodeCurrency AS CompanyCodeCurrency,
C_EG_StRpTaxItmGrpgWithDocType.CountryCurrency AS CountryCurrency,
C_EG_StRpTaxItmGrpgWithDocType.DocumentCurrency AS DocumentCurrency,
C_EG_StRpTaxItmGrpgWithDocType.ReportingCurrency AS ReportingCurrency,
C_EG_StRpTaxItmGrpgWithDocType.AdditionalCurrency1 AS AdditionalCurrency1,
C_EG_StRpTaxItmGrpgWithDocType.AdditionalCurrency2 AS AdditionalCurrency2,
C_EG_StRpTaxItmGrpgWithDocType.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
C_EG_StRpTaxItmGrpgWithDocType.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
C_EG_StRpTaxItmGrpgWithDocType.AmountInReportingCurrency AS AmountInReportingCurrency,
C_EG_StRpTaxItmGrpgWithDocType.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
C_EG_StRpTaxItmGrpgWithDocType.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
C_EG_StRpTaxItmGrpgWithDocType.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
C_EG_StRpTaxItmGrpgWithDocType.TaxAmount AS TaxAmount,
C_EG_StRpTaxItmGrpgWithDocType.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
C_EG_StRpTaxItmGrpgWithDocType.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
C_EG_StRpTaxItmGrpgWithDocType.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
C_EG_StRpTaxItmGrpgWithDocType.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
C_EG_StRpTaxItmGrpgWithDocType.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
C_EG_StRpTaxItmGrpgWithDocType.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
C_EG_StRpTaxItmGrpgWithDocType.TaxType AS TaxType,
C_EG_StRpTaxItmGrpgWithDocType.TaxCalculationProcedure AS TaxCalculationProcedure,
C_EG_StRpTaxItmGrpgWithDocType.TargetTaxCode AS TargetTaxCode,
C_EG_StRpTaxItmGrpgWithDocType.EUTaxClassification AS EUTaxClassification,
C_EG_StRpTaxItmGrpgWithDocType.TaxNumber1 AS TaxNumber1,
C_EG_StRpTaxItmGrpgWithDocType.TaxNumber2 AS TaxNumber2,
C_EG_StRpTaxItmGrpgWithDocType.TaxNumber3 AS TaxNumber3,
C_EG_StRpTaxItmGrpgWithDocType.BusinessPartner AS BusinessPartner,
C_EG_StRpTaxItmGrpgWithDocType.BusinessPartnerName AS BusinessPartnerName,
C_EG_StRpTaxItmGrpgWithDocType.CustomerSupplierAddress AS CustomerSupplierAddress,
C_EG_StRpTaxItmGrpgWithDocType.TaxIsNotDeductible AS TaxIsNotDeductible,
C_EG_StRpTaxItmGrpgWithDocType.SupplierAccountGroup AS SupplierAccountGroup,
C_EG_StRpTaxItmGrpgWithDocType.MiniOneStopShopTxRptgCntry AS MiniOneStopShopTxRptgCntry,
C_EG_StRpTaxItmGrpgWithDocType.ReferenceDocumentNumber AS ReferenceDocumentNumber,
C_EG_StRpTaxItmGrpgWithDocType.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
C_EG_StRpTaxItmGrpgWithDocType.BillingDocument AS BillingDocument,
C_EG_StRpTaxItmGrpgWithDocType.ReferenceSDDocument AS ReferenceSDDocument,
C_EG_StRpTaxItmGrpgWithDocType.RefAccountingDocument AS RefAccountingDocument,
C_EG_StRpTaxItmGrpgWithDocType.RefAccountingDocumentPostgDate AS RefAccountingDocumentPostgDate,
C_EG_StRpTaxItmGrpgWithDocType.BillingQuantityUnit AS BillingQuantityUnit,
C_EG_StRpTaxItmGrpgWithDocType.BillingQuantity AS BillingQuantity,
AdjustmentDocumentIsDerived,
AccountingDocumentNumberRange,
TaxCountry,
FinancialAccountType
FROM C_EG_StRpTaxItmGrpgWithDocType
LEFT OUTER JOIN I_EG_StRpTaxItemGrouping ON /* join condition not captured in parsed metadata */
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA