SAP FBL_PAYMENTDATA Table in S/4 HANA - Payment medium BAdI: Payment data
FBL_PAYMENTDATA is a standard SAP Table which is used to store Payment medium BAdI: Payment 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 FBL_PAYMENTDATA 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 (character-type or numeric)
Dictionary Type: Structure
Database Table: FBL_PAYMENTDATA
FBL_PAYMENTDATA table structure field list
Below is the full FBL_PAYMENTDATA 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 |
LAUFD | Date on Which the Program Is to Be Run | LAUFD | DATS | 8(0) | DATUM | |||||
LAUFI | Additional Identification | LAUFI | CHAR | 6(0) | LAUFI | |||||
XVORL | Indicator: Proposal Run | XVORL_FPM | CHAR | 1(0) | XFELD | |||||
DORIGIN | Grouping Origin | FIBL_DORIGIN | CHAR | 8(0) | Assigned to domain | FIBL_ORIGIN | ||||
GRPNO | Grouping Criterium for Payments | GRPNO_FPM | INT4 | 10(0) | GRPNO_FPM | |||||
SRTF1 | Format-Specific Sorting of Payment Data | SRTF1_FPM | CHAR | 30(0) | CHAR30 | |||||
SRTF2 | User-Defined Sorting of Payment Data | SRTF2_FPM | CHAR | 48(0) | CHAR48 | |||||
SRTF3 | Format-Specific Sorting of Payment Data | SRTF1_FPM | CHAR | 30(0) | CHAR30 | |||||
LFDNR | Sequential Payment Number | LFDNR_FPM | NUMC | 8(0) | NUMC8 | |||||
XCORR | Indicator: Payment Correspondence | XCORR_FPM | CHAR | 1(0) | XFELD | |||||
XAVIS | Indicator: Separate Payment Advice | XAVIS_FPM | CHAR | 1(0) | XFELD | |||||
XCOPM | Payment Medium for Business Partner (Correspondence) | XCOPM_FPM | CHAR | 1(0) | XCOPM_FPM | |||||
GPA1T | Category of Business Partner Receiving Payment | GPA1T_FPM | CHAR | 2(0) | GPATP_FPM | |||||
GPA1R | Reference to Business Partner Receiving Payment | GPA1R_FPM | CHAR | 16(0) | CHAR16 | |||||
ZADNR | Address Number | AD_ADDRNUM | CHAR | 10(0) | ADRC | ALPHA | AD_ADDRNUM | ADR | ||
ZANRE | Title of the payee | DZANRE | CHAR | 15(0) | TEXT15 | |||||
ZNME1 | Name of the Payee | FPM_NAME | CHAR | 40(0) | TEXT40 | |||||
ZNME2 | Name of the Payee | FPM_NAME | CHAR | 40(0) | TEXT40 | |||||
ZNME3 | Name of the Payee | FPM_NAME | CHAR | 40(0) | TEXT40 | |||||
ZNME4 | Name of the Payee | FPM_NAME | CHAR | 40(0) | TEXT40 | |||||
ZSPRA | Language Key | SPRAS | LANG | 1(0) | T002 | ISOLA | SPRAS | SPR | H_T002 | SPRAS |
ZLAND | Country Key | DZLAND | CHAR | 3(0) | T005 | LAND1 | LND | |||
ZREGI | Regional code of the payee | DZREGI | CHAR | 3(0) | T005S | REGIO | ||||
ZORT1 | City | AD_CITY1 | CHAR | 40(0) | TEXT40 | CLCITYNAME | CITY_NAME | |||
ZORT2 | District | AD_CITY2 | CHAR | 40(0) | TEXT40 | CITY_PART | CITY_PART | |||
ZPFOR | PO Box city | AD_POBXLOC | CHAR | 40(0) | TEXT40 | CITY_NAME | CITY_NAME | |||
ZPSTL | City postal code | AD_PSTCD1 | CHAR | 10(0) | CHAR10 | |||||
ZPST2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10(0) | CHAR10 | |||||
ZPST3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10(0) | CHAR10 | |||||
ZPFAC | PO Box | AD_POBX | CHAR | 10(0) | CHAR10 | |||||
ZSTRA | Street | AD_STREET | CHAR | 60(0) | TEXT60 | CLSTRTNAME | STREET | |||
ZTEL1 | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30(0) | CHAR30 | |||||
ZTEL2 | Telephone no.: Extension | AD_TLXTNS | CHAR | 10(0) | CHAR10 | |||||
ZFAX1 | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30(0) | CHAR30 | |||||
ZFAX2 | Fax no.: Extension | AD_FXXTNS | CHAR | 10(0) | CHAR10 | |||||
ZTELX | Payee telex number | TELEX_Z | CHAR | 30(0) | TEXT30 | |||||
STCD1 | Payee's tax number 1 | STCD1_Z | CHAR | 16(0) | STCD1 | |||||
ZBNKS | Country Key | DZBNKS | CHAR | 3(0) | T005 | LAND1 | LND | |||
ZBNKY | Bank key of the payee's bank | DZBNKY | CHAR | 15(0) | BANKK | |||||
ZBNKL | Bank number of the payee's bank | DZBNKL | CHAR | 15(0) | BANKL | |||||
ZSWIF | SWIFT/BIC for International Payments | SWIFT | CHAR | 11(0) | SWIFT | |||||
ZBNKN | Bank Account Number of the Payee | DZBNKN35 | CHAR | 35(0) | BANKN35 | |||||
ZBKON | Bank Control Key of the Payee's Bank | DZBKON | CHAR | 2(0) | BKONT | |||||
BKREF | Reference specifications for bank details | BKREF | CHAR | 20(0) | CHAR20 | |||||
ZIBAN | IBAN of the Payee | DZIBAN | CHAR | 34(0) | IBAN | |||||
KOINH | Account Holder Name | KOINH_FI | CHAR | 60(0) | KOINH | |||||
ZBNKA | Name of the Payee's Bank | DZBNKA | CHAR | 60(0) | TEXT60 | |||||
ZBSTR | Street of the Payee's Bank | DZBSTR | CHAR | 35(0) | TEXT35 | |||||
ZBORT | City of the Payee's Bank | DZBORT | CHAR | 35(0) | TEXT35 | |||||
ZBREG | Region (State, Province, County) | REGIO | CHAR | 3(0) | Assigned to domain | REGIO | ||||
ZBRCH | Bank Branch | BRNCH | CHAR | 40(0) | TEXT40 | |||||
ZBPSK | Account Number of Bank Account At Post Office | PSKTO | CHAR | 16(0) | PSKTO | |||||
XPGRZ | Post Office Bank Current Account | XPGRO | CHAR | 1(0) | XFELD | |||||
MGUID | Globally Unique Identifier | GUID | RAW | 16(0) | ||||||
ZBUKR | Paying company code | DZBUKR | CHAR | 4(0) | Assigned to domain | BUKRS | ||||
ABSBU | Sending company code | ABSBU | CHAR | 4(0) | Assigned to domain | BUKRS | ||||
HWAER | Local Currency | HWAER_FPM | CUKY | 5(0) | Assigned to domain | WAERS | ||||
EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 12(0) | CHAR12 | |||||
HBKID | Short key for a house bank | HBKID | CHAR | 5(0) | Assigned to domain | HBKID | ||||
HKTID | ID for account details | HKTID | CHAR | 5(0) | Assigned to domain | HKTID | ||||
UBHKT | G/L Account Number for Our Bank Account / Bank Subaccount | UBHKT | CHAR | 10(0) | Assigned to domain | ALPHA | SAKNR | |||
BTYP1 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | CHAR | 1(0) | BNTYP | |||||
BNKS1 | Bank country key | BANKS | CHAR | 3(0) | Assigned to domain | LAND1 | BKL | |||
BNKL1 | Bank Keys | BANKK | CHAR | 15(0) | BANKK | BNK | ||||
BNKN1 | Bank account number | BANKN35 | CHAR | 35(0) | BANKN35 | |||||
IBAN1 | IBAN (International Bank Account Number) | IBAN | CHAR | 34(0) | IBAN | |||||
BKON1 | Bank Control Key | BKONT | CHAR | 2(0) | BKONT | |||||
BKRF1 | Reference specifications for bank details | BKREF | CHAR | 20(0) | CHAR20 | |||||
BSWIFT1 | SWIFT/BIC for International Payments | SWIFT | CHAR | 11(0) | SWIFT | |||||
BTYP2 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | CHAR | 1(0) | BNTYP | |||||
BNKS2 | Bank country key | BANKS | CHAR | 3(0) | Assigned to domain | LAND1 | BKL | |||
BNKL2 | Bank Keys | BANKK | CHAR | 15(0) | BANKK | BNK | ||||
BNKN2 | Bank account number | BANKN35 | CHAR | 35(0) | BANKN35 | |||||
IBAN2 | IBAN (International Bank Account Number) | IBAN | CHAR | 34(0) | IBAN | |||||
BKON2 | Bank Control Key | BKONT | CHAR | 2(0) | BKONT | |||||
BKRF2 | Reference specifications for bank details | BKREF | CHAR | 20(0) | CHAR20 | |||||
BSWIFT2 | SWIFT/BIC for International Payments | SWIFT | CHAR | 11(0) | SWIFT | |||||
BTYP3 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | CHAR | 1(0) | BNTYP | |||||
BNKS3 | Bank country key | BANKS | CHAR | 3(0) | Assigned to domain | LAND1 | BKL | |||
BNKL3 | Bank Keys | BANKK | CHAR | 15(0) | BANKK | BNK | ||||
BNKN3 | Bank account number | BANKN35 | CHAR | 35(0) | BANKN35 | |||||
IBAN3 | IBAN (International Bank Account Number) | IBAN | CHAR | 34(0) | IBAN | |||||
BKON3 | Bank Control Key | BKONT | CHAR | 2(0) | BKONT | |||||
BKRF3 | Reference specifications for bank details | BKREF | CHAR | 20(0) | CHAR20 | |||||
BSWIFT3 | SWIFT/BIC for International Payments | SWIFT | CHAR | 11(0) | SWIFT | |||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2(0) | Assigned to domain | DTAWS | ||||
DTAMS | Report key for data medium exchange | DTAMS | CHAR | 1(0) | DTAMS | |||||
DTWS1 | Instruction Key 1 | DTAT16 | NUMC | 2(0) | Assigned to domain | DTWSX | ||||
DTWS2 | Instruction Key 2 | DTAT17 | NUMC | 2(0) | Assigned to domain | DTWSX | ||||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2(0) | Assigned to domain | DTWSX | ||||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2(0) | Assigned to domain | DTWSX | ||||
RFTTRN | Payment code | RFTTRN_BF | CHAR | 20(0) | RFTTRN_BF | |||||
UETR | Unique Transaction Reference (UETR) | FPM_UETR | CHAR | 36(0) | SMUM_C36 | |||||
DOC1T | Payment Document Category | DOC1T_FPM | CHAR | 2(0) | DOCTP_FPM | |||||
DOC1R | Reference to Payment Document | DOC1R_FPM | CHAR | 24(0) | CHAR24 | |||||
SRTGB | Business Area | GSBER | CHAR | 4(0) | Assigned to domain | GSBER | GSB | |||
WAERS | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
RWBTR | Amount paid in transaction currency | BF_RWBTR | CURR | 23(2) | WERTV12 | |||||
RWSKT | Total Cash Discount in Payment (Transaction Currency) | BF_RWSKT | CURR | 23(2) | WERTV12 | |||||
WQSTE | Withholding Tax Amount (+/-) in Foreign Currency | WQSTV_FPM | CURR | 23(2) | WERTV12 | |||||
WABZG | Total Deductions (+/-) in Foreign Currency | WABZV_FPM | CURR | 23(2) | WERTV12 | |||||
WRBTR | Amount Before Deductions in Foreign Currency with +/- Signs | WRBTV_FPM | CURR | 23(2) | WERTV12 | |||||
RBETR | Amount Paid in Local Currency | BF_RBETR | CURR | 23(2) | WERTV12 | |||||
RSKON | Total Cash Discount Included in Payment (Local Currency) | BF_RSKON | CURR | 23(2) | WERTV12 | |||||
XKDFB | Indicator: Do Not Post any Exchange Rate Differences | XKDFB_FPM | CHAR | 1(0) | XFELD | |||||
ZALDT | Posting date of the payment document | DZALDT_ZHL | DATS | 8(0) | DATUM | |||||
AUSFD | Due date of the paid items | AUSFD | DATS | 8(0) | DATUM | |||||
VALUT | Value date | VALUT | DATS | 8(0) | DATUM | |||||
CRVAL | Value Date at Payee's Bank | PRQ_CRVAL | DATS | 8(0) | DATUM | |||||
RPOST | Number of Items paid | BF_RPOST | DEC | 7(0) | PACK4 | |||||
RTEXT | Number of Text Lines for the Items Paid | BF_RTEXT | DEC | 7(0) | PACK4 | |||||
PAYGR | Grouping Field for Automatic Payments | PAYGR_FPM | CHAR | 20(0) | CHAR20 | |||||
WDATE | Bill of Exchange Issue Date | WDATE | DATS | 8(0) | DATUM | |||||
WEFAE | Bill of Exchange Due Date | WEFAE | DATS | 8(0) | DATUM | |||||
WEAMX | Number of Bills of Exchange with Maximum Amount | WEAMX | DEC | 3(0) | PACK2 | |||||
WEFMX | Maximum Amount per Bill of Exchange in Payment Currency | WEFMX | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
WEFRS | Remaining Amount in Payment Crcy for Last Bill of Exchange | WEFRS | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
RZAWE | Payment Method | DZLSCH | CHAR | 1(0) | Assigned to domain | ZLSCH | ||||
UZAWE | Payment method supplement | UZAWE | CHAR | 2(0) | Assigned to domain | UZAWE | ||||
AVISG | Reason for Printing Payment Advice | AVISG_FPM | CHAR | 1(0) | CHAR1 | |||||
INTRACOMP | Intracompany Payment | INTRACOMP_FPM | CHAR | 1(0) | XFELD | |||||
FORMZ | Supplement for Payment Medium Format | FORMZ_FPM | CHAR | 6(0) | Assigned to domain | FORMZ_FPM | ||||
PURP_CODE | SEPA Purpose Code: Classification of a Payment/Debit Memo | FPM_PURP_CODE | CHAR | 4(0) | CHAR4 | |||||
UBUSA | Accounting Clerk (Short Entry) | UBUSA_FPM | CHAR | 35(0) | CHAR35 | |||||
SALUT | Form of address text | AD_TITLE_T | CHAR | 20(0) | TEXT20 | |||||
FNAME | First name | AD_NAMEFIR | CHAR | 40(0) | TEXT40 | |||||
LNAME | Last name | AD_NAMELAS | CHAR | 40(0) | TEXT40 | |||||
NAMP1 | Full Name of Person | AD_NAMTEXT | CHAR | 80(0) | TEXT80 | |||||
NAMP2 | Name 2 | NAME2_GP | CHAR | 35(0) | NAME | |||||
ID_CODE | Short name for correspondence | AD_ID_CODE | CHAR | 10(0) | TEXT10 | |||||
SABSPRA | Language Key | SPRAS | LANG | 1(0) | ISOLA | SPRAS | SPR | H_T002 | SPRAS | |
ABTEI | Department | AD_DPRTMNT | CHAR | 40(0) | TEXT40 | |||||
FUNCTION | Function | AD_FNCTN | CHAR | 40(0) | TEXT40 | |||||
ROOMN | Room or Apartment Number | AD_ROOMNUM | CHAR | 10(0) | TEXT10 | |||||
BUILD | Building (Number or Code) | AD_BLDNG | CHAR | 20(0) | TEXT20 | |||||
FLOOR_C | Floor in building | AD_FLOOR | CHAR | 10(0) | TEXT10 | |||||
IH_MAIL | Internal Mail Postal Code | AD_IH_MAIL | CHAR | 10(0) | TEXT10 | |||||
TELF1 | Addresses: telephone no. | TLFNR | CHAR | 30(0) | TEXT30 | |||||
TEL_EXTEN1 | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10(0) | CHAR10 | |||||
TELF2 | Addresses: telephone no. | TLFNR | CHAR | 30(0) | TEXT30 | |||||
TEL_EXTEN2 | Telephone no.: Extension | AD_TLXTNS | CHAR | 10(0) | CHAR10 | |||||
TELFX | Fax Number | TELFX | CHAR | 31(0) | TEXT31 | |||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10(0) | CHAR10 | |||||
INTAD | Internet address of partner company clerk | INTAD | CHAR | 130(0) | TXT130 |
Search for further information about these or an SAP related objects