SAP DVKWA table - R/2-R/3 Link: BTCI Work Area for Deliveries details in SAP


SAP DVKWA table summary

Object Name: DVKWA
Dictionary Type: Structure
Description: R/2-R/3 Link: BTCI Work Area for Deliveries


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

Details
DVKWA-SNKOM table field - Record no.of communication doc.for decentralized shipping

Description: Record no.of communication doc.for decentralized shipping
Field Name: SNKOM
Data Element: SNKOM
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: SNKOM
MemoryID:
AppClass: VL
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNKOM

DVKWA-SSKOM table field - Status of communication record for decentralized shipping

Description: Status of communication record for decentralized shipping
Field Name: SSKOM
Data Element: SSKOM
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: LVS_SSKOM
MemoryID:
AppClass: LVS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SSKOM

DVKWA-LXX01 table field - Active record type within a communication record

Description: Active record type within a communication record
Field Name: LXX01
Data Element: LDK00LXX01
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: CHAR5
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LXX01

DVKWA-KUNNR table field - Ship-to Party

Description: Ship-to Party
Field Name: KUNNR
Data Element: KUNWE
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 KUNNR

DVKWA-ANRED table field - Form of address

Description: Form of address
Field Name: ANRED
Data Element: ANRED_VP
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: ANRED
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANRED

DVKWA-NAME1 table field - Name 1

Description: Name 1
Field Name: NAME1
Data Element: NAME1_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: NAME
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME1

DVKWA-NAME2 table field - Name 2

Description: Name 2
Field Name: NAME2
Data Element: NAME2_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: NAME
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME2

DVKWA-NAME3 table field - Name 3

Description: Name 3
Field Name: NAME3
Data Element: NAME3_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: NAME
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME3

DVKWA-NAME4 table field - Name 4

Description: Name 4
Field Name: NAME4
Data Element: NAME4_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: NAME
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME4

DVKWA-STRAS table field - Street and House Number

Description: Street and House Number
Field Name: STRAS
Data Element: STRAS
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 STRAS

DVKWA-LAND1 table field - Country/Region Key

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

See all SAP tables containing field LAND1

DVKWA-PSTLZ table field - Postal Code

Description: Postal Code
Field Name: PSTLZ
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

DVKWA-PSTL2 table field - P.O. Box Postal Code

Description: P.O. Box Postal Code
Field Name: PSTL2
Data Element: PSTL2
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 PSTL2

DVKWA-ORT01 table field - City

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

DVKWA-ORT02 table field - District

Description: District
Field Name: ORT02
Data Element: ORT02_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 ORT02

DVKWA-REGIO table field - Region (State, Province, County)

Description: Region (State, Province, County)
Field Name: REGIO
Data Element: REGIO
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGIO

DVKWA-PFACH table field - PO Box

Description: PO Box
Field Name: PFACH
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

DVKWA-TELF1 table field - First telephone number

Description: First telephone number
Field Name: TELF1
Data Element: TELF1
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: TEXT16
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELF1

DVKWA-TELFX table field - Fax Number

Description: Fax Number
Field Name: TELFX
Data Element: TELFX
Data Type: CHAR
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: TEXT31
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELFX

DVKWA-TELTX table field - Teletex number

Description: Teletex number
Field Name: TELTX
Data Element: TELTX
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 TELTX

DVKWA-TELX1 table field - Telex number

Description: Telex number
Field Name: TELX1
Data Element: TELX1
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 TELX1

DVKWA-SPRAS table field - Language Key

Description: Language Key
Field Name: SPRAS
Data Element: SPRAS
Data Type: LANG
length (Dec): 1(0)
Check table: *
Conversion Routine: ISOLA
Domain Name: SPRAS
MemoryID: SPR
AppClass: STXD
SHLP: H_T002
SHLP Field: SPRAS
ConvExit: ISOLA

See all SAP tables containing field SPRAS

DVKWA-LZONE table field - Transportation zone to or from which the goods are delivered

Description: Transportation zone to or from which the goods are delivered
Field Name: LZONE
Data Element: LZONE
Data Type:
length (Dec): 0(0)
Check table: *
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LZONE

DVKWA-VKORG table field - Sales Organization

