OIUVL_OILTKT_HST

Oil Ticket Current | #masterdata | Component: Valuation

🔑 Keys (5)
💰 Amounts (2)
∑ Quantities (2)
📅 Dates (3)
☰ Categorical (1)
Other (4)
🔗 Relations (14)

Column Name	Description
MANDT FK	Client
OILSTMTH_NO	Header System Number
RUN_TKT_NO	Run Ticket Number
SALE_DT	Sales Date / Month
ORIG_MP_NO	Original measurement point number

Column Name	Description
💲 Currency Key (OIUVL_OILTKT_CUR.VALUE_CURR):
VALUE_AMT	Value after gravity adjustment
💲 Currency Key (OIUVL_OILTKT_CUR.PC_CURR):
PC_AMT	Transporter unit value

Column Name	Description
📏 Density / Gravity Quantity Unit (OIUVL_OILTKT_CUR.DENSITY_U):
DENSITY	Density
📏 Volume Unit (OIUVL_OILTKT_CUR.VOLUME_UNIT):
VOLUME_AMT	Volume (Sales Volume)

Column Name	Description
SALE_DT	Sales Date / Month
EFF_FROM_DT	Effective from date
EFF_TO_DT	Effective To Date

Column Name	Description
VL_CLS_CD	Volume class code	Show values

Column Name	Description	Domain name
TRNSP_REF_NO	Transporter Reference Number	OIU_TEXT25
RVSL_ONLY_FL	Reversal Only Flag	OIU_FLAG
OIU_CRUSER	Name of Person Responsible for Creating the Object	USNAM
OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS

Master Data Relations	Join Conditions
Density / Gravity Quantity Unit	`OIUVL_OILTKT_HST.MANDT == T006.MANDT` `OIUVL_OILTKT_HST.DENSITY_U == T006.MSEHI`
Pricing Procedure in Pricing ? Pricing Procedure in Pricing ?	`OIUVL_OILTKT_HST.MANDT == T683.MANDT` `OIUVL_OILTKT_HST.[column in domain "KAPPL"] == T683.KAPPL` `OIUVL_OILTKT_HST.KALSM == T683.KALSM` `OIUVL_OILTKT_HST.[column in domain "KVEWE"] == T683.KVEWE`
Client	`OIUVL_OILTKT_HST.MANDT == T000.MANDT`
Material Number	`OIUVL_OILTKT_HST.MANDT == OIU_CM_MAT_PRCD.MANDT` `OIUVL_OILTKT_HST.MATNR == OIU_CM_MAT_PRCD.MATNR`
Condition Type Condition Type Client ? ?	`OIUVL_OILTKT_HST.PC_CONDITION == T685.KSCHL` `OIUVL_OILTKT_HST.MANDT == T685.MANDT` `OIUVL_OILTKT_HST.[column in domain "KVEWE"] == T685.KVEWE` `OIUVL_OILTKT_HST.[column in domain "KAPPL"] == T685.KAPPL`
PC Contract Number	`OIUVL_OILTKT_HST.MANDT == OIUCM_CONTRACT.MANDT` `OIUVL_OILTKT_HST.PC_CT_NO == OIUCM_CONTRACT.VBELN`
Currency Key	`OIUVL_OILTKT_HST.MANDT == TCURC.MANDT` `OIUVL_OILTKT_HST.PC_CURR == TCURC.WAERS`
PC Measurement point number	`OIUVL_OILTKT_HST.MANDT == OIU_PR_MP.MANDT` `OIUVL_OILTKT_HST.PC_MP == OIU_PR_MP.MP_NO`
PC Well Completion Number PC Well ID Number PC Well Completion Number	`OIUVL_OILTKT_HST.MANDT == OIU_PR_WC.MANDT` `OIUVL_OILTKT_HST.PC_WL == OIU_PR_WC.WL_NO` `OIUVL_OILTKT_HST.PC_WC == OIU_PR_WC.WC_NO`
PC Well ID Number	`OIUVL_OILTKT_HST.MANDT == OIU_PR_WELL.MANDT` `OIUVL_OILTKT_HST.PC_WL == OIU_PR_WELL.WL_NO`
Transporter number	`OIUVL_OILTKT_HST.MANDT == KNA1.MANDT` `OIUVL_OILTKT_HST.TRNSP_NO == KNA1.KUNNR`
Currency Key	`OIUVL_OILTKT_HST.MANDT == TCURC.MANDT` `OIUVL_OILTKT_HST.VALUE_CURR == TCURC.WAERS`
Volume type code	`OIUVL_OILTKT_HST.VL_TYPE == OIU_PR_VLTYP.VL_TYPE_CD`
Volume Unit	`OIUVL_OILTKT_HST.MANDT == T006.MANDT` `OIUVL_OILTKT_HST.VOLUME_UNIT == T006.MSEHI`