FICA_BANK_MAIN_STR_ITEMS SAP (Assigned Details) Structure details
Description: Assigned Details
Related tables to FICA_BANK_MAIN_STR_ITEMS
Access table FICA_BANK_MAIN_STR_ITEMS
Structure field list including key, data, relationships and ABAP select examples
FICA_BANK_MAIN_STR_ITEMS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Assigned Details" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FICA_BANK_MAIN_STR_ITEMS TYPE FICA_BANK_MAIN_STR_ITEMS.
The FICA_BANK_MAIN_STR_ITEMS table consists of various fields, each holding specific information or linking keys about Assigned Details data available in SAP. These include GPART (Business Partner Number), VKONT (Contract Account Number), VTREF (Reference Specifications from Contract), SUBAP (Subapplication in Contract Accounts Receivable and Payable).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP FICA_BANK_MAIN_STR_ITEMS structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
WA_ITEMS | 0 | ||||||||
GPART | Business Partner Number | GPART_KK | CHAR | 10 | ALPHA | BU_PARTNER | BPA | ||
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | ALPHA | VKONT_KK | KTO | FKKVKP_F4 | |
VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR | 1 | SUBAP_KK | 8SA | |||
PPACC | Prepaid Account | PPACC_KK | CHAR | 12 | ALPHA | PPACC_KK | 8PPACC | FKKPREPACC_F4 | |
WA_VKONTO | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | ALPHA | VKONT_KK | KTO | FKKVKP_F4 | |
GPART | Business Partner Number | GPART_KK | CHAR | 10 | ALPHA | BU_PARTNER | BPA | ||
VKBEZ | Contract account name | VKBEZ_KK | CHAR | 35 | TEXT35 | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDATP | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAMP | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 | ||||
STOPD | Processing lock until | STOPD_KK | DATS | 8 | STOPD_KK | ||||
QSZDT | Validity Date for Withholding Tax Exemption Certificate | QSZDT | DATS | 8 | DATUM | ||||
GUID | Business Agreement GUID | BUAG_GUID | RAW | 16 | SYSUUID | ||||
DDLAM | Direct Debit Limit | DDLAM_KK | CURR | 13(2) | WRTV7 | ||||
DDLCU | Currency of Direct Debit Limit | DDLCU_KK | CUKY | 5 | WAERS | ||||
DDLNM | Number of Months for Calculation of Direct Debit Limit | DDLNM_KK | NUMC | 2 | NUM02 | ||||
INV_CYCLE_START | Start Date of Billing Cycle in Contract Account | CYCLE_STARTDATE_KK | DATS | 8 | DATS | ||||
INV_CHGDISC_X | Int: Charges and Discounts Exist for BP-CrtAcct Relations | CHGDISC_X_KK | CHAR | 1 | XFELD | ||||
BPL_XPOCL | Business Partner Lock for Postings/Clearing | BPL_XPOCL_KK | CHAR | 1 | BPL_XPOCL_KK | ||||
BPL_FDATE | Lock valid from | FDATE_KK | DATS | 8 | DATUM | ||||
BPL_TDATE | Lock valid to | TDATE_KK | DATS | 8 | DATUM | ||||
EXVKO | Reference number for business partner | EXVKO_KK | CHAR | 25 | CHAR25 | ||||
OPBUK | Company Code Group | OPBUK_KK | CHAR | 4 | OPBUK_KK | OPBUK | |||
STDBK | Standard Company Code | STDBK_KK | CHAR | 4 | BUKRS | ||||
ABWRE | Alternative Payer | ABWRE_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
ABWRA | Alternative Payee | ABWRA_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
ABWMA | Alternative dunning recipient | ABWMA_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
EBVTY | Bank Details ID for Incoming Payments | EBVTY_KK | CHAR | 4 | CHAR4 | ||||
ABVTY | Bank Details ID for Outgoing Payments | ABVTY_KK | CHAR | 4 | CHAR4 | ||||
EZAWE | Incoming Payment Method | EZAWE_KK | CHAR | 1 | CHAR1 | ||||
EZASP | Lock Reason for Incoming Payments | EZASP_OLD_KK | CHAR | 1 | SPZAH_KK | ||||
AZAWE | Outgoing Payment Methods | AZAWE_KK | CHAR | 5 | CHAR5 | ||||
AZASP | Lock Reason for Outgoing Payments | AZASP_OLD_KK | CHAR | 1 | SPZAH_KK | ||||
EIGBV | Own Bank Details | EIGBV_KK | CHAR | 25 | EIGBV_KK | ||||
VWNZA | Create Where-Used List For Line Items | VWNZA_KK | CHAR | 1 | VWNZA_KK | ||||
LOEVM | Mark Contract Account for Deletion | LOEVM_KK | CHAR | 1 | LOEVM_KK | ||||
ABWVK | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | ALPHA | VKONT_KK | |||
IKEY | Interest Key | IKEY_KK | CHAR | 2 | IKEY_KK | ||||
MAHNV | Dunning Procedure | MAHNV_KK | CHAR | 2 | MAHNV_KK | FKK_MAHNV | |||
MANSP | Dunning Lock Reason | MANSP_OLD_KK | CHAR | 1 | MANSP_KK | ||||
MGRUP | Grouping fur Dunning Notices | MGRUP_KK | CHAR | 2 | MGRUP_KK | ||||
FDGRP | Planning Group | FDGRP_KK | CHAR | 10 | ALPHA | FDGRP | FFG | ||
VKPBZ | Relationship of Business Partner to Contract Account | VKPBZ_KK | CHAR | 2 | VKPBZ_KK | ||||
ADRNB | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
VKONV | Contract account used for payment transactions | VKONV_KK | CHAR | 12 | ALPHA | VKONT_KK | |||
GPARV | Business Partner Acting as Payer in Payment Transactions | GPARV_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
ADRRE | Address Number for Alternative Payer | ADRRE_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ADRRA | Address Number for Alternative Payee | ADRRA_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ADRMA | Address number for alternative dunning notice recipient | ADRMA_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ABWRH | Alternative Invoice Recipient | ABWRH_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
ADRRH | Address number for alternative bill recipient | ADRRH_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ADRJDC | Address Number for Jurisdiction Code Address | ADRJDC_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
TOGRU | Tolerance group for contract account | TOGRU_KK | CHAR | 4 | TOGRU_KK | ||||
STOPG | Reason for Processing Lock | STOPG_KK | CHAR | 1 | STOPG_KK | ||||
TXJCD | Jurisdiction for Tax Calculation - Tax Jurisdiction Code | TXJCD_NOCD_KK | CHAR | 15 | TXJCD | TXJ | |||
COPRC | Correspondence Variant | COPRC_KK | CHAR | 4 | COPRC_KK | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
CCARD_ID | Payment Card ID for Incoming Payments | CCID_IN_KK | CHAR | 6 | CHAR6 | ||||
CCARD_OUT | Payment Card ID for Outgoing Payments | CCID_OUT_KK | CHAR | 6 | CHAR6 | ||||
UEBTR | Items Transferred To Another Account | XUEBTR_KK | CHAR | 1 | XFELD | ||||
DEF_REC | Alternative Correspondence Recipient for Standard Case | DEF_CORR_PARTNER_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
DEF_REC_IND | FI-CA correspondence - activity key | DEF_CORR_ACKEY_KK | CHAR | 4 | CORR_ACKEY_KK | ||||
QSSKZ_A | Witholding Tax Code For Outgoing Payments | QSSKZ_A_KK | CHAR | 2 | QSSKZ | ||||
QSSKZ_E | Withholding Tax Code For Incoming Payments | QSSKZ_E_KK | CHAR | 2 | QSSKZ | ||||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
CORR_MAHNV | Correspondence Dunning Procedure | CORR_MAHNV_KK | CHAR | 2 | MAHNV_KK | ||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | ||||
PROVINCE | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
COUNTY | County Code | COUNC | CHAR | 3 | COUNC | ||||
VERTYP | Clearing Category For Clearing Postings | VERTYP_KK | CHAR | 4 | VERTYP_KK | ||||
AUGRS_DEF | Clearing Restriction | AUGRS_DEF_KK | CHAR | 1 | AUGRS_DEF_KK | ||||
LANDL | Country Supplied (for Tax Notifications) | LANDL_KK | CHAR | 3 | LAND1 | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | ||||
BPTAXTYPE1 | Tax Number Type 1 for Business Partner | BPTAXTYPE1 | CHAR | 4 | BPTAXTYPE | ||||
BPTAXTYPE2 | Tax Number type 2 for Business Partner | BPTAXTYPE2 | CHAR | 4 | BPTAXTYPE | ||||
PERSR | Clerk Responsible | PERSR_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
INV_CATEGORY | Invoicing Category | INV_CATEGORY_KK | CHAR | 4 | INV_CATEGORY_KK | ||||
DDLXG | Rolling Calculation of Direct Debit Limit | DDLXG_KK | CHAR | 1 | XFELD | ||||
CMGRP | Collection Management: Master Data Group | CMGRP_CM_KK | CHAR | 2 | CMGRP_CM_KK | ||||
STRAT | Collection Strategy | STRAT_CM_KK | CHAR | 2 | STRAT_CM_KK | ||||
CPERS | Collections Contact Person | CPERS_CM_KK | CHAR | 10 | ALPHA | BU_PARTNER | BPA | ||
BPCL_SUCC | Duplicate Processing: Predecessor/Successor Business Partner | BPCL_SUCC_KK | CHAR | 1 | BPCL_SUCC_KK | ||||
INV_SCHEDULE | Selection Characteristic for Scheduling | INV_SCHEDULE_KK | CHAR | 4 | INV_SCHEDULE_KK | ||||
INV_CYCLE | Billing Cycle | CYCLE_KK | CHAR | 4 | CYCLE_KK | ||||
INV_CYCLE_RULE | Field Is Not Used - CHAR4 | CYCLE_RULE_KK | CHAR | 4 | |||||
INV_CYCLE_DAY | Day of Period End | CYCLE_DAY_KK | CHAR | 2 | CYCLE_DAY_KK | ||||
INV_CYCLE_MONTH | Field Is Not Used - CHAR2 | NOT_USED_CHAR2_KK | CHAR | 2 | |||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 |
Key field | Non-key field |
How do I retrieve data from SAP structure FICA_BANK_MAIN_STR_ITEMS using ABAP code?
As FICA_BANK_MAIN_STR_ITEMS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FICA_BANK_MAIN_STR_ITEMS as there is no data to select.How to access SAP table FICA_BANK_MAIN_STR_ITEMS
Within an ECC or HANA version of SAP you can also view further information about FICA_BANK_MAIN_STR_ITEMS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects