top of page
BackGround_DarkMap.jpg

RUN SAP BETTER

SAP S/4 HANA Tables | ACDOCA Table

Tables

SAP Tables

Environment | Structural | Organizational

Table
Description
Type
Area
T-Code
Key Field1
Key Field 2
Key Field 3
Key Field 4
Add Field
Explanation
SKA1
G/L Account Master (Chart of Accounts)
Master Data
Accounting
FS00
SAKNR
KTOPL
SKAT
G/L Account Master Record (Chart of Accounts: Description)
Master Data
Accounting
FS00
SAKNR
KTOPL
SPRAS
SKB1
G/L account master (company code)
Master Data
Accounting
FS00
SAKNR
BUKRS
ACDOCA
Universal Journal Entry Line Items
Transactional
Accounting
FB01
BELNR
RBUKRS
GJAHR
RLDNR
S/4 HANA Universal Journal (Single Source of Truth). All Financial and Management Accounting Postings
ACDOCP
Plan Data Line Items
Transactional
Accounting
REQTSN
DATAPAKID
RECORD
RACCT
S/4 HANA Universal Journal for Plan Data Line Items
BKPF
Accounting Document Header
Transactional
Accounting
FB01
BELNR
BUKRS
GJAHR
BSEG
Accounting Document Segment
Transactional
Accounting
FB01
BELNR
BUKRS
GJAHR
REGUS
Accounts blocked by Payment proposal
Transactional
Accounts Payable
F110
BUKRS
KOART
LAUFI
LAUFD
Find payment proposals that are blocking payment runs
CSKS
Cost Center Master Record
Master Data
Cost Center
KS01
KOSTL
KOKRS
DATBI
CSKT
Cost Center Texts
Master Data
Cost Center
KS01
KOSTL
KOKRS
DATBI
SPRAS
COBK
CO Object: Document Header
Transactional
Cost Center
COEP
CO Object: Line Items (by Period)
Transactional
Cost Center
COSP
CO Object: Cost Totals for External Postings ("COSP")
Transactional
Cost Center
CSKA
Cost Elements (Data Dependent on Chart of Accounts)
Master Data
Cost Element
FS00 / KA01
KSTAR
KTOPL
CSKB
Cost Elements (Data Dependent on Controlling Area)
Master Data
Cost Element
FS00 / KA01
KSTAR
KOKRS
DATBI
CSKU
Cost Element Texts
Master Data
Cost Element
FS00 / KA01
KSTAR
KTOPL
SPRAS
KNA1
General Data in Customer Master
Master Data
Customer
BP / XD01
KUNNR
KNB1
Customer Master (Company Code)
Master Data
Customer
BP / XD01
KUNNR
BUKRS
KNB4
Customer Payment History
Master Data
Customer
BP / XD01
KUNNR
BUKRS
KNB5
Customer master (dunning data)
Master Data
Customer
BP / XD01
KUNNR
BUKRS
MABER
KNBW
Customer master record (withholding tax types) X
Master Data
Customer
BP / XD01
KUNNR
BUKRS
WITHT
KNVD
Customer master record sales request form
Master Data
Customer
KUNNR
VKORG
VTWEG
SPART
KNVP
Customer Master Partner Functions
Master Data
Customer
KUNNR
VKORG
VTWEG
SPART
KNVV
Customer Master Sales Data
Master Data
Customer
KUNNR
VKORG
VTWEG
SPART
MAKT
Material Descriptions
Master Data
Material
MM01
MATNR
SPRAS
MARA
General Material Data
Master Data
Material
MM01
MATNR
MARC
Plant Data for Material
Master Data
Material
MATNR
WERKS
MARM
Units of Measure for Material
Master Data
Material
MATNR
MEINH
MBEW
Material Valuation
Master Data
Material
MATNR
BWKEY
BWTAR
MLAN
Tax Classification for Material
Master Data
Material
MATNR
ALAND
MVKE
Sales Data for Material
Master Data
Material
MATNR
VKORG
VTWEG
PRODH
T179
Materials: Product Hierarchies
Master Data
Material
PRODH
T001
Company Codes
Customizing
Organizational
OBY6
BUKRS
T001W
Plants/Branches
Customizing
Organizational
WERKS
T002
Language Keys
Customizing
Organizational
SPRAS
T003
Document Types
Customizing
Organizational
BLART
T004
Directory of Charts of Accounts
Customizing
Organizational
KTOPL
T005
Countries
Customizing
Organizational
LAND1
T006
Units of Measurement
Customizing
Organizational
MSEHI
T008
Blocking Reasons for Automatic Payment Transcations
Customizing
Organizational
ZAHLS
T009
Fiscal Year Variants
Customizing
Organizational
PERIV
T011
Financial Statement Versions
Customizing
Organizational
VERSN
T012
House Banks
Customizing
Organizational
HBKID
BUKRS
T014
Credit control areas
Customizing
Organizational
KKBER
T016
Industries (Branch)
Customizing
Organizational
BRSCH
T030
Standard Accounts Table
Customizing
Organizational
OBYC
KTOPL
KTOSL
BKLAS
KOMOK
KONTS
Check the transaction OBYC (Automatic Accounting Posts - Procedures | Account Determination)
T030H
Acct Determ.for Open Item Exch.Rate Differences
Customizing
Organizational
OBA1
HKONT
KTOPL
WAERS
CURTP
Use to check the Account Determination for Open Item Exchange Rate Differences Account | This is used in FAGL_FCV (Foreign Currency Valuation)
PROJ
Project definition
Master Data
PS
PSPNR
PRPS
WBS (Work Breakdown Structure) Element Master Data
Master Data
PS
PSPNR
CEPC
Profit Center Master Data Table
Master Data
Profit Center
KE51
PRCTR
KOKRS
DATBI
CEPCT
Texts for Profit Center Master Data
Master Data
Profit Center
KE51
PRCTR
KOKRS
DATBI
SPRAS
T000
Clients
Customizing
System
SCC1
MANDT
DD03L
Table Fields
System
System
SE16H
FIELDNAME
You can check which tables a specific field is in
PRGN_CORR2
Correction Table for Modif. Transaction Codes in Area Menu
System
System
T_TCODE
S_TCODE
REL_NAME
You can check the old transaction that was replaced by new ones
TSTC
SAP Transactional Codes
System
System
SE93
TCODE
LFA1
Supplier Master (General Section)
Master Data
Vendor
BP / XK01
LIFNR
LFB1
Vendor Master (Company Code)
Master Data
Vendor
BP / XK01
LIFNR
BUKRS
LFB5
Vendor master (dunning data)
Master Data
Vendor
BP / XK01
LIFNR
BUKRS
MABER
LFBK
Vendor Master (Bank Details)
Master Data
Vendor
BP / XK01
LIFNR
BANKS
BANKL
BANKN
LFBW
Vendor master record (withholding tax types) X
Master Data
Vendor
BP / XK01
LIFNR
BUKRS
WITHT
LFM1
Vendor master record purchasing organization data
Master Data
Vendor
BP / XK01
LIFNR
EKORG
LFM2
Vendor Master Record: Purchasing Data
Master Data
Vendor
BP / XK01
LIFNR
EKORG
LTSNR
WERKS
ACDOCA

