I_OilPartnerRoles

OIL TSW: Partner roles | view: IOILPARTNERROLES | Extraction: Not supported | Component: Downstream

Tables used: OIJRRA

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical
Other
🔗 Relations (7)

Column Name	Description
Customer FK	Customer Number
SupplierAccount FK	Account Number of Supplier
Plant FK	Plant
StorageLocation FK	Storage location
OilRoleType FK	OIL-TSW: Role type
OilRoleDifferentiation	OIL-TSW: Role differentiator

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description	Domain name

Master Data Relations	Join Conditions
Customer Number Customer Number Client	`I_OILPARTNERROLES.CUSTOMER == KNA1.KUNNR` `I_OILPARTNERROLES.MANDT == KNA1.MANDT`
Location ID Client Location ID	`I_OILPARTNERROLES.MANDT == OIJLOC.MANDT` `I_OILPARTNERROLES.LOCATIONID == OIJLOC.LOCID`
OIL-TSW: Role type Client OIL-TSW: Role type	`I_OILPARTNERROLES.MANDT == OIJRRT.MANDT` `I_OILPARTNERROLES.OILROLETYPE == OIJRRT.RTYPE`
Plant Client Plant	`I_OILPARTNERROLES.MANDT == T001W.MANDT` `I_OILPARTNERROLES.PLANT == T001W.WERKS`
Storage location Client Storage location Plant	`I_OILPARTNERROLES.MANDT == T001L.MANDT` `I_OILPARTNERROLES.STORAGELOCATION == T001L.LGORT` `I_OILPARTNERROLES.PLANT == T001L.WERKS`
Account Number of Supplier Client Account Number of Supplier	`I_OILPARTNERROLES.MANDT == LFA1.MANDT` `I_OILPARTNERROLES.SUPPLIERACCOUNT == LFA1.LIFNR`

Other Relations \| to Master Data Relations ↑	Join Conditions
OIL-TSW: Role partner type Client OIL-TSW: Role partner type	`I_OILPARTNERROLES.MANDT == OIJRRPART.MANDT` `I_OILPARTNERROLES.OILPARTNERROLETYPE == OIJRRPART.RPART`