SAP MATERIAL_ALL_SUPPLIER_INFO table - Supplier information as per Transport optimisation screen details in SAP

SAP MATERIAL_ALL_SUPPLIER_INFO table summary

Object Name: MATERIAL_ALL_SUPPLIER_INFO
Dictionary Type: Structure
Description: Supplier information as per Transport optimisation screen

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

Details

MATERIAL_ALL_SUPPLIER_INFO-MATERIALID table field - Material Number ▼

Description: Material Number
Field Name: MATERIALID
Data Element: MATNR
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine: MATN1
Domain Name: MATNR
MemoryID: MAT
AppClass: MG
SHLP: S_MAT1
SHLP Field: MATNR
ConvExit: MATN1

See all SAP tables containing field MATERIALID

MATERIAL_ALL_SUPPLIER_INFO-MRPPLANT table field - Plant ▼

Description: Plant
Field Name: MRPPLANT
Data Element: WERKS_D
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: WERKS
MemoryID: WRK
AppClass: MG
SHLP: H_T001W_C
SHLP Field: WERKS
ConvExit:

See all SAP tables containing field MRPPLANT

MATERIAL_ALL_SUPPLIER_INFO-DELIVERYDATE table field - UTC Time Stamp in Short Form (YYYYMMDDhhmmss) ▼

Description: UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Field Name: DELIVERYDATE
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 DELIVERYDATE

MATERIAL_ALL_SUPPLIER_INFO-PREFERREDSUPPLIERID table field - Account Number of Supplier ▼

Description: Account Number of Supplier
Field Name: PREFERREDSUPPLIERID
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 PREFERREDSUPPLIERID

MATERIAL_ALL_SUPPLIER_INFO-VENDORNAME table field - Name ▼

Description: Name
Field Name: VENDORNAME
Data Element: NAME1
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VENDORNAME

MATERIAL_ALL_SUPPLIER_INFO-VENDORTYPEFLAG table field - Vendor Type (Standard or Quota) ▼

Description: Vendor Type (Standard or Quota)
Field Name: VENDORTYPEFLAG
Data Element: VENTYPEFLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: VENTYPEFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VENDORTYPEFLAG

MATERIAL_ALL_SUPPLIER_INFO-PREFERVENFLAG table field - Preferred Vendor or not (If marked then preferred Vendor) ▼

Description: Preferred Vendor or not (If marked then preferred Vendor)
Field Name: PREFERVENFLAG
Data Element: PREFERVENFLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PREFERVENFLAG

MATERIAL_ALL_SUPPLIER_INFO-ALTVENDFETCHFLAG table field - Flag for fetching only alternative vendors ▼

Description: Flag for fetching only alternative vendors
Field Name: ALTVENDFETCHFLAG
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 ALTVENDFETCHFLAG

MATERIAL_ALL_SUPPLIER_INFO-CITY table field - City ▼

Description: City
Field Name: CITY
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITY

MATERIAL_ALL_SUPPLIER_INFO-POST_CODE table field - City postal code ▼

Description: City postal code
Field Name: POST_CODE
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_CODE

MATERIAL_ALL_SUPPLIER_INFO-COUNTRY table field - Country/Region Key ▼

Description: Country/Region Key
Field Name: COUNTRY
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 COUNTRY

MATERIAL_ALL_SUPPLIER_INFO-DELIVERYTIME table field - Planned Delivery Time in Days ▼

Description: Planned Delivery Time in Days
Field Name: DELIVERYTIME
Data Element: PLIFZ
Data Type: DEC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DEC3
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DELIVERYTIME

MATERIAL_ALL_SUPPLIER_INFO-ORDERDATE table field - UTC Time Stamp in Short Form (YYYYMMDDhhmmss) ▼

Description: UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Field Name: ORDERDATE
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 ORDERDATE

MATERIAL_ALL_SUPPLIER_INFO-ORDERDAY table field - Number of days to order material ▼

Description: Number of days to order material
Field Name: ORDERDAY
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 ORDERDAY

MATERIAL_ALL_SUPPLIER_INFO-MIN_ORD_QTY table field - Minimum Purchase Order Quantity ▼

Description: Minimum Purchase Order Quantity
Field Name: MIN_ORD_QTY
Data Element: MINBM
Data Type: QUAN
length (Dec): 13(3)
Check table:
Conversion Routine:
Domain Name: MENG13
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIN_ORD_QTY

