SAP FAP_BPA_S_USER_DATA Table in S/4 HANA - Payment Approval - User Data
FAP_BPA_S_USER_DATA is a standard SAP Table which is used to store Payment Approval - User Data data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP FAP_BPA_S_USER_DATA table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: FAP_BPA_S_USER_DATA
FAP_BPA_S_USER_DATA table structure field list
Below is the full FAP_BPA_S_USER_DATA field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
USNAM | User Name in User Master Record | XUBNAME | CHAR | 12(0) | XUBNAME | XUS | ||||
TELNR_LONG | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
MOBILE_LONG | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30(0) | CHAR30 | |||||
SMTP_ADDR | E-Mail Address | AD_SMTPADR | CHAR | 241(0) | SXIDN | AD_SMTPADR | ||||
ADDR | STRU | 0(0) | ||||||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10(0) | ALPHA | AD_PERSNUM | CDT | ADDRESS | PERSNUMBER | |
ADDRNUMBER | Address Number | AD_ADDRNUM | CHAR | 10(0) | ALPHA | AD_ADDRNUM | ADR | |||
ADDRHANDLE | Handle for Creating Addresses/Persons (Bus. Addr. Services) | AD_HANDLE | CHAR | 140(0) | TEXT140 | |||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1(0) | AD_NATION | ADDRESS_NATION | ||||
DATE | Date referred to | AD_DATE | DATS | 8(0) | DATUM | |||||
PERSHANDLE | Handle for Creating Addresses/Persons (Bus. Addr. Services) | AD_HANDLE | CHAR | 140(0) | TEXT140 | |||||
DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8(0) | DATUM | |||||
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8(0) | DATUM | |||||
SO_KEY | SAP-Office key | AD_SO_KEY | CHAR | 10(0) | ALPHA | AD_SO_KEY | ADDRESS | PERSNUMBER | ||
DEPARTMENT | Department | AD_DPRTMNT | CHAR | 40(0) | TEXT40 | |||||
FUNCTION | Function | AD_FNCTN | CHAR | 40(0) | TEXT40 | |||||
BUILDING_C | Building (number or code) | AD_BLDNG_P | CHAR | 10(0) | TEXT10 | |||||
FLOOR_C | Floor in building | AD_FLOOR | CHAR | 10(0) | TEXT10 | |||||
ROOMNUM_C | Room or Apartment Number | AD_ROOMNUM | CHAR | 10(0) | TEXT10 | |||||
ID_CODE | Short name for correspondence | AD_ID_CODE | CHAR | 10(0) | TEXT10 | |||||
IH_MAIL | Internal Mail Postal Code | AD_IH_MAIL | CHAR | 10(0) | TEXT10 | |||||
SORT1_C | (Not Supported) Search Term | AD_SORTOLD | CHAR | 20(0) | CHAR20 | |||||
SORT2_C | (Not Supported) Search Term | AD_SORTOLD | CHAR | 20(0) | CHAR20 | |||||
SORT_PHN_C | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20(0) | CHAR20 | |||||
TITLE_P | Form-of-Address Key | AD_TITLE | CHAR | 4(0) | AD_TITLE | |||||
NAME_FIRST | First name | AD_NAMEFIR | CHAR | 40(0) | TEXT40 | |||||
NAME_LAST | Last name | AD_NAMELAS | CHAR | 40(0) | TEXT40 | |||||
NAME2_P | Name of person at birth | AD_NAME2_P | CHAR | 40(0) | TEXT40 | |||||
NAMEMIDDLE | Middle name or second forename of a person | AD_NAMEMID | CHAR | 40(0) | TEXT40 | |||||
NAME_LAST2 | Other Last Name of a Person | AD_NAMLAS2 | CHAR | 40(0) | TEXT40 | |||||
NAME_TEXT | Full Name of Person | AD_NAMTEXT | CHAR | 80(0) | TEXT80 | |||||
CONVERTED | Status of Field 'Full Name' NAME_TEXT | AD_NAMCONV | CHAR | 1(0) | AD_NAMCONV | |||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4(0) | AD_TITLE1 | AD_TITLE1 | TITLE_KEY | |||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4(0) | AD_TITLE1 | |||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4(0) | AD_PREFIX | |||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4(0) | AD_PREFIX | |||||
TITLE_SPPL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4(0) | AD_TITLES | |||||
NICKNAME | Nickname or name used | AD_NICKNAM | CHAR | 40(0) | TEXT40 | |||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10(0) | CHAR10 | |||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2(0) | AD_NAMFORM | |||||
NAMCOUNTRY | Country for Name Format Rule | AD_NAMCTRY | CHAR | 3(0) | LAND1 | |||||
PROFESSION | Profession | AD_PROFESS | CHAR | 40(0) | TEXT40 | |||||
SEX | Gender key | AD_SEX | CHAR | 1(0) | AD_SEX | |||||
LANGU_P | Language Key | SPRAS | LANG | 1(0) | ISOLA | SPRAS | SPR | H_T002 | SPRAS | |
SORT1_P | Search Term 1 | AD_SORT1UL | CHAR | 20(0) | TEXT20 | |||||
SORT2_P | Search Term 2 | AD_SORT2UL | CHAR | 20(0) | TEXT20 | |||||
SORT_PHN_P | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20(0) | CHAR20 | |||||
PERSORIGIN | Personal data source (key) | AD_ORIGINP | CHAR | 4(0) | AD_ORIGIN | |||||
LANGU_CR_P | Address record creation original language | AD_LANGUCR | LANG | 1(0) | ISOLA | SPRAS | ||||
DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 3(0) | AD_COMM | |||||
ADDR_COMP | (not used) | AD_ADDRCOM | CHAR | 10(0) | ALPHA | AD_ADDRNUM | ||||
AD_COMP_HD | First company address: internal ID if DB no. not yet issued | AD_COMP_HD | CHAR | 140(0) | TEXT140 | |||||
XPCPT | Business Purpose Completed Flag | AD_XPCPT | CHAR | 1(0) | AD_XPCPT | |||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4(0) | AD_TITLE | |||||
NAME1 | Name 1 | AD_NAME1 | CHAR | 40(0) | TEXT40 | |||||
NAME2 | Name 2 | AD_NAME2 | CHAR | 40(0) | TEXT40 | |||||
NAME3 | Name 3 | AD_NAME3 | CHAR | 40(0) | TEXT40 | |||||
NAME4 | Name 4 | AD_NAME4 | CHAR | 40(0) | TEXT40 | |||||
NAME_TXT | Converted name field (with form of address) | AD_NAMETXT | CHAR | 50(0) | TEXT50 | |||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40(0) | TEXT40 | |||||
CITY1 | City | AD_CITY1 | CHAR | 40(0) | TEXT40 | CLCITYNAME | CITY_NAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40(0) | TEXT40 | CITY_PART | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12(0) | ALPHA | CITY_CODE | ||||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8(0) | ALPHA | CITYP_CODE | ||||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40(0) | TEXT40 | |||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12(0) | ALPHA | CITY_CODE | ||||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1(0) | AD_CHECKST | |||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8(0) | REGIOGROUP | |||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10(0) | CHAR10 | |||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10(0) | CHAR10 | |||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10(0) | CHAR10 | |||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10(0) | CHAR10 | |||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10(0) | CHAR10 | |||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10(0) | CHAR10 | |||||
PO_BOX | PO Box | AD_POBX | CHAR | 10(0) | CHAR10 | |||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4(0) | AD_NO_USE | |||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1(0) | XFELD | |||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40(0) | TEXT40 | CITY_NAME | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12(0) | ALPHA | CITY_CODE | ||||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3(0) | REGIO | |||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3(0) | LAND1 | |||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15(0) | TEXT15 | |||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10(0) | ZONE | |||||
STREET | Street | AD_STREET | CHAR | 60(0) | TEXT60 | CLSTRTNAME | STREET | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4(0) | AD_NO_USE | |||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12(0) | ALPHA | STRT_CODE | ||||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2(0) | STRTYPEAB | |||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10(0) | TEXT10 | |||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10(0) | TEXT10 | |||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10(0) | TEXT10 | |||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40(0) | TEXT40 | |||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40(0) | TEXT40 | |||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40(0) | TEXT40 | |||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40(0) | TEXT40 | |||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20(0) | TEXT20 | |||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10(0) | TEXT10 | |||||
ROOMNUMBER | Room or Apartment Number | AD_ROOMNUM | CHAR | 10(0) | TEXT10 | |||||
COUNTRY | Country Key | LAND1 | CHAR | 3(0) | LAND1 | LND | ||||
LANGU | Language Key | SPRAS | LANG | 1(0) | ISOLA | SPRAS | SPR | H_T002 | SPRAS | |
REGION | Region (State, Province, County) | REGIO | CHAR | 3(0) | REGIO | |||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20(0) | TEXT20 | |||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20(0) | TEXT20 | |||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20(0) | CHAR20 | |||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4(0) | AD_ORIGIN | |||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40(0) | TEXT40 | |||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40(0) | TEXT40 | |||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6(0) | TZNZONE | |||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15(0) | AD_TXJCD | TXJ | ||||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10(0) | ALPHA | AD_ADDR_ID | ||||
REMARK | Address notes | AD_REMARK1 | CHAR | 50(0) | TEXT50 | |||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1(0) | ISOLA | SPRAS | ||||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40(0) | TEXT40 | |||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4(0) | AD_DELIVERY_SERVICE_TYPE | |||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10(0) | CHAR10 | |||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8(0) | ALPHA | CNTY_CODE | ||||
COUNTY | County | AD_COUNTY | CHAR | 40(0) | TEXT40 | CLTCNTYNAME | COUNTY | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8(0) | ALPHA | TWSHP_CODE | ||||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40(0) | TEXT40 | CLTWSHPNAME | TOWNSHIP | |||
TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30(0) | CHAR30 | |||||
TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10(0) | CHAR10 | |||||
FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30(0) | CHAR30 | |||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10(0) | CHAR10 | |||||
TEL_NUMCMP | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30(0) | CHAR30 | |||||
TEL_EXTCMP | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10(0) | CHAR10 | |||||
FAX_NUMCMP | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30(0) | CHAR30 | |||||
FAX_EXTCMP | First fax no.: extension | AD_FXXTNS1 | CHAR | 10(0) | CHAR10 | |||||
PERS_GROUP | Person Group (Key) (Business Address Services) | AD_GROUP_P | CHAR | 4(0) | AD_GROUP_P | |||||
ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | CHAR | 4(0) | AD_GROUP |
Search for further information about these or an SAP related objects