SAP ABAP Table OIH_J1B_SAL_2 (Brazil: ICMS Deferment)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS-TDP (Application Component) Tariffs, Duties and Permits
⤷ OIH_CV_BR (Package) Oil country version Brazil
⤷ IS-OIL-DS-TDP (Application Component) Tariffs, Duties and Permits
⤷ OIH_CV_BR (Package) Oil country version Brazil
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIH_J1B_SAL_2 | Table Relationship Diagram |
Short Description | Brazil: ICMS Deferment |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | G | Customizing table, protected against SAP Upd., only INS all. |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
3 | TXREG | J_1BTXREG | J_1BTXREG | CHAR | 3 | 0 | Tax Region | J_1BTREGX | |
4 | OIHVTYPE | OIH_J1B_VTYP | OIH_J1B_VTYP | CHAR | 1 | 0 | Vendor type (refinery/mill/other) (Brazil) | ||
5 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
6 | MTXGR | OIH_J1B_MTXGR | OIH_J1B_MTXGR | CHAR | 4 | 0 | Material tax group | OIH2M_J1B | |
7 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
8 | CUST_GROUP | OIH_J1B_CTXGR | OIH_J1B_CTXGR | CHAR | 4 | 0 | Customer tax group | OIH2C_J1B | |
9 | OPTYPE | OIH_J1B_INT | OIH_J1B_OPER_SALES | CHAR | 1 | 0 | Inter / intra operation type | ||
10 | ORDER_TYPE | AUART | AUART | CHAR | 4 | 0 | Sales Document Type | TVAK | |
11 | ITEM_CAT | PSTYV | PSTYV | CHAR | 4 | 0 | Sales document item category | TVPT | |
12 | VALIDFROM | J_1BTXDATF | DATUM_INV | CHAR | 8 | 0 | Date from which the tax rule is valid | ||
13 | VALIDTO | J_1BTXDATT | DATUM_INV | CHAR | 8 | 0 | Date to which the tax rule is valid | ||
14 | TAX_CODE | J_1BTXSDC_ | J_1BTXSDC | CHAR | 2 | 0 | SD tax code | J_1BTXSDC | |
15 | TXLW1 | J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | 0 | Tax law: ICMS | J_1BATL1 | |
16 | TXLW2 | J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | 0 | Tax law: IPI | J_1BATL2 | |
17 | TXLW4 | J_1BTAXLW4 | J_1BTAXLW4 | CHAR | 3 | 0 | COFINS Tax Law | J_1BATL4A | |
18 | TXLW5 | J_1BTAXLW5 | J_1BTAXLW5 | CHAR | 3 | 0 | PIS Tax Law | J_1BATL5 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIH_J1B_SAL_2 | CUST_GROUP | OIH2C_J1B | OIHCTXGR | |||
2 | OIH_J1B_SAL_2 | ITEM_CAT | TVPT | PSTYV | |||
3 | OIH_J1B_SAL_2 | KUNNR | KNA1 | KUNNR | |||
4 | OIH_J1B_SAL_2 | LAND1 | T005 | LAND1 | |||
5 | OIH_J1B_SAL_2 | MANDT | T000 | MANDT | |||
6 | OIH_J1B_SAL_2 | MATNR | MARA | MATNR | |||
7 | OIH_J1B_SAL_2 | MTXGR | OIH2M_J1B | OIHMTXGR | |||
8 | OIH_J1B_SAL_2 | ORDER_TYPE | TVAK | AUART | |||
9 | OIH_J1B_SAL_2 | TAX_CODE | J_1BTXSDC | TAXCODE | |||
10 | OIH_J1B_SAL_2 | TXLW1 | J_1BATL1 | TAXLAW | |||
11 | OIH_J1B_SAL_2 | TXLW2 | J_1BATL2 | TAXLAW | |||
12 | OIH_J1B_SAL_2 | TXLW4 | J_1BATL4A | TAXLAW | |||
13 | OIH_J1B_SAL_2 | TXLW5 | J_1BATL5 | TAXLAW | |||
14 | OIH_J1B_SAL_2 | TXREG | J_1BTREGX | TXREG |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C |