| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | DEBIT | Total Debit Postings | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_UMSOL | |
| 3 | CREDIT | Total Credit Postings | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_UMHAB | |
| 4 | TURNOVER | Balance | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_SALES | |
| 5 | COUNTER | Processed Database Table Rows | int | 10 | 0 | INT4 | ((0)) | Yes | | SYDBCNT | Allow NULL? |
| 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CURTP | Allow NULL? |
| 7 | CURRUNIT | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RSCURRENCY | Allow NULL? |
| 8 | QUANTITY | Quantity | decimal | 23 | 3 | QUAN | ((0)) | Yes | | QUAN1_12 | |
| 9 | QUANUNIT | Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | ROUNIT | Allow NULL? |
| 10 | CURRKEY_00 | Update Currency for General Ledger Totals Data | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_00 | Allow NULL? |
| 11 | CURRVAL_00 | Update Currency Value for General Ledger Totals Data | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_00 | |
| 12 | CURRKEY_10 | Company Code Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_10 | Allow NULL? |
| 13 | CURRVAL_10 | Company Code Currency Value | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_10 | |
| 14 | CURRKEY_11 | Company Code Currency Key, Group Valuation | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_11 | Allow NULL? |
| 15 | CURRVAL_11 | Company Code Currency Value, Group Valuation | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_11 | |
| 16 | CURRKEY_12 | Company Code Currency Key, Profit Center Valuation | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_12 | Allow NULL? |
| 17 | CURRVAL_12 | Company Code Currency Value, Profit Center Valuation | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_12 | |
| 18 | CURRKEY_20 | Controlling Area Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_20 | Allow NULL? |
| 19 | CURRVAL_20 | Controlling Area Currency Value | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_20 | |
| 20 | CURRKEY_21 | Controlling Area Currency Key, Group Valuation | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_21 | Allow NULL? |
| 21 | CURRVAL_21 | Controlling Area Currency Value, Group Valuation | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_21 | |
| 22 | CURRKEY_22 | Controlling Area Currency Key, Profit Center Valuation | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_22 | Allow NULL? |
| 23 | CURRVAL_22 | Controlling Area Currency Value, Profit Center Valuation | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_22 | |
| 24 | CURRKEY_30 | Group Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_30 | Allow NULL? |
| 25 | CURRVAL_30 | Group Currency Value | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_30 | |
| 26 | CURRKEY_31 | Group Currency Key, Group Valuation | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_31 | Allow NULL? |
| 27 | CURRVAL_31 | Group Currency Value, Group Valuation | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_31 | |
| 28 | CURRKEY_32 | Group Currency Key, Profit Center Valuation | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_32 | Allow NULL? |
| 29 | CURRVAL_32 | Group Currency Value, Profit Center Valuation | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_32 | |
| 30 | CURRKEY_90 | Profit Center Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_90 | Allow NULL? |
| 31 | CURRVAL_90 | Profit Center Currency Value | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_90 | |
| 32 | CURRKEY_91 | Profit Center Currency Key, Group Valuation | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_91 | Allow NULL? |
| 33 | CURRVAL_91 | Profit Center Currency Value, Group Valuation | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_91 | |
| 34 | CURRKEY_92 | Profit Center Currency Key, Profit Center Valuation | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_CURRKEY_92 | Allow NULL? |
| 35 | CURRVAL_92 | Profit Center Currency Value, Profit Center Valuation | decimal | 23 | 2 | CURR | ((0)) | Yes | | FAGL_CURRVAL_92 | |
| 36 | ACTIV | FI-SL Business Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ACTI1 | Allow NULL? |
| 37 | AFABE | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | AFABE_D | Allow NULL? |
| 38 | ALEBN | ALE: PCA document number in system where created | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PCA_ALEBN | Allow NULL? |
| 39 | ANBWA | Asset Transaction Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | ANBWA | Allow NULL? |
| 40 | ANLN1 | Main Asset Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ANLN1 | Allow NULL? |
| 41 | ANLN2 | Asset Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ANLN2 | Allow NULL? |
| 42 | AUBEL | Sales Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN_VA | Allow NULL? |
| 43 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 44 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | CO_AUFPL | Allow NULL? |
| 45 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR_VA | Allow NULL? |
| 46 | AUTOM | Indicator: Automatic posting lines | char | 1 | 0 | CHAR | (N' ') | Yes | | AUTOM | Allow NULL? |
| 47 | AWORG | Reference Organizational Units | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWORG | Allow NULL? |
| 48 | AWORG_REV | Reversal: Reverse Document Reference Organization | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWORG_REV | Allow NULL? |
| 49 | AWREF_REV | Reversal: Reverse Document Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWREF_REV | Allow NULL? |
| 50 | AWSYS | Logical system of source document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AWSYS | Allow NULL? |
| 51 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 52 | BLART | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BLART | Allow NULL? |
| 53 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 54 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 55 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BWART | Allow NULL? |
| 56 | BWKEY | Valuation Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BWKEY | Allow NULL? |
| 57 | BWTAR | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BWTAR_D | Allow NULL? |
| 58 | CO_PRZNR | Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CO_PRZNR | Allow NULL? |
| 59 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CPUDT | Allow NULL? |
| 60 | CPUTM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CPUTM | Allow NULL? |
| 61 | DABRZ | Reference Date for Settlement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DABRBEZ | Allow NULL? |
| 62 | DOCCT | Document Type | char | 1 | 0 | CHAR | (N' ') | Yes | | DOCCT | Allow NULL? |
| 63 | DOCLN | Document line | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | DOCLN | Allow NULL? |
| 64 | DOCNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 65 | DOCTY | FI-SL Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | DOCTY | Allow NULL? |
| 66 | DRCRK | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 67 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EBELN | Allow NULL? |
| 68 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | EBELP | Allow NULL? |
| 69 | EPRCTR | Partner profit center for elimination of internal business | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EPRCTR | Allow NULL? |
| 70 | ERKRS | Operating concern | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ERKRS | Allow NULL? |
| 71 | FISCPER | Fiscal year / period | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | RSFISCPER | Allow NULL? |
| 72 | FKART | Billing Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FKART | Allow NULL? |
| 73 | GRTYP | Statistical Key Figure Category | char | 1 | 0 | CHAR | (N' ') | Yes | | GRTYP | Allow NULL? |
| 74 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 75 | HRKFT | Origin Group as Subdivision of Cost Element | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HRKFT | Allow NULL? |
| 76 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | IMKEY | Allow NULL? |
| 77 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KDAUF | Allow NULL? |
| 78 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 79 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KOKRS | Allow NULL? |
| 80 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 81 | KSTRG | Cost Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | KSTRG | Allow NULL? |
| 82 | KTOPL | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KTOPL | Allow NULL? |
| 83 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 84 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 85 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 86 | LOGSYS | Logical System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYSTEM | Allow NULL? |
| 87 | LSTAR | Activity Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | LSTAR | Allow NULL? |
| 88 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 89 | OCLNT | Original client | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OCLNT | Allow NULL? |
| 90 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | RKEOBJNR | Allow NULL? |
| 91 | PASUBNR | Profitability segment changes (CO-PA) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RKESUBNR | Allow NULL? |
| 92 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 93 | POPER | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | POPER | Allow NULL? |
| 94 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR | Allow NULL? |
| 95 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_PSP_PNR | Allow NULL? |
| 96 | RACCT | Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RACCT | Allow NULL? |
| 97 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RASSC | Allow NULL? |
| 98 | RBUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 99 | REFACTIV | FI-SL Business Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ACTI1 | Allow NULL? |
| 100 | REFDOCCT | Document Type | char | 1 | 0 | CHAR | (N' ') | Yes | | DOCCT | Allow NULL? |
| 101 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 102 | REFDOCNR | Reference Document Number (External Document Number) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PCA_REFBELNR | Allow NULL? |
| 103 | REFRYEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 104 | REP_MATNR | Representative material for Profit Center Accounting | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | REP_MATNR | Allow NULL? |
| 105 | RFAREA | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FKBER | Allow NULL? |
| 106 | RHOART | Type of origin object (EC-PCA) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | HOART | Allow NULL? |
| 107 | RLDNR | Ledger | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RLDNR | Allow NULL? |
| 108 | RMVCT | Transaction Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | RMVCT | Allow NULL? |
| 109 | RPRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 110 | RRCTY | Record Type | char | 1 | 0 | CHAR | (N' ') | Yes | | RRCTY | Allow NULL? |
| 111 | RSCOPE | Object Class | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SCOPE_CV | Allow NULL? |
| 112 | RTCUR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RTCUR | Allow NULL? |
| 113 | RYEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 114 | SBUKRS | Sender company code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | S_BUKRS | Allow NULL? |
| 115 | SFAREA | Partner Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | SFKBER | Allow NULL? |
| 116 | SGTXT | Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SGTXT | Allow NULL? |
| 117 | SHOART | Type of receiver object | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SHOART | Allow NULL? |
| 118 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART | Allow NULL? |
| 119 | SPRCTR | Partner Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PPRCTR | Allow NULL? |
| 120 | STAGR | Statistical key figure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | STAGR | Allow NULL? |
| 121 | STFLG | Identifier for reversal document | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_STFLG | Allow NULL? |
| 122 | STOKZ | Indicator: Document Has Been Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_STOKZ | Allow NULL? |
| 123 | USNAM | User name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | USNAM | Allow NULL? |
| 124 | VALUT | Value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALUT | Allow NULL? |
| 125 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN | Allow NULL? |
| 126 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RASSC | Allow NULL? |
| 127 | VERSA | Results Analysis Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VERSN_ABGR | Allow NULL? |
| 128 | VKBUR | Sales Office | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKBUR | Allow NULL? |
| 129 | VKGRP | Sales Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VKGRP | Allow NULL? |
| 130 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 131 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VTWEG | Allow NULL? |
| 132 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 133 | WSDAT | Value Date for Currency Translation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WSDAT | Allow NULL? |
