UPOV_ALLOC_RESULTS_DIM

CDS View
37 Fields 4 CDS Views

Allocation Results based on dimension

UPOV_ALLOC_RESULTS_DIM is a CDS View in S/4HANA. Allocation Results based on dimension. It contains 37 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
UPOV_ALLOC_RESULTS view left_outer Allocation Results
UPOV_SUMMARY_AT_WC_VT16_DIM view from Allocation Results,VT16 per Dimension
UPOV_SUMMARY_AT_WC_VT91_DIM view from Allocation Results,VT91 per Dimension
UPOV_SUMMARY_AT_WC_VT99_DIM view from Allocation Results, VT99 per Dimension

Fields (37)

KeyField CDS FieldsUsed in Views
alloc_run_id alloc_run_id 3
conv_grp conv_grp 1
created_by created_by 1
created_tst created_tst 1
days_prod days_prod 1
dest_node_id dest_node_id 3
dimension dimension 3
dn_no dn_no 1
doc_year doc_year 1
eff_to_dt eff_to_dt 1
frequency frequency 1
gho_pn_tz gho_pn_tz 1
invt_dt invt_dt 1
material material 3
matnr matnr 3
medium medium 2
netid netid 1
orig_doc_year orig_doc_year 1
orig_no orig_no 1
origin_mp_no origin_mp_no 1
prd_hrs prd_hrs 1
prod_date prod_date 1
prod_time prod_time 1
qty_type qty_type 1
theo_act_ind theo_act_ind 1
theo_unit theo_unit 1
tkt_no tkt_no 1
tkt_timestamp tkt_timestamp 1
trnsp_no trnsp_no 1
trnsp_ref_no trnsp_ref_no 1
unit energy_unit,std_vol_unit,unit 4
vol_type vol_type 1
wc_no wc_no 1
well_floc well_floc 1
wl_no wl_no 1
xref_wc_no xref_wc_no 1
xref_wl_no xref_wl_no 1

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.

-- Allocation Results based on dimension
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UPOV_ALLOC_RESULTS_DIM (
    ALLOC_RUN_ID,
    CONV_GRP,
    CREATED_BY,
    CREATED_TST,
    DAYS_PROD,
    DEST_NODE_ID,
    DIMENSION,
    DN_NO,
    DOC_YEAR,
    EFF_TO_DT,
    FREQUENCY,
    GHO_PN_TZ,
    INVT_DT,
    MATERIAL,
    MATNR,
    MEDIUM,
    NETID,
    ORIG_DOC_YEAR,
    ORIG_NO,
    ORIGIN_MP_NO,
    PRD_HRS,
    PROD_DATE,
    PROD_TIME,
    QTY_TYPE,
    THEO_ACT_IND,
    THEO_UNIT,
    TKT_NO,
    TKT_TIMESTAMP,
    TRNSP_NO,
    TRNSP_REF_NO,
    UNIT,
    VOL_TYPE,
    WC_NO,
    WELL_FLOC,
    WL_NO,
    XREF_WC_NO,
    XREF_WL_NO
);

Learn More