SAP S/4 HANA ACDOCA and Elements

Field
Data Element
Short Description
Check Table
Domain
Data Type
Length
Decimal Places
Search Help
Origin of Input Help
RCLNT
MANDT
Client
T000
MANDT
CLNT
3
0
H_T000
Input help implemented with check table
RLDNR
FINS_LEDGER
Ledger in General Ledger Accounting
FINSC_LEDGER
FINS_LEDGER
CHAR
2
0
Input help implemented with check table
RBUKRS
BUKRS
Company Code
T001
BUKRS
CHAR
4
0
C_T001
Input help implemented with check table
GJAHR
GJAHR
Fiscal Year
GJAHR
NUMC
4
0
BELNR
BELNR_D
Accounting Document Number
BELNR
CHAR
10
0
DOCLN
DOCLN6
Six-Character Posting Item for Ledger
DOCLN6
CHAR
6
0
RYEAR
GJAHR_POS
General Ledger Fiscal Year
GJAHR
NUMC
4
0
DOCNR_LD
FINS_DOCNR_LD
Ledger specific Accounting Document Number
BELNR
CHAR
10
0
RRCTY
RRCTY
Record Type
RRCTY
CHAR
1
0
Input help with fixed values
.INCLUDE
ACDOC_SI_00
Universal Journal Entry: Transaction, Currencies, Units
STRU
0
0
RMVCT
RMVCT
Transaction type
T856
RMVCT
CHAR
3
0
H_T856
Input help implemented with check table
VORGN
VORGN
Transaction Type for General Ledger
VORGN
CHAR
4
0
VRGNG
CO_VORGANG
CO Business Transaction
TJ01
J_VORGANG
CHAR
4
0
H_TJ01
Input help implemented with check table
BTTYPE
FINS_BTTYPE
Business Transaction Type
FINSC_BTTYPE
FINS_BTTYPE
CHAR
4
0
Input help implemented with check table
AWTYP
AWTYP
Reference procedure
TTYP
AWTYP
CHAR
5
0
Input help implemented with check table
AWSYS
AWSYS
Logical system of source document
TBDLS
LOGSYS
CHAR
10
0
Input help implemented with check table
AWORG
AWORG
Reference Organizational Units
AWORG
CHAR
10
0
AWREF
AWREF
Reference document number
AWREF
CHAR
10
0
AWITEM
FINS_AWITEM
Reference Document Line Item
NUMC6
NUMC
6
0
AWITGRP
FINS_AWITGRP
Group of Reference Document Line Items
NUMC6
NUMC
6
0
SUBTA
FINS_SUBTA
Partial Document to be balanced to zero
NUMC6
NUMC
6
0
XREVERSING
FINS_XREVERSING
Indicator: Item is reversing another item
XFELD
CHAR
1
0
Input help with fixed values
XREVERSED
FINS_XREVERSED
Indicator: Item is reversed
XFELD
CHAR
1
0
Input help with fixed values
XTRUEREV
FINS_XTRUEREV
Indicator: True reversal (i.e. cancellation)
XFELD
CHAR
1
0
Input help with fixed values
AWTYP_REV
AWTYP_REV
Reversal: Reference Transaction of Document to Be Reversed
TTYP
AWTYP
CHAR
5
0
Input help implemented with check table
AWORG_REV
AWORG_REV
Reversal: Reference Organizations of Document to Be Reversed
AWORG
CHAR
10
0
AWREF_REV
AWREF_REV
Reversal: Reference Document No. of Document to Be Reversed
AWREF
CHAR
10
0
SUBTA_REV
FINS_SUBTA_REV
Reversal: Partial Document to be balanced to zero
NUMC6
NUMC
6
0
XSETTLING
FINS_XSETTLING
Indicator: Item is settling or transferring another item
XFELD
CHAR
1
0
Input help with fixed values
XSETTLED
FINS_XSETTLED
Indicator: Line item is settled or transferred
XFELD
CHAR
1
0
Input help with fixed values
PREC_AWTYP
FINS_PREC_AWTYP
Preceding Document Reference Transaction
TTYP
AWTYP
CHAR
5
0
Input help implemented with check table
PREC_AWSYS
FINS_PREC_AWSYS
Logical System of Preceding Reference Document
TBDLS
LOGSYS
CHAR
10
0
Input help implemented with check table
PREC_AWORG
FINS_PREC_AWORG
Preceding Document Reference Organizational Units
AWORG
CHAR
10
0
PREC_AWREF
FINS_PREC_AWREF
Preceding Document Reference Document Number
AWREF
CHAR
10
0
PREC_AWITEM
FINS_PREC_AWITEM
Preceding Reference Document Line Item
NUMC6
NUMC
6
0
PREC_SUBTA
FINS_PREC_SUBTA
Preceding Partial Document to be balanced to zero
NUMC6
NUMC
6
0
PREC_AWMULT
FINS_PREC_AWMULT_UUID
ID of multiple Preceding Document References
SYSUUID
RAW
16
0
XSECONDARY
FINS_SECONDARY_ENTRY
Secondary journal entry
BOOLE
CHAR
1
0
Input help with fixed values
SRC_AWTYP
FINS_SRC_AWTYP
Source Document Reference Transaction
TTYP
AWTYP
CHAR
5
0
Input help implemented with check table
SRC_AWSYS
FINS_SRC_AWSYS
Logical System of Source Reference Document
TBDLS
LOGSYS
CHAR
10
0
Input help implemented with check table
SRC_AWORG
FINS_SRC_AWORG
Source Document Reference Organizational Units
AWORG
CHAR
10
0
SRC_AWREF
FINS_SRC_AWREF
Source Document Reference Document Number
AWREF
CHAR
10
0
SRC_AWITEM
FINS_SRC_AWITEM
Source Reference Document Line Item
NUMC6
NUMC
6
0
SRC_AWSUBIT
FINS_SRC_AWSUBIT
Source Reference Document Sub-Item
NUMC6
NUMC
6
0
XCOMMITMENT
FINS_XCOMMITMENT
Indicator: Commitment
XFELD
CHAR
1
0
Input help with fixed values
OBS_REASON
FINS_OBSOLETE_ITEM_REASON
Reason why this item is obsolete
FINS_OBSOLETE_ITEM_REASON
CHAR
1
0
Input help with fixed values
.INCLUDE
ACDOC_SI_CURRKEYS
Universal Journal Entry: Currency Keys
STRU
0
0
RTCUR
FINS_CURRT
Balance Transaction Currency
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RWCUR
FINS_CURRW
Transaction Currency
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RHCUR
FINS_CURRH
Company Code Currency
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RKCUR
FINS_CURRK
Global Currency
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
ROCUR
FINS_CURR1
Freely Defined Currency 1
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RVCUR
FINS_CURR2
Freely Defined Currency 2
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RBCUR
FINS_CURR3
Freely Defined Currency 3
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RCCUR
FINS_CURR4
Freely Defined Currency 4
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RDCUR
FINS_CURR5
Freely Defined Currency 5
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RECUR
FINS_CURR6
Freely Defined Currency 6
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RFCUR
FINS_CURR7
Freely Defined Currency 7
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RGCUR
FINS_CURR8
Freely Defined Currency 8
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
RCO_OCUR
FINS_CO_OCUR
CO Object Currency
TCURC
WAERS
CUKY
5
0
Input help implemented with check table
.INCLUDE
ACDOC_SI_UNIT_OF_MEASURES
Universal Journal Entry: Unit of Measures
STRU
0
0
RUNIT
MEINS
Base Unit of Measure
T006
MEINS
UNIT
3
0
H_T006
Input help implemented with check table
RVUNIT
RVUNIT
Unit of Measure for Valuation Quantity
T006
MEINS
UNIT
3
0
H_T006
Input help implemented with check table
RRUNIT
RRUNIT
Unit of Measure for Reference Quantity
T006
MEINS
UNIT
3
0
H_T006
Input help implemented with check table
RIUNIT
FINS_RIUNIT
Unit of Measure for Inventory Quantity
T006
MEINS
UNIT
3
0
H_T006
Input help implemented with check table
QUNIT1
FCO_QUNIT1
Additional Unit of Measure 1
T006
MEINS
UNIT
3
0
H_T006
Input help implemented with check table
QUNIT2
FCO_QUNIT2
Additional Unit of Measure 2
T006
MEINS
UNIT
3
0
H_T006
Input help implemented with check table
QUNIT3
FCO_QUNIT3
Additional Unit of Measure 3
T006
MEINS
UNIT
3
0
H_T006
Input help implemented with check table
CO_MEINH
FCO_MEINH
Unit of Measure for CO Valuation Quantity
MEINS
UNIT
3
0
RACCT
RACCT
Account Number
SKB1
SAKNR
CHAR
10
0
SAKO
Input help implemented with check table
.INCLUDE
ACDOC_SI_GL_ACCAS
Universal Journal Entry: G/L additional account assignments
STRU
0
0
RCNTR
KOSTL
Cost Center
CSKS
KOSTL
CHAR
10
0
Input help implemented with check table
PRCTR
PRCTR
Profit Center
CEPC
PRCTR
CHAR
10
0
Input help implemented with check table
RFAREA
FKBER
Functional Area
TFKB
FKBER
CHAR
16
0
Input help implemented with check table
RBUSA
GSBER
Business Area
TGSB
GSBER
CHAR
4
0
H_TGSB
Input help implemented with check table
KOKRS
KOKRS
Controlling Area
TKA01
CACCD
CHAR
4
0
CSH_TKA01
Input help implemented with check table
SEGMENT
FB_SEGMENT
Segment for Segmental Reporting
FAGL_SEGM
FB_SEGMENT
CHAR
10
0
Input help implemented with check table
SCNTR
SKOST
Sender cost center
CSKS
KOSTL
CHAR
10
0
Input help implemented with check table
PPRCTR
PPRCTR
Partner Profit Center
CEPC
PRCTR
CHAR
10
0
Input help implemented with check table
SFAREA
SFKBER
Partner Functional Area
TFKB
FKBER
CHAR
16
0
Input help implemented with check table
SBUSA
PARGB
Trading partner's business area
TGSB
GSBER
CHAR
4
0
H_TGSB
Input help implemented with check table
RASSC
RASSC
Company ID of Trading Partner
T880
RCOMP
CHAR
6
0
CSHDP_T880
Input help implemented with check table
PSEGMENT
FB_PSEGMENT
Partner Segment for Segmental Reporting
FAGL_SEGM
FB_SEGMENT
CHAR
10
0
Input help implemented with check table
.INCLUDE
ACDOC_SI_VALUE_DATA
Universal Journal Entry: Value Fields
STRU
0
0
.INCLUDE
ACDOC_SI_VALUE_DATA_FLOW
Universal Journal Entry: Non-cumulative Value Fields
STRU
0
0
TSL
FINS_VTCUR12
Amount in Balance Transaction Currency
WERTV12
CURR
23
2
WSL
FINS_VWCUR12
Amount in Transaction Currency
WERTV12
CURR
23
2
WSL2
FINS_VWCUR12_2
Group Valuation Amount in Transaction Currency
WERTV12
CURR
23
2
WSL3
FINS_VWCUR12_3
Profit-Center Valuation Amount in Transaction Currency
WERTV12
CURR
23
2
HSL
FINS_VHCUR12
Amount in Company Code Currency
WERTV12
CURR
23
2
KSL
FINS_VKCUR12
Amount in Global Currency
WERTV12
CURR
23
2
OSL
FINS_VOCUR12
Amount in Freely Defined Currency 1
WERTV12
CURR
23
2
VSL
FINS_VVCUR12
Amount in Freely Defined Currency 2
WERTV12
CURR
23
2
BSL
FINS_VBCUR12
Amount in Freely Defined Currency 3
WERTV12
CURR
23
2
CSL
FINS_VCCUR12
Amount in Freely Defined Currency 4
WERTV12
CURR
23
2
DSL
FINS_VDCUR12
Amount in Freely Defined Currency 5
WERTV12
CURR
23
2
ESL
FINS_VECUR12
Amount in Freely Defined Currency 6
WERTV12
CURR
23
2
FSL
FINS_VFCUR12
Amount in Freely Defined Currency 7
WERTV12
CURR
23
2
GSL
FINS_VGCUR12
Amount in Freely Defined Currency 8
WERTV12
CURR
23
2
KFSL
FINS_VGCUR12_FIX
Fixed Amount in Global Currency
WERTV12
CURR
23
2
KFSL2
FINS_VGCUR12_FIX2
Group Valuation Fixed Amount in Global Currency
WERTV12
CURR
23
2
KFSL3
FINS_VGCUR12_FIX3
PrCtr Valuation Fixed Amount in Global Currency
WERTV12
CURR
23
2
PSL
FINS_VPCUR12
Total Price Variance in Global Currency
WERTV12
CURR
23
2
PSL2
FINS_VPCUR12_2
Group Valuation Total Price Variance in Global Currency
WERTV12
CURR
23
2
PSL3
FINS_VPCUR12_3
PrCtr Valuation Total Price Variance in Global Currency
WERTV12
CURR
23
2
PFSL
FINS_VPFCUR12
Fixed Price Variance in Global Currency
WERTV12
CURR
23
2
PFSL2
FINS_VPFCUR12_2
Group Valuation Fixed Price Variance in Global Currency
WERTV12
CURR
23
2
PFSL3
FINS_VPFCUR12_3
PrCtr Valuation Fixed Price Variance in Global Currency
WERTV12
CURR
23
2
CO_OSL
FINS_VCO_OCUR12
Amount in CO Object Currency
WERTV12
CURR
23
2
HSLALT
MLHSLALT
Alternative Value in Local Currency
WERTV12
CURR
23
2
KSLALT
MLKSLALT
Alternative Value in Group Currency
WERTV12
CURR
23
2
OSLALT
MLOSLALT
Alternative Value in Freely Defined Currency 1
WERTV12
CURR
23
2
VSLALT
ML4SLALT
Alternative Value in Freely Defined Currency 2
WERTV12
CURR
23
2
BSLALT
MLBSLALT
Alternative Value in Freely Defined Currency 3
WERTV12
CURR
23
2
CSLALT
MLCSLALT
Alternative Value in Freely Defined Currency 4
WERTV12
CURR
23
2
DSLALT
MLDSLALT
Alternative Value in Freely Defined Currency 5
WERTV12
CURR
23
2
ESLALT
MLESLALT
Alternative Value in Freely Defined Currency 6
WERTV12
CURR
23
2
FSLALT
MLFSLALT
Alternative Value in Freely Defined Currency 7
WERTV12
CURR
23
2
GSLALT
MLGSLALT
Alternative Value in Freely Defined Currency 8
WERTV12
CURR
23
2
HSLEXT
MLHSLEXT
External Value in Local Currency
WERTV12
CURR
23
2
KSLEXT
MLKSLEXT
External Value in Group Currency
WERTV12
CURR
23
2
OSLEXT
MLOSLEXT
External Value in Freely Defined Currency 1
WERTV12
CURR
23
2
VSLEXT
ML4SLEXT
External Value in Freely Defined Currency 2
WERTV12
CURR
23
2
BSLEXT
MLBSLEXT
External Value in Freely Defined Currency 3
WERTV12
CURR
23
2
CSLEXT
MLCSLEXT
External Value in Freely Defined Currency 4
WERTV12
CURR
23
2
DSLEXT
MLDSLEXT
External Value in Freely Defined Currency 5
WERTV12
CURR
23
2
ESLEXT
MLESLEXT
External Value in Freely Defined Currency 6
WERTV12
CURR
23
2
FSLEXT
MLFSLEXT
External Value in Freely Defined Currency 7
WERTV12
CURR
23
2
GSLEXT
MLGSLEXT
External Value in Freely Defined Currency 8
WERTV12
CURR
23
2
HVKWRT
MLHVKWRT
Value at Sales Price in Local Currency
WERTV12
CURR
23
2
MSL
QUAN1_12
Quantity
MENGV12
QUAN
23
3
MFSL
QUAN1_12_FIX
Fixed quantity
MENGV12
QUAN
23
3
VMSL
VQUAN1_12
Valuation quantity
MENGV12
QUAN
23
3
VMFSL
VQUAN1_12_FIX
Fixed valuation quantity
MENGV12
QUAN
23
3
RMSL
RQUAN1_12
Reference quantity
MENGV12
QUAN
23
3
QUANT1
FCO_QUAN1_L
Additional Quantity 1
MENGV12
QUAN
23
3
QUANT2
FCO_QUAN2_L
Additional Quantity 2
MENGV12
QUAN
23
3
QUANT3
FCO_QUAN3_L
Additional Quantity 3
MENGV12
QUAN
23
3
CO_MEGBTR
FCO_MEGBTR
CO Valuation Quantity
MENGV12
QUAN
23
3
CO_MEFBTR
FCO_MEFBTR
CO Valuation Quantity Fix
MENGV12
QUAN
23
3
.INCLUDE
ACDOC_SI_VALUE_DATA_BALANCE
Universal Journal Entry: Cumulative Value Fields
STRU
0
0
HSALK3
MLHSALK3
Inventory Value in Local Currency
WERTV12
CURR
23
2
KSALK3
MLKSALK3
Inventory Value in Group Currency
WERTV12
CURR
23
2
OSALK3
MLOSALK3
Inventory Value in Freely Defined Currency 1
WERTV12
CURR
23
2
VSALK3
ML4SALK3
Inventory Value in Freely Defined Currency 2
WERTV12
CURR
23
2
HSALKV
MLHSALKV
Alternative Inventory Value in Local Currency
WERTV12
CURR
23
2
KSALKV
MLKSALKV
Alternative Inventory Value in Group Currency
WERTV12
CURR
23
2
OSALKV
MLOSALKV
Alternative Inventory Value in Freely Defined Currency 1
WERTV12
CURR
23
2
VSALKV
ML4SALKV
Alternative Inventory Value in Freely Defined Currency 2
WERTV12
CURR
23
2
HPVPRS
MLHPVPRS
Moving Average Price in Local Currency
WERTV12
CURR
23
2
KPVPRS
MLKPVPRS
Moving Average Price in Group Currency
WERTV12
CURR
23
2
OPVPRS
MLOPVPRS
Moving Average Price in Another Currency
WERTV12
CURR
23
2
VPVPRS
ML4PVPRS
Moving Average Price in Fourth Currency
WERTV12
CURR
23
2
HSTPRS
MLHSTPRS
Standard Price in Local Currency
WERTV12
CURR
23
2
KSTPRS
MLKSTPRS
Standard Price in Group Currency
WERTV12
CURR
23
2
OSTPRS
MLOSTPRS
Standard Price in Another Currency
WERTV12
CURR
23
2
VSTPRS
ML4STPRS
Standard Price in Fourth Currency
WERTV12
CURR
23
2
HVKSAL
MLHVKSAL
Inventory Value at Sales Price in Local Currency
WERTV12
CURR
23
2
LBKUM
MLLBKUM
Inventory Quantity
MENGV12
QUAN
23
3
.INCLUDE
ACDOC_SI_FIX
Universal Journal Entry: Mandatory fields for G/L
STRU
0
0
DRCRK
SHKZG
Debit/Credit Indicator
SHKZG
CHAR
1
0
Input help with fixed values
POPER
POPER
Posting Period
POPER
NUMC
3
0
PERIV
PERIV
Fiscal Year Variant
T009
PERIV
CHAR
2
0
Input help implemented with check table
FISCYEARPER
JAHRPER
Period/Year
JAHRPER
NUMC
7
0
BUDAT
BUDAT
Posting Date in the Document
DATUM
DATS
8
0
Input help based on data type
BLDAT
BLDAT
Document Date in Document
DATUM
DATS
8
0
Input help based on data type
BLART
BLART
Document Type
T003
BLART
CHAR
2
0
CSH_T003
Input help implemented with check table
BUZEI
BUZEI
Number of Line Item Within Accounting Document
BUZEI
NUMC
3
0
ZUONR
DZUONR
Assignment number
ZUONR
CHAR
18
0
BSCHL
BSCHL
Posting Key
TBSL
BSCHL
CHAR
2
0
H_TBSL
Input help implemented with check table
BSTAT
BSTAT_D
Document Status
BSTAT
CHAR
1
0
Input help with fixed values
LINETYPE
LINETYPE
Item Category
T8G02
LINETYPE
CHAR
5
0
Input help implemented with check table
KTOSL
KTOSL
Transaction Key
CHAR3
CHAR
3
0
SLALITTYPE
SLALITTYPE
Subledger-Specific Line Item Type
FINSTS_SLALITTY
SLALITTYPE
NUMC
5
0
Input help implemented with check table
XSPLITMOD
XSPLITMOD
Item Changed by Document Splitting
XFELD
CHAR
1
0
Input help with fixed values
USNAM
USNAM
User Name
XUBNAME
CHAR
12
0
TIMESTAMP
TIMESTAMP
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
TZNTSTMPS
DEC
15
0
EPRCTR
EPRCTR
Partner profit center for elimination of internal business
CEPC
PRCTR
CHAR
10
0
Input help implemented with check table
RHOART
HOART
Type of origin object (EC-PCA)
HOART
NUMC
2
0
Input help with fixed values
GLACCOUNT_TYPE
GLACCOUNT_TYPE
Type of a General Ledger Account
GLACCOUNT_TYPE
CHAR
1
0
Input help with fixed values
KTOPL
KTOPL
Chart of Accounts
T004
KTOPL
CHAR
4
0
H_T004
Input help implemented with check table
LOKKT
ALTKT_SKB1
Alternative Account Number in Company Code
SKA1
SAKNR
CHAR
10
0
SAKO
Input help implemented with check table
KTOP2
KTOP2
Chart of Accounts According to Country Legislation
T004
KTOPL
CHAR
4
0
H_T004
Input help implemented with check table
.INCLUDE
ACDOC_SI_GEN
Universal Journal Entry: Fields for several subledgers
STRU
0
0
REBZG
REBZG
Document No. of the Invoice to Which the Transaction Belongs
BELNR
CHAR
10
0
REBZJ
REBZJ
Fiscal Year of the Relevant Invoice (for Credit Memo)
GJAHR
NUMC
4
0
REBZZ
REBZZ
Line Item in the Relevant Invoice
BUZEI
NUMC
3
0
REBZT
REBZT
Follow-On Document Type
REBZT
CHAR
1
0
RBEST
CO_RBEST
Category of Reference Purchase Order
BELEGTYP
NUMC
3
0
Input help with fixed values
EBELN
EBELN
Purchasing Document Number
EKKO
EBELN
CHAR
10
0
Input help implemented with check table
EBELP
EBELP
Item Number of Purchasing Document
EKPO
EBELP
NUMC
5
0
Input help implemented with check table
ZEKKN
DZEKKN
Sequential Number of Account Assignment
NUM02
NUMC
2
0
SGTXT
SGTXT
Item Text
TEXT50
CHAR
50
0
KDAUF
KDAUF
Sales Order Number
VBELN
CHAR
10
0
COBL_EX_VMVA
Explicit search help interface to field
KDPOS
KDPOS
Item number in Sales Order
NUM06
NUMC
6
0
COBL_EX_VMPC2
Explicit search help interface to field
MATNR
MATNR
Material Number
MARA
MATNR
CHAR
40
0
MAT1
Input help implemented with check table
WERKS
WERKS_D
Plant
T001W
WERKS
CHAR
4
0
H_T001W
Input help implemented with check table
LIFNR
LIFNR
Account Number of Supplier
LFA1
LIFNR
CHAR
10
0
KRED
Input help implemented with check table
KUNNR
KUNNR
Customer Number
KNA1
KUNNR
CHAR
10
0
DEBI
Input help implemented with check table
FBUDA
FBUDA
Date on which services are rendered
DATUM
DATS
8
0
Input help based on data type
Reference Transaction
Object Type Name
Structure
Remote
Function
/OPT/
Accounting document
ABR
FS-RI Sett. Document
ACE
Accrual Engine
ACEPS_AWKY
ACEPS_DOCUMENT_SENDER
ACES4
Accrual Engine
BKPF_AWOBJ
FI_DOCUMENT_SENDER
AFRU
Reporting document
COBK_AWOBJ
AC_DOCUMENT_AFRU_DISPLAY
AIBU
Assts und.const.set.
BKPF_AWOBJ
AMFI_SHOW_AM_DOCUMENT
AMBU
Asset Transaction
BKPF_AWOBJ
AMFI_SHOW_AM_DOCUMENT
AMDP
Depreciation posting
BKPF_AWOBJ
AC_DOCUMENT_RECORD
ANLA
Asset Transaction
AS91
FIAA old assets data
AUAK
Settlement document
K_SETTLEMENT_DOC_DISPLAY
AXBTA
Bus. Travel Account
BCAEB
Acc.Mgt Single Doc.
BCASU
Acc.Mgt Totals Doc.
BEBD
RE Billing Document
AC_DOCUMENT_SENDER_BEBD
BERD
Settlement document
AC_DOCUMENT_SENDER_CRM_REBATES
BERE
Transaction Data
AC_DOCUMENT_SENDER_CRM_REBATES
BKKEB
BCA individual doc.
BKK_DOCUMENT_SENDER_SU
BKKPR
Pmnt order from BCA
BKK_AWOBPR
BKKSU
BCA totals document
BKK_DOCUMENT_SENDER_SU
BKPF
Accounting document
BKPF_AWOBJ
FI_DOCUMENT_SENDER
BKPFE
Acctg doc.ECS
BKPF_AWOBJ
GLE_ECS_ITEM_SENDER
BKPFF
Actg doc.direct inpt
BKPF_AWOBJ
FI_DOCUMENT_SENDER
BKPFI
Acctg doc.f.initial.
BKPF_AWOBJ
ISH_ERP_FI_SD_VBRK_DISPLAY
BKPFM
Substitute Document
BKPF_AWOBJ
X
FDM_COLL_DOCUMENT_SENDER
BKPFO
Actg Doc.Direct Inpt
BKPF_AWOBJ
FI_DOCUMENT_SENDER
BKPFR
Reorg. Transfer
BKPF_AWOBJ
FAGL_R_DOCUMENT_SENDER
BKPWF
BKPF_AWOBJ
FAGL_R_DOCUMENT_SENDER
CACS
Commission Settlemt
ACCHD_AWOR
CACS_TRANSFER_DISPLAY_DOC
CAJO
Cash journal doc.
FCJ_DISPLAY_DOCUMENT_IN_CAJO
CATS
Document from CATS
COBK_AWOBJ
AC_CATS_DISPLAY_DOCUMENT
CF3P
CIAP
CMPEV
MEV_AC_DOCUMENT_SENDER
COBK
Controlling Document
COBK_AWOBJ
K_DOCUMENT_SENDER
COFIS
Reconcil. ledger
K_RCL_DOCUMENT_SENDER
COPA
Profitab. Analysis
COPCA
Profit center doc.
CRMCS
Claim Subm. Posting
X
CRMFM
Funds Posting
X
AC_DOCUMENT_SENDER_CRMFM
CRP
CRP Document
DBMCD
DBM Cash Desk
/DBM/CD_DOCUMENT_SENDER
DBMDP
DBM Down Payment
/DBM/DP_DOCUMENT_SENDER
DBMIB
DBM Int. Billing Doc
/DBM/IB_DOCUMENT_SENDER
DBMSO
DBM Workshop Order
/DBM/CO_UI_ORDER_SENDER
DBMTR
DBM Time Recording
/DBM/TR_DOCUMENT_SENDER
DBMVM
DBM Vehicle Mgmt.
/DBM/VM_DOCUMENT_SENDER
DELI
DIDPC
Down Payment Chains
/SAPPCE/KY
/SAPPCE/DPC_AC_DOCUMENT_DISP
DIPNV
Constr. Prog. Report
COBK_AWOBJ
/SAPPCE/PNV_AC_DOCUMENT_DISP
EACC
Accounting Engine
CON_FIN_AC_DOCUMENT_SENDER
EBKPF
External accounting
EBKPFAWOBJ
ECCS
Consolidation
ENTD
Deposit Refund Prog.
AC_DOCUMENT_SENDER_BEBD
EXTX
Excise Tax
BKPF-AWOBJ
X
FI_DOCUMENT_SENDER
FARA
FARR_ACCR_NAVIGATION
FARR
Rev. Recognition
FARR_ACCR_NAVIGATION
FCO
Failure Cost Proc.
FCO_DOCUMENT_DISPLAY
FCVS
FDIS
Cash Management
FEBEP
Acct statement item
FEBEPAWOBJ
DISPLAY_AS_LINE
FERC
FERC: Reporting
COBK_AWOBJ
FERC_DOCUMENT_SENDER
FICA
Contract A/R and A/P
FILA
Lease accounting
BKPF_AWOBJ
AMFI_SHOW_AM_DOCUMENT
FILC
Consolidation
FKKCO
Contract A/R and A/P
FKK_AC_DOCUMENT_FICA
FKKKO
FI-CA Document
FKK_DOCUMENT_SENDER
FKKSU
Contract A/R and A/P
FKK_AC_DOCUMENT_FICA
FMBHI
FM_LEDGER_SHOW_ORIG_DOCUMENT
FMBL
Budgetary Ledger
FMBTR
FM_LEDGER_SHOW_ORIG_DOCUMENT
FMCA
Funds Management doc
FMCCF
Cmmt Carryforw. Doc.
FM_CCF_DOCUMENT_DISPLAY
FMCJ
PS Cash journal
FMCJ_DOCUMENT_SENDER
FMCO
Proj.Cash Mngmnt doc
COBK_AWOBJ
PS13_CASH_DOCUMENT_SENDER
FMED
BCS Entry Documents
FMED_S_AW
FMKU_ED_DISPLAY
FMLI
BCS Change Document
FMLI_S_AW
FMKU_LI_DISPLAY
FMPSO
Request document
BKPF_AWOBJ
FI_PSO_DOCUMENT_SENDER
FMRES
Earmarked funds
FM_LEDGER_SHOW_ORIG_DOCUMENT
FOTP
One-Time Postings
BKPF_AWOBJ
FPL00
FPL01
FPL02
FPL03
FS-BA
GL Bank Analyzer
AC_DOCUMENT_SENDER_FSBA
FS-PM
Policy Management
GLAL0
FlexGL Allocation
FI_DOCUMENT_SENDER
GLX
Spec. purpose ledger
GLYEC
Year-End Closing Doc
FI_DOCUMENT_SENDER
GM
Grants Mgm. Doc.
GMBD
Grants Mgm. Doc.
GM_BDGT_DOCUMENT_DISPLAY
GMCTR
Guaran. Min.Contract
HRBLK
Funds Block
DOCUMENT_SENDER_HRFPM
HRBUD
Budget Planning
DOCUMENT_SENDER_HRFPM
HRCOM
HR funds commitment
DOCUMENT_SENDER_HRFPM
HRPAY
HR settlement post.
AC_DOCUMENT_SENDER_HRPAY
HRPRE
HR funds precommt
DOCUMENT_SENDER_HRFPM
HRRES
Funds Reservation
DOCUMENT_SENDER_HRFPM
HRTIM
Time management post
COBK_AWOBJ
HRTIM_AA_DOC_SHOW_REMOTE
IBKPF
Document from IDoc
FI_DOCUMENT_SENDER
IDOC
External IDoc doc.
ISU
IS-U billing request
ISUDR
ISU Agg. Invoice
ISU_DEREG_RECTRANSF_DISP_DOC
JVA
Joint Venture
JVAM
Joint Venture
BKPF_AWOBJ
KADO
Reval. of Act. Pstg
CKMLDUVACT_DOCUMENT_SENDER
KFPK
Fixed price alloc.
KFPRS_AC_DOCUMENT_SENDER_KFPK
KOROP
FS-RI Open Items
KORUM
FS-RI Transfer
LOANS
Loans
X
FVD_SM_SHOW_DOC
MKPF
Material document
MKPF_AWKEY
MB_DOCUMENT_SENDER_MKPF
MLCU
Cumulation fin.stats
CKMLAVR_DOCUMENT_SENDER
MLDUV
Mat. Posting Reval.
CKMLDUVACT_DOCUMENT_SENDER
MLHD
Material ledger
MLHD_AWKEY
CKML_F_AC_DOCUMENT_SENDER
MYDLT
Delta Posting Bal.Sh
MY_DELTALAUF_RESULT_GET
NFSC
Nota Fiscal Brazil
NFWRI
ITMF_DOCUMENT_SENDER_NFWRI
PAYRQ
Payment request
PCON
Contract
ME_DOCUMENT_SENDER
PEAC
Payment Engine
X
AC_DOCUMENT_SENDER_PE
PORD
Purchase order
ME_DOCUMENT_SENDER
PRCHG
Price change
MLHD_AWKEY
CKML_F_AC_DOCUMENT_SENDER
PREQ
Purchase requisition
ME_DOCUMENT_SENDER
PYMTD
Payment data
REACC
Real Estate document
RE_INTERFACE_DOCUMENT_SENDER
REACI
Real Estate document
RE_INTERFACE_DOCUMENT_SENDER
RECOM
Real Estate Contract
RE_INTERFACE_CONTRACT_SENDER
RESV
Material Reservation
FM_RESV_DOCUMENT_SENDER
RETAX
Real est. doc. in.tx
RE_INTERFACE_DOCUMENT_SENDER
RMBE
SRM Document
RMRP
Invoice receipt
X
MRM_AC_DOCUMENT_SENDER_RMRP
SLRV
Only Special Pur.Ldg
SLRV_DOCUMENT_SENDER
TBRR
Event-Based RevRecog
FINS_TRR_CLOSE_DISPLAYDOCUMENT
TR-TM
Treasury Management
TRCA_DOCUMENT_SENDER_TRTM
TRAVL
Posting: Travel Exp.
AC_DOCUMENT_SENDER_TRAVL
UKPF
Rtl revaluation doc.
SP_DOCUMENT_SENDER_UKPF
VBAK
Sales Document
AC_DOCUMENT_SENDER_VBAK
VBRK
Billing document
AC_DOCUMENT_SENDER_VBRK
VBRR
Original Document
SD_REV_REC_ORIGINAL_DOCUMENT
VOVP
VZBL
Int.doc.in PS
SHOW_DOCUMENT_CREATE_REVERSE
WBRK
Vendor Bill.Document
WLF_AC_DOCUMENT_SENDER_WBRK
WTYD
Warranty Claim
WTYD_AWKEY
WTYD_DOCUMENT_SENDER
XIPAC
/IRM/IPG_FI_TO_IP_NAVIGATE
XIPST
/IRM/IPG_FI_TO_IP_NAVIGATE
Business Transaction Type
Text
ABAK
Last retirement on Group Asset
ABAW
New Revaluation
ABGA
Asset Retirement
ACEA
ACE Accruals Postings
ACPA
One Allocation Plan Assess.
ACPD
One Allocation Plan Distrib.
AFAB
Legacy data transfer: pst. val
ANZA
Down Payment
AS91
Legacy data transfer: cum. val
AUAB
Retirement of Inv. Meas. AuC
AUFW
Revaluation
AUUA
AuC: Transf. Retirem. to Asset
AUUS
AuC: Transf. Retirem. to Other
AUUZ
AuC: Transf. Acquis. on Asset
AUVA
AuC: Part. Clearing Down Pmnt
AUVZ
AuC: Part. Settlement of APC
AUZF
AuC: Acquisition Other Receiv.
AZAF
Down Payment Request
AZBU
Down Payment Clearing
AZUM
Down Payment - Transfer Postg
AZVA
AuC: Carryforward of Down Pmnt
AZVZ
AuC: Carryforward of APC
CFPC
CF: PCA internal posting
COFI
Online Posting from CO
COFM
CO-FM Integration
GLA0
GL Act. Assessment:Integrative
GLD0
GL Actual Distrib: Integrative
GLYC
G/L Year End Closing
GPDP
Distribution Primary Costs
GPDS
Distribution Secondary Costs
HRP1
HR Payroll Accounting
INVZ
Investment Support
JVAB
JVA: Retirement
JVUM
JVA:Transfer Retirement
KAMV
Manual Cost Allocation
KAZI
Actual Cost Center Accrual
KOAE
Actual Settlement (external)
KOAO
Actual Settlement
KPPE
Std cost est. (ind.purch.ordr)
KPPP
Standard costing (primary)
KPPS
Standard costing (secondary)
KPPZ
Standard costing (overhead)
KSII
Actual Price Calculation
KSPA
Assessment to CO-PA
KTDA
COPA: TOP-DOWN: Actuals
KZPI
Actual Overhead (periodic)
KZRI
Interest Calculation (actual)
NACH
Post-Capitalization
OCAB
Asset OrgAssChg: Transfer RET
OCZU
Asset OrgAssChg: Transfer ACQ
PRC5
Profit Center Document Entry
RFAD
Accrual / Deferral
RFBC
Balance Carryforward
RFBU
FI Postings
RFCL
Manual Clearing
RFCV
Foreign Currency Valuation
RFIC
Customer Invoice / Credit Memo
RFIG
FI Memo Postings
RFIV
Vendor Invoice / Credit Memo
RFPI
Incoming Payment
RFPO
Outgoing Payment
RFRA
G/L Realignment
RFT1
Travel Expenses
RFTP
Tax Payable
RKIB
Actual Periodic Repostings
RKIL
Actual Inverse Activity Alloc.
RKIU
Actual Overhead Assessment
RKIV
Actual Overhead Distribution
RKL
Actual Activity Allocation
RKLN
Revaluation at Actual Price
RKLT
Actual Template Allocation
RKLU
Activity Allocation Reposting
RKLX
Predistribution of Fixed Costs
RKU1
Repost Costs
RKU2
Repost Revenue
RKU3
Repost CO Line Items
RMBK
Adjustment of Inventory Value
RMBL
Material Debit/Credit
RMM1
Post Closing Material Ledger
RMM2
Material Ledger Initialization
RMPR
Change in Material Price
RMRP
Incoming Invoice
RMRU
Confirm Order
RMWA
Goods Movement
RMWE
Goods Receipt for Purch. Order
RMWF
Goods Receipt for Prodn. Order
RMWI
Inventory Difference
RMWL
Goods Issue Delivery
RMWQ
Goods Movement for Usage Dec.
SD00
Billing Document
TBCS
COGS Split
TBRR
Event Based Revenue Recognitn.
UMAB
Asset Transfer (retirement)
UMAI
Posting Outflow Internal
UMZI
Posting Access Internal
UMZU
Asset Transfer (acquisition)
Material

