In this post, I will try and describe everything you need to know about the SAP gacn_structure table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for GACN_STRUCTURE what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from GACN_STRUCTURE....Right lets get started!
Object Name: GACN_STRUCTURE
Dictionary Type: Structure
Description: Golden Audit China DMEE interface
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| IDCN_GA_COMMONINFO | IDCN_GA_COMMONINFO | STRU | 0(0) | |||||||||
| F_B_BUKRS | BUKRS | CHAR | 4(0) | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | |||
| B_CODE | B_CODE | CHAR | 60(0) | Electronic Account Book ID | ||||||||
| B_DESC | B_DESC | CHAR | 200(0) | Electronic Account Book Name | ||||||||
| ORG_DESC | ORG_DESC | CHAR | 200(0) | Company Name | ||||||||
| ORG_CODE | ORG_CODE | CHAR | 20(0) | Organizational Code | ||||||||
| ORG_CATG | ORG_CATG | CHAR | 8(0) | Company Type | ||||||||
| IND_CODE | IND_CODE | CHAR | 20(0) | Industry | ||||||||
| DEV_BY | DEV_BY | CHAR | 200(0) | Development by | ||||||||
| SOFT_REL_VER | IDCN008 | CHAR | 20(0) | Accounting Software Version | ||||||||
| LOC_CURR | IDCN020 | CHAR | 14(0) | GL Account Currency Type | ||||||||
| FISCAL_YEAR | GJAHR | NUMC | 4(0) | Fiscal Year | GJAHR | GJR | FB | |||||
| REL_VER | REL_VER | CHAR | 30(0) | National Standard | ||||||||
| FISCAL_PRD | MONAT | NUMC | 2(0) | Fiscal Period | MONAT | MG | ||||||
| PRD_STRAT_DATE | CPUDT | DATS | 8(0) | Day On Which Accounting Document Was Entered | DATUM | MB | ||||||
| PRD_END_DATE | CPUDT | DATS | 8(0) | Day On Which Accounting Document Was Entered | DATUM | MB | ||||||
| DOC_TYPE | B_CODE | CHAR | 60(0) | Electronic Account Book ID | ||||||||
| DOC_DESC | B_CODE | CHAR | 60(0) | Electronic Account Book ID | ||||||||
| DOC_S_DESC | ORG_CODE | CHAR | 20(0) | Organizational Code | ||||||||
| ER_TYPE | IDCN_ER_TYPE | CHAR | 60(0) | Exchange Rate Type (Golden Audit) | ||||||||
| ER_DESC | IDCN_ER_DESC | CHAR | 60(0) | Description of Exchange Rate Type (Golden Audit) | ||||||||
| CURR_TYPE | WAERS | CUKY | 5(0) | Currency Key | WAERS | FWS | FB | |||||
| CURR_DESC | IDCN020 | CHAR | 14(0) | GL Account Currency Type | ||||||||
| PAY_METHOD | DZLSCH | CHAR | 1(0) | Payment Method | ZLSCH | FB | ||||||
| PAY_METHOD_DESC | TEXT1 | CHAR | 50(0) | Text | TEXT50 | SAP | ||||||
| DEP_CODE | KOSTL | CHAR | 10(0) | Cost Center | KOSTL | KOS | KS | |||||
| DEP_DESC | LTEXT | CHAR | 40(0) | Long Text | TEXT40 | MG | ||||||
| SUP_CODE | SUP_CODE | CHAR | 60(0) | Supevisory department code | ||||||||
| EMP_NO | B_CODE | CHAR | 60(0) | Electronic Account Book ID | ||||||||
| EMP_NAME | IDCN011 | CHAR | 30(0) | Account Structure | ||||||||
| ID_DOC_TYPE | IDCN011 | CHAR | 30(0) | Account Structure | ||||||||
| ID_DOC_NO | IDCN011 | CHAR | 30(0) | Account Structure | ||||||||
| GENDER | IND_CODE | CHAR | 20(0) | Industry | ||||||||
| BIRTHDATE | CPUDT | DATS | 8(0) | Day On Which Accounting Document Was Entered | DATUM | MB | ||||||
| DEPT_CODE | B_CODE | CHAR | 60(0) | Electronic Account Book ID | ||||||||
| EMPLOYMENT_START_DATE | CPUDT | DATS | 8(0) | Day On Which Accounting Document Was Entered | DATUM | MB | ||||||
| EMPLOYMENT_END_DATE | CPUDT | DATS | 8(0) | Day On Which Accounting Document Was Entered | DATUM | MB | ||||||
| V_CODE | LIFNR | CHAR | 10(0) | Account Number of Vendor or Creditor | LIFNR | LIF | FB | KRED_C | LIFNR | |||
| V_DES | CHAR | 70(0) | Name of the Vendor | |||||||||
| V_S_DESC | SORTL | CHAR | 10(0) | Sort field | CHAR10 | FB | ||||||
| CUST_CODE | KUNNR | CHAR | 10(0) | Customer Numbers | KUNNR | KUN | V | C_KUNNR | KUNNR | |||
| CUST_DESC | CHAR | 70(0) | Name of theCustomer | |||||||||
| CUST_S_DESC | SORTL | CHAR | 10(0) | Sort field | CHAR10 | FB | ||||||
| ARCHIVE_CODE | IDCN_ARCHIVE_CODE | CHAR | 50(0) | Archive Code | ||||||||
| ARCHIVE_NAME | IDCN_ARCHIVE_NAME | CHAR | 200(0) | Archive Name | ||||||||
| ARCHIVE_DESC | IDCN_ARCHIVE_DESC | CHAR | 200(0) | Archive Description | ||||||||
| HIERARCHY | IDCN_HIERARCHY_CN | CHAR | 1(0) | Hierarchy | IDCN_HIERARCHY_CN | |||||||
| ARCHIVE_NUM_RULE | IDCN_ARCHIVE_NUM_RULE | CHAR | 200(0) | Archive Numbering Rule | ||||||||
| ARCHIVE_CODE_V | IDCN_ARCHIVE_CODE | CHAR | 50(0) | Archive Code | ||||||||
| ARCHIVE_VALUE_CODE | IDCN_ARCHIVE_VALUE_CODE | CHAR | 60(0) | Archive Value Code (Golden Audit) | ||||||||
| ARCHIVE_VALUE_NAME | IDCN_ARCHIVE_VALUE_NAME | CHAR | 200(0) | Archive Value Name (Golden Audit) | ||||||||
| ARCHIVE_VALUE_DESC | IDCN_ARCHIVE_VALUE_DESC | CHAR | 200(0) | Archive Value Description (Golden Audit) | ||||||||
| ARCHIVE_VALUE_UPPER_NODE | IDCN_ARCHIVE_VALUE_UPPER_NODE | CHAR | 60(0) | Archive Value Upper Node (Golden Audit) | ||||||||
| ARCHIVE_VALUE_LEVEL | IDCN_ARCHIVE_VALUE_LEVEL | CHAR | 2(0) | Archive Value Level (Golden Audit) | ||||||||
| IDCN_GA_FIAAXML | IDCN_GA_FIAAXML | STRU | 0(0) | |||||||||
| BUKRS | BUKRS | CHAR | 4(0) | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | |||
| KTOGR | KTOGR | CHAR | 8(0) | Account determination | KTOGR | AB | ||||||
| KTANSW | KTANSW | CHAR | 10(0) | Bal. sheet account: Acquisition and production costs | SAKNR | ABB | ||||||
| KTAUNB | KTAUFW | CHAR | 10(0) | Reconciliation account: Revaluation | SAKNR | ABB | ||||||
| KTNAFB | KTNAFB | CHAR | 10(0) | Accumulated depreciation account for ordinary depreciation | SAKNR | ABB | ||||||
| ANLKL_CODE | IDCN_ANLKLCODE | CHAR | 60(0) | Rule of fixed asset type Code | CHAR60 | |||||||
| ANLKL | ANLKL | CHAR | 8(0) | Asset Class | ANLKL | ANK | AA | SH_ANLKA | ANLKL | |||
| TXK50 | TXT50_ANKT | CHAR | 50(0) | Asset class description | TEXT50 | AA | ||||||
| BWAGRP_CN | IDCN_BWAGRP | CHAR | 4(0) | Asset Transaction Group (Golden Audit) | CHAR04 | |||||||
| BWATXT | BWATXT | CHAR | 50(0) | Asset transaction type name | TEXT50 | AB | ||||||
| ANLN1 | ANLN1 | CHAR | 12(0) | Main Asset Number | ANLN1 | AN1 | AA | |||||
| ANLN2 | ANLN2 | CHAR | 4(0) | Asset Subnumber | ANLN2 | AN2 | AA | |||||
| TXT50 | TXA50_ANLT | CHAR | 50(0) | Asset description | TEXT50 | AA | ||||||
| AKTIV | AKTIVD | DATS | 8(0) | Asset capitalization date | DATUM | AA | ||||||
| MONAT | MONAT | NUMC | 2(0) | Fiscal Period | MONAT | MG | ||||||
| MSEHT | MSEHT | CHAR | 10(0) | Unit of Measurement Text (Maximum 10 Characters) | TEXT10 | MG | ||||||
| MENGE | CHAR23 | CHAR | 23(0) | Character Field of Length 23 | CHAR23 | SAP | ||||||
| RAUMN | RAUMNR | CHAR | 8(0) | Room | CHAR8 | INST | ||||||
| AFATXT | AFATXT | CHAR | 50(0) | Name for external depreciation key | TEXT50 | ABA | ||||||
| AFASL | AFASL | CHAR | 4(0) | Depreciation key | AFASL | AB | SH_AFASL | AFASL | ||||
| FORMULAE | IDCN_DEPFORM | CHAR | 200(0) | Formula for Asset Depreciation (Golden Audit) | CHAR200 | |||||||
| AFPROZ | AFPROZ | DEC | 7(4) | Depreciation percentage rate | AFPROZ | ABA | ||||||
| NDPER | NDPER | NUMC | 3(0) | Planned useful life in periods | PERAF | ABA | ||||||
| WAERS | WAERS | CUKY | 5(0) | Currency Key | WAERS | FWS | FB | |||||
| WAERS_TEXT | IDCN020 | CHAR | 14(0) | GL Account Currency Type | ||||||||
| NAFAP_PER | NAFAP | CURR | 13(2) | Planned ordinary depreciation for the year | ANLKWERT | AB | ||||||
| KANSW | KANSW | CURR | 13(2) | Cumulative acquisition and production costs | ANLKWERT | AB | ||||||
| KNAFA | KNAFA | CURR | 13(2) | Accumulated ordinary depreciation | ANLKWERT | AB | ||||||
| GJA_BCHWRT | GJA_BCHWRT | CURR | 13(2) | Asset book value at beginning of fiscal year | ANLKWERT | AW | ||||||
| KOSTL | KOSTL | CHAR | 10(0) | Cost Center | KOSTL | KOS | KS | |||||
| DEP_RATIO | IDCN_RATIO | DEC | 3(1) | GA China: Depreciation Ratio | DEC2_1 | |||||||
| BELNR | BELNR_D | CHAR | 10(0) | Accounting Document Number | BELNR | BLN | FB | |||||
| BUDAT | BUDAT | DATS | 8(0) | Posting Date in the Document | DATUM | FB | ||||||
| STATUS_CODE | ORD41 | CHAR | 4(0) | Evaluation group 1 | ORD4X | AA | ||||||
| STATUS_CODE_TEXT | ORDTX | CHAR | 30(0) | Evaluation group:Short description | TEXT30 | AA | ||||||
| TYPE_CODE | ORD42 | CHAR | 4(0) | Evaluation group 2 | ORD4X | AA | ||||||
| TYPE_CODE_TEXT | ORDTX | CHAR | 30(0) | Evaluation group:Short description | TEXT30 | AA | ||||||
| SERNR | AM_SERNR | CHAR | 18(0) | Serial number | GERNR | SER | INST | |||||
| INVNR | INVNR_ANLA | CHAR | 25(0) | Inventory number | INVNR_ANLA | AA | ||||||
| TYPBZ | TYPBZ_ANLA | CHAR | 15(0) | Asset type name | TYPBZ_ANLA | AA | ||||||
| ANBTR | ANBTR | CURR | 13(2) | Amount posted | ANLKWERT | ABB | ||||||
| AFBLPE | AFBLPE | NUMC | 3(0) | Period in which last depreciation was posted | PERAF | AB | ||||||
| INKEN | INKEN | CHAR | 1(0) | Inventory indicator | XFELD | AA | ||||||
| KAUFW | KAUFW | CURR | 13(2) | Cumulative revaluation on the replacement value | ANLKWERT | AB | ||||||
| MEINS_AFASL | MEINS | UNIT | 3(0) | Base Unit of Measure | MEINS | MG | ||||||
| GSTZAHL | GSTZAHL | DEC | 15(0) | Total number of units, which is available as of this period | PACK8 | |||||||
| STZAHL | STZAHL | DEC | 15(0) | Planned number of units in the period | PACK8 | ABA | ||||||
| AHPROZ | ANBTR | CURR | 13(2) | Amount posted | ANLKWERT | ABB | ||||||
| AHPROZ_VALUE | ANBTR | CURR | 13(2) | Amount posted | ANLKWERT | ABB | ||||||
| MENGE_ANEK | CHAR23 | CHAR | 23(0) | Character Field of Length 23 | CHAR23 | SAP | ||||||
| APC_REDUCE | ANBTR | CURR | 13(2) | Amount posted | ANLKWERT | ABB | ||||||
| NAFAV | NAFAV | CURR | 13(2) | Proportional accumulated ordinary depreciation | ANLKWERT | AB | ||||||
| ZUONR | DZUONR | CHAR | 18(0) | Assignment Number | ZUONR | FB | ||||||
| NBV_REDUCE | ANBTR | CURR | 13(2) | Amount posted | ANLKWERT | ABB | ||||||
| ERLBT | ERLBT | CURR | 13(2) | Revenue from asset sale | ANLKWERT | ABB | ||||||
| VERKO | VERKO_D | CURR | 13(2) | Costs from asset retirement | ANLKWERT | ABB | ||||||
| RAUMN_NEW | RAUMNR | CHAR | 8(0) | Room | CHAR8 | INST | ||||||
| RAUMN_OLD | RAUMNR | CHAR | 8(0) | Room | CHAR8 | INST | ||||||
| REDUCTION | CHAR1 | CHAR | 1(0) | Single-Character Indicator | CHAR1 | SAP | ||||||
| NODE | CHAR2 | CHAR | 2(0) | Version Number Component | CHAR2 | TEST | ||||||
| DOCUMENT_ID | CHAR50 | CHAR | 50(0) | Comment | TEXT50 | SAP | ||||||
| AMOR_REDUCE | ANBTR | CURR | 13(2) | Amount posted | ANLKWERT | ABB | ||||||
| IDCN_GA_APAR | IDCN_GA_APAR | STRU | 0(0) | |||||||||
| BUKRS | BUKRS | CHAR | 4(0) | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | |||
| DTCODE | IDCNDTCODE | CHAR | 5(0) | Document Type | IDCNDTCODE | |||||||
| DTCODE_D | IDCNDTCODE_T | CHAR | 60(0) | Document Type Description | IDCNDTCODE_T | |||||||
| TTCODE | IDCNTTCODE | CHAR | 5(0) | Transaction Type | IDCNTTCODE | |||||||
| TTCODE_D | IDCNTTCODE_T | CHAR | 60(0) | Transaction Type Description | IDCNTTCODE_T | |||||||
| KUNNR | KUNNR | CHAR | 10(0) | Customer Numbers | KUNNR | KUN | V | C_KUNNR | KUNNR | |||
| LIFNR | LIFNR | CHAR | 10(0) | Account Number of Vendor or Creditor | LIFNR | LIF | FB | KRED_C | LIFNR | |||
| HKONT | HKONT | CHAR | 10(0) | General Ledger Account | SAKNR | FB | ||||||
| BLDAT | BLDAT | DATS | 8(0) | Document Date in Document | DATUM | FB | ||||||
| BUDAT | BUDAT | DATS | 8(0) | Posting Date in the Document | DATUM | FB | ||||||
| GJAHR | GJAHR | NUMC | 4(0) | Fiscal Year | GJAHR | GJR | FB | |||||
| MONAT | MONAT | NUMC | 2(0) | Fiscal Period | MONAT | MG | ||||||
| BLART | CHAR | 60(0) | ||||||||||
| BELNR | BELNR_D | CHAR | 10(0) | Accounting Document Number | BELNR | BLN | FB | |||||
| HWAER | IDCN020 | CHAR | 14(0) | GL Account Currency Type | ||||||||
| KURSF | CHAR9 | CHAR | 9(0) | Character field of 9 digits | CHAR9 | |||||||
| SHKZG | SHKZG | CHAR | 1(0) | Debit/Credit Indicator | SHKZG | FB | ||||||
| DMBTR | DMBTR | CURR | 13(2) | Amount in Local Currency | WERT7 | FB | ||||||
| WRBTR | WRBTR | CURR | 13(2) | Amount in document currency | WERT7 | FB | ||||||
| DMBTR_TOT | DMBTR | CURR | 13(2) | Amount in Local Currency | WERT7 | FB | ||||||
| DOC_CURR | IDCN020 | CHAR | 14(0) | GL Account Currency Type | ||||||||
| WRBTR_TOT | WRBTR | CURR | 13(2) | Amount in document currency | WERT7 | FB | ||||||
| SGTXT | SGTXT | CHAR | 50(0) | Item Text | TEXT50 | SAP | ||||||
| VALUT | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| AUGBL | AUGBL | CHAR | 10(0) | Document Number of the Clearing Document | BELNR | FB | ||||||
| AUGDT_CLR | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| DTCODE1 | IDCNDTCODE | CHAR | 5(0) | Document Type | IDCNDTCODE | |||||||
| TTCODE1 | IDCNTTCODE | CHAR | 5(0) | Transaction Type | IDCNTTCODE | |||||||
| VBELN | AWKEY | CHAR | 20(0) | Reference Key | AWKEY | FB | ||||||
| XBLNR | XBLNR | CHAR | 16(0) | Reference Document Number | XBLNR | FB | ||||||
| VBELN_VA | AWKEY | CHAR | 20(0) | Reference Key | AWKEY | FB | ||||||
| EBELN | AWKEY | CHAR | 20(0) | Reference Key | AWKEY | FB | ||||||
| ZLSCH | SCHZW_BSEG | CHAR | 1(0) | Payment Method | ZLSCH | FB | ||||||
| AUGDT | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| CLFLAG | XFELD | CHAR | 1(0) | Checkbox | XFELD | FB | ||||||
| BOENUM | BELNR_D | CHAR | 10(0) | Accounting Document Number | BELNR | BLN | FB | |||||
| DUMAR | XFELD | CHAR | 1(0) | Checkbox | XFELD | FB | ||||||
| DUMAP | XFELD | CHAR | 1(0) | Checkbox | XFELD | FB | ||||||
| WAERS | WAERS | CUKY | 5(0) | Currency Key | WAERS | FWS | FB | |||||
| IDCN_GA_GL | IDCN_GA_GL | STRU | 0(0) | |||||||||
| BUKRS | BUKRS | CHAR | 4(0) | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | |||
| GL_AC_R | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| CH_NUM_R | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| DOCHDREXFSTR | CHAR50 | CHAR | 50(0) | Comment | TEXT50 | SAP | ||||||
| DOCHDREXFARV | CHAR50 | CHAR | 50(0) | Comment | TEXT50 | SAP | ||||||
| DOCITMEXFSTR | CHAR50 | CHAR | 50(0) | Comment | TEXT50 | SAP | ||||||
| DOCITMEXFARV | CHAR50 | CHAR | 50(0) | Comment | TEXT50 | SAP | ||||||
| HKONT | HKONT | CHAR | 10(0) | General Ledger Account | SAKNR | FB | ||||||
| TXT50_SKAT | TXT50_SKAT | CHAR | 50(0) | G/L Account Long Text | TEXT50 | FB | ||||||
| GL_ACC_LEVEL | CHAR2 | CHAR | 2(0) | Version Number Component | CHAR2 | TEST | ||||||
| GL_CAT | IDCNACCTY | CHAR | 20(0) | Golden Audit Interface China: Account Type | IDCNACCTY | |||||||
| SHKZG | CHAR5 | CHAR | 5(0) | R/2 table | CHAR5 | SDIN | ||||||
| SUB_HKONT | HKONT | CHAR | 10(0) | General Ledger Account | SAKNR | FB | ||||||
| SUB_NUMB | CHAR2 | CHAR | 2(0) | Version Number Component | CHAR2 | TEST | ||||||
| SUB_ITEM_DESC | CHAR50 | CHAR | 50(0) | Comment | TEXT50 | SAP | ||||||
| SUB_ARHV | CHAR50 | CHAR | 50(0) | Comment | TEXT50 | SAP | ||||||
| SUB_ITEM_DESC1 | CHAR50 | CHAR | 50(0) | Comment | TEXT50 | SAP | ||||||
| CASH_ITM_CODE | CHAR20 | CHAR | 20(0) | Char 20 | CHAR20 | SAP | ||||||
| CASH_ITM_NAME | CHAR30 | CHAR | 30(0) | 30 Characters | CHAR30 | SAP | ||||||
| CASH_ITM_DESC | CHAR50 | CHAR | 50(0) | Comment | TEXT50 | SAP | ||||||
| CASH_LEVEL | CHAR2 | CHAR | 2(0) | Version Number Component | CHAR2 | TEST | ||||||
| CASH_LEVEL_ITEM | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| CASH_UP_CODE | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| CASH_DATA_SRC | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| CASH_ITM_ATTR | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| ACBAL_HKONT | HKONT | CHAR | 10(0) | General Ledger Account | SAKNR | FB | ||||||
| ACBAL_SUB1 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB2 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB3 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB4 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB5 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB6 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB7 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB8 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB9 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB10 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB11 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB12 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB13 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB14 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB15 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB16 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB17 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB18 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB19 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB20 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB21 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB22 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB23 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB24 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB25 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB26 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB27 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB28 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB29 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SUB30 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACBAL_SHKZG_PRD_SRT | CHAR5 | CHAR | 5(0) | R/2 table | CHAR5 | SDIN | ||||||
| ACBAL_SHKZG_PRD_END | CHAR5 | CHAR | 5(0) | R/2 table | CHAR5 | SDIN | ||||||
| ACBAL_CURR_CODE | IDCN020 | CHAR | 14(0) | GL Account Currency Type | ||||||||
| ACBAL_UNIT_MSR | IDCN018 | CHAR | 10(0) | Measurement unit | ||||||||
| ACBAL_GJAHR | GJAHR | NUMC | 4(0) | Fiscal Year | GJAHR | GJR | FB | |||||
| ACBAL_MONAT | MONAT | NUMC | 2(0) | Fiscal Period | MONAT | MG | ||||||
| ACBAL_PRD_BEG_QUAN | CHAR23 | CHAR | 23(0) | Character Field of Length 23 | CHAR23 | SAP | ||||||
| ACBAL_DOC_CURR_BG | TSLXX | CURR | 15(2) | Total transactions of the period in transaction currency | WERTV8 | FG | ||||||
| ACBAL_LCL_CURR_BG | HSLXX | CURR | 15(2) | Total transactions in the period in local currency (curr 2) | WERTV8 | FB | ||||||
| ACBAL_DR_QUAN | CHAR23 | CHAR | 23(0) | Character Field of Length 23 | CHAR23 | SAP | ||||||
| ACBAL_DR_DOC_CURR | TSLXX | CURR | 15(2) | Total transactions of the period in transaction currency | WERTV8 | FG | ||||||
| ACBAL_DR_LCL_CURR | HSLXX | CURR | 15(2) | Total transactions in the period in local currency (curr 2) | WERTV8 | FB | ||||||
| ACBAL_CR_QUAN | CHAR23 | CHAR | 23(0) | Character Field of Length 23 | CHAR23 | SAP | ||||||
| ACBAL_CR_DOC_CURR | TSLXX | CURR | 15(2) | Total transactions of the period in transaction currency | WERTV8 | FG | ||||||
| ACBAL_CR_LCL_CURR | HSLXX | CURR | 15(2) | Total transactions in the period in local currency (curr 2) | WERTV8 | FB | ||||||
| ACBAL_PRD_END_QUAN | CHAR23 | CHAR | 23(0) | Character Field of Length 23 | CHAR23 | SAP | ||||||
| ACBAL_DOC_CURR_END | TSLXX | CURR | 15(2) | Total transactions of the period in transaction currency | WERTV8 | FG | ||||||
| ACBAL_LCL_CURR_END | HSLXX | CURR | 15(2) | Total transactions in the period in local currency (curr 2) | WERTV8 | FB | ||||||
| ACDOC_BUDAT | BUDAT | DATS | 8(0) | Posting Date in the Document | DATUM | FB | ||||||
| ACDOC_GJAHR | GJAHR | NUMC | 4(0) | Fiscal Year | GJAHR | GJR | FB | |||||
| ACDOC_MONAT | MONAT | NUMC | 2(0) | Fiscal Period | MONAT | MG | ||||||
| ACDOC_BLART | BLART | CHAR | 2(0) | Document Type | BLART | BAR | FB | |||||
| ACDOC_BELNR | BELNR_D | CHAR | 10(0) | Accounting Document Number | BELNR | BLN | FB | |||||
| ACDOC_BUZEI | BUZEI | NUMC | 3(0) | Number of Line Item Within Accounting Document | BUZEI | BUZ | FB | |||||
| ACDOC_BKTXT | BKTXT | CHAR | 25(0) | Document Header Text | TEXT25 | FB | ||||||
| ACDOC_HKONT | HKONT | CHAR | 10(0) | General Ledger Account | SAKNR | FB | ||||||
| ACDOC_SUB1 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB2 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB3 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB4 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB5 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB6 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB7 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB8 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB9 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB10 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB11 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB12 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB13 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB14 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB15 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB16 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB17 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB18 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB19 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB20 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB21 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB22 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB23 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB24 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB25 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB26 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB27 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB28 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB29 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_SUB30 | CHAR58 | CHAR | 58(0) | Character field of length 58 | CHAR58 | |||||||
| ACDOC_CURR_CODE | IDCN020 | CHAR | 14(0) | GL Account Currency Type | ||||||||
| ACDOC_UNIT_MSR | IDCN018 | CHAR | 10(0) | Measurement unit | ||||||||
| ACDOC_DR_QUAN | CHAR23 | CHAR | 23(0) | Character Field of Length 23 | CHAR23 | SAP | ||||||
| ACDOC_DR_DOC_CURR | TSLXX | CURR | 15(2) | Total transactions of the period in transaction currency | WERTV8 | FG | ||||||
| ACDOC_DR_LCL_CURR | HSLXX | CURR | 15(2) | Total transactions in the period in local currency (curr 2) | WERTV8 | FB | ||||||
| ACDOC_CR_QUAN | CHAR23 | CHAR | 23(0) | Character Field of Length 23 | CHAR23 | SAP | ||||||
| ACDOC_CR_DOC_CURR | TSLXX | CURR | 15(2) | Total transactions of the period in transaction currency | WERTV8 | FG | ||||||
| ACDOC_CR_LCL_CURR | HSLXX | CURR | 15(2) | Total transactions in the period in local currency (curr 2) | WERTV8 | FB | ||||||
| ACDOC_EXG_CODE | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| ACDOC_EXG_RATE | CHAR18 | CHAR | 18(0) | Field length 18 | CHAR18 | |||||||
| ACDOC_UNT_PRC | CHAR22 | CHAR | 22(0) | Text string 22 characters | CHAR22 | SAB4 | ||||||
| ACDOC_FLX_HDR | CHAR20 | CHAR | 20(0) | Char 20 | CHAR20 | SAP | ||||||
| ACDOC_FLX_ITM | CHAR20 | CHAR | 20(0) | Char 20 | CHAR20 | SAP | ||||||
| ACDOC_PYMT_MTHD | IDCN047 | CHAR | 20(0) | Settlement method | ||||||||
| ACDOC_ORIG_DOC | IDCN048 | CHAR | 20(0) | Bill type | ||||||||
| ACDOC_ORIG_NUM | IDCN049 | CHAR | 30(0) | Bill number | ||||||||
| ACDOC_ORIG_BUDAT | BUDAT | DATS | 8(0) | Posting Date in the Document | DATUM | FB | ||||||
| ACDOC_ATH_QTY | CHAR4 | CHAR | 4(0) | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | SAP | ||||||
| ACDOC_DOC_CTR | IDCN052 | CHAR | 20(0) | Voucher-making accountant | ||||||||
| ACDOC_DOC_RCV | IDCN053 | CHAR | 20(0) | Double check staff | ||||||||
| ACDOC_DOC_BK_KPR | IDCN054 | CHAR | 20(0) | Bookkeeper | ||||||||
| ACDOC_POSTED | IDCN056 | CHAR | 1(0) | 'Posted' sign | ||||||||
| ACDOC_CANCELLED | IDCN057 | CHAR | 1(0) | 'Reversed' sign | ||||||||
| ACDOC_SRC_APPL | CHAR20 | CHAR | 20(0) | Char 20 | CHAR20 | SAP | ||||||
| CASH_DOC_TYP | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| CASH_DOC_NUMBER | BELNR_D | CHAR | 10(0) | Accounting Document Number | BELNR | BLN | FB | |||||
| CASH_DOC_CURR_CODE | IDCN020 | CHAR | 14(0) | GL Account Currency Type | ||||||||
| CASH_DOC_STM_NUM | BUZEI | NUMC | 3(0) | Number of Line Item Within Accounting Document | BUZEI | BUZ | FB | |||||
| CASH_DOC_ABST | CHAR40 | CHAR | 40(0) | Character field of length 40 | CHAR40 | SDOC | ||||||
| CASH_DOC_ITM_CODE | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
| CASH_DOC_ITM_ATTR | CHAR20 | CHAR | 20(0) | Char 20 | CHAR20 | SAP | ||||||
| CASH_DOC_CURR | TSLXX | CURR | 15(2) | Total transactions of the period in transaction currency | WERTV8 | FG | ||||||
| CASH_DOC_LCL_CURR | HSLXX | CURR | 15(2) | Total transactions in the period in local currency (curr 2) | WERTV8 | FB | ||||||
| REP_CODE | IDCNREPNO | NUMC | 2(0) | Report Number | IDCNREPNO | |||||||
| REP_NAME | IDCN058 | CHAR | 20(0) | Report serial number | ||||||||
| REP_DATE | IDCN060 | CHAR | 8(0) | Reporting Date | ||||||||
| REP_PRD | CHAR6 | CHAR | 6(0) | Character field of length 6 | CHAR6 | SAP | ||||||
| REP_BUSS_ETY | IDCN059 | CHAR | 60(0) | Reporting company code | ||||||||
| REP_CURR_UT | IDCN061 | CHAR | 10(0) | Currency Scale | ||||||||
| REP_ITM_CODE | IDCNREPNO | NUMC | 2(0) | Report Number | IDCNREPNO | |||||||
| REP_ITM_CODE_ITEM | IDCN063 | CHAR | 20(0) | Report item ID | IDCNREPITEMID | |||||||
| REP_ITEM_DT_ELMT | IDCN062 | CHAR | 60(0) | Report item content | IDCNREPITEMCONT | |||||||
| REP_ITM_FRML | IDCNREPITEMFRML | CHAR | 200(0) | Report item formula | IDCNREPITEMFRML | |||||||
| REP_ITM_AMT | IDCN066 | DEC | 20(2) | Amount of this month | IDCNDEC20_2 | |||||||
| WAERS | WAERS | CUKY | 5(0) | Currency Key | WAERS | FWS | FB | |||||
| USER_FIELD_1 | USER_FIELD_1 | CHAR | 40(0) | First Field Entered by User | CHAR40 | |||||||
| USER_FIELD_2 | USER_FIELD_2 | CHAR | 40(0) | Second Field Entered by User | CHAR40 | |||||||
| USER_FIELD_3 | USER_FIELD_3 | CHAR | 40(0) | Third Field Entered by User | CHAR40 | |||||||
| USER_FIELD_4 | USER_FIELD_4 | CHAR | 40(0) | Fourth Field Entered by User | CHAR40 | |||||||
| USER_FIELD_A | USER_FIELD_A | CHAR | 40(0) | Field A Entered by User | CHAR40 | |||||||
| USER_FIELD_B | USER_FIELD_B | CHAR | 40(0) | Field B Entered by User | CHAR40 | |||||||
| USERFIELDNUM1 | USERFIELDNUM1 | CURR | 15(2) | Summarizable Field 1 To Be Filled by User | WERTV8 | |||||||
| USERFIELDNUM2 | USERFIELDNUM2 | CURR | 15(2) | Summarizable Field To Be Filled by User 2 | WERTV8 |