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 Request UUID
KEY externalmasterdataproviderid MDQDPI_PROVIDER_ID Data Provider ID
KEY bpreferencerecordexternalid MDQDPI_REFREC_EXTERNAL_ID ID
businesspartnerfullname MDQDPIMP_BP_NAME Name
streetname AD_STREET Street
housenumber AD_HSNM1 House Number
cityname AD_CITY1 City
postalcode AD_PSTCD1 Postal Code
country MDQDPIMP_BP_COUNTRY_REGION Country/Region
bpidentificationnumber MDQDPI_TAX_ID_NUMBER Tax/ID Number
bprefrecordproviderscorevalue MDQDPIMP_OVERALL_SCORE_VALUE Score
bprefrecdprvdrresponseposition MDQDPI_REFREC_RESPONSE_POS Position
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,   -- Request UUID [MDQDPI_REQUEST_UUID]
    EXTERNALMASTERDATAPROVIDERID,    -- Data Provider ID [MDQDPI_PROVIDER_ID]
    BPREFERENCERECORDEXTERNALID,     -- ID [MDQDPI_REFREC_EXTERNAL_ID]
    BUSINESSPARTNERFULLNAME,         -- Name [MDQDPIMP_BP_NAME]
    STREETNAME,                      -- Street [AD_STREET]
    HOUSENUMBER,                     -- House Number [AD_HSNM1]
    CITYNAME,                        -- City [AD_CITY1]
    POSTALCODE,                      -- Postal Code [AD_PSTCD1]
    COUNTRY,                         -- Country/Region [MDQDPIMP_BP_COUNTRY_REGION]
    BPIDENTIFICATIONNUMBER,          -- Tax/ID Number [MDQDPI_TAX_ID_NUMBER]
    BPREFRECORDPROVIDERSCOREVALUE,   -- Score [MDQDPIMP_OVERALL_SCORE_VALUE]
    BPREFRECDPRVDRRESPONSEPOSITION,  -- Position [MDQDPI_REFREC_RESPONSE_POS]
    CREATEDAT,                       -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (CLIENT, EXTERNALMDPROVIDERREQUESTUUID, EXTERNALMASTERDATAPROVIDERID, BPREFERENCERECORDEXTERNALID)
);

Learn More