MDQDPI_LOOKUP

Transparent Table Temporary Data
14 Fields 1 CDS Views

Lookup Buffer

MDQDPI_LOOKUP is an SAP database table in S/4HANA. Lookup Buffer. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPReferenceRecord view_entity from Business Partner Reference Record

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY externalmdproviderrequestuuid mdqdpi_request_uuid
KEY externalmasterdataproviderid mdqdpi_provider_id
KEY bpreferencerecordexternalid mdqdpi_refrec_external_id
businesspartnerfullname mdqdpimp_bp_name
streetname ad_street Street
housenumber ad_hsnm1 House Number
cityname ad_city1 City
postalcode ad_pstcd1 Postal Code
country mdqdpimp_bp_country_region
bpidentificationnumber mdqdpi_tax_id_number
bprefrecordproviderscorevalue mdqdpimp_overall_score_value
bprefrecdprvdrresponseposition mdqdpi_refrec_response_pos
createdat timestamp Time Stamp

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.

-- Lookup Buffer
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDQDPI_LOOKUP (
    CLIENT,                          -- Client [mandt]
    EXTERNALMDPROVIDERREQUESTUUID,   -- mdqdpi_request_uuid
    EXTERNALMASTERDATAPROVIDERID,    -- mdqdpi_provider_id
    BPREFERENCERECORDEXTERNALID,     -- mdqdpi_refrec_external_id
    BUSINESSPARTNERFULLNAME,         -- mdqdpimp_bp_name
    STREETNAME,                      -- Street [ad_street]
    HOUSENUMBER,                     -- House Number [ad_hsnm1]
    CITYNAME,                        -- City [ad_city1]
    POSTALCODE,                      -- Postal Code [ad_pstcd1]
    COUNTRY,                         -- mdqdpimp_bp_country_region
    BPIDENTIFICATIONNUMBER,          -- mdqdpi_tax_id_number
    BPREFRECORDPROVIDERSCOREVALUE,   -- mdqdpimp_overall_score_value
    BPREFRECDPRVDRRESPONSEPOSITION,  -- mdqdpi_refrec_response_pos
    CREATEDAT,                       -- Time Stamp [timestamp]
    PRIMARY KEY (CLIENT, EXTERNALMDPROVIDERREQUESTUUID, EXTERNALMASTERDATAPROVIDERID, BPREFERENCERECORDEXTERNALID)
);

Learn More