SAP BAPIHR0009 table - HR: HR Master Record Infotype 0009 (Bank Details) details in SAP


SAP BAPIHR0009 table summary

Object Name: BAPIHR0009
Dictionary Type: Structure
Description: HR: HR Master Record Infotype 0009 (Bank Details)


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

Details
BAPIHR0009-OBJ_ID table field - Personnel Number

Description: Personnel Number
Field Name: OBJ_ID
Data Element: PERNR_D
Data Type: NUMC
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: PERNR
MemoryID: PER
AppClass: PB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJ_ID

BAPIHR0009-INFOTYPE table field - Infotype

Description: Infotype
Field Name: INFOTYPE
Data Element: INFTY
Data Type: CHAR
length (Dec): 4(0)
Check table: T582A
Conversion Routine:
Domain Name: INFOTYP
MemoryID: ITP
AppClass: PP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INFOTYPE

BAPIHR0009-SUBTYPE table field - Subtype

Description: Subtype
Field Name: SUBTYPE
Data Element: SUBTY
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: SUBTY
MemoryID: SUB
AppClass: PINF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUBTYPE

BAPIHR0009-OBJECT_IDENTIFICATION table field - Object Identification

Description: Object Identification
Field Name: OBJECT_IDENTIFICATION
Data Element: OBJPS
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: OBJPS
MemoryID: OPS
AppClass: PB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_IDENTIFICATION

BAPIHR0009-LOCKINDIC table field - Lock Indicator for HR Master Data Record

Description: Lock Indicator for HR Master Data Record
Field Name: LOCKINDIC
Data Element: SPRPS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SPRPS
MemoryID:
AppClass: PINF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKINDIC

BAPIHR0009-TO_DATE table field - End Date

Description: End Date
Field Name: TO_DATE
Data Element: ENDDA
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 TO_DATE

BAPIHR0009-FROM_DATE table field - Start Date

Description: Start Date
Field Name: FROM_DATE
Data Element: BEGDA
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 FROM_DATE

BAPIHR0009-IT_REC_NO table field - Number of Infotype Record With Same Key

Description: Number of Infotype Record With Same Key
Field Name: IT_REC_NO
Data Element: SEQNR
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 IT_REC_NO

BAPIHR0009-CHANGED_ON table field - Last Changed On

Description: Last Changed On
Field Name: CHANGED_ON
Data Element: AEDAT
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 CHANGED_ON

BAPIHR0009-CHANGED_BY table field - Name of Person Who Changed Object

Description: Name of Person Who Changed Object
Field Name: CHANGED_BY
Data Element: AENAM
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 CHANGED_BY

BAPIHR0009-HIST_FLAG table field - Historical Record Flag

Description: Historical Record Flag
Field Name: HIST_FLAG
Data Element: HISTO
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 HIST_FLAG

BAPIHR0009-INFOTYPE_TEXT_EXISTS table field - Text Exists for Infotype

Description: Text Exists for Infotype
Field Name: INFOTYPE_TEXT_EXISTS
Data Element: ITXEX
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 INFOTYPE_TEXT_EXISTS

BAPIHR0009-REFERENCE_FILEDS_EXIST table field - Reference Fields Exist (Primary/Secondary Costs)

Description: Reference Fields Exist (Primary/Secondary Costs)
Field Name: REFERENCE_FILEDS_EXIST
Data Element: PRFEX
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 REFERENCE_FILEDS_EXIST

BAPIHR0009-CONFIRMATION_FIELDS_EXIST table field - Confirmation Fields Exist

Description: Confirmation Fields Exist
Field Name: CONFIRMATION_FIELDS_EXIST
Data Element: ORDEX
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 CONFIRMATION_FIELDS_EXIST

BAPIHR0009-INFOTYPE_SCREEN_CONTROL table field - Infotype Screen Control

Description: Infotype Screen Control
Field Name: INFOTYPE_SCREEN_CONTROL
Data Element: ITBLD
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INFOTYPE_SCREEN_CONTROL

BAPIHR0009-REASON_TO_CHANGE_MASTER_DATA table field - Reason for Changing Master Data

Description: Reason for Changing Master Data
Field Name: REASON_TO_CHANGE_MASTER_DATA
Data Element: PREAS
Data Type: CHAR
length (Dec): 2(0)
Check table: T530E
Conversion Routine:
Domain Name: PREAS
MemoryID:
AppClass: PINF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REASON_TO_CHANGE_MASTER_DATA

BAPIHR0009-FLAG_1 table field - Reserved Field/Unused Field

Description: Reserved Field/Unused Field
Field Name: FLAG_1
Data Element: NUSED
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: NUSED
MemoryID:
AppClass: PLOH
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLAG_1

BAPIHR0009-FLAG_2 table field - Reserved Field/Unused Field

Description: Reserved Field/Unused Field
Field Name: FLAG_2
Data Element: NUSED
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: NUSED
MemoryID:
AppClass: PLOH
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLAG_2

BAPIHR0009-FLAG_3 table field - Reserved Field/Unused Field