SAP Tables Relationship | Material Master Record

Material Master Record

Material Master Tables

Table Category

The table category defines whether a physical table exists for the logical table description defined in the ABAP Dictionary and how the table is stored on the database.

Transparent Tables (TRANSP)

There is a physical table on the database for each transparent table. The names of the physical table and the logical table definition in the ABAP/4 Dictionary agree. All the business and application data is stored in transparent tables.

 

Structure (INTTAB)

No data records exist on the database for a structure. Structures are used for the interface definition between programs or between screens and programs.

Append Structure (APPEND)

An Append structure defines a subset of fields which belong to another table or structure but which are treated as a separate object in the correction management. Append structures are used to support modifications.

 

Pooled table

Pooled tables can be used to store control data (e.g. screen sequences, program parameters or temporary data). Several pooled tables can be combined to form a table pool. The table pool corresponds to a physical table on the database in which all the records of the allocated pooled tables are stored.

 

Cluster table

Cluster tables contain continuous text, for example documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table category. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least part of the keys must agree. Several cluster tables are stored in one corresponding table on the database.

 

Generated view structure (VIEW)

A structure is generated for a view during activation. This structure is used as the interface for the runtime environment. It is not usually displayed in the ABAP Dictionary.

Category

Internal Table

Internal tables are dynamic data objects containing any number of rows with a common row type. Internal tables are particularly well suited for editing mass data in business applications. As well as the row type, the data type of an internal table is also defined by its table category and a table key.

