UPOT_INT_MPVNQCI

Transparent Table Application Table
6 Fields 5 CDS Views

PRA Measuring Pt Vol. No. to UOM QCI Vol. GUID

UPOT_INT_MPVNQCI is an SAP database table in S/4HANA. PRA Measuring Pt Vol. No. to UOM QCI Vol. GUID. It contains 6 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
UPOV_ME_MEDOC_IT_UOM view from Measurement document item (UOM)
UPOV_ME_MEDOC_UOM view from Measurement document header UOM Data
UPOV_MEASDOC_DTL view inner Measurement document Details
UPOV_PR_MPVL_UOM view from Measurement Point Volumetric Data (UOM)
UPOV_UOM_DATA view from UOM data for a Business Key

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY mpvl_no oiu_mpvl_no Document no
KEY mpvl_year oiu_mpvl_year Fiscal Year
KEY bus_key gho_meas_guid Meas. GUIDD
me_docnr oiu_me_docnr DocNr
me_docyr oiu_me_docyr Doc. year

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.

-- PRA Measuring Pt Vol. No. to UOM QCI Vol. GUID
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UPOT_INT_MPVNQCI (
    MANDT,      -- Client [mandt]
    MPVL_NO,    -- Document no [oiu_mpvl_no]
    MPVL_YEAR,  -- Fiscal Year [oiu_mpvl_year]
    BUS_KEY,    -- Meas. GUIDD [gho_meas_guid]
    ME_DOCNR,   -- DocNr [oiu_me_docnr]
    ME_DOCYR,   -- Doc. year [oiu_me_docyr]
    PRIMARY KEY (MANDT, MPVL_NO, MPVL_YEAR, BUS_KEY)
);

Learn More