- Home
- Resources
- SAP Tables
- ZZSL01A - Actual line item table
SAP Table ZZSL01A
Actual line item table
ZZSL01A (Actual line item table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ZZSL01A to other SAP tables.
Source: ZZSL01A (Actual line item table)
ZZSL01A table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| RCLNT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| GL_SIRID |
Record number of the line item record |
GU_RECID |
|
CHAR |
|
18 |
0 |
|
| RLDNR |
Ledger |
RLDNR |
T881
|
CHAR |
|
2 |
0 |
|
| RRCTY |
Record Type |
RRCTY |
|
CHAR |
|
1 |
0 |
Possible values
| 0 |
Actual |
| 1 |
Plan |
| 2 |
Actual assessment/distribution |
| 3 |
Planned assessment/distribution |
|
| RVERS |
Version |
RVERS |
T894
|
CHAR |
|
3 |
0 |
|
| RYEAR |
Fiscal Year |
GJAHR |
|
NUMC |
|
4 |
0 |
|
| RTCUR |
Currency Key |
RTCUR |
TCURC
|
CUKY |
|
5 |
0 |
|
| RUNIT |
Base Unit of Measure |
MEINS |
T006
|
UNIT |
|
3 |
0 |
|
| DRCRK |
Debit/Credit Indicator |
SHKZG |
|
CHAR |
|
1 |
0 |
Possible values
|
| POPER |
Posting period |
POPER |
|
NUMC |
|
3 |
0 |
|
| DOCCT |
Document Type |
DOCCT |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Documents with assigned document no. of receiver application |
| * |
Any document type |
| B |
Documents from accounting |
| C |
Documents from currency translation |
| K |
Documents from CO |
| G |
Documents from FI-SL for global postings |
| L |
Documents from FI-SL for local postings |
| T |
Reverse documents from FI-SL for global postings |
| U |
Reverse documents from FI-SL for local postings |
| S |
Documents for which FI-SL assigns document numbers |
| J |
Documents from Joint Venture |
| R |
Rollup documents |
| M |
Consolidation documents (EC-MC) |
| W |
Documents from the FI/CO doc |
| P |
Documents from manual planning |
| X |
Reversal for global postings in different fiscal year |
| Y |
Reversal for local postings in different fiscal year |
|
| DOCNR |
Accounting Document Number |
BELNR_D |
|
CHAR |
|
10 |
0 |
|
| DOCLN |
Six-Character Posting Item for Ledger |
DOCLN6 |
|
CHAR |
|
6 |
0 |
|
| RBUKRS |
Company Code |
BUKRS |
T001
|
CHAR |
|
4 |
0 |
|
| RACCT |
Account Number |
RACCT |
|
CHAR |
|
10 |
0 |
|
| RCNTR |
Cost Center |
KOSTL |
|
CHAR |
|
10 |
0 |
|
| RPRCTR |
Profit Center |
PRCTR |
|
CHAR |
|
10 |
0 |
|
| RZZUSER1 |
Territory |
ZZUSERFLD1 |
|
CHAR |
|
9 |
0 |
Possible values
| CAN |
Canada |
| FR |
France |
| GER |
Germany |
| JPN |
Japan |
| UK |
United Kingdom |
| US |
United States |
|
| RZZUSER2 |
Owner/Cont. |
ZZUSERFLD2 |
|
CHAR |
|
12 |
0 |
|
| RZZUSER3 |
Vein |
ZZUSERFLD3 |
|
CHAR |
|
22 |
0 |
|
| RZZSTATE |
State/Province Code |
ZZSTATE |
|
CHAR |
|
3 |
0 |
|
| RZZREG |
Location |
ZZREGION |
|
CHAR |
|
3 |
0 |
|
| RZZFKBER |
Functional Area |
FKBER |
|
CHAR |
|
16 |
0 |
|
| LOGSYS |
Logical system |
LOGSYS |
TBDLS
|
CHAR |
|
10 |
0 |
|
| SBUKRS |
Company code of partner |
PBUKRS |
T001
|
CHAR |
|
4 |
0 |
|
| SACCT |
Partner account number |
PRACCT |
|
CHAR |
|
10 |
0 |
|
| SCNTR |
Partner cost center |
PKOSTL |
|
CHAR |
|
10 |
0 |
|
| SPRCTR |
Profit Center |
PRCTR |
|
CHAR |
|
10 |
0 |
|
| SZZUSER1 |
Territory |
ZZUSERFLD1 |
|
CHAR |
|
9 |
0 |
Possible values
| CAN |
Canada |
| FR |
France |
| GER |
Germany |
| JPN |
Japan |
| UK |
United Kingdom |
| US |
United States |
|
| SZZUSER2 |
Owner/Cont. |
ZZUSERFLD2 |
|
CHAR |
|
12 |
0 |
|
| SZZUSER3 |
Vein |
ZZUSERFLD3 |
|
CHAR |
|
22 |
0 |
|
| SZZSTATE |
State/Province Code |
ZZSTATE |
|
CHAR |
|
3 |
0 |
|
| SZZREG |
Location |
ZZREGION |
|
CHAR |
|
3 |
0 |
|
| TSL |
Value in Transaction Currency |
VTCUR9 |
|
CURR |
|
17 |
2 |
|
| HSL |
Value in local currency |
VLCUR9 |
|
CURR |
|
17 |
2 |
|
| KSL |
Value in group currency |
VGCUR9 |
|
CURR |
|
17 |
2 |
|
| MSL |
Quantity |
QUAN1 |
|
QUAN |
|
15 |
3 |
|
| ASL |
Additional Quantity |
QUAN2 |
|
QUAN |
|
15 |
3 |
|
| AUNIT |
Additional unit of measure |
AUNIT |
T006
|
UNIT |
|
3 |
0 |
|
| SGTXT |
Item Text |
SGTXT |
|
CHAR |
|
50 |
0 |
|
| DOCTY |
FI-SL Document Type |
DOCTY |
T889
|
CHAR |
|
2 |
0 |
|
| ACTIV |
Business Transaction |
GLVOR |
|
CHAR |
|
4 |
0 |
|
| BUDAT |
Posting Date in the Document |
BUDAT |
|
DATS |
|
8 |
0 |
|
| WSDAT |
Value Date for Currency Translation |
WSDAT |
|
DATS |
|
8 |
0 |
|
| REFDOCNR |
Reference document number of an accounting document |
REFBELNR |
|
CHAR |
|
10 |
0 |
|
| REFRYEAR |
Reference fiscal year |
REFGJAHR |
|
NUMC |
|
4 |
0 |
|
| REFDOCLN |
Six-digit number of the reference posting line |
REFBUZEI6 |
|
NUMC |
|
6 |
0 |
|
| REFDOCCT |
Reference document category |
REFDOCCT |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Documents with assigned document no. of receiver application |
| * |
Any document type |
| B |
Documents from accounting |
| C |
Documents from currency translation |
| K |
Documents from CO |
| G |
Documents from FI-SL for global postings |
| L |
Documents from FI-SL for local postings |
| T |
Reverse documents from FI-SL for global postings |
| U |
Reverse documents from FI-SL for local postings |
| S |
Documents for which FI-SL assigns document numbers |
| J |
Documents from Joint Venture |
| R |
Rollup documents |
| M |
Consolidation documents (EC-MC) |
| W |
Documents from the FI/CO doc |
| P |
Documents from manual planning |
| X |
Reversal for global postings in different fiscal year |
| Y |
Reversal for local postings in different fiscal year |
|
| REFACTIV |
FI-SL Business Reference Transaction |
REFGLVOR |
|
CHAR |
|
4 |
0 |
|
| CPUDT |
Day On Which Accounting Document Was Entered |
CPUDT |
|
DATS |
|
8 |
0 |
|
| CPUTM |
Time of Entry |
CPUTM |
|
TIMS |
|
6 |
0 |
|
| USNAM |
User name |
USNAM |
|
CHAR |
|
12 |
0 |
|
| AWTYP |
Reference Transaction |
AWTYP |
TTYP
|
CHAR |
|
5 |
0 |
|
| AWORG |
Reference Organizational Units |
AWORG |
|
CHAR |
|
10 |
0 |
|
ZZSL01A foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| ZZSL01A |
AUNIT |
ZZSL01A |
AUNIT |
T006 |
Units of Measurement |
MSEHI |
| ZZSL01A |
AUNIT |
ZZSL01A |
RCLNT |
T006 |
Units of Measurement |
MANDT |
| ZZSL01A |
AWTYP |
ZZSL01A |
AWTYP |
TTYP |
Object Types for Accounting |
AWTYP |
| ZZSL01A |
DOCTY |
ZZSL01A |
RCLNT |
T889 |
FI-SL Document Types |
MANDT |
| ZZSL01A |
DOCTY |
ZZSL01A |
DOCTY |
T889 |
FI-SL Document Types |
DOCTY |
| ZZSL01A |
LOGSYS |
ZZSL01A |
LOGSYS |
TBDLS |
Logical system |
LOGSYS |
| ZZSL01A |
RBUKRS |
ZZSL01A |
RCLNT |
T001 |
Company Codes |
MANDT |
| ZZSL01A |
RBUKRS |
ZZSL01A |
RBUKRS |
T001 |
Company Codes |
BUKRS |
| ZZSL01A |
RCLNT |
ZZSL01A |
RCLNT |
T000 |
Clients |
MANDT |
| ZZSL01A |
RLDNR |
ZZSL01A |
RCLNT |
T881 |
Ledger Master |
MANDT |
| ZZSL01A |
RLDNR |
ZZSL01A |
RLDNR |
T881 |
Ledger Master |
RLDNR |
| ZZSL01A |
RTCUR |
ZZSL01A |
RCLNT |
TCURC |
Currency Codes |
MANDT |
| ZZSL01A |
RTCUR |
ZZSL01A |
RTCUR |
TCURC |
Currency Codes |
WAERS |
| ZZSL01A |
RUNIT |
ZZSL01A |
RUNIT |
T006 |
Units of Measurement |
MSEHI |
| ZZSL01A |
RUNIT |
ZZSL01A |
RCLNT |
T006 |
Units of Measurement |
MANDT |
| ZZSL01A |
RVERS |
ZZSL01A |
RVERS |
T894 |
FI-SL and FI-LC Versions |
RVERS |
| ZZSL01A |
RVERS |
ZZSL01A |
RLDNR |
T894 |
FI-SL and FI-LC Versions |
RLDNR |
| ZZSL01A |
RVERS |
ZZSL01A |
RCLNT |
T894 |
FI-SL and FI-LC Versions |
MANDT |
| ZZSL01A |
SBUKRS |
ZZSL01A |
SBUKRS |
T001 |
Company Codes |
BUKRS |
| ZZSL01A |
SBUKRS |
ZZSL01A |
RCLNT |
T001 |
Company Codes |
MANDT |
