OIH_J1B_PPR SAP (Brazil Tax: Pondered average price table for final consume) Table details

Dictionary Type: Table
Description: Brazil Tax: Pondered average price table for final consume




ABAP Code to SELECT data from OIH_J1B_PPR
Related tables to OIH_J1B_PPR
Access table OIH_J1B_PPR




Table field list including key, data, relationships and ABAP select examples

OIH_J1B_PPR is a standard SAP Table which is used to store Brazil Tax: Pondered average price table for final consume data and is available within R/3 SAP systems depending on the version and release level.

The OIH_J1B_PPR table consists of various fields, each holding specific information or linking keys about Brazil Tax: Pondered average price table for final consume data available in SAP. These include LAND1 (Country Key), TXREG (Tax Region), OIHVTYPE (Vendor type (refinery/mill/other) (Brazil)), MATNR (Material Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIH_J1B_PPR table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LAND1Country Key LAND1CHAR3T005LAND1LND
TXREGTax Region J_1BTXREGCHAR3J_1BTREGXJ_1BTXREG
OIHVTYPEVendor type (refinery/mill/other) (Brazil) OIH_J1B_VTYPCHAR1OIH_J1B_VTYP
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MTXGRMaterial tax group OIH_J1B_MTXGRCHAR4OIH2M_J1BOIH_J1B_MTXGRH_OIHMTXGR
VALIDFROMDate from which the tax rule is valid J_1BTXDATFCHAR8INVDTDATUM_INVJ_1B_GET_DATE
VALIDTODate to which the tax rule is valid J_1BTXDATTCHAR8INVDTDATUM_INVJ_1B_GET_DATE
PRICEPMPF price OIH_J1B_PMPF_PRICEDEC15(4) OIH_J1B_PRICE
FACTORNumber of units for Sub.Trib. calc. (price per n units) J_1BTXSTFDEC6(2) DEC4_2
UNITUnit for price (Brazil tax) OIH_J1B_PRUNITUNIT3Assigned to domainCUNITMEINS
TXLW1Tax law: ICMS J_1BTAXLW1CHAR3J_1BATL1ALPHAJ_1BTAXLW1
OIHREFSTBrazil: Refinery ST applied to end customer OIH_REFST_ENDCHAR1OIH_REFST
TXLW1_INTERTax law: ICMS J_1BTAXLW1CHAR3J_1BATL1ALPHAJ_1BTAXLW1

Key field Non-key field



How do I retrieve data from SAP table OIH_J1B_PPR using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIH_J1B_PPR to SELECT all data from the table
DATA: WA_OIH_J1B_PPR TYPE OIH_J1B_PPR.

SELECT SINGLE *
FROM OIH_J1B_PPR
INTO CORRESPONDING FIELDS OF WA_OIH_J1B_PPR
WHERE...

How to access SAP table OIH_J1B_PPR

Within an ECC or HANA version of SAP you can also view further information about OIH_J1B_PPR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!