Fields (30)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- 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
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA