SAP MHND_MASTER table - SQL Selection of Master Data (Part of mhnd_doc_master) details in SAP

SAP MHND_MASTER table summary

Object Name: MHND_MASTER
Dictionary Type: Structure
Description: SQL Selection of Master Data (Part of mhnd_doc_master)

Field list for MHND_MASTER table on an S/4 SAP system

Details

MHND_MASTER-MANDT_MASTER table field - Client ▼

Description: Client
Field Name: MANDT_MASTER
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: T000
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT_MASTER

MHND_MASTER-BUKRS table field - Document Company Code ▼

Description: Document Company Code
Field Name: BUKRS
Data Element: BBUKRS
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: BUKRS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUKRS

MHND_MASTER-DUNN_BUKRS table field - Company Code ▼

Description: Company Code
Field Name: DUNN_BUKRS
Data Element: BUKRS
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: BUKRS
MemoryID: BUK
AppClass: FB
SHLP: C_T001
SHLP Field: BUKRS
ConvExit:

See all SAP tables containing field DUNN_BUKRS

MHND_MASTER-LAND1_KNA1 table field - Country/Region Key ▼

Description: Country/Region Key
Field Name: LAND1_KNA1
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAND1_KNA1

MHND_MASTER-XMABE_T047 table field - Checkbox ▼

Description: Checkbox
Field Name: XMABE_T047
Data Element: XFELD
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XMABE_T047

MHND_MASTER-XSTMV_T047 table field - Checkbox ▼

Description: Checkbox
Field Name: XSTMV_T047
Data Element: XFELD
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XSTMV_T047

MHND_MASTER-KUNNR_MASTER table field - Customer Number ▼

Description: Customer Number
Field Name: KUNNR_MASTER
Data Element: KUNNR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID: KUN
AppClass: V
SHLP: C_KUNNR
SHLP Field: KUNNR
ConvExit: ALPHA

See all SAP tables containing field KUNNR_MASTER

MHND_MASTER-DUNN_KUNNR table field - Customer Number ▼

Description: Customer Number
Field Name: DUNN_KUNNR
Data Element: KUNNR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID: KUN
AppClass: V
SHLP: C_KUNNR
SHLP Field: KUNNR
ConvExit: ALPHA

See all SAP tables containing field DUNN_KUNNR

MHND_MASTER-XCPDK table field - Indicator: Is the account a one-time account? ▼

Description: Indicator: Is the account a one-time account?
Field Name: XCPDK
Data Element: XCPDK
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XCPDK

MHND_MASTER-LIFNR_KNA1 table field - Account Number of Supplier ▼

Description: Account Number of Supplier
Field Name: LIFNR_KNA1
Data Element: LIFNR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: LIFNR
MemoryID: LIF
AppClass: FB
SHLP: KRED_C
SHLP Field: LIFNR
ConvExit: ALPHA

See all SAP tables containing field LIFNR_KNA1

MHND_MASTER-PSTLZ_KNA1 table field - Postal Code ▼

Description: Postal Code
Field Name: PSTLZ_KNA1
Data Element: PSTLZ
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: PSTLZ
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PSTLZ_KNA1

MHND_MASTER-ORT01_KNA1 table field - City ▼

Description: City
Field Name: ORT01_KNA1
Data Element: ORT01_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: TEXT35
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORT01_KNA1

MHND_MASTER-STRAS_KNA1 table field - Street and House Number ▼

Description: Street and House Number
Field Name: STRAS_KNA1
Data Element: STRAS_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: TEXT35
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STRAS_KNA1

MHND_MASTER-PFACH_KNA1 table field - PO Box ▼

Description: PO Box
Field Name: PFACH_KNA1
Data Element: PFACH
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: PFACH
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PFACH_KNA1

MHND_MASTER-BUSAB table field - Dunning Clerk ▼

Description: Dunning Clerk
Field Name: BUSAB
Data Element: BUSAB_MA
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: BUSAB
MemoryID:
AppClass: FBM
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUSAB

MHND_MASTER-XVERR_KNB1 table field - Indicator: Clearing between customer and vendor ? ▼

Description: Indicator: Clearing between customer and vendor ?
Field Name: XVERR_KNB1
Data Element: XVERR_KNB1
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XVERR_KNB1

MHND_MASTER-VZSKZ table field - Interest Indicator ▼

Description: Interest Indicator
Field Name: VZSKZ
Data Element: VZSKZ
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: VZSKZ
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VZSKZ

MHND_MASTER-XDIRECT_DEBIT table field - Indicator: Payment Method Used for Incoming Payments ▼

Description: Indicator: Payment Method Used for Incoming Payments
Field Name: XDIRECT_DEBIT
Data Element: XEINZ
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XDIRECT_DEBIT

MHND_MASTER-ZAHLS_KNB1 table field - Block Key for Payment ▼

Description: Block Key for Payment
Field Name: ZAHLS_KNB1
Data Element: DZAHLS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ZAHLS_KNB1

MHND_MASTER-MGRUP_KNB1 table field - Key for Dunning Notice Grouping ▼

Description: Key for Dunning Notice Grouping
Field Name: MGRUP_KNB1
Data Element: MGRUP
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: MGRUP
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MGRUP_KNB1

MHND_MASTER-XDEZV_KNB1 table field - Indicator: Local Processing? ▼

Description: Indicator: Local Processing?
Field Name: XDEZV_KNB1
Data Element: XDEZV
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XDEZV_KNB1

MHND_MASTER-KNRZE_KNB1 table field - Head office account number (in branch accounts) ▼

Description: Head office account number (in branch accounts)
Field Name: KNRZE_KNB1
Data Element: KNRZE
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field KNRZE_KNB1

MHND_MASTER-MAHNA table field - Dunning Procedure ▼

Description: Dunning Procedure
Field Name: MAHNA
Data Element: MAHNA
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: MAHNA
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAHNA

MHND_MASTER-GMVDT table field - Date of the Legal Dunning Proceedings ▼

Description: Date of the Legal Dunning Proceedings
Field Name: GMVDT
Data Element: GMVDT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GMVDT

MHND_MASTER-MABER_KNB5 table field - Dunning Area ▼

Description: Dunning Area
Field Name: MABER_KNB5
Data Element: MABER
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: MABER
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MABER_KNB5

MHND_MASTER-MANSP_KNB5 table field - Dunning Block ▼

Description: Dunning Block
Field Name: MANSP_KNB5
Data Element: MANSP
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: MANSP
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANSP_KNB5

MHND_MASTER-MADAT_KNB5 table field - Date of Last Dunning Notice ▼

Description: Date of Last Dunning Notice
Field Name: MADAT_KNB5
Data Element: MADAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MADAT_KNB5

MHND_MASTER-MAHNS_KNB5 table field - Old Dunning Level ▼

Description: Old Dunning Level
Field Name: MAHNS_KNB5
Data Element: MAHNS_ALT
Data Type: NUMC
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: MAHNS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAHNS_KNB5

MHND_MASTER-EARLIEST_NEXT_MADAT table field - Date of Last Dunning Notice ▼

Description: Date of Last Dunning Notice
Field Name: EARLIEST_NEXT_MADAT
Data Element: MADAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EARLIEST_NEXT_MADAT

MHND_MASTER-KNRMA_KNB5 table field - Account Number of the Dunning Recipient ▼

Description: Account Number of the Dunning Recipient
Field Name: KNRMA_KNB5
Data Element: KNRMA
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID: KUN
AppClass: V
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field KNRMA_KNB5

MHND_MASTER-MAX_MAHNS table field - Dunning Level ▼

Description: Dunning Level
Field Name: MAX_MAHNS
Data Element: MAHNS_D
Data Type: NUMC
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: MAHNS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_MAHNS

MHND_MASTER-KULEP_T047A table field - Grace Periods per Line Item ▼

Description: Grace Periods per Line Item
Field Name: KULEP_T047A
Data Element: KULEP_047A
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: NUM03
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KULEP_T047A

MHND_MASTER-XNUMS_T047A table field - Include Standard Transactions? ▼

Description: Include Standard Transactions?
Field Name: XNUMS_T047A
Data Element: XNUMS_047A
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XNUMS_T047A

MHND_MASTER-UMSKD_T047A table field - List of Special G/L Indicators to Be Edited ▼

Description: List of Special G/L Indicators to Be Edited
Field Name: UMSKD_T047A
Data Element: UMSKL_047A
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UMSKD_T047A

MHND_MASTER-UMSKK_T047A table field - List of Special G/L Indicators to Be Edited ▼

Description: List of Special G/L Indicators to Be Edited
Field Name: UMSKK_T047A
Data Element: UMSKL_047A
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UMSKK_T047A

MHND_MASTER-LIFNR table field - Account Number of Supplier ▼

Description: Account Number of Supplier
Field Name: LIFNR
Data Element: LIFNR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: LIFNR
MemoryID: LIF
AppClass: FB
SHLP: KRED_C
SHLP Field: LIFNR
ConvExit: ALPHA

See all SAP tables containing field LIFNR

MHND_MASTER-KUNNR_LFA1 table field - Customer Number ▼

Description: Customer Number
Field Name: KUNNR_LFA1
Data Element: KUNNR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID: KUN
AppClass: V
SHLP: C_KUNNR
SHLP Field: KUNNR
ConvExit: ALPHA

See all SAP tables containing field KUNNR_LFA1

MHND_MASTER-XVERR_LFB1 table field - Indicator: Clearing between customer and vendor? ▼

Description: Indicator: Clearing between customer and vendor?
Field Name: XVERR_LFB1
Data Element: XVERR_LFB1
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XVERR_LFB1

View list of all SAP tables(S4H/ECC)

Select data from SAP table