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 | ||||||
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 | ||||||
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 |