SAP FARP_BLNC_CNFRM_LETTER_EXP_S Table in S/4 HANA - Balance Confirmation Letter Export To Memory
FARP_BLNC_CNFRM_LETTER_EXP_S is a standard SAP Table which is used to store Balance Confirmation Letter Export To Memory 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 FARP_BLNC_CNFRM_LETTER_EXP_S 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: FARP_BLNC_CNFRM_LETTER_EXP_S
FARP_BLNC_CNFRM_LETTER_EXP_S table structure field list
Below is the full FARP_BLNC_CNFRM_LETTER_EXP_S 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 |
| KEY | STRU | 0(0) | ||||||||
| TYPE | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 | |||||
| COMPANY_CODE | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
| ACCOUNT | Customer Number | KUNNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR | |
| VALUE | STRU | 0(0) | ||||||||
| S_HEADER | STRU | 0(0) | ||||||||
| ADRNR | Address | ADRNR | CHAR | 10(0) | ALPHA | ADRNR | ||||
| LINE0 | Address line | LINES | CHAR | 80(0) | LINES | |||||
| LINE1 | Address line | LINES | CHAR | 80(0) | LINES | |||||
| LINE2 | Address line | LINES | CHAR | 80(0) | LINES | |||||
| LINE3 | Address line | LINES | CHAR | 80(0) | LINES | |||||
| LINE4 | Address line | LINES | CHAR | 80(0) | LINES | |||||
| LINE5 | Address line | LINES | CHAR | 80(0) | LINES | |||||
| LINE6 | Address line | LINES | CHAR | 80(0) | LINES | |||||
| LINE7 | Address line | LINES | CHAR | 80(0) | LINES | |||||
| LINE8 | Address line | LINES | CHAR | 80(0) | LINES | |||||
| LINE9 | Address line | LINES | CHAR | 80(0) | LINES | |||||
| LAND1 | Country Key | LAND1 | CHAR | 3(0) | LAND1 | LND | ||||
| KONTO | Customer or Vendor Account Number | F130KONT | CHAR | 10(0) | ALPHA | MAXKK | ||||
| ZSABE | Accounting Clerk at Customer or Vendor | DZSABE | CHAR | 15(0) | TEXT15 | |||||
| EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 12(0) | CHAR12 | |||||
| BUSAB | Accounting Clerk Abbreviation | BUSAB | CHAR | 2(0) | BUSAB | |||||
| SALUT | Form of address text | AD_TITLE_T | CHAR | 20(0) | TEXT20 | |||||
| LNAME | Last name | AD_NAMELAS | CHAR | 40(0) | TEXT40 | |||||
| TELF1 | Addresses: telephone no. | TLFNR | CHAR | 30(0) | TEXT30 | |||||
| TEL_EXTEN1 | First Telephone No.: Extension | AD_TLXTNS1 | 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 | |||||
| USRNAM | SAPoffice user name | SO_USR_NAM | CHAR | 12(0) | USERNAME | |||||
| BP_NAME | Name of Receipt Recipient | CJBPNAME | CHAR | 35(0) | NAME | |||||
| SADRNR | Addresses: Address Number | CADNR | CHAR | 10(0) | ALPHA | CADRNR | ||||
| NATIO | International address version ID | INTER | CHAR | 1(0) | NATION | |||||
| SNAME | Name of Accounting Clerk | SNAME_001S | CHAR | 30(0) | TEXT30 | |||||
| INLND | Country Key | LAND1 | CHAR | 3(0) | LAND1 | LND | ||||
| CURRENCY | Currency Key | WAERS | CUKY | 5(0) | WAERS | FWS | ||||
| EC_CURRENCY | Currency Key | WAERS | CUKY | 5(0) | WAERS | FWS | ||||
| H_NET_AMOUNT | Cash Journal Document Net Amount - Document Currency | CJNET_AMOUNT | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
| EC_H_NET_AMOUNT | Cash Journal Document Net Amount - Document Currency | CJNET_AMOUNT | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
| H_TAX_AMOUNT | Tax Amount in Document Currency | WMWST | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
| EC_H_TAX_AMOUNT | Tax Amount in Document Currency | WMWST | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
| H_NET_PAYMENT_WT | Net Payment Amount (Withholding Tax Deducted) | CJNET_PAYMENT_WT | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| EC_H_NET_PAYMENT_WT | Net Payment Amount (Withholding Tax Deducted) | CJNET_PAYMENT_WT | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| WRSHB | Foreign Currency Amount with Signs (+/-) | WRSHB | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
| EC_WRSHB | Foreign Currency Amount with Signs (+/-) | WRSHB | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
| QBUIHB | Withholding Tax Amount Entered Manually in Document Currency | WT_QBUIHB | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| EC_QBUIHB | Withholding Tax Amount Entered Manually in Document Currency | WT_QBUIHB | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| WT_NEWWT | Indicator: Extended Withholding Tax Active | WT_NEWWT | CHAR | 1(0) | XFELD | |||||
| CORRID | Correspondence: ID for RFKORD_S_HEADER | RFKORD_HEADER_CORRID | CHAR | 3(0) | RFKORD_HEADER_CORRID | |||||
| CORRID2 | Correspondence: ID for RFKORD_S_HEADER | RFKORD_HEADER_CORRID | CHAR | 3(0) | RFKORD_HEADER_CORRID | |||||
| CORRID3 | Correspondence: ID for RFKORD_S_HEADER | RFKORD_HEADER_CORRID | CHAR | 3(0) | RFKORD_HEADER_CORRID | |||||
| CORRID4 | Correspondence: ID for RFKORD_S_HEADER | RFKORD_HEADER_CORRID | CHAR | 3(0) | RFKORD_HEADER_CORRID | |||||
| BUKRS | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
| HWAER | Local Currency | HWAER | CUKY | 5(0) | WAERS | |||||
| BBUKR | Source Company Code | AUSBK | CHAR | 4(0) | BUKRS | |||||
| EVENT | Identification for Correspondence | EVENT_KORR | CHAR | 5(0) | EVENT_KORR | |||||
| KOART | Account type | KOART | CHAR | 1(0) | KOART | |||||
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
| AVSID | Payment Advice Number | AVSID | CHAR | 16(0) | AVSID | AVN | ||||
| CAJON | Cash Journal Number | CJNR | CHAR | 4(0) | CJNR | CJCAJONR | H_CAJO_NUMBER | CAJO_NUMBER | ||
| D_POSTING_NUMB | Cash Journal Document Number for Display | CJBELNR_DISP | CHAR | 10(0) | ALPHA | BELNR | ||||
| USNAM | User Name | USNAM | CHAR | 12(0) | XUBNAME | USR | ||||
| DATUM | Date | DATUM | DATS | 8(0) | DATUM | |||||
| RETURNLETTER | Type of Reply | CHAR | 1(0) | |||||||
| TXTKO | Header Text Name in Word Processing | TXTKO_001G | CHAR | 16(0) | TDFORMNEW | |||||
| TXTAB | Text Name for the Sender Details in the Letter Window | TXTAB_001G | CHAR | 16(0) | TDFORMNEW | |||||
| TXTFU | Footer Text Name in Word Processing | TXTFU_001G | CHAR | 16(0) | TDFORMNEW | |||||
| TXTUN | Text Name for the Signature | TXTUN_001G | CHAR | 16(0) | TDFORMNEW | |||||
| HEADER | Smart Forms: Name of Header Text in Text Processing | FSF_HEADER | CHAR | 30(0) | TDSFNAME | |||||
| FOOTER | Smart Forms: Name of Footer in Text Processing | FSF_FOOTER | CHAR | 30(0) | TDSFNAME | |||||
| SENDER | Smart Forms: Name of Sender Text in Text Processing | FSF_SENDER | CHAR | 30(0) | TDSFNAME | |||||
| GREETINGS | Smart Forms: Name of Greeting in Text Processing | FSF_GREETINGS | CHAR | 30(0) | TDSFNAME | |||||
| LOGO | URL for PDF Logo | FURL_LOGO | CHAR | 255(0) | SSFURL | |||||
| GRAPH | URL for PDF Graphic | FURL_GRAPHIC | CHAR | 255(0) | SSFURL | |||||
| SPRAS | Language Key | SPRAS | LANG | 1(0) | ISOLA | SPRAS | SPR | H_T002 | SPRAS | |
| TDNAME | Name | TDOBNAME | CHAR | 70(0) | TDOBNAME | |||||
| TDSPRAS | Language Key | SPRAS | LANG | 1(0) | ISOLA | SPRAS | SPR | H_T002 | SPRAS | |
| BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25(0) | TEXT25 | |||||
| ORT01 | City | ORT01 | CHAR | 25(0) | TEXT25 | |||||
| CAJO_NAME | Cash Journal Name | CJNAME | CHAR | 25(0) | CHAR_25 | |||||
| VTEXT | Name | VTXTK | CHAR | 20(0) | TEXT20 | |||||
| POSITION_TEXT | Cash Journal Line Item Text | CJPOSTEXT | CHAR | 50(0) | TEXT50 | |||||
| TRANSACT_NAME | Cash Journal Business Transaction | CJTRANSTXT | CHAR | 25(0) | CHAR_25 | |||||
| WORD | Amount in words | IN_WORDS | CHAR | 255(0) | CHAR255 | |||||
| DECWORD | Decimal places in words | DECWORD | CHAR | 128(0) | CHAR128 | |||||
| DATE_FROM | Date Specification for Correspondence | DATUM_KORR | DATS | 8(0) | DATUM | |||||
| DATE_TO | Date Specification for Correspondence | DATUM_KORR | DATS | 8(0) | DATUM | |||||
| KEY_DATE | Date Specification for Correspondence | DATUM_KORR | DATS | 8(0) | DATUM | |||||
| VSTID | Date Specification for Correspondence | DATUM_KORR | DATS | 8(0) | DATUM | |||||
| ZALBT | Payment Amount | DZALBT_F15 | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| AUGBT | Clearing Amount | AUGBT_F152 | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| BRTBT | Gross Amount of Payment (Cleared Items and Partial Payment) | BRTBT_F152 | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
| UMBBT | Other Transfer Postings | UMBBT_F152 | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
| DIFBT | Difference Amount | DIFBT_F152 | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| SKTBT | Cash Discount Amount | SKTBT_F152 | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| TLZBT | Partial Payment Amount | TLZBT_F152 | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| WAERS | Currency Key | WAERS | CUKY | 5(0) | WAERS | FWS | ||||
| RPOBT | Difference Amount | DIFBT_F152 | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| ACOBT | Difference Amount | DIFBT_F152 | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
| BZSBVERF | Confirmation Procedure Name | F130SBVT | CHAR | 30(0) | CHAR30 | |||||
| LAUFI | Additional Heading | ALLGLIN2 | CHAR | 20(0) | CHAR20 | |||||
| REPID | ABAP Program: Current Master Program | SYREPID | CHAR | 40(0) | PROGRAMM | |||||
| DECADE | Factory calendar: Factory date | FACDATE | DEC | 5(0) | HFDATE | |||||
| ABSTIDAT | Balance Reconciliation Key Date | F130STAG | DATS | 8(0) | DATUM | |||||
| AUSSTDAT | Issue Date of the Balance Confirmations | F130ASDT | DATS | 8(0) | DATUM | |||||
| RUECKDAT | Latest Date up Until Which a Reply Should Take Place | F130RADT | DATS | 8(0) | DATUM | |||||
| URUECKDA | Last Date up Until Which a Reply Is to Take Place | F130UADT | DATS | 8(0) | DATUM | |||||
| UAUSTDAT | Last Issue Date of Balance Confirmations | F130USDT | DATS | 8(0) | DATUM | |||||
| T_ITEM | TTYP | 0(0) | ||||||||
| T_SUM | TTYP | 0(0) | ||||||||
| T_ADDRESS | TTYP | 0(0) | ||||||||
| T_CONTACT | TTYP | 0(0) | ||||||||
| T_LIST | TTYP | 0(0) |
Search for further information about these or an SAP related objects