I_TicketTankSqncNoVH

Tank Sequence Number Value Help | view: ITKTTANKVH | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIISOCIBLOIISOCTSM
Column Name Description
LocationId FK Business location identifier (IS-Oil MRN)
ScheduledMaterial FK Material Number
BusinessPartnerRole FK MRN business partner role / relation type
TankSequenceNumber Sequence number of SO assigned to business location
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
QuantityEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
NominationDoc Nomination (technical) Key OIJ_NOMTK
NominationDocItem Nomination Key Item OIJ_ITEM
Master Data Relations Join Conditions
MRN business partner role / relation type
  • Client
  • MRN business partner role / relation type
  • I_TICKETTANKSQNCNOVH.MANDT == OIFBRF1.MANDT
  • I_TICKETTANKSQNCNOVH.BUSINESSPARTNERROLE == OIFBRF1.PARFN
Business location identifier (IS-Oil MRN)
  • Client
  • Business location identifier (IS-Oil MRN)
  • I_TICKETTANKSQNCNOVH.MANDT == OIFSPBL.MANDT
  • I_TICKETTANKSQNCNOVH.LOCATIONID == OIFSPBL.PBLNR
Material Number
  • Client
  • Material Number
  • I_TICKETTANKSQNCNOVH.MANDT == MARA.MANDT
  • I_TICKETTANKSQNCNOVH.SCHEDULEDMATERIAL == MARA.MATNR
SOC: Storage object characteristic segment number
  • Client
  • SOC: Storage object characteristic segment number
  • I_TICKETTANKSQNCNOVH.MANDT == OIISOCK.MANDT
  • I_TICKETTANKSQNCNOVH.STORAGEOBJECTSEGMENTNUMBER == OIISOCK.SOCNR