/dmbe/i_Oil_partner_filter

OIL Partner roles filter | view: /DMBE/OILFILTER | Extraction: Not supported | Component: Commodity Management – Deal Capture
Tables used: OIJRRA
Column Name Description
kunnr FK Customer Number
lifnr FK Account Number of Supplier
werk FK Plant
lgort FK Storage location
rtype FK OIL-TSW: Role type
rdiff OIL-TSW: Role differentiator
Column Name Description
Column Name Description
Column Name Description
erdat Date on which the record was created
erzeit Time of creation
aedat Last Changed On
aezeit Time of day the record was changed
Column Name Description
bloind Blocking indicator Show values
delind Deletion indicator Show values
tktselect Flag to Set Tickets Selectable Show values
Column Name Description Domain name
cparid Location Partner OIJ_PARTNR
parnm OIL-TSW: Common partner name NAME
tsparid OIL-TSW: Pipeline partner ID CHAR30
ernam Name of Person Responsible for Creating the Object USNAM
aenam Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Client
  • /DMBE/I_OIL_PARTNER_FILTER.KUNNR == KNA1.KUNNR
  • /DMBE/I_OIL_PARTNER_FILTER.MANDT == KNA1.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • /DMBE/I_OIL_PARTNER_FILTER.LGORT == T001L.LGORT
  • /DMBE/I_OIL_PARTNER_FILTER.MANDT == T001L.MANDT
  • /DMBE/I_OIL_PARTNER_FILTER.WERK == T001L.WERKS
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • /DMBE/I_OIL_PARTNER_FILTER.LIFNR == LFA1.LIFNR
  • /DMBE/I_OIL_PARTNER_FILTER.MANDT == LFA1.MANDT
Location ID
  • Location ID
  • Client
  • /DMBE/I_OIL_PARTNER_FILTER.LOCID == OIJLOC.LOCID
  • /DMBE/I_OIL_PARTNER_FILTER.MANDT == OIJLOC.MANDT
OIL-TSW: Role type
  • Client
  • OIL-TSW: Role type
  • /DMBE/I_OIL_PARTNER_FILTER.MANDT == OIJRRT.MANDT
  • /DMBE/I_OIL_PARTNER_FILTER.RTYPE == OIJRRT.RTYPE
OIL-TSW: Ticket number rules
  • Client
  • OIL-TSW: Ticket number rules
  • /DMBE/I_OIL_PARTNER_FILTER.MANDT == OIJHTNR.MANDT
  • /DMBE/I_OIL_PARTNER_FILTER.RULEID == OIJHTNR.RULEID
Transport system
  • Transport system
  • Client
  • /DMBE/I_OIL_PARTNER_FILTER.TSYST == OIJTS.TSYST
  • /DMBE/I_OIL_PARTNER_FILTER.MANDT == OIJTS.MANDT
Plant
  • Client
  • Plant
  • /DMBE/I_OIL_PARTNER_FILTER.MANDT == T001W.MANDT
  • /DMBE/I_OIL_PARTNER_FILTER.WERK == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
OIL-TSW: Role partner type
  • OIL-TSW: Role partner type
  • Client
  • /DMBE/I_OIL_PARTNER_FILTER.RPART == OIJRRPART.RPART
  • /DMBE/I_OIL_PARTNER_FILTER.MANDT == OIJRRPART.MANDT