SAP /SRMSMC/S_DNB_LU table - Structure of the DNB Lookup Response details in SAP

SAP /SRMSMC/S_DNB_LU table summary

Object Name: /SRMSMC/S_DNB_LU
Dictionary Type: Structure
Description: Structure of the DNB Lookup Response

Field list for /SRMSMC/S_DNB_LU table on an S/4 SAP system

Details

/SRMSMC/S_DNB_LU-DUNS table field - Unique D&B identifier for this company ▼

Description: Unique D&B identifier for this company
Field Name: DUNS
Data Element: /SRMSMC/DNB_DUNS_NBR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUNS

/SRMSMC/S_DNB_LU-REQUEST table field - UTC Time Stamp in Short Form (YYYYMMDDhhmmss) ▼

Description: UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Field Name: REQUEST
Data Element: TIMESTAMP
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQUEST

/SRMSMC/S_DNB_LU-CREA_UNAME table field - User Name ▼

Description: User Name
Field Name: CREA_UNAME
Data Element: UNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: UNAME
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREA_UNAME

/SRMSMC/S_DNB_LU-ADR_LINE table field - Address line of physical location ▼

Description: Address line of physical location
Field Name: ADR_LINE
Data Element: /SRMSMC/DNB_ADR_LINE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADR_LINE

/SRMSMC/S_DNB_LU-BR_IND table field - Indicates whether subject is a branch location ▼

Description: Indicates whether subject is a branch location
Field Name: BR_IND
Data Element: /SRMSMC/DNB_BR_IND
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/DNB_YES_NO
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BR_IND

/SRMSMC/S_DNB_LU-CONF_CD table field - Confidence code for the matches obtained ▼

Description: Confidence code for the matches obtained
Field Name: CONF_CD
Data Element: /SRMSMC/DNB_CONF_CD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONF_CD

/SRMSMC/S_DNB_LU-CTRY_CD table field - The 2-character ISO code for the country/region ▼

Description: The 2-character ISO code for the country/region
Field Name: CTRY_CD
Data Element: /SRMSMC/DNB_CTRY_CD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CTRY_CD

/SRMSMC/S_DNB_LU-DSR table field - Indicator signifying company is a D-U-N-S® Support Record ▼

Description: Indicator signifying company is a D-U-N-S® Support Record
Field Name: DSR
Data Element: /SRMSMC/DNB_DSR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SRMSMC/DNB_DSR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSR

/SRMSMC/S_DNB_LU-DUNS_NBR table field - Unique D&B identifier for this company ▼

Description: Unique D&B identifier for this company
Field Name: DUNS_NBR
Data Element: /SRMSMC/DNB_DUNS_NBR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUNS_NBR

/SRMSMC/S_DNB_LU-IN_DT_IND table field - An indicator ▼

Description: An indicator
Field Name: IN_DT_IND
Data Element: /SRMSMC/DNB_IN_DT_IND
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IN_DT_IND

/SRMSMC/S_DNB_LU-MTCH_GRD table field - A sequence of match grades for inputs ▼

Description: A sequence of match grades for inputs
Field Name: MTCH_GRD
Data Element: /SRMSMC/DNB_MTCH_GRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MTCH_GRD

/SRMSMC/S_DNB_LU-NME table field - Business name or principal name from inquiry request ▼

Description: Business name or principal name from inquiry request
Field Name: NME
Data Element: /SRMSMC/DNB_NME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NME

/SRMSMC/S_DNB_LU-NME_PCT_GRD table field - The percentage of match for the Name in the request ▼

Description: The percentage of match for the Name in the request
Field Name: NME_PCT_GRD
Data Element: /SRMSMC/DNB_NME_PCT_GRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NME_PCT_GRD

/SRMSMC/S_DNB_LU-NON_POST_TOWN table field - Non-postal town ▼

Description: Non-postal town
Field Name: NON_POST_TOWN
Data Element: /SRMSMC/DNB_NON_POST_TOWN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NON_POST_TOWN

/SRMSMC/S_DNB_LU-NON_POST_TWN_PCT_GRD table field - The percentage of match for the City in the request ▼

Description: The percentage of match for the City in the request
Field Name: NON_POST_TWN_PCT_GRD
Data Element: /SRMSMC/DNB_NON_PSTTWN_PCT_GRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NON_POST_TWN_PCT_GRD

/SRMSMC/S_DNB_LU-PRIM_GEO_AREA table field - Main sub-entity within the ctry/reg, such as state, province ▼

Description: Main sub-entity within the ctry/reg, such as state, province
Field Name: PRIM_GEO_AREA
Data Element: /SRMSMC/DNB_PRIM_GEO_AREA
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRIM_GEO_AREA

