_NFITEMTAX

_NFITEMTAX is an SAP database table in S/4HANA. It contains 30 fields.

Fields (30)

KeyField CDS FieldsUsed in Views
_BR_ICMSBaseDetn _BR_ICMSBaseDetn 1
_BR_ICMSExemptionReason _BR_ICMSExemptionReason 1
_BR_ICMSSTBaseDetn _BR_ICMSSTBaseDetn 1
_BR_ICMSTaxSituation _BR_ICMSTaxSituation 1
BR_EffctvCalcBasisAmount BR_EffctvCalcBasisAmount 1
BR_EffectiveICMSAmount BR_EffectiveICMSAmount 1
BR_EffectiveICMSRate BR_EffectiveICMSRate 1
BR_FCPOnICMSSTWithheldAmount BR_FCPOnICMSSTWithheldAmount 1
BR_FCPOnICMSSTWithheldBaseAmt BR_FCPOnICMSSTWithheldBaseAmt 1
BR_FCPonICMSSTWithheldRate BR_FCPonICMSSTWithheldRate 1
BR_ICMSBaseDetn BR_ICMSBaseDetn 1
BR_ICMSDefermentAmount BR_ICMSDefermentAmount 1
BR_ICMSDeferralTaxRate BR_ICMSDeferralTaxRate 1
BR_ICMSExemptionReason BR_ICMSExemptionReason 1
BR_ICMSSTBaseDetermination BR_ICMSSTBaseDetermination 1
BR_ICMSSTDestTaxAmount BR_ICMSSTDestTaxAmount 1
BR_ICMSSTDestTaxBaseAmount BR_ICMSSTDestTaxBaseAmount 1
BR_ICMSSTMarginAddedPercent BR_ICMSSTMarginAddedPercent 1
BR_ICMSSTRateIncludingFCP BR_ICMSSTRateIncludingFCP 1
BR_ICMSTaxSituation BR_ICMSTaxSituation 1
BR_IOFTaxAmount BR_IOFTaxAmount 1
BR_IPIControlSealCode BR_IPIControlSealCode 1
BR_IPIControlSealQuantityValue BR_IPIControlSealQuantityValue 1
BR_ReducnPctEffctvCalcBasis BR_ReducnPctEffctvCalcBasis 1
BR_SubstituteICMSAmount BR_SubstituteICMSAmount 1
BR_TobaccoBeverageIPIClassfctn BR_TobaccoBeverageIPIClassfctn 1
BR_WithholdingICMSSTAmount BR_WithholdingICMSSTAmount 1
BR_WithholdingICMSSTBaseAmount BR_WithholdingICMSSTBaseAmount 1
CustomsChargesAmount CustomsChargesAmount 1
SalesDocumentCurrency SalesDocumentCurrency 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 _NFITEMTAX (
    _BR_ICMSBASEDETN,
    _BR_ICMSEXEMPTIONREASON,
    _BR_ICMSSTBASEDETN,
    _BR_ICMSTAXSITUATION,
    BR_EFFCTVCALCBASISAMOUNT,
    BR_EFFECTIVEICMSAMOUNT,
    BR_EFFECTIVEICMSRATE,
    BR_FCPONICMSSTWITHHELDAMOUNT,
    BR_FCPONICMSSTWITHHELDBASEAMT,
    BR_FCPONICMSSTWITHHELDRATE,
    BR_ICMSBASEDETN,
    BR_ICMSDEFERMENTAMOUNT,
    BR_ICMSDEFERRALTAXRATE,
    BR_ICMSEXEMPTIONREASON,
    BR_ICMSSTBASEDETERMINATION,
    BR_ICMSSTDESTTAXAMOUNT,
    BR_ICMSSTDESTTAXBASEAMOUNT,
    BR_ICMSSTMARGINADDEDPERCENT,
    BR_ICMSSTRATEINCLUDINGFCP,
    BR_ICMSTAXSITUATION,
    BR_IOFTAXAMOUNT,
    BR_IPICONTROLSEALCODE,
    BR_IPICONTROLSEALQUANTITYVALUE,
    BR_REDUCNPCTEFFCTVCALCBASIS,
    BR_SUBSTITUTEICMSAMOUNT,
    BR_TOBACCOBEVERAGEIPICLASSFCTN,
    BR_WITHHOLDINGICMSSTAMOUNT,
    BR_WITHHOLDINGICMSSTBASEAMOUNT,
    CUSTOMSCHARGESAMOUNT,
    SALESDOCUMENTCURRENCY
);