SAP ABAP Table OIH_J1B_CPR (Brazil: Posting exceptions for ICMS complement)

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIH_J1B_CPR	Table Relationship Diagram
Short Description	Brazil: Posting exceptions for ICMS complement

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	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	OPTYPE	☑	OIH_J1B_INT	OIH_J1B_OPER_SALES	CHAR	1	0	Inter / intra operation type
6	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
7	CGROUP	☑	OIH_J1B_CTXGR	OIH_J1B_CTXGR	CHAR	4	0	Customer tax group	OIH2C_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	EXC_ICOP	☐	OIH_J1B_EXC_ICOP	OIH_J1B_EXC_ICOP	CHAR	1	0	Exception indicator for ICMS complement (Brazil taxes)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIH_J1B_CPR	CGROUP	OIH2C_J1B	OIHCTXGR
2	OIH_J1B_CPR	KUNNR	KNA1	KUNNR	KEY	1	CN
3	OIH_J1B_CPR	LAND1	T005	LAND1	KEY	1	CN
4	OIH_J1B_CPR	MANDT	T000	MANDT	KEY	1	CN
5	OIH_J1B_CPR	TXREG	J_1BTREGX	TXREG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in