SAP table J_1BNFE_CB_ICMS (Benefit Code for ICMS Tax)
SAP table J_1BNFE_CB_ICMS has 3 primary key fields being MANDT,REGIO,CBENEF.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| REGIO | Region (State, Province, County) | CHAR | 3 | 0 | T005S | REGIO | |
| CBENEF | State Fiscal Benefit Code | CHAR | 10 | 0 | J_1BNFE_CBENEF |
J_1BNFE_CB_ICMS foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 J_1BNFE_CB_ICMS | MANDT | T000 | Clients | MANDT |
| 1 J_1BNFE_CB_ICMS | REGIO | T005S | Taxes: Region (Province) Key | LAND1 |