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

87 columns | Print definition?ERP 6.0  | FORM_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/CT_PDF_PFPDF Log: Profiles5FORM_NAMESmart Forms: Form Namenvarchar300
2CNVCDOPUCIA_FORMCDOP: UCIA: Impact on SAP Subroutines called externally4FORM_NAMEName of the Subroutinenvarchar300
3EHHSSD_PCI_INQUIProcess Control - Inquiry14FORM_NAMEForm Namenvarchar200
4EHHSSD_RPL_INQUIProcess Control - Mass Replace Controls - Inquiry14FORM_NAMEForm Namenvarchar200
5EHHSSD_SI_ROOTSafety Instruction - Root12FORM_NAMEForm Namenvarchar200
6EHPRCC_OUTPLOutgoing Template6FORM_NAMEForm Namenvarchar200
7EHPRCD_PSI_INQUIProcess Control - Inquiry15FORM_NAMEForm Namenvarchar200
8EPIC_C_FORMCONFEPIC: PDF Printing Form Configuration4FORM_NAMEPDF-Based Forms: Form Namenvarchar300
9EPIC_EBR_FORMEBR FORM3FORM_NAMEPDF-Based Forms: Form Namenvarchar300
10FIGEKWC_ROLESEQAssign Form Signatures to Roles3FORM_NAMEPDF-Based Forms: Form Namenvarchar300
11FIKZ_FSFORMSFinacial statement (Kazakhstan): Adobe forms4FORM_NAMEPDF-Based Forms: Form Namenvarchar300
12FILFGNC_ROLESEQAssign Form Signatures to Roles3FORM_NAMEPDF-Based Forms: Form Namenvarchar300
13FIQAC_PDFCustomizing table of PDF forms4FORM_NAMEPDF-Based Forms: Form Namenvarchar300
14J_5K_LFCL3FORM_NAMEnvarchar40
15P33_CLFORMTDescription of legal forms2FORM_NAMELegal Form Namenvarchar80
16T7INFORM_SUBTYMap adobe form per subtype of infotype 09065FORM_NAMEPDF/Smart Form: Form Namenvarchar300
17T7RU_CLFORMTDescription of legal forms2FORM_NAMELegal Form Namenvarchar80
18TIVXCESAUTCOMAutonomous community4FORM_NAMEPDF-Based Forms: Form Namenvarchar300
TOPBasic Functions
19LECI_FORMSDefinition of Forms and Print Programs3FORM_NAMESmart Forms: Form Namenvarchar300
TOPBudgeting
20FMBUDTXT_KEYBudget Text Key Customizing15FORM_NAMESmart Forms: Form Namenvarchar300
TOPBusiness Framework Architecture
21TERPFORMLISTList of New Forms1FORM_NAMEPDF-Based Forms: Form Namenvarchar300
TOPBusiness Objects, Common Components
22EHDMOD_ADR_ATFAddress - Attached Document12FORM_NAMEForm Namenvarchar200
23EHFNDD_MAP_ROOTMapping Root3FORM_NAMEForm Namenvarchar200
TOPCross-Application Components
24J_5KFH_CLFCTCustomizing table for cluster tables2FORM_NAMEName of Form Objectnvarchar40
25J_5KFH_CLFORMLegal forms2FORM_NAMEName of Form Objectnvarchar40
26J_5KFH_CLFORMCMPLegal forms in company3FORM_NAMEName of Form Objectnvarchar40
27J_5KFH_CLFORMTDescription of legal forms3FORM_NAMEName of Form Objectnvarchar40
28J_5KFH_CLNRELDATNot relevant gathered data of Legal Forms2FORM_NAMEName of Form Objectnvarchar40
29J_5KFH_CLNRELPARNot relevant parameters and select options for Legal Forms2FORM_NAMEName of Form Objectnvarchar40
30J_5KFH_LFHDRLegal form header3FORM_NAMEName of Form Objectnvarchar40
TOPCustom Development Management Cockpit
31CNVCDMCUCIA_FORMCDMC: UCIA: Impact on SAP Subroutines called externally4FORM_NAMEName of the Subroutinenvarchar300
TOPDefault Risk and Limit System
32KLFORMIDTText Table for KLDORMID: Formulas3FORM_NAMEFormula Valuesnvarchar600
TOPDocument Builder
33/IPRO/TTEXT_TText table associated with TTEXT14FORM_NAMEForm Namenvarchar300
TOPE-Recruiting
34T77RCF_PER_NOTIFNotifications4FORM_NAMEFormnvarchar300
TOPFunds Management
35TKBBADocument Types12FORM_NAMEName of Form Objectnvarchar300
TOPIncident Interactive Forms and Print Forms
36EHHSSC_INC_FORMrelated objects and checks2FORM_NAMEForm Namenvarchar200
37EHHSSC_INC_F_REGIncident Report Form Regulation Configuration Table2FORM_NAMEForm Namenvarchar200
TOPIncident Recording
38EHHSSC_STEPCATIncident Investigation - Step Category5FORM_NAMEForm Namenvarchar200
39EHHSSC_STEP_AIFInvestigation Template - Steps3FORM_NAMEForm Namenvarchar200
40EHHSSD_INC_ATDOCIncident - Attached Document11FORM_NAMEInteractive Form Namenvarchar200
41EHHSSD_INC_INSTPInvestigation Step17FORM_NAMEForm Name for Investigation Stepnvarchar200
42EHHSSD_INC_SNAPSIncident Snapshot for Form Generation8FORM_NAMEForm Namenvarchar200
TOPIncident Reporting
43EHHSSD_IRT_ROOTReport - Root13FORM_NAMEForm Namenvarchar200
44EHHSSD_ISR_ROOTReport - Root13FORM_NAMEForm Namenvarchar200
TOPIncident Workflow and Tasks
45EHHSSD_PII_INQUIProcess Control - Inquiry14FORM_NAMEForm Namenvarchar200
TOPInformation system
46FMCOBJHZuordnung Betragsobjekte (Head)6FORM_NAMEName des Formularsnvarchar150
47FMFORMANSAPSCRIPT-Formular für den Anordnungsdruck4FORM_NAMEName eines Formularobjektsnvarchar300
48FMFORMZUZuordnungstabelle der SAP-Script Formulare3FORM_NAMENazwa formularzanvarchar150
49FMRECSteuerung des Quittungsdrucks3FORM_NAMEName eines Formularobjektsnvarchar300
TOPInterface to Terminal Automation System
50TOIKDTDTabel for defaulting to dates6FORM_NAMEForm name to be processednvarchar300
TOPJapan
51T7JPCP_FORMCATTDefine Form Category Text4FORM_NAMEForm Namenvarchar300
TOPLocalization
52J_3R_CLFCTCustomizing table for cluster tables2FORM_NAMEName of Form Objectnvarchar80
53J_3R_CLFORMLegal forms1FORM_NAMEName of Form Objectnvarchar80
54J_3R_CLFORMCMPLegal forms in company3FORM_NAMEName of Form Objectnvarchar80
55J_3R_CLFORMTDescription of legal forms2FORM_NAMEName of Form Objectnvarchar80
56J_3R_CLNRELDATNot relevant gathered data of Legal Forms2FORM_NAMEName of Form Objectnvarchar80
57J_3R_CLNRELPARNot relevant parameters and select options for Legal Forms2FORM_NAMEName of Form Objectnvarchar80
58J_3R_LFHDRLegal form header3FORM_NAMEName of Form Objectnvarchar80
TOPMaintenance Processing
59/MRSS/C_DPR_FORMForms for Communication via E-Mail and Groupware4FORM_NAMESmart Forms: Form Namenvarchar300
60/MRSS/D_DPR_FORMForms for Communication via E-Mail and Groupware2FORM_NAMEForm Namenvarchar300
TOPPatient Accounting
61NWVIEW_L07IS-H: Definition of Form Folders4FORM_NAMEIS-H: Form Name for Service Entrynvarchar150
62NWVIEW_L07_FORMSIS-H: Forms Entered for Case5FORM_NAMEIS-H: Form Name for Service Entrynvarchar150
63TNSRVF01IS-H: Form-Based Service Entry Header (Form Attributes)2FORM_NAMEIS-H: Form Name for Service Entrynvarchar150
TOPPatient Management
64NWVIEW_A01IS-H: Clinical Process Builder - Additional Data of View4FORM_NAMEIS-H: Form Name for Service Entrynvarchar150
TOPPortfolio Management
65/RPM/OBJ_FORMSPrinting Object Forms4FORM_NAMEPrint Form Namenvarchar300
TOPPrint Forms and Interactive Forms
66EHFNDC_ADS_FGFAAssignment of Forms to Form Group3FORM_NAMEForm Namenvarchar200
67EHFNDC_ADS_FORMDefinition of forms2FORM_NAMEForm Namenvarchar200
68EHFNDC_ADS_F_TForm description3FORM_NAMEForm Namenvarchar200
TOPProduction Orders
69COCF_CU_SNTYPEShift Note Type - Settings for Subscreen 013020FORM_NAMEPDF-Based Forms: Form Namenvarchar300
70COCF_CU_SRTYPECShift Report Type - Content5FORM_NAMEPDF-Based Forms: Form Namenvarchar300
TOPProject Management
71DPR_FORMForms2FORM_NAMEForm Namenvarchar300
72DPR_FORMFPPDF Print Forms2FORM_NAMEName of PDF Formnvarchar300
73DPR_FORMFP_PRTYPPDF Print Templates per Project Type3FORM_NAMEName of PDF Formnvarchar300
74DPR_FORM_PRTYPPrint Templates per Project Type3FORM_NAMEForm Namenvarchar300
TOPPublic Sector Contract Accounts Receivable and Payable
75DFMCA_BRF180BRF: Parameters for Value Request with Name of XML Node6FORM_NAMEName of XML Documentnvarchar300
76DFMCA_BRF200BRF: Parameters for Writing Values in XML Nodes7FORM_NAMEName of XML Documentnvarchar300
77TFMCA_BRF210BRF: Header Parameter for Definition of Rules for Form6FORM_NAMEForm for ISR Scenarionvarchar300
78TFMCA_BRF290BRF: Parameters for Address Check6FORM_NAMEName of XML Documentnvarchar300
TOPRegulatory reporting for insurance companies
79ISSR_MACVISSR: Steuerungstabelle für Feldzuordnung (Nachbuchung)8FORM_NAMEISSR: Formroutinennamen im Exitprogrammnvarchar300
TOPResources
80PRP_FORMSForms for Communication via E-Mail and Groupware4FORM_NAMESmart Forms: Form Namenvarchar300
TOPSAP Business Workflow
81SWDSDSTEPSWF Definition: Definition-Relevant Steps Only7FORM_NAMEFormnvarchar300
82SWDSFORMSWF Definition: Forms5FORM_NAMEFormnvarchar300
TOPSAP NetWeaver Mobile - Use subcomponents
83UQFORMTEXTText for Forms4FORM_NAME30 Charactersnvarchar300
TOPStructure
84DPR_PHA_TYPEPhase Type6FORM_NAMEPrint Form for Approval Documentnvarchar300
TOPWeb Survey
85UWS_PDF_FORMSTable of the existing PDF forms for questionnairies5FORM_NAMEName of Form Objectnvarchar300
TOPWorkflows and Tasks for Risk Assessment
86EHHSSD_EVL_INQUIProcess Control - Inquiry14FORM_NAMEForm Namenvarchar200
TOPWorkforce Management Core
87WFDSC_FORMSForms for communication4FORM_NAMESmart Forms: Form Namenvarchar300