OIFBBP1

Business partner role assignments (IS-Oil MRN) | #masterdata | Component: Marketing Retail Network
Column Name Description
MANDT FK Client
PBLNR FK Business location identifier (IS-Oil MRN)
PARFN FK MRN business partner role / relation type
FTMSTM Start of partner function validity period: time stamp
PARPOS Partner counter
Column Name Description
💲 Currency Key (SBBEZ):
BBEZ Relationship amount
Column Name Description
Column Name Description
ERDAT Date Record Created on (Date)
ERZEIT Time Record Created at (Time)
AEDAT Date Record Changed on (Date)
AEZEIT Time when Record Was Changed
Column Name Description
BLOIND Block Indicator Show values
DELIND Deletion indicator Show values
GENPAR Partner entry generated for role: IS-Oil MRN Show values
GENINS Suppress location entry generation in partner - IS-Oil MRN Show values
MANDEL Location entry in partner was manually deleted (IS-Oil MRN) Show values
Column Name Description Domain name
TTMSTM End of partner function validity period - timestamp OIF_TMSTM
ERNAM User who Created Record USNAM
AENAM User who Changed Record USNAM
PBEZ Relationship percentage DEC3_7
Master Data Relations Join Conditions
User Name in User Master Record
  • OIFBBP1.MANDT == USR02.MANDT
  • OIFBBP1.BNAME == USR02.BNAME
ID of customer/debitor business partner
  • OIFBBP1.MANDT == KNA1.MANDT
  • OIFBBP1.KUNNR == KNA1.KUNNR
ID of vendor/creditor business partner
  • OIFBBP1.MANDT == LFA1.MANDT
  • OIFBBP1.LIFNR == LFA1.LIFNR
Foreign key relationship between oifpbl and t000 mandt OIFBBP1.MANDT == T000.MANDT
MRN business partner role / relation type
  • MRN business partner role / relation type
  • Client
Technical characteristic for partner role
Business location identifier (IS-Oil MRN)
  • Business location identifier (IS-Oil MRN)
  • Client
Currency Key
  • OIFBBP1.MANDT == TCURC.MANDT
  • OIFBBP1.SBBEZ == TCURC.WAERS
Division
  • OIFBBP1.MANDT == TSPA.MANDT
  • OIFBBP1.SPART == TSPA.SPART
Sales Organization
  • OIFBBP1.MANDT == TVKO.MANDT
  • OIFBBP1.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • OIFBBP1.VTWEG == TVTW.VTWEG
  • OIFBBP1.MANDT == TVTW.MANDT