Row Type

The row type can be a non-generic data type from ABAP Dictionary or global class or interface, a non-generic type in the local program, or a predefined ABAP type. Any types can be used as row types, such as elementary types, structured types, table types, and reference types.

 

Table Category

The table category defines how individual rows can be accessed:

  • Standard tables: They are managed using a row index. New rows can either be appended to end of the table or inserted at specific positions. Individual rows are accessed using the table key or the row index.

  • Sorted tables: They are also managed using a row index, but are sorted by the table key in ascending order. New rows can be inserted or appended only if they are sorted. The rows are accessed in the same way as in standard tables.

  • Hashed tables: They are managed using a hash algorithm. The rows are accessed using the table key only. Index operations are not possible.

Generic Table Categories

Two other generic table categories exist that can be used when typing formal parameters and field symbols.

 

  • Any Table: covers all table categories

  • Index Table: only covers those where index operations are possible (namely standard tables and sorted tables)

Table Key

Internal tables have a primary table key and can also have secondary table keys. If the row types are structured, the table key can consist of a list of structure components. Alternatively, the pseudo component table_line can be used to specify the entire table row as a key. Another option is to specify the standard key DEFAULT KEY. This key contains all components that are not numeric and are not themselves table types. The primary table key of a standard table can also be empty. Table keys in standard keys are always non-unique, which means multiple rows in the same table can have the same key. Hashed tables, on the other hand, always have a unique key. In sorted tables, this property can be defined using the additions UNIQUE and NON-UNIQUE.

