SAP FAC_S_ACCDOC_LB_ITM_ODATA Table in S/4 HANA - OData: Entity Bank Statement Item Data
FAC_S_ACCDOC_LB_ITM_ODATA is a standard SAP Table which is used to store OData: Entity Bank Statement Item 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 FAC_S_ACCDOC_LB_ITM_ODATA 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: FAC_S_ACCDOC_LB_ITM_ODATA
FAC_S_ACCDOC_LB_ITM_ODATA table structure field list
Below is the full FAC_S_ACCDOC_LB_ITM_ODATA 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 |
KUKEY | Short Key (Surrogate) | KUKEY_EB | NUMC | 8(0) | KUKEY_EB | |||||
ESNUM | Memo Record Number (Line Item Number in Bank Statement) | ESNUM_EB | NUMC | 5(0) | NUM5 | |||||
FWAER | Payment Currency Key | FARP_FWAER | CUKY | 5(0) | Assigned to domain | WAERS | ||||
FWBTR | Payment Amount | FARP_FWBTR | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
REPROCREASONCODE | Reprocessing Reason Code | FEB_REPRO_REASON_CODE | CHAR | 2(0) | FEB_REPRO_RRC | FEB_REPRO_REASON_CODE | ||||
REPROCREASONCODE_T | Reprocessing Reason | FEB_REPRO_REASON_CODE_T | CHAR | 60(0) | TEXT60 | |||||
AVKOA | Account Type | FARP_KOART | CHAR | 1(0) | FARP_KOART | |||||
AV_KUNNR | Customer Number | KUNNR | CHAR | 10(0) | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR |
AV_LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C | LIFNR |
AV_HKONT | General Ledger Account | FARP_HKONT | CHAR | 10(0) | Assigned to domain | ALPHA | SAKNR | SAK | FAC_GL_ACCOUNT | GLACCT |
AVKON | Account Number | KTONR_AV | CHAR | 10(0) | ALPHA | KTONR | ||||
AVKON_AVSIDVALUEHELP | Account Number | KTONR_AV | CHAR | 10(0) | ALPHA | KTONR | ||||
TATYP | Payment Transaction Category | FAC_BS_IT_TATYP | CHAR | 4(0) | FAC_BS_IT_TATYP | H_TATYP | TATYP | |||
TATXT | Name of Transaction Category | FAC_BS_IT_TATXT | CHAR | 60(0) | TEXT60 | |||||
AVSID | Payment Advice Number | FARP_AVSID | CHAR | 16(0) | AVSID | |||||
UX_FC_AV_HKONT | UI Field Control Byte (Should be defined centrally) | FDC_UX_FC | INT1 | 3(0) | INT1 | |||||
UX_FC_FWBTR | UI Field Control Byte (Should be defined centrally) | FDC_UX_FC | INT1 | 3(0) | INT1 | |||||
UX_FC_AVSID | UI Field Control Byte (Should be defined centrally) | FDC_UX_FC | INT1 | 3(0) | INT1 | |||||
ASTAT | Statement Status | ASTAT_EB | CHAR | 1(0) | CHAR1 | |||||
VB2OK | 2nd Update OK | VB2OK_EB | CHAR | 1(0) | CHAR1 | |||||
N2PCH | Note to Payee Has Been Changed Manually | FEB_N2PCHGIND | CHAR | 1(0) | FEB_N2PCHGIND | |||||
NBBLN | Subledger document number | NBBLN_EB | CHAR | 10(0) | ALPHA | BELNR | ||||
AKBLN | Payment on account document number | AKBLN_EB | CHAR | 10(0) | ALPHA | BELNR | ||||
AZNUM | Statement Number | AZNUM_EB | NUMC | 5(0) | NUM5 | |||||
HBKID | Short key for a house bank | HBKID | CHAR | 5(0) | Assigned to domain | HBKID | ||||
HKTID | House Bank Account | FAC_HKTID | CHAR | 5(0) | Assigned to domain | HKTID | ||||
VGEXT | External Transaction | FARP_VGEXT | CHAR | 27(0) | Assigned to domain | VGEXT_EB | ||||
BANKA | Name of House Bank | FARP_BANKA | CHAR | 60(0) | TEXT60 | |||||
KWBTR | Amount in Account Currency | KWBTR_EB | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
WAERS | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
BUKRS | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3(0) | BUZEI | BUZ | ||||
N2POR | Original Note to Payee | FDC_ORIG_NOTE_TO_PAYEE | STRG | 0(0) | ||||||
CURR_RATE | Exchange Rate | FAC_KURSF_EXT | CHAR | 12(0) | FAC_KURSF_EXT | |||||
STGRD | Reason for Reversal | STGRD | CHAR | 2(0) | Assigned to domain | STGRD | FSG | |||
PABLZ | Partner Bank Account: Bank Number | FARP_PABLZ | CHAR | 15(0) | BANKK | |||||
PAKTO | Partner Bank Account: Account Number | FARP_PAKTO | CHAR | 18(0) | BANKN | |||||
PABKS | Partner Bank Account: Bank Country Key | FARP_PABKS | CHAR | 3(0) | Assigned to domain | LAND1 | ||||
PIBAN | Partner Bank Account: IBAN | PIBAN_EB | CHAR | 34(0) | IBAN | |||||
PASWI | SWIFT Code of Partner Bank | PASWI_EB | CHAR | 11(0) | SWIFT | |||||
PARTN | Business Partner | PARTN_EB | CHAR | 55(0) | CHAR55 | |||||
EPVOZ | Debit/Credit Key for Line Items (for Bank Purposes) | EPVOZ_EB | CHAR | 1(0) | CHAR1 | |||||
BANK_KEY | Bank Keys | BANKK | CHAR | 15(0) | BANKK | BNK | ||||
BANK_ACCT | Bank Account Number | FARP_BANKN | CHAR | 18(0) | BANKN | |||||
AZDAT | Lockbox Date | FARP_LB_AZDAT | DATS | 8(0) | DATE_EB | |||||
VALUT | Value Date | FARP_VALUT | DATS | 8(0) | DATE_EB | |||||
VGINT | Bank Statement Posting Rule | FARP_VGINT | CHAR | 4(0) | Assigned to domain | VGINT_EB | ||||
VGINT_TEXT | Bank Statement Posting Rule Description | FARP_VGINT_TEXT | CHAR | 40(0) | TXT40 | |||||
LOGHANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22(0) | SYSUUID_22 | |||||
VGMAN | Manual Transaction | FAR_VGMAN | CHAR | 4(0) | Assigned to domain | VGMAN_EB | ||||
VGMAN_TEXT | Manual Transaction Text | FAR_VGMAN_TEXT | CHAR | 40(0) | TEXT40 | |||||
VGTYP | Transaction Type | VGTYP_EB | CHAR | 8(0) | Assigned to domain | VGTYP_EB | ||||
B1APP | Application Indicator | APPLK_BF | CHAR | 6(0) | Assigned to domain | APPLK_BF | ||||
B1APP_TEXT | Text (non-language specific) | TXTSU | CHAR | 30(0) | TEXT30 | |||||
B2APP | Application Indicator | APPLK_BF | CHAR | 6(0) | Assigned to domain | APPLK_BF | ||||
B2APP_TEXT | Text (non-language specific) | TXTSU | CHAR | 30(0) | TEXT30 | |||||
BANK_ACCT_TECH_ID | Bank Account Technical ID | FAR_BAM_ACC_ID | NUMC | 10(0) | NUM10 | |||||
BANK_ACCT_UUID | Bank Account UUID | FAR_BAM_UUID | CHAR | 32(0) | SYSUUID_C | |||||
DISPUTE_CASE_UUID | FSCM-DM: GUID (Internal Key of Dispute Case) | BDM_CASE_GUID | CHAR | 32(0) | SYSUUID_C | |||||
DISPUTE_CASE_ID | Case ID | FDM_EXT_KEY | CHAR | 12(0) | ALPHA | FDM_EXT_KEY | ||||
AVKOA_TEXT | Payment Advice Account Type Name | FARP_AVKOATX | CHAR | 15(0) | CHAR15 | |||||
CUST_REF | Customer Reference Number | FARP_CUST_REF | CHAR | 13(0) | CHCKN | |||||
CONF_CHECT | Number of the confirmed check | FARP_CHECT_CONF | CHAR | 13(0) | CHCKN | |||||
CONF_RENUM | Number of confirmed Payment Medium Reference | FARP_RENUM_CONF | CHAR | 16(0) | TEXT16 | |||||
NUMBER_OF_ATT | Number of Attachments | FARP_NUMBER_OF_ATTACHMENTS | CHAR | 8(0) | ||||||
NUMBER_OF_NOTES | Number of Notes | FARP_NUMBER_OF_NOTES | CHAR | 8(0) | ||||||
GLACCT | G/L Account | FIS_RACCT | CHAR | 10(0) | Assigned to domain | ALPHA | SAKNR | |||
UX_FC_GLACCT | UI Field Control Byte (Should be defined centrally) | FDC_UX_FC | INT1 | 3(0) | INT1 | |||||
GLACCT_TXT | GL Account Description | FDC_HKONT_TXT | CHAR | 20(0) | TEXT20 | |||||
GLACCT_EDITLOKKT | Data entry in local G/L account number | FDC_GLACCT_EDITLOKKT | CHAR | 1(0) | XFELD | |||||
GLACCT_TXT_VH | GL Account Description | FDC_HKONT_TXT | CHAR | 20(0) | TEXT20 | |||||
AV_GLACCT | G/L Account | FIS_RACCT | CHAR | 10(0) | Assigned to domain | ALPHA | SAKNR | |||
UX_FC_AV_GLACCT | UI Field Control Byte (Should be defined centrally) | FDC_UX_FC | INT1 | 3(0) | INT1 | |||||
AV_GLACCT_TXT | GL Account Description | FDC_HKONT_TXT | CHAR | 20(0) | TEXT20 | |||||
AV_GLACCT_TXT_VH | GL Account Description | FDC_HKONT_TXT | CHAR | 20(0) | TEXT20 | |||||
LOCKBOX_ITM_LIFECYC_STS | Lockbox Item Life Cycle Status | FARP_LB_ITM_LIFECYC_STAT | CHAR | 1(0) | FARP_LB_ITM_LIFECYC_STAT | |||||
INCOMINGPAYMENTFILEID | Incoming Payment File ID | FARP_EFILEID | CHAR | 14(0) | FARP_EFILEID | |||||
LB_DESTINATION | Lockbox File Destination | FARP_DESTINATION | CHAR | 10(0) | FARP_ORIGIN_DES | |||||
LB_ORIGIN | Lockbox File origin | FARP_ORIGIN | CHAR | 10(0) | FARP_ORIGIN_DES | |||||
LB_NUM | Lockbox Number | FAR_LBNUM | NUMC | 7(0) | NUM07 | FARP_LOCKBOX_SHELP | LOCKBOX | |||
BELNR_GJAHR | Fiscal Year of Bank Accounting Document | BELNR_GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
NBBLN_GJAHR | Fiscal Year of Subledger Accounting Document | NBBLN_GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR |
Search for further information about these or an SAP related objects