OIURV_SSTD

Settlement statement detail | #masterdata | Component: Valuation

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

Column Name	Description
MANDT	Client
DOC_NO	Val. document number
DOC_YEAR	Document year
LINE_ITEM_NO	Document Line Item Number

Column Name	Description
💲 Currency Key (CURR):
ACTL_GR_VAL	Actual Gross Value Amount

Column Name	Description
📏 Measurement unit (TOT_GR_VL_U):
ACTL_GR_VL	Actual Gross Volume Amount
PVR	Plant volume reduction amount
📏 Measurement unit (ENERGY_U):
ACTL_ENERGY	Actual Energy
📏 Measurement unit (HEAT_VAL_FCT_U):
ACT_HEAT_VAL_FCT	Actual Heating Factor

Column Name	Description
SALE_DT	Sales Date / Month

Column Name	Description
LINE_ITEM_STS_CD	Line Item Processing Status	Show values
FREQ_CD	Frequency	Show values
CALC_TAXES_FL	Calculate Tax Flag	Show values

Column Name	Description	Domain name
REJ_RSN_CD	Rejection Reason Code	OIU_REJ_RSN_CD
HEAT_VAL_CLS	Heat value class	OIUVL_HEAT_VAL_CLS
OIU_CRUSER	Name of Person Responsible for Creating the Object	USNAM
OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
VL_DOC_NO	Val. document number	OIU_MP_NO

Master Data Relations	Join Conditions
Company Code	`OIURV_SSTD.MANDT == T001.MANDT` `OIURV_SSTD.BUKRS == T001.BUKRS`
Cost Center Sales Date / Month Cost Center ?	`OIURV_SSTD.MANDT == CSKS.MANDT` `OIURV_SSTD.SALE_DT == CSKS.DATBI` `OIURV_SSTD.COST_CENTER == CSKS.KOSTL` `OIURV_SSTD.[column in domain "KOKRS"] == CSKS.KOKRS`
Contract Number	`OIURV_SSTD.MANDT == OIUCM_CONTRACT.MANDT` `OIURV_SSTD.CT_NO == OIUCM_CONTRACT.VBELN`
Currency Key	`OIURV_SSTD.MANDT == TCURC.MANDT` `OIURV_SSTD.CURR == TCURC.WAERS`
Division of interest (DOI) Joint venture Division of interest (DOI) Company Code	`OIURV_SSTD.MANDT == OIU_DO_DI.MANDT` `OIURV_SSTD.VNAME == OIU_DO_DI.VNAME` `OIURV_SSTD.DOI_NO == OIU_DO_DI.DOI_NO` `OIURV_SSTD.BUKRS == OIU_DO_DI.BUKRS`
Measurement unit	`OIURV_SSTD.MANDT == T006.MANDT` `OIURV_SSTD.ENERGY_U == T006.MSEHI`
Measurement unit	`OIURV_SSTD.MANDT == T006.MANDT` `OIURV_SSTD.HEAT_VAL_FCT_U == T006.MSEHI`
Material Number	`OIURV_SSTD.MANDT == OIU_CM_MAT_PRCD.MANDT` `OIURV_SSTD.MATNR == OIU_CM_MAT_PRCD.MATNR`
Prior Period Adjustment Reason Code	`OIURV_SSTD.MANDT == OIU_CM_PPARSN.MANDT` `OIURV_SSTD.PPA_RSN_CD == OIU_CM_PPARSN.PPA_RSN_CD`
Purchaser's Xref Product / Material ? Purchaser's Lease Number Purchaser's Xref Product / Material Sales Date / Month	`OIURV_SSTD.MANDT == OIU_RV_PDXSS.MANDT` `OIURV_SSTD.[column in domain "OIU_PU_NO"] == OIU_RV_PDXSS.PU_NO` `OIURV_SSTD.PU_VNAME == OIU_RV_PDXSS.PU_VNAME` `OIURV_SSTD.PU_MATNR == OIU_RV_PDXSS.PU_MATNR` `OIURV_SSTD.SALE_DT == OIU_RV_PDXSS.EFF_FROM_DT`
Purchaser's Lease Number ? Purchaser's Lease Number Purchaser's Xref Product / Material Sales Date / Month	`OIURV_SSTD.MANDT == OIU_RV_PDXSS.MANDT` `OIURV_SSTD.[column in domain "OIU_PU_NO"] == OIU_RV_PDXSS.PU_NO` `OIURV_SSTD.PU_VNAME == OIU_RV_PDXSS.PU_VNAME` `OIURV_SSTD.PU_MATNR == OIU_RV_PDXSS.PU_MATNR` `OIURV_SSTD.SALE_DT == OIU_RV_PDXSS.EFF_FROM_DT`
PVR Volume Unit of Measure	`OIURV_SSTD.MANDT == T006.MANDT` `OIURV_SSTD.PVR_AM_U == T006.MSEHI`
Measurement unit	`OIURV_SSTD.MANDT == T006.MANDT` `OIURV_SSTD.TOT_GR_VL_U == T006.MSEHI`
Volume type code	`OIURV_SSTD.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD`
Joint venture Joint venture Company Code	`OIURV_SSTD.MANDT == OIU_DO_JV.MANDT` `OIURV_SSTD.VNAME == OIU_DO_JV.VNAME` `OIURV_SSTD.BUKRS == OIU_DO_JV.BUKRS`