Editing Internal Tables

Internal tables can be edited, for example, using the statements:

 

  • READ TABLE

  • LOOP AT

  • INSERT INTO TABLE

  • MODIFY TABLE

  • DELETE TABLE

Example

  1. Declares an internal table itab with a structured row type

  2. Fills the table by inserting rows

  3. Reads the rows sequentially in a loop / Assigns the fifth row to a field symbol declared inline

Internal Table

* 1 Declare an internal table

* ---

               DATA: BEGIN OF struc,
  col1 TYPE i,
  col2 TYPE i,
END OF struc,
itab LIKE STANDARD TABLE OF struc.

* 2 Inserting rows

* ---

DO 10 TIMES.
  struc-col1 = sy-index.
  struc-col2 = sy-index ** 2.
  INSERT struc INTO TABLE itab.
ENDDO.

* 3 Reads in a loop

* ---

LOOP AT itab INTO struc.
  WRITE: / struc-col1, struc-col2.
ENDLOOP.

READ TABLE itab INDEX 5 ASSIGNING FIELD-SYMBOL(<line>).
WRITE: / <line>-col1, <line>-col2.

References: SAP (www.sap.com); SAP Support (support.sap.com); SAP Help (help.sap.com); SAP Blog (blogs.sap.com)

bottom of page