/SRMSMC/S_DNB_LU-POST_CODE table field - The country/region-specific post code ▼

Description: The country/region-specific post code
Field Name: POST_CODE
Data Element: /SRMSMC/DNB_POST_CODE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_CODE

/SRMSMC/S_DNB_LU-POST_TOWN table field - Postal town where the business is located ▼

Description: Postal town where the business is located
Field Name: POST_TOWN
Data Element: /SRMSMC/DNB_POST_TOWN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_TOWN

/SRMSMC/S_DNB_LU-PO_BOX_PCT_GRD table field - The percentage of match for the PO Box in the request ▼

Description: The percentage of match for the PO Box in the request
Field Name: PO_BOX_PCT_GRD
Data Element: /SRMSMC/DNB_PO_BOX_PCT_GRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX_PCT_GRD

/SRMSMC/S_DNB_LU-PRIM_GEO_AREA_NBR_PCT_GRD table field - The percentage match of the main sub-entity in the ctry/reg ▼

Description: The percentage match of the main sub-entity in the ctry/reg
Field Name: PRIM_GEO_AREA_NBR_PCT_GRD
Data Element: /SRMSMC/DNB_PRIGEOANBR_PCT_GRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRIM_GEO_AREA_NBR_PCT_GRD

/SRMSMC/S_DNB_LU-PROB_OF_ACCR table field - The field that reflects the overall quality of the match ▼

Description: The field that reflects the overall quality of the match
Field Name: PROB_OF_ACCR
Data Element: /SRMSMC/DNB_PROB_OF_ACCR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROB_OF_ACCR

/SRMSMC/S_DNB_LU-STR_NBR_PCT_GRD table field - The percentage of match for the Street Number in the request ▼

Description: The percentage of match for the Street Number in the request
Field Name: STR_NBR_PCT_GRD
Data Element: /SRMSMC/DNB_STR_NBR_PCT_GRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STR_NBR_PCT_GRD

/SRMSMC/S_DNB_LU-STR_NME_PCT_GRD table field - The percentage of match for the Street Name in the request ▼

Description: The percentage of match for the Street Name in the request
Field Name: STR_NME_PCT_GRD
Data Element: /SRMSMC/DNB_STR_NME_PCT_GRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STR_NME_PCT_GRD

/SRMSMC/S_DNB_LU-SBRI_UMTC_AGN table field - Gen. number from the Small Business Risk Insight database ▼

Description: Gen. number from the Small Business Risk Insight database
Field Name: SBRI_UMTC_AGN
Data Element: /SRMSMC/DNB_SBRI_UMTC_AGN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SBRI_UMTC_AGN

/SRMSMC/S_DNB_LU-TLCM_NBR table field - The main telephone number of the business ▼

Description: The main telephone number of the business
Field Name: TLCM_NBR
Data Element: /SRMSMC/DNB_TLCM_NBR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TLCM_NBR

/SRMSMC/S_DNB_LU-TLCM_PCT_GRD table field - The percentage of match for the telephone ▼

Description: The percentage of match for the telephone
Field Name: TLCM_PCT_GRD
Data Element: /SRMSMC/DNB_TLCM_PCT_GRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TLCM_PCT_GRD

/SRMSMC/S_DNB_LU-TRDG_STYL table field - Trade styles used by business ▼

Description: Trade styles used by business
Field Name: TRDG_STYL
Data Element: /SRMSMC/DNB_TRDG_STYL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRDG_STYL

/SRMSMC/S_DNB_LU-MTCH_BASS table field - ▼

Description:
Field Name: MTCH_BASS
Data Element: /SRMSMC/S_DNB_MTCH_BASS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MTCH_BASS

/SRMSMC/S_DNB_LU-MTCH_BASS_ENTR table field - ▼

Description:
Field Name: MTCH_BASS_ENTR
Data Element: /SRMSMC/S_DNB_MTCH_BASS_ENTR_A
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MTCH_BASS_ENTR

/SRMSMC/S_DNB_LU-ARRAY_OF_MTCH_BASS_ENTRITEM table field - ▼

Description:
Field Name: ARRAY_OF_MTCH_BASS_ENTRITEM
Data Element: /SRMSMC/T_DNB_MTCH_BASS_ENTR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ARRAY_OF_MTCH_BASS_ENTRITEM

/SRMSMC/S_DNB_LU-MTCH_CNT table field - ▼

Description:
Field Name: MTCH_CNT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MTCH_CNT

View list of all SAP tables(S4H/ECC)

Select data from SAP table