P_EG_STRPTAXITEM

CDS View

P_EG_STRPTAXITEM is a CDS View in S/4HANA. It contains 16 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_EG_StRpTaxItemCube view from COMPOSITE Tax Item view for Statutory Reporting for Egypt
I_EG_StRpTaxItemCube view union_all COMPOSITE Tax Item view for Statutory Reporting for Egypt
P_EG_StRpTaxItemBox view from COMPOSITE
P_EG_StRpTaxItemBox view union_all COMPOSITE

Fields (16)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY DebitCreditCode DebitCreditCode 2
KEY FiscalYear FiscalYear 2
KEY TaxItem TaxItem 2
KEY TransactionTypeDetermination TransactionTypeDetermination 2
_AccountingDocument _AccountingDocument 2
_ReportingCurrency _ReportingCurrency 2
AccountingDocumentType AccountingDocumentType 2
BillingDocument BillingDocument 2
TargetTaxCode TargetTaxCode 2
TaxCalculationProcedure TaxCalculationProcedure 2
TaxCode TaxCode 2
TaxItemGroup TaxItemGroup 2
TaxReturnCountry TaxReturnCountry 2
TaxType TaxType 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EG_STRPTAXITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR,
    TAXITEM,
    TRANSACTIONTYPEDETERMINATION,
    _ACCOUNTINGDOCUMENT,
    _REPORTINGCURRENCY,
    ACCOUNTINGDOCUMENTTYPE,
    BILLINGDOCUMENT,
    TARGETTAXCODE,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXITEMGROUP,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, DEBITCREDITCODE, FISCALYEAR, TAXITEM, TRANSACTIONTYPEDETERMINATION)
);