P_DEFTAX_ITEM

CDS View

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

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_DEFTAX_ITEM_2 view from CONSUMPTION
P_HR_DefTaxItem view_entity from COMPOSITE Croatia deferred tax item
P_MY_StRpTxItmWithOriglDoc view left_outer COMPOSITE

Fields (16)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 2
CAReversalDocumentNumber CAReversalDocumentNumber 1
CAReversalDocumentYear CAReversalDocumentYear 1
ClearingAccountingDocument ClearingAccountingDocument 1
CompanyCode CompanyCode 2
FiscalYear FiscalYear 2
GrossAmtInLocalCrcy GrossAmtInLocalCrcy 1
GrossAmtInNationalCrcy GrossAmtInNationalCrcy 1
PartialGrossAmtInLocalCrcy PartialGrossAmtInLocalCrcy 1
PartialGrossAmtInNationalCrcy PartialGrossAmtInNationalCrcy 1
PaymentAccountingDocument PaymentAccountingDocument 1
PaymentFiscalYear PaymentFiscalYear 1
TaxCode TaxCode 1
TaxTransferDocument TaxTransferDocument 1
TaxTransferDocumentYear TaxTransferDocumentYear 1
TransactionTypeDetermination TransactionTypeDetermination 1

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_DEFTAX_ITEM (
    ACCOUNTINGDOCUMENT,
    CAREVERSALDOCUMENTNUMBER,
    CAREVERSALDOCUMENTYEAR,
    CLEARINGACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    GROSSAMTINLOCALCRCY,
    GROSSAMTINNATIONALCRCY,
    PARTIALGROSSAMTINLOCALCRCY,
    PARTIALGROSSAMTINNATIONALCRCY,
    PAYMENTACCOUNTINGDOCUMENT,
    PAYMENTFISCALYEAR,
    TAXCODE,
    TAXTRANSFERDOCUMENT,
    TAXTRANSFERDOCUMENTYEAR,
    TRANSACTIONTYPEDETERMINATION
);