SAP table KOMU (Account Assignment Templates for G/L Account Items)
SAP table KOMU has 3 primary key fields being MANDT,KMNAM,KMZEI.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||||||
| KMNAM | FI: Account Assignment Template Name | CHAR | 25 | 0 | KMNAM_ENJ | ||||||
| KMZEI | FI: Account Assignment Model Item Number | NUMC | 3 | 0 | KMZEI_D | ||||||
| BUKRS | Company Code | CHAR | 4 | 0 | BUKRS | ||||||
| KMZIF | FI: Account Assignment Model Equivalence Number | INT2 | 5 | 0 | KMZIF | ||||||
| BSCHL | Posting Key | CHAR | 2 | 0 | BSCHL | ||||||
| SHKZG | Debit/Credit Indicator | CHAR | 1 | 0 | SHKZG |
|
|||||
| GSBER | Business Area | CHAR | 4 | 0 | GSBER | ||||||
| PARGB | Trading partner's business area | CHAR | 4 | 0 | PARGB | ||||||
| MWSKZ | Tax on sales/purchases code | CHAR | 2 | 0 | MWSKZ | ||||||
| WRBTR | Amount in document currency | CURR | 23 | 2 | WRBTR | ||||||
| DMBTR | Amount in local currency | CURR | 23 | 2 | DMBTR | ||||||
| DMBE2 | Amount in Second Local Currency or Global Currency | CURR | 23 | 2 | DMBE2 | ||||||
| DMBE3 | Amount in Third Local Currency or First Freely-Def. Currency | CURR | 23 | 2 | DMBE3 | ||||||
| VALUT | Value date | DATS | 8 | 0 | VALUT | ||||||
| ZUONR | Assignment number | CHAR | 18 | 0 | DZUONR | ||||||
| SGTXT | Item Text | CHAR | 50 | 0 | SGTXT | ||||||
| VBUND | Company ID of Trading Partner | CHAR | 6 | 0 | RASSC | ||||||
| BEWAR | Transaction type | CHAR | 3 | 0 | RMVCT | ||||||
| KOSTL | Cost Center | CHAR | 10 | 0 | KOSTL | ||||||
| AUFNR | Order Number | CHAR | 12 | 0 | AUFNR | ||||||
| VBEL2 | Sales Document | CHAR | 10 | 0 | VBELN_VA | ||||||
| POSN2 | Sales Document Item | NUMC | 6 | 0 | POSNR_VA | ||||||
| ETEN2 | Schedule Line Number | NUMC | 4 | 0 | ETENR | ||||||
| ANLN1 | Main Asset Number | CHAR | 12 | 0 | ANLN1 | ||||||
| ANLN2 | Asset Subnumber | CHAR | 4 | 0 | ANLN2 | ||||||
| ANBWA | Asset Transaction Type | CHAR | 3 | 0 | ANBWA | ||||||
| BZDAT | Asset Value Date | DATS | 8 | 0 | BZDAT | ||||||
| DABRZ | Reference date for settlement | DATS | 8 | 0 | DABRBEZ | ||||||
| PERNR | Personnel Number | NUMC | 8 | 0 | PERNR_D | ||||||
| XSKRL | Indicator: Line Item Not Liable to Cash Discount? | CHAR | 1 | 0 | XSKRL | ||||||
| HKONT | General Ledger Account | CHAR | 10 | 0 | HKONT | ||||||
| BVTYP | Partner bank type | CHAR | 4 | 0 | BVTYP | ||||||
| ABPER | Settlement Period | ACCP | 6 | 0 | ABPER_RF | ||||||
| MATNR | Material Number | CHAR | 40 | 0 | MATNR | ||||||
| WERKS | Plant | CHAR | 4 | 0 | WERKS_D | ||||||
| MENGE | Quantity | QUAN | 13 | 3 | MENGE_D | ||||||
| MEINS | Base Unit of Measure | UNIT | 3 | 0 | MEINS | ||||||
| PRCTR | Profit Center | CHAR | 10 | 0 | PRCTR | ||||||
| VNAME | Joint venture | CHAR | 6 | 0 | JV_NAME | ||||||
| RECID | Recovery Indicator | CHAR | 2 | 0 | JV_RECIND | ||||||
| EGRUP | Equity group | CHAR | 3 | 0 | JV_EGROUP | ||||||
| VPTNR | Partner account number | CHAR | 10 | 0 | JV_PART | ||||||
| TXJCD | Tax Jurisdiction | CHAR | 15 | 0 | TXJCD | ||||||
| IMKEY | Internal Key for Real Estate Object | CHAR | 8 | 0 | IMKEY | ||||||
| KSTRG | Cost Object | CHAR | 12 | 0 | KSTRG | ||||||
| NPLNR | Network Number for Account Assignment | CHAR | 12 | 0 | NPLNR | ||||||
| AUFPL | Routing number of operations in the order | NUMC | 10 | 0 | CO_AUFPL | ||||||
| PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | 0 | RKEOBJNR | ||||||
| PASUBNR | Profitability Segment Changes (CO-PA) | NUMC | 4 | 0 | RKESUBNR | ||||||
| BTYPE | Billing Indicator | CHAR | 2 | 0 | JV_BILIND | ||||||
| ETYPE | Equity type | CHAR | 3 | 0 | JV_ETYPE | ||||||
| FIKRS | Financial Management Area | CHAR | 4 | 0 | FIKRS | ||||||
| FIPOS | Commitment Item | CHAR | 14 | 0 | FIPOS | ||||||
| FISTL | Funds Center | CHAR | 16 | 0 | FISTL | ||||||
| GEBER | Fund | CHAR | 10 | 0 | BP_GEBER | ||||||
| BUDST | Budget Center | CHAR | 16 | 0 | BUDST | ||||||
| BUPOS | Budget Item | CHAR | 14 | 0 | BUPOS | ||||||
| PPRCT | Partner Profit Center | CHAR | 10 | 0 | PPRCTR | ||||||
| PROJK | Work Breakdown Structure Element (WBS Element) | NUMC | 8 | 0 | PS_PSP_PNR | ||||||
| RSTGR | Reason Code for Payments | CHAR | 3 | 0 | RSTGR | ||||||
| KMREQ | Acct Assgn.Model: Item Contains Init.Required Fields Indic. | CHAR | 1 | 0 | KMREQ | ||||||
| KMICT | Indicator: Item Contains External Company Code | CHAR | 1 | 0 | KMICT | ||||||
| KBLNR | Document Number for Earmarked Funds | CHAR | 10 | 0 | KBLNR_FI | ||||||
| KBLPOS | Earmarked Funds: Document Item | NUMC | 3 | 0 | KBLPOS | ||||||
| FKBER | Functional Area | CHAR | 16 | 0 | FKBER | ||||||
| DUMMY_INCL_EEW_COBL | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY | ||||||
| VORNR | Operation/Activity Number | CHAR | 4 | 0 | VORNR | ||||||
| SWENR | Business Entity Number | CHAR | 8 | 0 | SWENR | ||||||
| SGENR | Building Number | CHAR | 8 | 0 | SGENR | ||||||
| SGRNR | Land Number for BE | CHAR | 8 | 0 | SGRNR | ||||||
| SMENR | Number of Rental Unit | CHAR | 8 | 0 | SMENR | ||||||
| SNKSL | Service Charge Key | CHAR | 4 | 0 | SNKSL | ||||||
| EMPSL | Settlement Unit | CHAR | 5 | 0 | SEMPSL | ||||||
| SMIVE | Lease-Out Number | CHAR | 13 | 0 | SMIVE | ||||||
| EMIVE | Contract No. of Collective Lease-Outs | CHAR | 13 | 0 | VVESMIVE | ||||||
| SVWNR | Management Contract Number | CHAR | 13 | 0 | VVSVWNR | ||||||
| RECNNR | Real Estate Contract Number | CHAR | 13 | 0 | RECNNR | ||||||
| CPUDT | Day On Which Accounting Document Was Entered | DATS | 8 | 0 | CPUDT | ||||||
| USNAM | User Name | CHAR | 12 | 0 | USNAM | ||||||
| TCODE | Transaction Code | CHAR | 20 | 0 | TCODE | ||||||
| ERLKZ | Used earmarked funds are set to "Completed". | CHAR | 1 | 0 | REFSETERLK | ||||||
| GRANT_NBR | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||||||
| SEGMENT | Segment for Segmental Reporting | CHAR | 10 | 0 | FB_SEGMENT | ||||||
| PSEGMENT | Partner Segment for Segmental Reporting | CHAR | 10 | 0 | FB_PSEGMENT | ||||||
| BUDGET_PD | Budget Period | CHAR | 10 | 0 | FM_BUDGET_PERIOD |