I_FreightContractVH

Value Help for Freight Contract | view: IFRCNTRCTVH | TRAN | Extraction: Not supported | Component: Cost Management for Hydrocarbons
Tables used: EKKO, EKPO, EKET, OIJ_EL_CP_LAYT, OIJ_EL_LAYT_INF, LFA1, T161
Column Name Description
FreightContract Purchasing Document Number
FreightContractItem null
SequenceNumber TSW: Sequence number
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
ScheduleLine Delivery Schedule Line Counter EETEN
OrganizationBPName1 Name 1 NAME
Batch Batch Number CHARG
ExchangeAgreement Exchange agreement number OIA_EXGNUM
ExchangeAgreementType Exchange type OIA_EXGTYP
ModeOfTransport IS-OIL MAP external details mode of transport VKTRA
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_FREIGHTCONTRACTVH.COMPANYCODE == T001.BUKRS
  • I_FREIGHTCONTRACTVH.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • I_FREIGHTCONTRACTVH.MANDT == TCURC.MANDT
  • I_FREIGHTCONTRACTVH.DOCUMENTCURRENCY == TCURC.WAERS
Location ID
  • Location ID
  • Client
  • I_FREIGHTCONTRACTVH.LOCATIONID == OIJLOC.LOCID
  • I_FREIGHTCONTRACTVH.MANDT == OIJLOC.MANDT
Material Number
  • Client
  • Material Number
  • I_FREIGHTCONTRACTVH.MANDT == MARA.MANDT
  • I_FREIGHTCONTRACTVH.MATERIAL == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_FREIGHTCONTRACTVH.MANDT == T006.MANDT
  • I_FREIGHTCONTRACTVH.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • I_FREIGHTCONTRACTVH.MANDT == T001W.MANDT
  • I_FREIGHTCONTRACTVH.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • I_FREIGHTCONTRACTVH.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_FREIGHTCONTRACTVH.[column in domain "BSTYP"] == T161.BSTYP
  • I_FREIGHTCONTRACTVH.MANDT == T161.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_FREIGHTCONTRACTVH.PURCHASINGORGANIZATION == T024E.EKORG
  • I_FREIGHTCONTRACTVH.MANDT == T024E.MANDT
Storage location
  • Client
  • Plant
  • Storage location
  • I_FREIGHTCONTRACTVH.MANDT == T001L.MANDT
  • I_FREIGHTCONTRACTVH.PLANT == T001L.WERKS
  • I_FREIGHTCONTRACTVH.STORAGELOCATION == T001L.LGORT
Vendor's account number
  • Client
  • Vendor's account number
  • I_FREIGHTCONTRACTVH.MANDT == LFA1.MANDT
  • I_FREIGHTCONTRACTVH.SUPPLIER == LFA1.LIFNR
Valuation Type
  • Client
  • Valuation Type
  • I_FREIGHTCONTRACTVH.MANDT == T149D.MANDT
  • I_FREIGHTCONTRACTVH.VALUATIONTYPE == T149D.BWTAR
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • I_FREIGHTCONTRACTVH.MANDT == OIGV.CLIENT
  • I_FREIGHTCONTRACTVH.VEHICLEID == OIGV.VEHICLE