SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

137 columns | Print definition?ERP 6.0  | RECORD_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_QU_INDXQU2 Index Table1RECORD_IDParameter ID for Editing objectnvarchar200
2/FLDQ/HNA_PREQU2staging table for RSADRQU2 report1RECORD_IDParameter ID for Editing objectnvarchar200
3/FLDQ/HNA_PSTQU2Result Table for RSADRQU2 report1RECORD_IDParameter ID for Editing objectnvarchar200
4/SYCLO/PSH01Syclo Push Register5RECORD_IDRecord Idint100
5/SYCLO/PSH10Push framework: subscription queue3RECORD_IDRecord Numbernvarchar100
6/SYCLO/SYSLOG001System statistics - Middleware integration3RECORD_IDRecord no.nvarchar100
7/SYCLO/WB001DevTool: Mobile Screen Definition7RECORD_IDDevTool: readable identifierint100
8/SYCLO/WB001FDevTool: Mobile Screen layout12RECORD_IDDevTool: readable identifierint100
9/SYCLO/WB001VDevTool: Screen field value table10RECORD_IDDevTool: readable identifierint100
10/SYCLO/WB002DevTool: object7RECORD_IDDevTool: readable identifierint100
11/SYCLO/WB002ADevTool: Object attributes9RECORD_IDDevTool: readable identifierint100
12/SYCLO/WB003DevTool: Mobile Screen Set8RECORD_IDDevTool: readable identifierint100
13/SYCLO/WB004DevTool: Action definition9RECORD_IDDevTool: readable identifierint100
14/SYCLO/WB005DevTool: client data table8RECORD_IDDevTool: readable identifierint100
15/SYCLO/WB005RDevTool: Data table entries8RECORD_IDDevTool: readable identifierint100
16/SYCLO/WB006DevTool: Transaction definition header7RECORD_IDDevTool: readable identifierint100
17/SYCLO/WB006ADevTool: Client transaction attributes10RECORD_IDDevTool: readable identifierint100
18/XFT/EPA_B0001Checklists2RECORD_IDRecord IDnvarchar320
19/XFT/EPA_TBARCOOpen barcodes5RECORD_IDRecord IDnvarchar320
20/XFT/EPA_TPROTLog3RECORD_IDRecord IDnvarchar320
21/XFT/SRM_DEMO_02Property Extension2RECORD_IDRecord IDnvarchar320
22CIAP_D_NFCIAP Nota Fiscal/Record relationship2RECORD_IDCIAP Record Unique IDvarbinary160
23CIAP_D_QUOTACIAP record quota2RECORD_IDCIAP Record Unique IDvarbinary160
24CIAP_D_SUSPCIAP Records that were manually suspended2RECORD_IDCIAP Record Unique IDvarbinary160
25CNVC_CCE_USG_RESCustomizing Comparison:Result table for usage of customizing6RECORD_IDnvarchar100
26T7BREFD_BENINFOBeneficiary and income identification3RECORD_IDRecord codenvarchar90
27T7BREFD_BENONRESData of beneficiary non-resident or resident abroad3RECORD_IDRecord codenvarchar90
28T7BREFD_BRANCHPlace of work3RECORD_IDRecord codenvarchar90
29T7BREFD_DEPPLANDependent of health care private plan3RECORD_IDRecord codenvarchar90
30T7BREFD_DETCOMDetail of competences to which the payment refers3RECORD_IDRecord codenvarchar90
31T7BREFD_DETDEDUCDetail of deductions3RECORD_IDRecord codenvarchar90
32T7BREFD_DNOD1300Dependents control of the eSocial framework 1300 - PAY3RECORD_IDRecord codenvarchar90
33T7BREFD_DTCTRLCurrent and previous validity3RECORD_IDRecord codenvarchar90
34T7BREFD_EEABSEmployee temporary absence3RECORD_IDRecord codenvarchar90
35T7BREFD_EEADDREmployee address3RECORD_IDRecord codenvarchar90
36T7BREFD_EEASOOccupational health certificate3RECORD_IDRecord codenvarchar90
37T7BREFD_EEBANKEmployee bank details3RECORD_IDRecord codenvarchar90
38T7BREFD_EECNTCEmployee contact information3RECORD_IDRecord codenvarchar90
39T7BREFD_EECNTREmployment information3RECORD_IDRecord codenvarchar90
40T7BREFD_EECOMPEmployee identification additional information3RECORD_IDRecord codenvarchar90
41T7BREFD_EEDEPDependents3RECORD_IDRecord codenvarchar90
42T7BREFD_EEDISAChallenged employee3RECORD_IDRecord codenvarchar90
43T7BREFD_EEDOCSEmployee identification documents3RECORD_IDRecord codenvarchar90
44T7BREFD_EEDWSCRegular workday information3RECORD_IDRecord codenvarchar90
45T7BREFD_EEEDMPDismissal protection end3RECORD_IDRecord codenvarchar90
46T7BREFD_EEEODSUnion leader source company3RECORD_IDRecord codenvarchar90
47T7BREFD_EEEWSCSpecial workday information3RECORD_IDRecord codenvarchar90
48T7BREFD_EEEXAMTests done3RECORD_IDRecord codenvarchar90
49T7BREFD_EEFACTRelevant fact statement3RECORD_IDRecord codenvarchar90
50T7BREFD_EEFORForeign employee3RECORD_IDRecord codenvarchar90
51T7BREFD_EEFWSCWorkday in fixed shifts information3RECORD_IDRecord codenvarchar90
52T7BREFD_EEGARPayments made to alimony beneficiaries3RECORD_IDRecord codenvarchar90
53T7BREFD_EEIDPYWorker identification3RECORD_IDRecord codenvarchar90
54T7BREFD_EEINFOEmployee information3RECORD_IDRecord codenvarchar90
55T7BREFD_EELAWSLawsuit of the employee3RECORD_IDRecord codenvarchar90
56T7BREFD_EELINFEmployee legal information3RECORD_IDRecord codenvarchar90
57T7BREFD_EELVNTEmployee leave notice3RECORD_IDRecord codenvarchar90
58T7BREFD_EEOINFOther information of employee3RECORD_IDRecord codenvarchar90
59T7BREFD_EEORESCondominium information3RECORD_IDRecord codenvarchar90
60T7BREFD_EEPACTPerformed activity3RECORD_IDRecord codenvarchar90
61T7BREFD_EERABSEmployee temporary absence return3RECORD_IDRecord codenvarchar90
62T7BREFD_EEREMRemuneration information3RECORD_IDRecord codenvarchar90
63T7BREFD_EERISKHarmful agents3RECORD_IDRecord codenvarchar90
64T7BREFD_EERSNCChange to absence reason3RECORD_IDRecord codenvarchar90
65T7BREFD_EESDMPDismissal protection start3RECORD_IDRecord codenvarchar90
66T7BREFD_EESVNCInformation group of employment relationship succession3RECORD_IDRecord codenvarchar90
67T7BREFD_EETEMPWorker on temporary loan3RECORD_IDRecord codenvarchar90
68T7BREFD_EETERMTermination3RECORD_IDRecord codenvarchar90
69T7BREFD_EETRFRWorker transfer information group3RECORD_IDRecord codenvarchar90
70T7BREFD_EEVWSCRelief shift workday information3RECORD_IDRecord codenvarchar90
71T7BREFD_EEWDAYContract schedule3RECORD_IDRecord codenvarchar90
72T7BREFD_EEWERTInfo termination employee with no employment relationship3RECORD_IDRecord codenvarchar90
73T7BREFD_EEWRKPEmployee place of work3RECORD_IDRecord codenvarchar90
74T7BREFD_EEWSCHWorkday3RECORD_IDRecord codenvarchar90
75T7BREFD_ERBKSHBank information3RECORD_IDRecord codenvarchar90
76T7BREFD_ERCNTCContact of person responsible for information3RECORD_IDRecord codenvarchar90
77T7BREFD_ERCOINFOCompany additional information3RECORD_IDRecord codenvarchar90
78T7BREFD_EREXEMAdditional information - Exempted companies - Exemption data3RECORD_IDRecord codenvarchar90
79T7BREFD_ERFGTSExclusive information for FGTS3RECORD_IDRecord codenvarchar90
80T7BREFD_ERINFOEmployer identification3RECORD_IDRecord codenvarchar90
81T7BREFD_EROINFOther employer information3RECORD_IDRecord codenvarchar90
82T7BREFD_ERSWHOSoftware house information3RECORD_IDRecord codenvarchar90
83T7BREFD_EVDELEvent exclusion3RECORD_IDRecord codenvarchar90
84T7BREFD_EXMPINCExempt/non-taxable income3RECORD_IDRecord codenvarchar90
85T7BREFD_FINISNIS archive information3RECORD_IDRecord codenvarchar90
86T7BREFD_HELPLANCNPJ of health plan provider3RECORD_IDRecord codenvarchar90
87T7BREFD_INFRRAAdditional information - income received cumulatively3RECORD_IDRecord codenvarchar90
88T7BREFD_ININFOTrainee exclusive information3RECORD_IDRecord codenvarchar90
89T7BREFD_JOBJob information3RECORD_IDRecord codenvarchar90
90T7BREFD_LAWCOINFAdditional information of legal decisions3RECORD_IDRecord codenvarchar90
91T7BREFD_LAWYERLawyer identification3RECORD_IDRecord codenvarchar90
92T7BREFD_LEGALFEEDetail of lawsuit fees3RECORD_IDRecord codenvarchar90
93T7BREFD_LEGCOMPInformation regarding legal compensation3RECORD_IDRecord codenvarchar90
94T7BREFD_NOTPERNotice3RECORD_IDRecord codenvarchar90
95T7BREFD_NRESIPAYPayment to non-resident or resident abroad3RECORD_IDRecord codenvarchar90
96T7BREFD_NTPRCACancellation of notice period3RECORD_IDRecord codenvarchar90
97T7BREFD_PAYBPFBeneficiary natural person - resident in Brazil3RECORD_IDRecord codenvarchar90
98T7BREFD_PAYBPJFramework table control3RECORD_IDRecord codenvarchar90
99T7BREFD_PYAGREIdentification of agreement/convention/bargaining3RECORD_IDRecord codenvarchar90
100T7BREFD_PYCMPLPayroll additional information3RECORD_IDRecord codenvarchar90
101T7BREFD_PYGARPayments made to alimony beneficiaries3RECORD_IDRecord codenvarchar90
102T7BREFD_PYINFOPayroll additional information3RECORD_IDRecord codenvarchar90
103T7BREFD_PYPAYWage types that form employee remuneration3RECORD_IDRecord codenvarchar90
104T7BREFD_PYPERperiod to which the remuneration differences refer to3RECORD_IDRecord codenvarchar90
105T7BREFD_PYREMEmployee remuneration information3RECORD_IDRecord codenvarchar90
106T7BREFD_PYREOTRemuneration other company codes3RECORD_IDRecord codenvarchar90
107T7BREFD_PYRESCInformation regarding indemnity amounts3RECORD_IDRecord codenvarchar90
108T7BREFD_PYREVNPayroll additional information3RECORD_IDRecord codenvarchar90
109T7BREFD_PYTOTTotaling of worker's remuneration3RECORD_IDRecord codenvarchar90
110T7BREFD_PYWPLEstablishment identification and workplace3RECORD_IDRecord codenvarchar90
111T7BREFD_PYWTAMWage types that form employee remuneration3RECORD_IDRecord codenvarchar90
112T7BREFD_TEMPWRKInfomation regarding temporary worker's remuneration3RECORD_IDRecord codenvarchar90
113T7BREFD_WRKPLCWorkplace information3RECORD_IDRecord codenvarchar90
114T7BREFD_WRKSCHWorkday information3RECORD_IDRecord codenvarchar90
115T7BREFD_WTLAWSProcesses3RECORD_IDRecord codenvarchar90
116T7BREFD_WTYPEWage type information3RECORD_IDRecord codenvarchar90
TOPBasis Components
117/XFT/INV_QInvoice receipt queue: Header23RECORD_IDRecord IDnvarchar320
118/XFT/INV_Q_SInvoice receipt queue: Header23RECORD_IDRecord IDnvarchar320
TOPClinical System
119N2DI_RECORDAdministration Data of Speech Recording2RECORD_IDRecording IDnvarchar320
120N2DI_RECORD_TEXTClear Text of Speech Recording2RECORD_IDRecording IDnvarchar320
TOPContract Accounts Receivable and Payable
121TFKK_EXTR_STRShort Extracts: Structures2RECORD_IDShort Extracts: Record IDnvarchar20
TOPEasy Enhancement Workbench
122AXT_TABLE_TMPLExtensibility Template for new tables2RECORD_IDRecord IDvarbinary160
TOPLoans Management
123VDCBR_RES_HTHeader and Totals Records for Data Reported to Credit Bur.6RECORD_IDKey for Header Record of Reporting Filenvarchar60
TOPMaster Data
124BCA_US_HLD2RELHold Records which have not been released - Dual Control4RECORD_IDRecord ID Type for Hold Tablenvarchar100
125BCA_US_HOLDHold Amounts Which Affect Available Balance4RECORD_IDRecord ID Type for Hold Tablenvarchar100
126ISM_PCSADR_LOGIS-M Postal Change Service: Address Update - Log Table4RECORD_IDRecord Indexnvarchar90
TOPSAP Records Management
127SRMRGCONTCContext Counter: Highest Counter Readings3RECORD_IDRecord Character Generator: Unique IDnvarchar320
TOPWorkforce Management Application
128WFA_AGTEVT_ELAgent (Scheduled) Event Eligibility7RECORD_IDWFM GUIDvarbinary160
129WFA_SCEVT_ORGSchedule Event - Organization Relationship9RECORD_IDWFM GUIDvarbinary160
130WFA_SCEVT_QULSchedule Event - Qualifications Relationship9RECORD_IDWFM GUIDvarbinary160
131WFA_SCEVT_WAWork filter on schedule events7RECORD_IDWFM GUIDvarbinary160
132WFA_TEAM_EVTTeams assigned to a scheduled event10RECORD_IDWFM GUIDvarbinary160
TOPWorkforce Management Core
133WFMCAS_AGTEVT_ELAgent (Scheduled) Event Eligibility7RECORD_IDWFM GUIDvarbinary160
134WFMCAS_SCEVT_ORGSchedule Event - Organization Relationship9RECORD_IDWFM GUIDvarbinary160
135WFMCAS_SCEVT_QULSchedule Event - Qualifications Relationship9RECORD_IDWFM GUIDvarbinary160
136WFMCAS_SCEVT_WAWork filter on schedule events7RECORD_IDWFM GUIDvarbinary160
137WFMCAS_TEAM_EVTTeams assigned to a scheduled event10RECORD_IDWFM GUIDvarbinary160