MATERIAL_ALL_SUPPLIER_INFO-MAX_ORD_QTY table field - Maximum Purchase Order Quantity ▼

Description: Maximum Purchase Order Quantity
Field Name: MAX_ORD_QTY
Data Element: MAXBM
Data Type: QUAN
length (Dec): 13(3)
Check table:
Conversion Routine:
Domain Name: MENG13
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_ORD_QTY

MATERIAL_ALL_SUPPLIER_INFO-ORD_QTY_UNIT table field - Base Unit of Measure ▼

Description: Base Unit of Measure
Field Name: ORD_QTY_UNIT
Data Element: MEINS
Data Type: UNIT
length (Dec): 3(0)
Check table:
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field ORD_QTY_UNIT

MATERIAL_ALL_SUPPLIER_INFO-ORDQTYUNITPRECISION table field - No. of decimal places for rounding ▼

Description: No. of decimal places for rounding
Field Name: ORDQTYUNITPRECISION
Data Element: ANDEC
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: ANDEC
MemoryID:
AppClass: BZME
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORDQTYUNITPRECISION

MATERIAL_ALL_SUPPLIER_INFO-ROUNDING_PROFILE table field - Rounding Profile ▼

Description: Rounding Profile
Field Name: ROUNDING_PROFILE
Data Element: RDPRF
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: RDPRF
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROUNDING_PROFILE

MATERIAL_ALL_SUPPLIER_INFO-NET_PRICE table field - Net Price in Purchasing Info Record ▼

Description: Net Price in Purchasing Info Record
Field Name: NET_PRICE
Data Element: IPREI
Data Type: CURR
length (Dec): 11(2)
Check table:
Conversion Routine:
Domain Name: WERT11
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NET_PRICE

MATERIAL_ALL_SUPPLIER_INFO-CURRENCYKEY table field - Currency Key ▼

Description: Currency Key
Field Name: CURRENCYKEY
Data Element: WAERS
Data Type: CUKY
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: WAERS
MemoryID: FWS
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRENCYKEY

MATERIAL_ALL_SUPPLIER_INFO-CURRENCYKEYPRECISION table field - Number of decimal places ▼

Description: Number of decimal places
Field Name: CURRENCYKEYPRECISION
Data Element: CURRDEC
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CURRDEC
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRENCYKEYPRECISION

MATERIAL_ALL_SUPPLIER_INFO-PRICEUNIT table field - Price unit ▼

Description: Price unit
Field Name: PRICEUNIT
Data Element: PEINH
Data Type: DEC
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: PACK3
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRICEUNIT

MATERIAL_ALL_SUPPLIER_INFO-ORDERPRICEUNIT table field - Order Price Unit (Purchasing) ▼

Description: Order Price Unit (Purchasing)
Field Name: ORDERPRICEUNIT
Data Element: BBPRM
Data Type: UNIT
length (Dec): 3(0)
Check table:
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field ORDERPRICEUNIT

MATERIAL_ALL_SUPPLIER_INFO-CURRENT_QUOTA table field - ▼

Description:
Field Name: CURRENT_QUOTA
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 CURRENT_QUOTA

MATERIAL_ALL_SUPPLIER_INFO-TARGET_QUOTA table field - ▼

Description:
Field Name: TARGET_QUOTA
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 TARGET_QUOTA

MATERIAL_ALL_SUPPLIER_INFO-GAP_QUOTA_SORT table field - Used for sorting quota vendors ▼

Description: Used for sorting quota vendors
Field Name: GAP_QUOTA_SORT
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 GAP_QUOTA_SORT

MATERIAL_ALL_SUPPLIER_INFO-CONTRACT_ALLOC_QTY table field - Quota Base Quantity of Quota Arrangement Item ▼

Description: Quota Base Quantity of Quota Arrangement Item
Field Name: CONTRACT_ALLOC_QTY
Data Element: QUBAS
Data Type: QUAN
length (Dec): 15(3)
Check table:
Conversion Routine:
Domain Name: MENG15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTRACT_ALLOC_QTY

MATERIAL_ALL_SUPPLIER_INFO-CONTRACT_REM_QTY table field - Quota Base Quantity of Quota Arrangement Item ▼