Description: Sales Organization
Field Name: VKORG
Data Element: VKORG
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: VKORG
MemoryID: VKO
AppClass: MG
SHLP: C_VKORG
SHLP Field: VKORG
ConvExit:

See all SAP tables containing field VKORG

DVKWA-VTWEG table field - Distribution Channel

Description: Distribution Channel
Field Name: VTWEG
Data Element: VTWEG
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: VTWEG
MemoryID: VTW
AppClass: MG
SHLP: C_VTWEG
SHLP Field: VTWEG
ConvExit:

See all SAP tables containing field VTWEG

DVKWA-SPART table field - Division

Description: Division
Field Name: SPART
Data Element: SPART
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: SPART
MemoryID: SPA
AppClass: V
SHLP: C_SPART
SHLP Field: SPART
ConvExit:

See all SAP tables containing field SPART

DVKWA-VSTEL table field - Shipping Point / Receiving Point

Description: Shipping Point / Receiving Point
Field Name: VSTEL
Data Element: VSTEL
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: VSTEL
MemoryID: VST
AppClass: VV
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VSTEL

DVKWA-LFART table field - Delivery Type

Description: Delivery Type
Field Name: LFART
Data Element: LFART
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: LFART
MemoryID: ALT
AppClass: VL
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LFART

DVKWA-COMMN table field - Communication number for Q-API interface

Description: Communication number for Q-API interface
Field Name: COMMN
Data Element: COMMN
Data Type: CHAR
length (Dec): 5(0)
Check table: *
Conversion Routine:
Domain Name: COMMN
MemoryID:
AppClass: LVS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMN

DVKWA-VERUR table field - Distribution delivery

Description: Distribution delivery
Field Name: VERUR
Data Element: VERUR_VL
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VERUR

DVKWA-WADAT table field - Goods Issue Date

Description: Goods Issue Date
Field Name: WADAT
Data Element: WADAT
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 WADAT

DVKWA-LIFSP table field - Default Delivery Block

Description: Default Delivery Block
Field Name: LIFSP
Data Element: LIFSP
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: LIFSP
MemoryID:
AppClass: VL
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIFSP

DVKWA-ERNAM table field - Name of Person Responsible for Creating the Object

Description: Name of Person Responsible for Creating the Object
Field Name: ERNAM
Data Element: ERNAM
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: USNAM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ERNAM

DVKWA-ERDAT table field - Date on which the record was created

Description: Date on which the record was created
Field Name: ERDAT
Data Element: ERDAT
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 ERDAT

DVKWA-ERZET table field - Entry time

Description: Entry time
Field Name: ERZET
Data Element: ERZET
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ERZET

DVKWA-SPDNR table field - Forwarding Agent

Description: Forwarding Agent
Field Name: SPDNR
Data Element: SPDNR
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: LIFNR
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field SPDNR

DVKWA-AUTLF table field - Complete Delivery Defined for Each Sales Order?

Description: Complete Delivery Defined for Each Sales Order?
Field Name: AUTLF
Data Element: AUTLF
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 AUTLF

DVKWA-ANZPK table field - Total Number of Packages in Delivery

Description: Total Number of Packages in Delivery
Field Name: ANZPK
Data Element: ANZPK
Data Type: NUMC
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: ANZPK
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANZPK

DVKWA-ABLAD table field - Unloading Point

Description: Unloading Point
Field Name: ABLAD
Data Element: ABLAD
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: TEXT25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ABLAD

DVKWA-VSBED table field - Shipping Conditions

Description: Shipping Conditions
Field Name: VSBED
Data Element: VSBED
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: VSBED
MemoryID:
AppClass: VV
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VSBED

DVKWA-LPRIO table field - Delivery Priority

Description: Delivery Priority
Field Name: LPRIO
Data Element: LPRIO
Data Type: NUMC
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: LPRIO
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LPRIO

DVKWA-POSNR table field - Delivery Item

Description: Delivery Item
Field Name: POSNR
Data Element: POSNR_VL
Data Type: NUMC
length (Dec): 6(0)
Check table: *
Conversion Routine:
Domain Name: POSNR
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSNR

DVKWA-UEPOS table field - Higher-Level Item in Bill of Material Structures

Description: Higher-Level Item in Bill of Material Structures
Field Name: UEPOS
Data Element: UEPOS
Data Type: NUMC
length (Dec): 6(0)
Check table: *
Conversion Routine:
Domain Name: POSNR
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UEPOS

DVKWA-MATNR table field - Material Number

Description: Material Number
Field Name: MATNR
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 MATNR

DVKWA-WERKS table field - Plant

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

DVKWA-LGORT table field - Storage location

Description: Storage location
Field Name: LGORT
Data Element: LGORT_D
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: LGORT
MemoryID: LAG
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LGORT

DVKWA-CHARG table field - Batch Number

Description: Batch Number
Field Name: CHARG
Data Element: CHARG_D
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: CHARG
MemoryID: CHA
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHARG

DVKWA-SOBKZ table field - Special Stock Indicator

Description: Special Stock Indicator
Field Name: SOBKZ
Data Element: SOBKZ
Data Type: CHAR
length (Dec): 1(0)
Check table: *
Conversion Routine:
Domain Name: SOBKZ
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SOBKZ

DVKWA-LFIMG table field - Delivery quantity (special storage for decentral.shipping)

Description: Delivery quantity (special storage for decentral.shipping)
Field Name: LFIMG
Data Element: LFIMG_DV
Data Type: NUMC
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: NUM14
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LFIMG

DVKWA-UMVKZ table field - Counter for converting to base unit (spec.stor.dec.ship)

Description: Counter for converting to base unit (spec.stor.dec.ship)
Field Name: UMVKZ
Data Element: UMVKZ_DV
Data Type: NUMC
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: NUM05
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UMVKZ

DVKWA-UMVKN table field - Denominator for converting to base qty (spec.stor.dec.ship)

Description: Denominator for converting to base qty (spec.stor.dec.ship)
Field Name: UMVKN
Data Element: UMVKN_DV
Data Type: NUMC
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: NUM05
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UMVKN

DVKWA-MEINS table field - Base Unit of Measure

Description: Base Unit of Measure
Field Name: MEINS
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 MEINS

DVKWA-VRKME table field - Sales unit

Description: Sales unit
Field Name: VRKME
Data Element: VRKME
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 VRKME

DVKWA-BRGEW table field - Gross weight (special storage for decentralized shipping)

Description: Gross weight (special storage for decentralized shipping)
Field Name: BRGEW
Data Element: BRGEW_DV
Data Type: NUMC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: NUM16
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BRGEW

DVKWA-NTGEW table field - Net weight (special storage for decentralized shipping)

Description: Net weight (special storage for decentralized shipping)
Field Name: NTGEW
Data Element: NTGEW_DV
Data Type: NUMC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: NUM16
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTGEW

DVKWA-GEWEI table field - Weight Unit

Description: Weight Unit
Field Name: GEWEI
Data Element: GEWEI
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 GEWEI

DVKWA-VOLUM table field - Volume (special storage for decentralized shipping)

Description: Volume (special storage for decentralized shipping)
Field Name: VOLUM
Data Element: VOLUM_DV
Data Type: NUMC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: NUM16
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VOLUM

DVKWA-VOLEH table field - Volume unit

Description: Volume unit
Field Name: VOLEH
Data Element: VOLEH
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 VOLEH

DVKWA-KZTLF table field - Partial delivery at item level

Description: Partial delivery at item level
Field Name: KZTLF
Data Element: KZTLF
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: KZTLF
MemoryID:
AppClass: VL
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KZTLF

DVKWA-ARKTX table field - Short text for sales order item

Description: Short text for sales order item
Field Name: ARKTX
Data Element: ARKTX
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ARKTX

DVKWA-UEBTK table field - Unlimited Overdelivery Allowed

Description: Unlimited Overdelivery Allowed
Field Name: UEBTK
Data Element: UEBTK
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 UEBTK

DVKWA-TOURN table field - Route

Description: Route
Field Name: TOURN
Data Element: ROUTE
Data Type: CHAR
length (Dec): 6(0)
Check table: *
Conversion Routine:
Domain Name: ROUTE
MemoryID:
AppClass: VV
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOURN

DVKWA-TOURT table field - Route description

Description: Route description
Field Name: TOURT
Data Element: ROUTE_BEZ2
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOURT


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table