SAP ABAP Table OIH_J1B_COP (Brazil: Controled prices table)
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_COP | Table Relationship Diagram |
Short Description | Brazil: Controled prices table |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | STATE | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
4 | CITY | CITYC | CITYC | CHAR | 4 | 0 | City Code | T005G | |
5 | OIHVTYPE | OIH_J1B_VTYP | OIH_J1B_VTYP | CHAR | 1 | 0 | Vendor type (refinery/mill/other) (Brazil) | ||
6 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
7 | MTXGR | OIH_J1B_MTXGR | OIH_J1B_MTXGR | CHAR | 4 | 0 | Material tax group | OIH2M_J1B | |
8 | VALIDFROM | J_1BTXDATF | DATUM_INV | CHAR | 8 | 0 | Date from which the tax rule is valid | ||
9 | VALIDTO | J_1BTXDATT | DATUM_INV | CHAR | 8 | 0 | Date to which the tax rule is valid | ||
10 | PUMPPRICE | OIH_J1B_PPRICE | OIH_J1B_PRICE | DEC | 15 | 4 | Pump price per unit | ||
11 | FACTOR | J_1BTXSTF | DEC4_2 | DEC | 6 | 2 | Number of units for Sub.Trib. calc. (price per n units) | ||
12 | UNIT | OIH_J1B_PRUNIT | MEINS | UNIT | 3 | 0 | Unit for price (Brazil tax) | T006 | |
13 | LOWEST | OIH_J1B_LOWEST | XFELD | CHAR | 1 | 0 | Indicator lowest pump price |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIH_J1B_COP | CITY | T005G | CITYC | |||
2 | OIH_J1B_COP | LAND1 | T005 | LAND1 | |||
3 | OIH_J1B_COP | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | OIH_J1B_COP | MATNR | MARA | MATNR | KEY | 1 | CN |
5 | OIH_J1B_COP | MTXGR | OIH2M_J1B | OIHMTXGR | KEY | 1 | CN |
6 | OIH_J1B_COP | STATE | T005S | BLAND | KEY | 1 | CN |
7 | OIH_J1B_COP | UNIT | T006 | MSEHI | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |