OIH_J1B_APR

Brazil tax: Acquisition price table | #masterdata | Component: Tariffs, Duties and Permits
Column Name Description
MANDT FK Client
PLANT FK Plant
TXREG FK Tax Region
PRODUCT FK Material Number
MTXGR FK Material tax group
VENDOR FK Account Number of Supplier
VALIDFROM Date from which the tax rule is valid
Column Name Description
Column Name Description
Column Name Description
Column Name Description
OPTYPE Inter / intra operation type Show values
LOWEST_APR Indicator lowest Acquisition price Show values
Column Name Description Domain name
VALIDTO Date to which the tax rule is valid DATUM_INV
APRICE Acquisition price per unit OIH_J1B_PRICE
APRICE_P Acq.price including charges per unit OIH_J1B_PRICE
FACTOR Number of units for Sub.Trib. calc. (price per n units) DEC4_2
Master Data Relations Join Conditions
Client OIH_J1B_APR.MANDT == T000.MANDT
Plant
  • OIH_J1B_APR.MANDT == T001W.MANDT
  • OIH_J1B_APR.PLANT == T001W.WERKS
Material Number
  • Material Number
  • Client
  • OIH_J1B_APR.PRODUCT == MARA.MATNR
  • OIH_J1B_APR.MANDT == MARA.MANDT
Tax Region
  • ?
  • Tax Region
Unit for price (Brazil tax)
  • OIH_J1B_APR.MANDT == T006.MANDT
  • OIH_J1B_APR.UNIT == T006.MSEHI
Account Number of Supplier
  • OIH_J1B_APR.MANDT == LFA1.MANDT
  • OIH_J1B_APR.VENDOR == LFA1.LIFNR
Other Relations | to Master Data Relations ↑ Join Conditions
Material tax group