OIURV_SSTD

Transparent Table Application Table
31 Fields 1 CDS Views

Settlement statement detail

OIURV_SSTD is an SAP database table in S/4HANA. Settlement statement detail. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRASettlmtStmntDetail view_entity from BASIC Settlement statement detail

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY doc_no oiurv_docnr DocNr
KEY doc_year oiu_doc_year Document year
KEY line_item_no oiuvl_line_item_no Doc ln item no
line_item_sts_cd oiuvl_line_item_sts_cd Line status cd
rej_rsn_cd oiu_rej_rsn_cd Rejection Rsn
pu_vname oiu_pu_jv_name Purch Lease No
pu_matnr oiu_pu_matnr Xref Mat
matnr matnr Material
sale_dt oiu_sale_dt Sales Date
ct_no oiu_ct_no Contract
ppa_rsn_cd oiu_ppa_rsn_cd PPA Reason
freq_cd oiu_freq_cd Frequency
cost_center kostl Cost Center
bukrs bukrs Company Code
vname jv_name Joint venture
doi_no oiu_doi_no Venture/DOI
vl_type_cd oiu_vt_cd Volume Type
tot_gr_vl_u oiu_meas_u UoM
actl_gr_vl oiu_actl_gr_vl_am Act Gross Vol
energy_u oiu_meas_u UoM
actl_energy oiu_actl_energy Energy
pvr_am_u oiuvl_pvr_am_u PVR amt uom
heat_val_fct_u oiu_meas_u UoM
act_heat_val_fct oiu_act_heat_val_fct Actual Heat Fct
curr waers Currency
actl_gr_val oiu_actl_gr_val_am Gross Value
heat_val_cls oiuvl_heat_val_cls Heat val class
calc_taxes_fl oiu_tax_calc_fl Calc Tax
pvr oiuvl_pvr Plant vol red
vl_doc_no oiurv_docnr DocNr

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Settlement statement detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIURV_SSTD (
    MANDT,             -- Client [mandt]
    DOC_NO,            -- DocNr [oiurv_docnr]
    DOC_YEAR,          -- Document year [oiu_doc_year]
    LINE_ITEM_NO,      -- Doc ln item no [oiuvl_line_item_no]
    LINE_ITEM_STS_CD,  -- Line status cd [oiuvl_line_item_sts_cd]
    REJ_RSN_CD,        -- Rejection Rsn [oiu_rej_rsn_cd]
    PU_VNAME,          -- Purch Lease No [oiu_pu_jv_name]
    PU_MATNR,          -- Xref Mat [oiu_pu_matnr]
    MATNR,             -- Material [matnr]
    SALE_DT,           -- Sales Date [oiu_sale_dt]
    CT_NO,             -- Contract [oiu_ct_no]
    PPA_RSN_CD,        -- PPA Reason [oiu_ppa_rsn_cd]
    FREQ_CD,           -- Frequency [oiu_freq_cd]
    COST_CENTER,       -- Cost Center [kostl]
    BUKRS,             -- Company Code [bukrs]
    VNAME,             -- Joint venture [jv_name]
    DOI_NO,            -- Venture/DOI [oiu_doi_no]
    VL_TYPE_CD,        -- Volume Type [oiu_vt_cd]
    TOT_GR_VL_U,       -- UoM [oiu_meas_u]
    ACTL_GR_VL,        -- Act Gross Vol [oiu_actl_gr_vl_am]
    ENERGY_U,          -- UoM [oiu_meas_u]
    ACTL_ENERGY,       -- Energy [oiu_actl_energy]
    PVR_AM_U,          -- PVR amt uom [oiuvl_pvr_am_u]
    HEAT_VAL_FCT_U,    -- UoM [oiu_meas_u]
    ACT_HEAT_VAL_FCT,  -- Actual Heat Fct [oiu_act_heat_val_fct]
    CURR,              -- Currency [waers]
    ACTL_GR_VAL,       -- Gross Value [oiu_actl_gr_val_am]
    HEAT_VAL_CLS,      -- Heat val class [oiuvl_heat_val_cls]
    CALC_TAXES_FL,     -- Calc Tax [oiu_tax_calc_fl]
    PVR,               -- Plant vol red [oiuvl_pvr]
    VL_DOC_NO,         -- DocNr [oiurv_docnr]
    PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR, LINE_ITEM_NO)
);

Learn More