SAP ABAP Table FIDOCUMENT_RAW_DATA (Data from one FI Document as stored in the data base)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
FBAS (Package) Financial accounting 'Basis'
⤷
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | FIDOCUMENT_RAW_DATA |
|
| Short Description | Data from one FI Document as stored in the data base |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
BKPF | STRU | 0 | 0 | ||||
| 2 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | ||
| 3 | |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
| 4 | |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
| 5 | |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
| 6 | |
BLART | BLART | CHAR | 2 | 0 | Document type | ||
| 7 | |
BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
| 8 | |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
| 9 | |
MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
| 10 | |
CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
| 11 | |
CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
| 12 | |
AEDAT_BKPF | DATUM | DATS | 8 | 0 | Date of the Last Document Change by Transaction | ||
| 13 | |
UPDDT | DATUM | DATS | 8 | 0 | Date of the Last Document Update | ||
| 14 | |
WWERT_D | DATUM | DATS | 8 | 0 | Translation date | ||
| 15 | |
USNAM | XUBNAME | CHAR | 12 | 0 | User name | ||
| 16 | |
TCODE | TCODE | CHAR | 20 | 0 | Transaction Code | ||
| 17 | |
BVORG | BVORG | CHAR | 16 | 0 | Number of Cross-Company Code Posting Transaction | ||
| 18 | |
XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
| 19 | |
DBBLG | BELNR | CHAR | 10 | 0 | Recurring Entry Document Number | ||
| 20 | |
STBLG | BELNR | CHAR | 10 | 0 | Reverse Document Number | ||
| 21 | |
STJAH | GJAHR | NUMC | 4 | 0 | Reverse document fiscal year | ||
| 22 | |
BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
| 23 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
| 24 | |
KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
| 25 | |
KZWRS | WAERS | CUKY | 5 | 0 | Currency Key for the Group Currency | ||
| 26 | |
KZKRS | KURSF | DEC | 9 | 5 | Group Currency Exchange Rate | ||
| 27 | |
BSTAT_D | BSTAT | CHAR | 1 | 0 | Document Status | ||
| 28 | |
XNETB | XFELD | CHAR | 1 | 0 | Indicator: Document posted net ? | ||
| 29 | |
FRATH | WERT7 | CURR | 13 | 2 | Unplanned Delivery Costs | ||
| 30 | |
XRUEB | XFELD | CHAR | 1 | 0 | Indicator: Document is posted to a previous period | ||
| 31 | |
GLVOR | CHAR4 | CHAR | 4 | 0 | Business Transaction | ||
| 32 | |
GRPID_BKPF | CHAR12 | CHAR | 12 | 0 | Batch Input Session Name | ||
| 33 | |
DOKID_BKPF | CHAR40 | CHAR | 40 | 0 | Document Name in the Archive System | ||
| 34 | |
EXTID_BKPF | CHAR10 | CHAR | 10 | 0 | Extract ID Document Header | ||
| 35 | |
IBLAR | IBLAR | CHAR | 2 | 0 | Internal Document Type for Document Control | ||
| 36 | |
AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | ||
| 37 | |
AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
| 38 | |
FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | ||
| 39 | |
HWAER | WAERS | CUKY | 5 | 0 | Local Currency | ||
| 40 | |
HWAE2 | WAERS | CUKY | 5 | 0 | Currency Key of Second Local Currency | ||
| 41 | |
HWAE3 | WAERS | CUKY | 5 | 0 | Currency Key of Third Local Currency | ||
| 42 | |
KURS2 | KURSF | DEC | 9 | 5 | Exchange Rate for the Second Local Currency | ||
| 43 | |
KURS3 | KURSF | DEC | 9 | 5 | Exchange Rate for the Third Local Currency | ||
| 44 | |
CURSR | CURSR | CHAR | 1 | 0 | Source Currency for Currency Translation | ||
| 45 | |
CURSR | CURSR | CHAR | 1 | 0 | Source Currency for Currency Translation | ||
| 46 | |
UMRD2 | CURDT | CHAR | 1 | 0 | Translation Date Type for Second Local Currency | ||
| 47 | |
UMRD3 | CURDT | CHAR | 1 | 0 | Translation Date Type for Third Local Currency | ||
| 48 | |
XSTOV | XFELD | CHAR | 1 | 0 | Indicator: Document is flagged for reversal | ||
| 49 | |
STODT | DATUM | DATS | 8 | 0 | Planned Date for the Reverse Posting | ||
| 50 | |
XMWST | XFELD | CHAR | 1 | 0 | Calculate tax automatically | ||
| 51 | |
CURT2 | CURTP | CHAR | 2 | 0 | Currency Type of Second Local Currency | ||
| 52 | |
CURT3 | CURTP | CHAR | 2 | 0 | Currency Type of Third Local Currency | ||
| 53 | |
KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | ||
| 54 | |
KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | ||
| 55 | |
XSNET | XFELD | CHAR | 1 | 0 | G/L account amounts entered exclude tax | ||
| 56 | |
AUSBK | BUKRS | CHAR | 4 | 0 | Source Company Code | ||
| 57 | |
XUSVR_BKPF | XFELD | CHAR | 1 | 0 | Indicator: US taxes changed at detail level ? | ||
| 58 | |
DUEFL_BKPF | DUEFL_BKPF | CHAR | 1 | 0 | Status of Data Transfer into Subsequent Release | ||
| 59 | |
LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | ||
| 60 | |
TXKRS_BKPF | KURSF | DEC | 9 | 5 | Exchange Rate for Taxes | ||
| 61 | |
PSO_LOTKZ | LOTKZ | CHAR | 10 | 0 | Lot Number for Requests | ||
| 62 | |
XWVOF | XFELD | CHAR | 1 | 0 | Indicator: Customer bill of exchange payment before due date | ||
| 63 | |
STGRD | STGRD | CHAR | 2 | 0 | Reason for Reversal | ||
| 64 | |
PPNAM | XUBNAME | CHAR | 12 | 0 | Name of User Who Parked this Document | ||
| 65 | |
J_1ABRNCH | J_1BBRANCH | CHAR | 4 | 0 | Branch number | ||
| 66 | |
J_1ANOPG | J_1ANOPG | NUMC | 3 | 0 | Number of pages of invoice | ||
| 67 | |
J_1ADISC | ADISC | CHAR | 1 | 0 | Indicator: entry represents a discount document | ||
| 68 | |
XREF1_HD | CHAR20 | CHAR | 20 | 0 | Reference Key 1 Internal for Document Header | ||
| 69 | |
XREF2_HD | CHAR20 | CHAR | 20 | 0 | Reference Key 2 Internal for Document Header | ||
| 70 | |
XREVERSAL | XREVERSAL | CHAR | 1 | 0 | Specifies whether doc. is reversal doc. or reversed doc. | ||
| 71 | |
REINDAT | DATUM | DATS | 8 | 0 | Invoice Receipt Date | ||
| 72 | |
FAGL_RLDNR | RLDNR | CHAR | 2 | 0 | Ledger in General Ledger Accounting | ||
| 73 | |
FAGL_LDGRP | FAGL_LDGRP | CHAR | 4 | 0 | Ledger Group | ||
| 74 | |
RE_MANDAT | RE_MANDAT | CHAR | 13 | 0 | Real Estate Management Mandate | ||
| 75 | |
XBLNR_ALT | XBLNR_ALT | CHAR | 26 | 0 | Alternative Reference Number | ||
| 76 | |
VATDATE | DATUM | DATS | 8 | 0 | Tax Reporting Date | ||
| 77 | |
DOCUMENT_CATEGORY | DOCUMENT_CATEGORY | CHAR | 6 | 0 | Classification of an FI Document | ||
| 78 | |
SPLIT_POSTING | XFELD | CHAR | 1 | 0 | FI Document Originates from Split Posting (Indicator) | ||
| 79 | |
FAGL_CASH_ALLOC | BOOLE | CHAR | 1 | 0 | Cash-Relevant Document | ||
| 80 | |
FAGL_FOLLOW_ON | FAGL_FOLLOW_ON | CHAR | 1 | 0 | Follow-on document indicator | ||
| 81 | |
FAGL_R_XDOC_REORG | FLAG | CHAR | 1 | 0 | Doc. Contains Open Item that Was Transferred During Reorg. | ||
| 82 | |
ACC_SUBSET | ACC_SUBSET | CHAR | 4 | 0 | Defines subset of components for the FI/CO interface | ||
| 83 | |
KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | ||
| 84 | |
GLE_FXR_DTE_RATEX28 | GLE_FXR_RATEX28 | DEC | 28 | 14 | Market Data Exchange Rate | ||
| 85 | |
GLE_FXR_DTE_RATE2X28 | GLE_FXR_RATEX28 | DEC | 28 | 14 | Market Data Exchange Rate 2 | ||
| 86 | |
GLE_FXR_DTE_RATE3X28 | GLE_FXR_RATEX28 | DEC | 28 | 14 | Market Data Exchange Rate 3 | ||
| 87 | |
GLE_DTE_MCA_XMCA | XFELD | CHAR | 1 | 0 | Document Originates from Multi Currency Accounting | ||
| 88 | |
0 | 0 | F15 Append BKPF | |||||
| 89 | |
/SAPF15/STATUS | /SAPF15/STATUS | CHAR | 1 | 0 | Document Status | ||
| 90 | |
0 | 0 | IS-PS: BKPF Append Structure for Payment Requests | |||||
| 91 | |
0 | 0 | IS-PS: Include Structure BKPF Payment Request Doc.Header | |||||
| 92 | |
0 | 0 | IS-PS: Include for Append Parked Payment Request Doc.Header | |||||
| 93 | |
PSOTY_D | PSOTY | CHAR | 2 | 0 | Document category payment requests | ||
| 94 | |
PSOAK | PSOAK | CHAR | 10 | 0 | Reason | ||
| 95 | |
PSOKS | PSOKS | CHAR | 10 | 0 | Region | ||
| 96 | |
PSOSG | PSOSG | CHAR | 1 | 0 | Reason for reversal - IS-PS requests | ||
| 97 | |
PSOFN | CHAR30 | CHAR | 30 | 0 | IS-PS: File number | ||
| 98 | |
FM_INTFORM | CHAR4 | CHAR | 4 | 0 | Interest Formula | ||
| 99 | |
FM_INTDATE | DATUM | DATS | 8 | 0 | Interest Calc. Date | ||
| 100 | |
PSOBT | DATUM | DATS | 8 | 0 | Posting Day | ||
| 101 | |
PSOZL | XFELD | CHAR | 1 | 0 | Actual posting | ||
| 102 | |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 103 | |
PSOTM | UZEIT | TIMS | 6 | 0 | Last changed at | ||
| 104 | |
0 | 0 | IS-PS: Append Structure for Transfer Transaction FMITPO | |||||
| 105 | |
FM_UMART | FM_UMART | CHAR | 1 | 0 | Type of Payment Transfer | ||
| 106 | |
0 | 0 | Credit Card: Append for BKPF | |||||
| 107 | |
0 | 0 | Credit Card: Include for Appends for BKPF, VBKPF | |||||
| 108 | |
CCINS_30F | CCINS_30F | CHAR | 4 | 0 | Payment cards: Card type | ||
| 109 | |
CCNUM_30F | CCNUM_30F | CHAR | 25 | 0 | Payment cards: Card number | ||
| 110 | |
0 | 0 | Append structure for US federal government | |||||
| 111 | |
SSBLK | SSBLK | CHAR | 1 | 0 | Payment Statistical Sampling Block | ||
| 112 | |
LOTKZ | LOTKZ | CHAR | 10 | 0 | Lot Number for Documents | ||
| 113 | |
UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
| 114 | |
SAMPLED | SSBLK | CHAR | 1 | 0 | Sampled Invoice by Payment Certification | ||
| 115 | |
EXCLUDE_FLG | XFELD | CHAR | 1 | 0 | PPA Exclude Indicator | ||
| 116 | |
FM_BLIND | FM_BLIND | CHAR | 1 | 0 | Budgetary Ledger Indicator | ||
| 117 | |
FMFG_OFFSET_STATUS | FMFG_OFFSET_STATUS | CHAR | 2 | 0 | Treasury Offset Status | ||
| 118 | |
FMFG_REFERRED_OFFSET_DAT | DATUM | DATS | 8 | 0 | Date Record Referred to Treasury | ||
| 119 | |
PENRC | CHAR2 | CHAR | 2 | 0 | Reason for Late Payment | ||
| 120 | |
0 | 0 | Joint Venture fields | |||||
| 121 | |
KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
| 122 | |
BSEG_T | TTYP | 0 | 0 | ||||
| 123 | |
FAGL_T_BSEG_ADD | TTYP | 0 | 0 |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 606 |