KMZEI SAP (FI: Account Assignment Model Item Information) Table details
Dictionary Type: Table
Description: FI: Account Assignment Model Item Information
Description: FI: Account Assignment Model Item Information
Table field list including key, data, relationships and ABAP select examples
KMZEI is a standard SAP Table which is used to store FI: Account Assignment Model Item Information data and is available within R/3 SAP systems depending on the version and release level.
The KMZEI table consists of various fields, each holding specific information or linking keys about FI: Account Assignment Model Item Information data available in SAP. These include KMNAM (FI: Account Assignment Model Name), KMZEI (FI: Account Assignment Model Item Number), BUKRS (Company Code), KMZIF (FI: Account Assignment Model Equivalence Number).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP KMZEI table 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KMNAM | FI: Account Assignment Model Name | KMNAM | CHAR | 10 | Assigned to domain | KMNAM | KMN | H_KMKPF | |
KMZEI | FI: Account Assignment Model Item Number | KMZEI_D | NUMC | 3 | BUZEI | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
KMZIF | FI: Account Assignment Model Equivalence Number | KMZIF | INT2 | 5 | KMZIF | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | TGSB | GSBER | GSB | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
DMBE2 | Amount in Second Local Currency | DMBE2 | CURR | 13(2) | WERT7 | ||||
DMBE3 | Amount in Third Local Currency | DMBE3 | CURR | 13(2) | WERT7 | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
BEWAR | Transaction Type | RMVCT | CHAR | 3 | T856 | RMVCT | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
ETEN2 | Delivery Schedule Line Number | ETENR | NUMC | 4 | VBEP | ETENR | |||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
ANBWA | Asset Transaction Type | ANBWA | CHAR | 3 | TABW | BWASL | |||
BZDAT | Asset value date | BZDAT | DATS | 8 | DATUM | ||||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
XSKRL | Indicator: Line item not liable to cash discount? | XSKRL | CHAR | 1 | XFELD | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
ABPER | Settlement period | ABPER_RF | ACCP | 6 | BUPER | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
VNAME | Joint Venture | JV_NAME | CHAR | 6 | T8JV | ALPHA | JV_NAME | JVV | |
RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | T8JJ | ALPHA | JV_RECIND | ||
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | T8JF | ALPHA | JV_EGROUP | GJE | |
VPTNR | Partner account number | JV_PART | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
KSTRG | Cost Object | KSTRG | CHAR | 12 | Assigned to domain | KSTRG | KTR | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | AUFK | ALPHA | AUFNR | NET | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PASUBNR | Profitability segment changes (CO-PA) | RKESUBNR | NUMC | 4 | RKESUBNR | ||||
BTYPE | Payroll Type | JV_BILIND | CHAR | 2 | T8JA | ALPHA | JV_BILIND | ||
ETYPE | Equity type | JV_ETYPE | CHAR | 3 | T8JE | ALPHA | JV_ETYPE | ||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | FM01 | FIKRS | FIK | ||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | FMFPO | FIPOS | FIP | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | FMFINCODE | BP_GEBER | FIC | ||
BUDST | Budget center | BUDST | CHAR | 16 | BUDST | ||||
BUPOS | Budget item | BUPOS | CHAR | 14 | BUPOS | ||||
PPRCT | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
PROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | T053R | RSTGR | |||
KMREQ | Acct Assgn.Model: Item Contains Init.Required Fields Indic. | KMREQ | CHAR | 1 | XFELD | ||||
KMICT | Indicator: Item Contains External Company Code | KMICT | CHAR | 1 | XFELD | ||||
KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | KBL | |
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | KBP | ||
FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
SWENR | Site Number | SWENR | CHAR | 8 | Assigned to domain | SWENR | SWENR | WEH | MCWE |
SGENR | Building Number | SGENR | CHAR | 8 | Assigned to domain | SGENR | SGENR | GEB | MCGE |
SGRNR | Property Number for BE | SGRNR | CHAR | 8 | Assigned to domain | SGRNR | SGRNR | GRS | MCGR |
SMENR | Number of Rental Unit | SMENR | CHAR | 8 | Assigned to domain | SMENR | SMENR | MEH | MCME |
SNKSL | Service Charge Key | SNKSL | CHAR | 4 | Assigned to domain | ALPHA | SNKSL | NKL | REFXCLSNKSL |
EMPSL | Settlement Unit | SEMPSL | CHAR | 5 | Assigned to domain | ALPHA | SEMPSL | EMP | MCEM |
SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
EMIVE | Contract No. of Collective Lease-Outs | VVESMIVE | CHAR | 13 | ALPHA | VVSMIVE | MVE | ||
SVWNR | Management Contract Number | VVSVWNR | CHAR | 13 | VIVW01 | ALPHA | VVSVWNR | VWV | MCVW |
RECNNR | Real Estate Contract Number | RECNNR | CHAR | 13 | ALPHA | RECNNR | RECNNR | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER |
Key field | Non-key field |
How do I retrieve data from SAP table KMZEI using ABAP code
The following ABAP code Example will allow you to do a basic selection on KMZEI to SELECT all data from the tableDATA: WA_KMZEI TYPE KMZEI.
SELECT SINGLE *
FROM KMZEI
INTO CORRESPONDING FIELDS OF WA_KMZEI
WHERE...
How to access SAP table KMZEI
Within an ECC or HANA version of SAP you can also view further information about KMZEI 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