Description: Reserved Field/Unused Field
Field Name: FLAG_3
Data Element: NUSED
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: NUSED
MemoryID:
AppClass: PLOH
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLAG_3

BAPIHR0009-FLAG_4 table field - Reserved Field/Unused Field

Description: Reserved Field/Unused Field
Field Name: FLAG_4
Data Element: NUSED
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: NUSED
MemoryID:
AppClass: PLOH
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLAG_4

BAPIHR0009-RESERVED_FIELD_1 table field - Reserved Field/Unused Field of Length 2

Description: Reserved Field/Unused Field of Length 2
Field Name: RESERVED_FIELD_1
Data Element: NUSED2
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: NUSED2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESERVED_FIELD_1

BAPIHR0009-RESERVED_FIELD_2 table field - Reserved Field/Unused Field of Length 2

Description: Reserved Field/Unused Field of Length 2
Field Name: RESERVED_FIELD_2
Data Element: NUSED2
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: NUSED2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESERVED_FIELD_2

BAPIHR0009-OPERATIND table field - Operation Indicator for Wage Types

Description: Operation Indicator for Wage Types
Field Name: OPERATIND
Data Element: OPKEN
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: OPKEN
MemoryID:
AppClass: PLOH
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPERATIND

BAPIHR0009-STANDARD_VALUE table field - Default Value

Description: Default Value
Field Name: STANDARD_VALUE
Data Element: PAD_VGBTR_BAPI
Data Type: DEC
length (Dec): 23(4)
Check table:
Conversion Routine:
Domain Name: BAPICURR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STANDARD_VALUE

BAPIHR0009-CURRENCY table field - Currency Key

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

See all SAP tables containing field CURRENCY

BAPIHR0009-CURRENCY_ISO table field - ISO currency code

Description: ISO currency code
Field Name: CURRENCY_ISO
Data Element: ISOCD
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ISOCD
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRENCY_ISO

BAPIHR0009-STANDARD_PERCENTAGE table field - Standard Percentage

Description: Standard Percentage
Field Name: STANDARD_PERCENTAGE
Data Element: VGPRO
Data Type: DEC
length (Dec): 5(2)
Check table:
Conversion Routine:
Domain Name: DEC3_2
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STANDARD_PERCENTAGE

BAPIHR0009-TIME_UNIT table field - Time/Measurement Unit

Description: Time/Measurement Unit
Field Name: TIME_UNIT
Data Element: PT_ZEINH
Data Type: CHAR
length (Dec): 3(0)
Check table: T538A
Conversion Routine:
Domain Name: RPMSH
MemoryID:
AppClass: PTIM
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIME_UNIT

BAPIHR0009-BANK_DETAIL_RECORD_TYPE table field - Type of Bank Details Record

Description: Type of Bank Details Record
Field Name: BANK_DETAIL_RECORD_TYPE
Data Element: BNKSA
Data Type: CHAR
length (Dec): 4(0)
Check table: T591A
Conversion Routine:
Domain Name: SUBTY_591A
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BANK_DETAIL_RECORD_TYPE

BAPIHR0009-PAYMENT_METHOD table field - Payment Method

Description: Payment Method
Field Name: PAYMENT_METHOD
Data Element: PCODE
Data Type:
length (Dec): 0(0)
Check table: T042Z
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAYMENT_METHOD

BAPIHR0009-PAYEE_TEXT table field - Payee Text

Description: Payee Text
Field Name: PAYEE_TEXT
Data Element: EMFTX
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 PAYEE_TEXT

BAPIHR0009-POSTAL_CODE table field - Postal Code

Description: Postal Code
Field Name: POSTAL_CODE
Data Element: BKPLZ
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 POSTAL_CODE

BAPIHR0009-CITY table field - City

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

BAPIHR0009-BANK_CTRY table field - Country/Region Key of Bank

Description: Country/Region Key of Bank
Field Name: BANK_CTRY
Data Element: BANKS
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID: BKL
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BANK_CTRY

BAPIHR0009-BANK_CTRY_ISO table field - ISO Code of the Country/Region

Description: ISO Code of the Country/Region
Field Name: BANK_CTRY_ISO
Data Element: INTCA
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: INTCA
MemoryID:
AppClass:
SHLP: F4_INTCA
SHLP Field: INTCA
ConvExit:

See all SAP tables containing field BANK_CTRY_ISO

BAPIHR0009-BANK_KEY table field - Bank Keys

Description: Bank Keys
Field Name: BANK_KEY
Data Element: BANKK
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: BANKK
MemoryID: BNK
AppClass: FBZ
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BANK_KEY

BAPIHR0009-BANK_ACCT table field - Bank account number

Description: Bank account number
Field Name: BANK_ACCT
Data Element: BANKN
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: BANKN
MemoryID:
AppClass: FBZ
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BANK_ACCT

BAPIHR0009-BANK_CODE_CHECK_DIGIT table field - Check Digit for Bank No./Account