Description: Quota Base Quantity of Quota Arrangement Item
Field Name: CONTRACT_REM_QTY
Data Element: QUBAS
Data Type: QUAN
length (Dec): 15(3)
Check table:
Conversion Routine:
Domain Name: MENG15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTRACT_REM_QTY

MATERIAL_ALL_SUPPLIER_INFO-CONTRACT_MAX_QTY table field - Quota Base Quantity of Quota Arrangement Item ▼

Description: Quota Base Quantity of Quota Arrangement Item
Field Name: CONTRACT_MAX_QTY
Data Element: QUBAS
Data Type: QUAN
length (Dec): 15(3)
Check table:
Conversion Routine:
Domain Name: MENG15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTRACT_MAX_QTY

MATERIAL_ALL_SUPPLIER_INFO-CONTRACT_UNIT table field - Base Unit of Measure ▼

Description: Base Unit of Measure
Field Name: CONTRACT_UNIT
Data Element: MEINS
Data Type: UNIT
length (Dec): 3(0)
Check table:
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field CONTRACT_UNIT

MATERIAL_ALL_SUPPLIER_INFO-CONTRACTUNITPRECISION table field - No. of decimal places for rounding ▼

Description: No. of decimal places for rounding
Field Name: CONTRACTUNITPRECISION
Data Element: ANDEC
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: ANDEC
MemoryID:
AppClass: BZME
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTRACTUNITPRECISION

MATERIAL_ALL_SUPPLIER_INFO-CONTRACT_VALID_DATE table field - UTC Time Stamp in Short Form (YYYYMMDDhhmmss) ▼

Description: UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Field Name: CONTRACT_VALID_DATE
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 CONTRACT_VALID_DATE

MATERIAL_ALL_SUPPLIER_INFO-PRIORITY table field - Priority for Determination of Sequence ▼

Description: Priority for Determination of Sequence
Field Name: PRIORITY
Data Element: PREIH
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: NUMC2
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRIORITY

MATERIAL_ALL_SUPPLIER_INFO-CONV_PURCHASEQTY table field - Denominator for Conversion of Order Unit to Base Unit ▼

Description: Denominator for Conversion of Order Unit to Base Unit
Field Name: CONV_PURCHASEQTY
Data Element: UMBSN
Data Type: DEC
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: UMBSN
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONV_PURCHASEQTY

MATERIAL_ALL_SUPPLIER_INFO-CONV_PURCHASEUOM table field - Purchase Order Unit of Measure ▼

Description: Purchase Order Unit of Measure
Field Name: CONV_PURCHASEUOM
Data Element: BSTME
Data Type: UNIT
length (Dec): 3(0)
Check table:
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field CONV_PURCHASEUOM

MATERIAL_ALL_SUPPLIER_INFO-CONV_BASEQTY table field - Numerator for Conversion of Order Unit to Base Unit ▼

Description: Numerator for Conversion of Order Unit to Base Unit
Field Name: CONV_BASEQTY
Data Element: UMBSZ
Data Type: DEC
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: UMBSZ
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONV_BASEQTY

MATERIAL_ALL_SUPPLIER_INFO-CONV_BASEUOM table field - Base Unit of Measure ▼

Description: Base Unit of Measure
Field Name: CONV_BASEUOM
Data Element: MEINS
Data Type: UNIT
length (Dec): 3(0)
Check table:
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field CONV_BASEUOM

MATERIAL_ALL_SUPPLIER_INFO-TEL_NUMBER table field - First Cell Phone Number: Dialing Code + Number ▼

Description: First Cell Phone Number: Dialing Code + Number
Field Name: TEL_NUMBER
Data Element: AD_MBNMBR1
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEL_NUMBER

MATERIAL_ALL_SUPPLIER_INFO-SMTP_ADDR table field - E-Mail Address ▼

Description: E-Mail Address
Field Name: SMTP_ADDR
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field SMTP_ADDR

MATERIAL_ALL_SUPPLIER_INFO-CONTACT_NAME table field - Full Name of Person ▼

Description: Full Name of Person
Field Name: CONTACT_NAME
Data Element: AD_NAMTEXT
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: TEXT80
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTACT_NAME

View list of all SAP tables(S4H/ECC)

Select data from SAP table