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

53 columns | Print definition?ERP 6.0  | DEPARTMENT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI16DEPARTMENTDepartmentnvarchar400
2/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh16DEPARTMENTDepartmentnvarchar400
3/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table16DEPARTMENTDepartmentnvarchar400
4/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program17DEPARTMENTDepartmentnvarchar400
5/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE16DEPARTMENTDepartmentnvarchar400
6/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE16DEPARTMENTDepartmentnvarchar400
7/FLDQ/AD_PUPDATEMatchcode Records pending to be updated16DEPARTMENTDepartmentnvarchar400
8/FLDQ/HNA_BM_INHANA task Batch Match Input Records9DEPARTMENTDepartmentnvarchar400
9/OPT/WT_3S_MAPSupplier Self Service - User Mapping6DEPARTMENTSupplier Self Service - Invoice Criterianvarchar200
10/ORS/RECENTUSERMost Recently Selected Users9DEPARTMENTDepartmentnvarchar500
11/ORS/USERMAPOptura User Mapping Object9DEPARTMENTDepartmentnvarchar500
12/XLSO/ROLE_ASSGNFor assigning partner function after effective date6DEPARTMENTDepartment numbernvarchar40
13/XLSO/USER_COMPXLSO Table to store the assignment of Company and User4DEPARTMENTDepartment numbernvarchar40
14BBP_TMP_ZA_ASPTemporary: Request 'Bidder', Contact Addresses67DEPARTMENTDepartmentnvarchar40
15GRACREQUSERADRUser Communication Fields5DEPARTMENTDepartmentnvarchar1000
16GRACUSERUser Table8DEPARTMENTDepartmentnvarchar1000
17REQADDRESSDelivery Address for Requirement Coverage Request Lines34DEPARTMENTDepartmentnvarchar400
18T7BREFD_ININFOTrainee exclusive information7DEPARTMENTAction area of the traineenvarchar500
19ZSE_RSUSR100ZZRSUSR10016DEPARTMENTDepartmentnvarchar400
20ZSKSYSUSERuser in den IDES-Systemen6DEPARTMENTnvarchar300
21ZZRSUSR100ZZRSUSR10014DEPARTMENTDepartmentnvarchar400
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
22CRMAHRData on Persons7DEPARTMENTDepartmentnvarchar400
TOPAddress ManagementBusiness Address
23ADCPPerson/Address Assignment (Business Address Services)9DEPARTMENTDepartmentnvarchar400
24ADCPSShadow Table: Assignment Person/Addr. (Bus. Addr. Services)10DEPARTMENTDepartmentnvarchar400
TOPBasic Functions
25LECI_EVENT_DATAActivity Data Within the Check-in/Check-out Process26DEPARTMENTDepartmentnvarchar400
TOPClaims Management
26ICLDIAGNOSISDiagnoses Made26DEPARTMENTDepartment (Key)nvarchar40
27ICLPROCEDURESProcedures16DEPARTMENTDepartment (Key)nvarchar40
28ICSDIAGNOSISDiagnoses26DEPARTMENTDepartment (Key)nvarchar40
29ICSPROCEDURESProcedures16DEPARTMENTDepartment (Key)nvarchar40
30TICL364Departments2DEPARTMENTDepartment (Key)nvarchar40
31TICL364TTexts for Departments3DEPARTMENTDepartment (Key)nvarchar40
TOPCommunication Services Mail, Fax, SMS, Telephony
32BCST_PPFMDPersistence of BCS Medium for PPF13DEPARTMENTSpool Department Namenvarchar120
33BCST_RESPOBCS: Persistence of a Spool/Print Recipient3DEPARTMENTSpool Department Namenvarchar120
TOPCross-Application Components
34SDEPMENTDepartments: Starting Situation3DEPARTMENTDepartment codenvarchar40
35SDEPMENTTTexts for the Departments: Starting Situation3DEPARTMENTDepartment codenvarchar40
36SDEPMENT_CHDepartments: Enhance with Dept. Head and Time in Incl. (2)3DEPARTMENTDepartment codenvarchar40
37SDEPMENT_CSHDepartments: Collective Search Help3DEPARTMENTDepartment codenvarchar40
38SDEPMENT_SEARCHDepartments: Search Help3DEPARTMENTDepartment codenvarchar40
39SEMPLOYESEmployee Table: Starting Version6DEPARTMENTDepartment codenvarchar40
40SEMPLOYES_APPEmployees: Enhancement by Append (4)6DEPARTMENTDepartment codenvarchar40
41SEMPLOYES_RBEmployees: Enhancement by No. of Agency (2)6DEPARTMENTDepartment codenvarchar40
42SEMPLOYES_TIEmployees: Enhancement by Time Field in Include (3)6DEPARTMENTDepartment codenvarchar40
43SEMPLOY_CSHEmployee table: Collective Search Help6DEPARTMENTDepartment codenvarchar40
44SEMPLOY_SEARCHEmployee Table: Search Help Attachment to Table6DEPARTMENTDepartment codenvarchar40
TOPGeneral Application Functions
45TFAX1Fax information extendable sample4DEPARTMENTTextnvarchar500
TOPPost Processing Framework
46PPFTBCSTETransmission Medium Database Table (Template)16DEPARTMENTSpool Department Namenvarchar120
47PPFTSFPRRUPPF: Medium Smart Forms Print (Runtime)4DEPARTMENTSpool Department Namenvarchar120
48PPFTSFPRT2PPF: Medium Smart Forms Print (Template)4DEPARTMENTSpool Department Namenvarchar120
49PPFTSFPRTEPPF: Medium Smart Forms Print (Template)4DEPARTMENTSpool Department Namenvarchar120
TOPSAP Business Workflow
50SWH_ABSENCEWorkflow: Demo for Workflow Infos6DEPARTMENTDepartmentnvarchar400
51SWXFORMABSForm: Notification of Absence9DEPARTMENTDepartmentnvarchar400
TOPSAP Healthcare - Industry-Specific Components for Hospitals
52NLDBC_014ISH NL: DBC Ablauf steurung27DEPARTMENTIS-H: Org. eenheid die spec. aan een ZGV wordt toegewezennvarchar80
TOPUser and Authorization Management
53USARC_CDNot Required: Archived User Data -> Change Documents15DEPARTMENTDepartmentnvarchar400