Description: Check Digit for Bank No./Account
Field Name: BANK_CODE_CHECK_DIGIT
Data Element: BANKP
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: BANKP
MemoryID:
AppClass: PINF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BANK_CODE_CHECK_DIGIT

BAPIHR0009-CTRL_KEY table field - Bank Control Key

Description: Bank Control Key
Field Name: CTRL_KEY
Data Element: BKONT
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: BKONT
MemoryID:
AppClass: FBZ
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CTRL_KEY

BAPIHR0009-SWIFT_CODE table field - SWIFT/BIC for International Payments

Description: SWIFT/BIC for International Payments
Field Name: SWIFT_CODE
Data Element: SWIFT
Data Type: CHAR
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: SWIFT
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SWIFT_CODE

BAPIHR0009-INSTR_KEY table field - Instruction key for data medium exchange

Description: Instruction key for data medium exchange
Field Name: INSTR_KEY
Data Element: DTAWS
Data Type: CHAR
length (Dec): 2(0)
Check table: T015W
Conversion Routine:
Domain Name: DTAWS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTR_KEY

BAPIHR0009-DME_IND table field - Report key for data medium exchange

Description: Report key for data medium exchange
Field Name: DME_IND
Data Element: DTAMS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DTAMS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DME_IND

BAPIHR0009-TAX_NO_1 table field - Tax Number 1

Description: Tax Number 1
Field Name: TAX_NO_1
Data Element: STCD1
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: STCD1
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TAX_NO_1

BAPIHR0009-TAX_NO_2 table field - Tax Number 2

Description: Tax Number 2
Field Name: TAX_NO_2
Data Element: STCD2
Data Type: CHAR
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: STCD2
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TAX_NO_2

BAPIHR0009-POST_OFFICE_ACCOUNT_NO table field - PO Bank Current Acct No. or Building Society Ref. No.

Description: PO Bank Current Acct No. or Building Society Ref. No.
Field Name: POST_OFFICE_ACCOUNT_NO
Data Element: PSKTO
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: PSKTO
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_OFFICE_ACCOUNT_NO

BAPIHR0009-POR_SUBSCRIBER_NO table field - ISR subscriber number

Description: ISR subscriber number
Field Name: POR_SUBSCRIBER_NO
Data Element: ESRNR
Data Type: CHAR
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: ESRNR
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POR_SUBSCRIBER_NO

BAPIHR0009-POR_REFERENCE_NO table field - ISR/QR Reference Number

Description: ISR/QR Reference Number
Field Name: POR_REFERENCE_NO
Data Element: ESRRE
Data Type: CHAR
length (Dec): 27(0)
Check table:
Conversion Routine: ALPHA
Domain Name: ESRRE
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field POR_REFERENCE_NO

BAPIHR0009-POR_CHECK_DIGIT table field - POR check digit

Description: POR check digit
Field Name: POR_CHECK_DIGIT
Data Element: ESRPZ
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POR_CHECK_DIGIT

BAPIHR0009-PAYEE_KEY table field - Payee key for bank transfers

Description: Payee key for bank transfers
Field Name: PAYEE_KEY
Data Element: EMFSL
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: EMFSL
MemoryID:
AppClass: PSTA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAYEE_KEY

BAPIHR0009-BANK_TRANSFER_PURPOSE table field - Purpose of Bank Transfers

Description: Purpose of Bank Transfers
Field Name: BANK_TRANSFER_PURPOSE
Data Element: DZWECK
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 BANK_TRANSFER_PURPOSE

BAPIHR0009-TRANFER_TYPE table field - PBS Transfer Type

Description: PBS Transfer Type
Field Name: TRANFER_TYPE
Data Element: P09_BTTYP
Data Type: NUMC
length (Dec): 2(0)
Check table: T5M3T
Conversion Routine:
Domain Name: P09_BTTYP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRANFER_TYPE

BAPIHR0009-PAYTYPE table field - Payroll type

Description: Payroll type
Field Name: PAYTYPE
Data Element: PAYTY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: PAYTY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAYTYPE

BAPIHR0009-PAYID table field - Payroll Identifier

Description: Payroll Identifier
Field Name: PAYID
Data Element: PAYID
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 PAYID

BAPIHR0009-OFF_CYCLE_REASON table field - Reason for Off-Cycle Payroll

Description: Reason for Off-Cycle Payroll
Field Name: OFF_CYCLE_REASON
Data Element: PAY_OCRSN
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: PAY_OCRSN
MemoryID: OCR
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OFF_CYCLE_REASON

BAPIHR0009-BONUSDATE table field - Off-cycle payroll payment date

Description: Off-cycle payroll payment date
Field Name: BONUSDATE
Data Element: BONDT
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 BONUSDATE

BAPIHR0009-IBAN table field - IBAN (International Bank Account Number)

Description: IBAN (International Bank Account Number)
Field Name: IBAN
Data Element: IBAN
Data Type: CHAR
length (Dec): 34(0)
Check table:
Conversion Routine:
Domain Name: IBAN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IBAN


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table