SAP table OIH_J1B_FAC (Brazil: Factor for calculation of PIS / COFINS ST)

SAP table OIH_J1B_FAC has 7 primary key fields being MANDT,MATNR,MTXGR,MOVTP,KUNNR,CGROUP,VALIDFROM.

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
MATNR Material Number CHAR 40 0 MARA MATNR
MTXGR Material tax group CHAR 4 0 OIH2M_J1B OIH_J1B_MTXGR
MOVTP Movement type (business operation) for taxes Brazil CHAR 1 0 OIH_J1B_MOVTP
P Purchase
S Sale
T Transfer
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
CGROUP Customer tax group CHAR 4 0 OIH2C_J1B OIH_J1B_CTXGR
VALIDFROM Date from which the tax rule is valid CHAR 8 0 J_1BTXDATF
VALIDTO Date to which the tax rule is valid CHAR 8 0 J_1BTXDATT
FACPIS Factor for PIS ST calculation DEC 6 2 OIH_J1B_FACPIS
FACCOF Factor for COFINS ST calculation DEC 6 2 OIH_J1B_FACCOF
FORMULA Formula type for PIS/COFINS ST calculation CHAR 1 0 OIH_J1B_PIS_FORM
PRINT_IND Indicator for PIS/COFINS ST printing exceptions CHAR 1 0 OIH_J1B_IPRINT_PIS
TXLW4 COFINS Tax Law CHAR 3 0 J_1BATL4A J_1BTAXLW4
TXLW5 PIS Tax Law CHAR 3 0 J_1BATL5 J_1BTAXLW5

OIH_J1B_FAC foreign key relationships

Table Field Check Table Check Field
0 OIH_J1B_FAC CGROUP OIH2C_J1B Check table for customer tax group MANDT
0 OIH_J1B_FAC CGROUP OIH2C_J1B Check table for customer tax group OIHCTXGR
1 OIH_J1B_FAC KUNNR KNA1 General Data in Customer Master MANDT
1 OIH_J1B_FAC KUNNR KNA1 General Data in Customer Master KUNNR
0 OIH_J1B_FAC MANDT T000 Clients MANDT
1 OIH_J1B_FAC MATNR MARA General Material Data MANDT
1 OIH_J1B_FAC MATNR MARA General Material Data MATNR
0 OIH_J1B_FAC MTXGR OIH2M_J1B Check table for material tax group MANDT
1 OIH_J1B_FAC TXLW4 J_1BATL4A Tax Laws COFINS MANDT
0 OIH_J1B_FAC TXLW5 J_1BATL5 PIS Tax Law MANDT