SAP Table OIH_J1B_FAC

Brazil: Factor for calculation of PIS / COFINS ST

OIH_J1B_FAC (Brazil: Factor for calculation of PIS / COFINS ST) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIH_J1B_FAC to other SAP tables.

OIH_J1B_FAC table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
MTXGR Material tax group OIH_J1B_MTXGR OIH2M_J1B CHAR 4 0
MOVTP Movement type (business operation) for taxes Brazil OIH_J1B_MOVTP CHAR 1 0
P Purchase
T Transfer
S Sale
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
CGROUP Customer tax group OIH_J1B_CTXGR OIH2C_J1B CHAR 4 0
VALIDFROM Date from which the tax rule is valid J_1BTXDATF CHAR 8 0
VALIDTO Date to which the tax rule is valid J_1BTXDATT CHAR 8 0
FACPIS Factor for PIS ST calculation OIH_J1B_FACPIS DEC 6 2
FACCOF Factor for COFINS ST calculation OIH_J1B_FACCOF DEC 6 2
FORMULA Formula type for PIS/COFINS ST calculation OIH_J1B_PIS_FORM CHAR 1 0
A Formula A (NO calculation - exception)
B Formula B (value = item-value * factor * rate)
C Formula C (value = item-value * alc-mix * factor * rate)
D Formula D (value = item-value * alc-mix * factor * rate)
E Formula E (value = item-qty * 1-acq-px * alc-mix * fac * rt)
F Formula F (value = item-qty * acq-price * factor * rate)
G Formula G (value = item-qty * acq-price * factor * rate)
H Formula H like G
PRINT_IND Indicator for PIS/COFINS ST printing exceptions OIH_J1B_IPRINT_PIS CHAR 1 0
NULL Print tax in own field and post to tax account
A Print tax in additional field, do not post tax
X Print tax in additional field and post to tax acc.
B Print ONLY ICMS in add.field, does not affect other taxes
C Print tax in add.field and add to price
TXLW4 COFINS Tax Law J_1BTAXLW4 J_1BATL4A CHAR 3 0
TXLW5 PIS Tax Law J_1BTAXLW5 J_1BATL5 CHAR 3 0

OIH_J1B_FAC foreign key relationships

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