SAP FICA_ZERO_DOC_STR_ITEMS Table in S/4 HANA - Business Partner Items (Logical View)
FICA_ZERO_DOC_STR_ITEMS is a standard SAP Table which is used to store Business Partner Items (Logical View) 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 FICA_ZERO_DOC_STR_ITEMS 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: FICA_ZERO_DOC_STR_ITEMS
FICA_ZERO_DOC_STR_ITEMS table structure field list
Below is the full FICA_ZERO_DOC_STR_ITEMS 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 |
WA_ITEMS | STRU | 0(0) | ||||||||
MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12(0) | ALPHA | OPBEL_KK | 80B | |||
OPUPW | Repetition Item in Contract Account Document | OPUPW_KK | NUMC | 3(0) | OPUPW_KK | |||||
OPUPK | Item number in contract account document | OPUPK_KK | NUMC | 4(0) | OPUPK_KK | |||||
OPUPZ | Subitem for a Partial Clearing in Document | OPUPZ_KK | NUMC | 3(0) | OPUPZ_KK | |||||
BUKRS | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
GSBER | Business Area | GSBER | CHAR | 4(0) | GSBER | GSB | ||||
BUPLA | Business Place | BUPLA | CHAR | 4(0) | J_1BBRANCH | |||||
SEGMENT | Segment for Segmental Reporting | SEGMT_KK | CHAR | 10(0) | ALPHA | FB_SEGMENT | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
AUGST | Clearing Status | AUGST_KK | CHAR | 1(0) | AUGST_KK | |||||
GPART | Business Partner Number | GPART_KK | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | |||
VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20(0) | ALPHA | VTREF_KK | VTZ | |||
VTPOS | Contract: Item Number | VTPOS_KK | NUMC | 6(0) | VTPOS_KK | |||||
VTRE2 | Additional Reference Information | VTRE2_KK | CHAR | 20(0) | ALPHA | VTREF_KK | ||||
VKONT | Contract Account Number | VKONT_KK | CHAR | 12(0) | ALPHA | VKONT_KK | KTO | FKKVKP_F4 | VKONT | |
ABWBL | Number of the Substitute FI-CA Document | ABWBL_KK | CHAR | 12(0) | ALPHA | ABWBL_KK | ||||
ABWTP | Category of Substitute Document in FI-CA | ABWTP_KK | CHAR | 1(0) | ABWTP_KK | |||||
ABWKT | Alternative Contract Account for Collective Bills | ABWVK_KK | CHAR | 12(0) | ALPHA | VKONT_KK | ||||
APPLK | Application Area | APPLK_KK | CHAR | 1(0) | APPLK_KK | |||||
HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4(0) | HVORG_KK | 8HV | ||||
TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4(0) | TVORG_KK | |||||
KOFIZ | Account Determination ID | KOFIZ_KK | CHAR | 2(0) | KOFIZ_KK | |||||
SPART | Division | SPART_KK | CHAR | 2(0) | SPART | SPA | ||||
HKONT | General ledger account | HKONT_KK | CHAR | 10(0) | ALPHA | SAKNR | SAKO | SAKNR | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | MWSKZ | |||||
MWSZKZ | Supplementary Tax | MWSZKZ_KK | CHAR | 2(0) | MWSKZ | |||||
XANZA | Item is a Down Payment/Down Payment Request | XANZA_KK | CHAR | 1(0) | XFELD | |||||
STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1(0) | STAKZ_KK | |||||
BLDAT | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
BUDAT | Posting Date in the Document | BUDAT_KK | DATS | 8(0) | DATUM | |||||
OPTXT | Item text | OPTXT_KK | CHAR | 50(0) | TEXT50 | |||||
WAERS | Transaction Currency | BLWAE_KK | CUKY | 5(0) | WAERS | FWS | ||||
FAEDN | Due date for net payment | FAEDN_KK | DATS | 8(0) | DATUM | |||||
FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8(0) | DATUM | |||||
VERKZ | Item Can Only Be Cleared | VERKZ_KK | CHAR | 1(0) | VERKZ_KK | |||||
STUDT | Deferral to | STUDT_KK | DATS | 8(0) | DATUM | |||||
SKTPZ | Cash Discount Percentage Rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | |||||
XMANL | Exclude Item from Dunning Run | XMANL_KK | CHAR | 1(0) | XFELD | |||||
KURSF | Exchange rate | KURSF_KK | DEC | 9(5) | EXCRT | KURSF | ||||
BETRH | Amount In Local Currency With +/- Signs | BETRH_KK | CURR | 13(2) | WRTV7 | |||||
BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | |||||
BETR2 | Amount in Second Parallel Currency with +/- Sign | BETR2_KK | CURR | 13(2) | WRTV7 | |||||
BETR3 | Amount in Third Parallel Currency with +/- Sign | BETR3_KK | CURR | 13(2) | WRTV7 | |||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT_KK | CURR | 13(2) | WRTV7 | |||||
SBETH | Tax Amount in Local Currency With +/- Sign | SBETH_KK | CURR | 13(2) | WRTV7 | |||||
SBETW | Tax Amount in Transaction Currency with +/- Sign | SBETW_KK | CURR | 13(2) | WRTV7 | |||||
SBET2 | Tax Amount in Second Parallel Currency | SBET2_KK | CURR | 13(2) | WRTV7 | |||||
SBET3 | Tax Amount in Third Parallel Currency | SBET3_KK | CURR | 13(2) | WRTV7 | |||||
MWSKO | Account for posting taxes for down payments | MWSKO_KK | CHAR | 10(0) | ALPHA | SAKNR | ||||
MWVKO | Account for offsetting tax posting in down payments | MWVKO_KK | CHAR | 10(0) | ALPHA | SAKNR | ||||
TXRUL | Update Rule for Tax and Tax Clearing | TXRUL_KK | CHAR | 1(0) | TXRUL_KK | |||||
SPZAH | Lock Reason for Automatic Payment | SPZAH_KK | CHAR | 1(0) | SPZAH_KK | |||||
PYMET | Payment Method | PYMET_KK | CHAR | 1(0) | PYMET_KK | |||||
PYBUK | Company Code for Automatic Payment Transactions | PYBUK_KK | CHAR | 4(0) | BUKRS | |||||
PERNR | Personnel Number | PERNR_D | NUMC | 8(0) | PERNR | PER | ||||
GRKEY | Grouping Key for Displaying Open Items | GRKEY_KK | CHAR | 3(0) | CHAR3 | |||||
PERSL | Key for Period Assignment | PERSL_KK | CHAR | 4(0) | PERSL_KK | |||||
XAESP | Printing - No Changes Possible | XAESP_KK | CHAR | 1(0) | XFELD | |||||
AUGDT | Clearing Date | AUGDT_KK | DATS | 8(0) | DATUM | |||||
AUGBL | Clearing Document or Printed Document | AUGBL_KK | CHAR | 12(0) | ALPHA | AUGBL_KK | ||||
AUGBD | Clearing Document Posting Date | AUGBD_KK | DATS | 8(0) | DATUM | |||||
AUGRD | Clearing Reason | AUGRD_KK | CHAR | 2(0) | AUGRD_KK | |||||
AUGWA | Clearing Currency | AUGWA_KK | CUKY | 5(0) | WAERS | |||||
AUGBT | Clearing Amount in Clearing Currency | AUGBT_KK | CURR | 13(2) | WRTV7 | |||||
AUGBS | Tax Amount in Clearing Currency | AUGBS_KK | CURR | 13(2) | WRTV7 | |||||
AUGSK | Cash Discount Granted/Surcharge Levied in Clearing Currency | AUGSK_KK | CURR | 13(2) | WRTV7 | |||||
AUGVD | Value date for clearing | AUGVD_KK | DATS | 8(0) | DATUM | |||||
AUGOB | Item Canceled | AUGOB_KK | CHAR | 1(0) | XFELD | |||||
WHANG | Number of repetition items | WHANG_KK | NUMC | 3(0) | NUM03 | |||||
WHGRP | Repetition group | WHGRP_KK | NUMC | 3(0) | WHGRP_KK | |||||
XEIPH | Create Line Item in General Ledger | XEIPH_KK | CHAR | 1(0) | XFELD | |||||
MAHNV | Dunning Procedure | MAHNV_KK | CHAR | 2(0) | MAHNV_KK | FKK_MAHNV | MAHNV | |||
MANSP | Dunning Lock Reason | MANSP_KK | CHAR | 1(0) | MANSP_KK | |||||
XAUGP | Check Sample Record Clearing | XAUGP_KK | CHAR | 1(0) | XFELD | |||||
ABRZU | Lower Limit of Billing Period | ABRZU_KK | DATS | 8(0) | DATUM | |||||
ABRZO | Upper Limit of the Billing Period | ABRZO_KK | DATS | 8(0) | DATUM | |||||
FDGRP | Planning Group | FDGRP_KK | CHAR | 10(0) | ALPHA | FDGRP | FFG | |||
FDLEV | Planning level | FDLEV_KK | CHAR | 2(0) | FDLEV | FFE | ||||
FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2(0) | NUM2 | |||||
FDWBT | Planned Amount in Document or G/L Account Currency | FDWBT_KK | CURR | 13(2) | WERTV7 | |||||
XTAUS | Item Split | XTAUS_KK | CHAR | 1(0) | XFELD | |||||
AUGRS | Clearing restriction | AUGRS_KK | CHAR | 1(0) | AUGRS_KK | |||||
PYGRP | Grouping field for automatic payments | PYGRP_KK | CHAR | 10(0) | CHAR10 | |||||
PDTYP | Category of Payment Specification | PDTYP_KK | CHAR | 1(0) | PDTYP_KK | |||||
SPERZ | Interest Lock Reason | SPERZ_KK | CHAR | 1(0) | SPERZ_KK | |||||
INFOZ | Doubtful Item Entry/Individual Value Adjustment | INFOZ_KK | NUMC | 3(0) | INFOZ_KK | |||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15(0) | TXJCD | TXJ | ||||
TXDAT | Decisive Date for Calculating Taxes | TXDAT_KK | DATS | 8(0) | DATUM | |||||
VBUND | Company ID of Trading Partner | RASSC | CHAR | 6(0) | ALPHA | RCOMP | PGS | |||
KONTT | Account Assignment Category | KONTT_KK | CHAR | 2(0) | KONTT_KK | |||||
KONTL | Acct assnmnt string for industry-specific account assngments | KONTL_KK | CHAR | 50(0) | CHAR50 | |||||
OPSTA | Dunning indicator | OPSTA_KK | CHAR | 3(0) | OPSTA_KK | |||||
BLART | Document Type | BLART_KK | CHAR | 2(0) | BLART_KK | |||||
EMGPA | Alternative Business Partner for Payments | EMGPA_KK | CHAR | 10(0) | ALPHA | BU_PARTNER | BUPA | PARTNER | ||
EMBVT | Bank Details ID of Payee | EMBVT_KK | CHAR | 4(0) | CHAR4 | |||||
EMADR | Address Number | AD_ADDRNUM | CHAR | 10(0) | ALPHA | AD_ADDRNUM | ADR | |||
IKEY | Interest Key | IKEY_KK | CHAR | 2(0) | IKEY_KK | |||||
EUROU | Status of Euro Conversion | EUROU_KK | CHAR | 1(0) | EUROU_KK | |||||
XRAGL | Clearing posting reversed | XRAGL_KK | CHAR | 1(0) | XFELD | |||||
XWHPO | Expanded Repetition Item | XWHPO_KK | CHAR | 1(0) | XFELD | |||||
ASTKZ | Statistical Key of the Initiating Item | ASTKZ_KK | CHAR | 1(0) | ASTKZ_KK | |||||
ASBLG | Number of Triggering Document | ASBLG_KK | CHAR | 12(0) | ALPHA | OPBEL_KK | ||||
XBLNR | Reference document number | XBLNR_KK | CHAR | 16(0) | ALPHA | XBLNR_KK | ||||
INKPS | Collection Item | INKPS_KK | NUMC | 3(0) | NUM03 | |||||
RNDPS | Type of Rounding Item | RNDPS_KK | CHAR | 1(0) | RNDPS_KK | |||||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2(0) | QSSKZ | |||||
QSSEW | Withholding Tax Supplement | QSSEW_KK | CHAR | 2(0) | QSSEW_KK | |||||
QSPTP | Line Item Category From Withholding Tax View | QSPTP_KK | CHAR | 1(0) | QSPTP_KK | |||||
QSSHB | Tax Base Amount | QSSHB_KK | CURR | 13(2) | WRTV7 | |||||
QBSHB | Withholding Tax Amount (in Document Currency) | QBSHB_KK | CURR | 13(2) | WRTV7 | |||||
QSPRZ | Withholding Tax Percentage | QSPRZ_KK | NUMC | 6(0) | STPRZ_KK | |||||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10(0) | CHAR10 | |||||
XWHEX | Variable Withholding Tax in DFKKOPWH | XWHEX_KK | CHAR | 1(0) | XFELD | |||||
RFUPK | Reference Item In FI-CA Document | RFUPK_KK | NUMC | 4(0) | OPUPK_KK | |||||
STRKZ | Tax Code for Other Taxes | STRKZ_KK | CHAR | 2(0) | STRKZ_KK | |||||
FITPR | Tax type | J_1AFITP_D | CHAR | 2(0) | J_1AFITP | |||||
XPYOR | Item Included in a Payment Order | XPYOR_KK | CHAR | 1(0) | XPYOR_KK | |||||
LANDL | Country Supplied (for Tax Notifications) | LANDL_KK | CHAR | 3(0) | LAND1 | |||||
INTBU | Reason for Automatic Creation of Posting | INTBU_KK | CHAR | 1(0) | INTBU_KK | |||||
EMCRD | Alternative Payment Card ID in Document | EMCRD_KK | CHAR | 6(0) | CHAR6 | |||||
C4EYE | Check Reason for Workflows Acc. to Dual Control Principle | C4EYE_KK | CHAR | 2(0) | C4EYE_KK | |||||
CFOPN | CFOP Code and Extension | J_1BCFOP | CHAR | 10(0) | CFOBR | J_1BCFOP | ||||
C4EYP | Editing Process To Be Confirmed | C4EYP_KK | CHAR | 1(0) | C4EYP_KK | |||||
TXGRP | Grouping Key for Tax Items | TXGRP_KK | CHAR | 6(0) | CHAR6 | |||||
SCTAX | Tax Portion in FI-CA Local Currency | SCTAX_KK | CURR | 13(2) | WRTV7 | |||||
STTAX | Tax Amount as Statistical Information in Document Currency | STTAX_KK | CURR | 13(2) | WRTV7 | |||||
STZAL | Status of Payment Processing | STZAL_KK | CHAR | 1(0) | STZAL_KK | |||||
ORUPZ | Subitem Number before Item Split | ORUPZ_KK | CHAR | 3(0) | CHAR3 | |||||
NEGBU | Control Field for Negative Posting | NEGBU_KK | NUMC | 1(0) | NEGBU_KK | |||||
SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR | 1(0) | SUBAP_KK | 8SA | ||||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL_KK | CUKY | 5(0) | WAERS | |||||
PSWBT | Amount for Updating in General Ledger | PSWBT_KK | CURR | 13(2) | WRTV7 | |||||
PSWTX | Tax Amount for Update in General Ledger | PSWTX_KK | CURR | 13(2) | WRTV7 | |||||
PSGRP | Grouping Key for Document Items | PSGRP_KK | CHAR | 4(0) | CHAR4 | |||||
XCOLC | Item Is Included in Collection Case | XCOLC_KK | CHAR | 1(0) | XFELD | |||||
AASTA | Control Field for Account Assignment Distributions | AASTA_KK | CHAR | 1(0) | AASTA_KK | |||||
XCSHA | Document Contains Assignments from Cash Flows | XCSHA_KK | CHAR | 1(0) | XFELD | |||||
REACC | Originating Account in Cash Flow Anlaysis | REACC_KK | CHAR | 10(0) | ALPHA | SAKNR | ||||
REBUK | Partner Company Code for Cash Flow Analysis | REBUK_KK | CHAR | 4(0) | BUKRS | |||||
XUSTPD | Tax on Sales/Purchases Was Calculated by Document | XUSTPD_KK | CHAR | 1(0) | XFELD | |||||
PTITM | Status of Partner Settlement Using Billable Items | PTITM_KK | CHAR | 1(0) | PTITM_KK | |||||
EMMND | SEPA Mandate Identifier | EMMND_KK | NUMC | 6(0) | NUM06 | |||||
PALIX | Item Is Part of a Collaborative Liability | PALIX_KK | CHAR | 1(0) | PALIX_KK | |||||
CLRLOCK | Clearing Lock Reason | CLRLO_KK | CHAR | 1(0) | SPPOS_KK | |||||
PNNUM | SEPA: Number of Direct Debit Pre-Notification | PNNUM_KK | CHAR | 16(0) | ALPHA | PNNUM_KK | ||||
PNHKF | SEPA: Origin of Direct Debit Pre-Notification | PNHKF_KK | CHAR | 2(0) | PNHKF_KK | |||||
PNEXD | SEPA: Date of Execution of Direct Debit Pre-Notifcation | PNEXD_KK | DATS | 8(0) | DATUM | |||||
PNCTR | SEPA: Requirement for a Pre-Notification | PNCTR_KK | CHAR | 1(0) | PNCTR_KK | |||||
FINRE | Contract Account of Final Recipient | FINRE_KK | CHAR | 12(0) | ALPHA | VKONT_KK | FKKVKP_F4 | VKONT | ||
RDSTA | Current Distribution Status | RDSTA_KK | CHAR | 1(0) | RDSTAT_KK | |||||
RDSTB | Last Distribution Status Reported | RDSTB_KK | CHAR | 1(0) | RDSTAT_KK | |||||
FASTA | Factoring: Current Status of Receivable | FASTA_KK | CHAR | 1(0) | FASTA_KK | |||||
PASTA | Factoring: Check Status for Clearing Information | PASTA_KK | CHAR | 1(0) | PASTA_KK | |||||
OPUPF | Subitems in Factoring | OPUPF_KK | NUMC | 3(0) | OPUPZ_KK | |||||
FMTYP | Update Method for FM - FI-CA Integration | FMTYP_KK | CHAR | 2(0) | FMTYP_KK | |||||
ORIGFIKRS | Original FM Area for FM Account Assignment | ORIGFIKRS_KK | CHAR | 4(0) | FIKRS | |||||
FIPEX | Commitment item | FM_FIPEX | CHAR | 24(0) | FM_FIPEX | FPS | ||||
FISTL | Funds Center | FISTL | CHAR | 16(0) | FISTL | FIS | ||||
FONDS | Fund | BP_GEBER | CHAR | 10(0) | BP_GEBER | FIC | ||||
FKBER | Functional Area | FKBER | CHAR | 16(0) | FKBER | FBE | ||||
MEASURE | Funded Program | FM_MEASURE | CHAR | 24(0) | FM_MEASURE | FM_MEASURE | ||||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20(0) | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | GRANT_NUMBER | |
BUDGETYEAR | Original Year for FM Account Assignment | FM_START_OF_CHAIN | NUMC | 4(0) | GJAHR | GJAHR | ||||
BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | CHAR | 10(0) | FM_BUDGET_PERIOD | BUDPER | ||||
APERD | Non-Periodic Posting | APERI_SC | CHAR | 1(0) | BOOLE | |||||
COLOGRP | Colocation Group for Business Partner | COLOGRP_BP_KK | CHAR | 12(0) | COLOGRP_KK | |||||
HERKF_KK | Document Origin Key | HERKF_KK | CHAR | 2(0) | HERKF_KK | |||||
/SAPCE/FKRU_CN | Number of corrected document | /SAPCE/FKRU_CBLNR | CHAR | 12(0) | ALPHA | OPBEL_KK | FKDCF | OPBEL | ||
/SAPCE/FKRU_CD | Posting date of corrected document | /SAPCE/FKRU_CUDAT | DATS | 8(0) | DATUM | |||||
/SAPCE/FKRU_RN | Revision Number | /SAPCE/FKRU_RNUM | NUMC | 2(0) | /SAPCE/FKRU_RNUM | |||||
/SAPCE/FKRU_AB | Date from which time slice is valid | ABZEITSCH | DATS | 8(0) | DATUM | |||||
/SAPCE/FKRU_BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 8(0) | DATUM | |||||
INTOP | Internal Generation Characteristic for Document Item | INTOP_KK | CHAR | 1(0) | INTOP_KK | |||||
CPUDT_OP | Document Item Creation Date | CPUDT_OP_KK | DATS | 8(0) | DATUM | |||||
CPUTM_OP | Time of Document Item Creation | CPUTM_OP_KK | TIMS | 6(0) | UZEIT | |||||
CPUDT_ST | Document Item Reversal Date | CPUDT_ST_KK | DATS | 8(0) | DATUM | |||||
CPUTM_ST | Time of Document Item Reversal | CPUTM_ST_KK | TIMS | 6(0) | UZEIT | |||||
_DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8(0) | DATA_TEMPERATURE | |||||
AUGRE | Additional Clearing Restriction | AUGRE_KK | CHAR | 3(0) | AUGRE_KK | |||||
INTTX | Internal Tax Characteristic for Tax Handling | INTTX_KK | CHAR | 1(0) | XFELD | |||||
TXDAT_FROM | Valid-From Date of the Tax Rate | FOT_TXDAT_FROM | DATS | 8(0) | ||||||
DUMMY_FKKOP_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 1(0) |
Search for further information about these or an SAP related objects