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

104 columns | Print definition?ERP 6.0  | SEQNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_CPHRRClaim Payee and HCM Person Relation9SEQNUMSequence Number for Claim Payee IO HCM Person Relationnvarchar50
2BTP_DL_IDXATTRATBTP Index Attribute Answer Texts2SEQNUMBTP Index Attribute Answer Sequence Numbernvarchar30
3BTP_DL_IDXATTRAVBTP Index Attribute Answer Values2SEQNUMBTP Index Attribute Answer Sequence Numbernvarchar30
4BTP_DL_LSCPRFCBTP System Landscape RFC Connections4SEQNUMBTP Sequence Number of RFC in Landscapenvarchar30
5BTP_DL_LSSYTYRFCBTP RFC-Connections in a System Landscape Template4SEQNUMBTP Sequence Number of RFC in Landscapenvarchar30
6BTP_DL_LSSYTYRFTBTP RFC-Connections for System Types in a System Landscape4SEQNUMBTP Sequence Number of RFC in Landscapenvarchar30
7BTP_DL_PAVDEXTBTP Project Composed IT Approaches in Phases2SEQNUMBTP Sequence Number of IT Approach within a Project Phasenvarchar30
8BTP_DL_PPHASEBTP Project Composed Phases2SEQNUMBTP Project Phase Sequence Numbernvarchar30
9BTP_DL_PROJPATPHBTP Phases in Project Patterns2SEQNUMBTP Project Phase Sequence Numbernvarchar30
10BTP_DL_UCFAVBTP Use Case User Favorites3SEQNUMBTP User Case Favorite Sequence Numbernvarchar30
11CNVA_CCD_ANA_CNTCount table for the scanned objects in CNVA_CCD_ANA packag10SEQNUMnvarchar10
12CNVLTHCM_I_STYPLT HCM: Standard Selection Types2SEQNUMSequence Numbernvarchar20
13CNVMBT09TABLETables to be processed9SEQNUMMBT PCL processing sequence numbernvarchar30
14CNVMBTCHKLOGCHKCheck Framework: Log Check Executions5SEQNUMCheck Framework: Execution Sequence Numbernvarchar40
15CNVMBTCHKLOGCHKOCheck Framework: Data Objects of Check Executions5SEQNUMCheck Framework: Execution Sequence Numbernvarchar40
16CNVMBTCHKLOGCHKPCheck Framework: Parameters of Check Executions5SEQNUMCheck Framework: Execution Sequence Numbernvarchar40
17CNVMBTCOBJconversion objects8SEQNUMSequence Numbernvarchar20
18CNVMBTDELPARAMSParameter for the generic deletion program18SEQNUMMBT PCL processing sequence numbernvarchar30
19CNVMBTGLBVARCONTContents of PIFD Global Variant3SEQNUMSequence numberint100
20CNVMBTSPEZRULESSpecic function modules to be called during load / copy6SEQNUMSequence Numbernvarchar20
21CNVMBTSUBSTATEStatus table for execution of all subactivities and histor40SEQNUMMBT PCL processing sequence numbernvarchar30
22CNVMBTTECHTABPIFD Technical Table Description for Variants2SEQNUMSequence Numbernvarchar50
23CNVMBT_DEL_TABLETable to be processed9SEQNUMMBT PCL processing sequence numbernvarchar30
24CNVTDMS_09_PROGTable for generated programs8SEQNUMSequence number for processing tablesnvarchar30
25CNVTDMS_09_TABLETables to be processed9SEQNUMSequence number for processing tablesnvarchar30
26CNV_10030_PFIELDInformation for program generation at field level8SEQNUMSequencenvarchar20
27CNV_10940_VARDETStoring values of variants11SEQNUMSequence numbertinyint30
28CNV_10996_FIELDSSpecific conversion routines11SEQNUMField conversion sequence Numbernvarchar20
29CNV_20551_OBJObject types for check routines & Find_Objects6SEQNUMDetermination: Sequence numbernvarchar10
30CNV_20551_RESULTFound relevant objects for deletion (statistics)10SEQNUMDetermination: Sequence numbernvarchar10
31CNV_INDX_FIELDSINDX conversion: Conv.-relev. RELID component fields10SEQNUMSequencenvarchar20
32CNV_INDX_IEINCLSIncludes for versions of RELID import/export routines6SEQNUMConversion: Sequence Numbernvarchar20
33CNV_INDX_STRVERSAdditional versions of RELID structure retrieval methods5SEQNUMConversion: Sequence Numbernvarchar20
34CNV_INDX_TABLESINDX conversion: Conv.-relev. RELID components7SEQNUMConversion: Sequence Numbernvarchar20
35CNV_MBT_09_TABLETables for table deletion9SEQNUMMBT PCL processing sequence numbernvarchar30
36CNV_MBT_DEL_TABSDMIS: Table for Data Deletion9SEQNUMMBT PCL processing sequence numbernvarchar30
37DMC_ACP_STG_LISTValue List for Precalculation generation2SEQNUMSequence Numbernvarchar50
38DMC_ACP_STG_STRGValue List for Precalculation generation2SEQNUMSequence Numbernvarchar50
39DMC_BO_STRUCTMWB: Business Objects (Structure)2SEQNUMDMC: Position in Tree Depth-Firstnvarchar40
40DMC_FILE_LISTMWB: File List3SEQNUMMWB: Sequence Number for Filesint100
41DMC_MT_TABLESDMC: Tables for a Mass Data Transfer16SEQNUMSequence Numbernvarchar20
42DMC_STREE_TRACEMWB: Trace storage for table DMC_STREE7SEQNUMDMC: Position in Tree Depth-Firstnvarchar40
43IUUC_PERF_OPTIONtable-specific options for performance improvements7SEQNUMSequence Numbernvarchar20
44IUUC_RECON_F2FIUUC: Reconciliation Field to Field Comparison4SEQNUMDMC: Globally Unique Key (22 Characters)nvarchar220
45IUUC_RECON_F2F_RIUUC: Reconcilation Field-to-Field Result5SEQNUMDMC: Globally Unique Key (22 Characters)nvarchar220
46IUUC_RECON_RCIUUC: Reconciliation Field to Field Comparison4SEQNUMSequence Numbernvarchar50
47IUUC_RECON_WCL_CIUUC: Where Cluase4SEQNUMSequence Numbernvarchar50
48J_1BNFE_D_CCEFLDCC-e Event Correction Letter Fields4SEQNUMInternal Sequence Number for Eventnvarchar20
49J_3RF_REGINV_INIncoming Invoice Registration Journal39SEQNUMSequential Number of Entryint100
50J_3RF_REGINV_OUTOutgoing Invoice Registration Journal40SEQNUMSequential Number of Entryint100
51MBO_FIELDBO - Table to maintain key information2SEQNUMDMC: Position in Tree Depth-Firstnvarchar40
52MBO_FORKEYbo foreign key table2SEQNUMDMC: Position in Tree Depth-Firstnvarchar40
TOPBusiness Application Support
53CNVFIELDSConversion: Table fields affected11SEQNUMField conversion sequence Numbernvarchar20
54CNVFIELDSCConversion: Table fields with conflicts in blending12SEQNUMField conversion sequence Numbernvarchar20
55CNVFIELDSCUConversion: User-defined table fields affected11SEQNUMSequencenvarchar20
56CNVJOBPROFILERequirement profile by job7SEQNUMConversion: Sequence Numbernvarchar20
57CNVTABLESConversion: Tables for processing by package8SEQNUMConversion: Sequence Numbernvarchar20
58CNVTABLESCConversion: conflict tables in blending9SEQNUMConversion: Sequence Numbernvarchar20
59CNVTABLESCUConversion: user-defined tables affected8SEQNUMConversion: Sequence Numbernvarchar20
60CNV_CHKORDER_ARWorking table for function module cnv_check_seqnum_order4SEQNUMSequencenvarchar20
61CNV_CHKORDER_BLTable for block administration of module cnv_check_seqnum_5SEQNUMSequencenvarchar20
TOPClaims Management
62ICL_CWCMP_CTLGAssignment of Disabilility Class - Benefit Catalogs3SEQNUMItem Sequence Numbernvarchar40
TOPClinical System
63N1BCHLDBasic Cat.: Catalog Assignment Definition6SEQNUMBasic Catalog: Sequence Catalog Assignment Definitionnvarchar50
64N1BCP2BCPBasic Cat.: Catalog Item to Catalog Item Assignment8SEQNUMBasic Cat.: Item Assignment Sequencenvarchar50
65N1BCP2HIERBasic Cat.: Catalog Item to Hierarchy Assignment6SEQNUMBasic Catalog: Hierarchy Assignment Sequencenvarchar50
66N1BCP2RCBasic Cat.: Item - Display Configuration Assignment7SEQNUMSequence Numbernvarchar50
67N1BCRGBasic Cat.: Display Group5SEQNUMSequence Numbernvarchar50
68N1BCSEOBSOLETE: Basic Cat.: Basic Catalog Set Entry5SEQNUMBasic Cat.: Basic Catalog Set Sequence in a Setnvarchar50
69N1BCSEPOBSOLETE: Basic Cat.: Basic Catalog Set Entry Property5SEQNUMBasic Cat.: Basic Catalog Set Sequence in a Setnvarchar50
70N1BCSFBasic Catalog Set: Folder4SEQNUMBasic Cat.: Basic Catalog Set Sequence in a Setnvarchar50
71N1BCSGOBSOLETE: Basic Cat.: Basic Catalog Set Group5SEQNUMBasic Cat.: Basic Catalog Set Sequence in a Setnvarchar50
72N1BCSMCBasic Catalog Set: Main Catalog5SEQNUMBasic Cat.: Basic Catalog Set Sequence in a Setnvarchar50
73N1BCSPCBasic Catalog Set: Property Catalog5SEQNUMBasic Cat.: Basic Catalog Set Sequence in a Setnvarchar50
74N1BCSPEC2BCPBasic Cat.: Range to Catalog Item Assignment6SEQNUMBasic Catalog: Range Assignment Sequencenvarchar50
75N1BCUFAVPBasic Cat.: User-Specific Favorites - Items5SEQNUMBasic Cat.: Favorite Items Sequencenvarchar50
76N1SRVPROPNursing Services: Service Properties4SEQNUMServices: Sequence Number of Propertynvarchar40
TOPCustomizing Tools Techniques
77ZC014Conversion toolbox : Fields & rules2SEQNUMCounternvarchar30
TOPData Conversion
78DMC_FMSEQDMC: Transformations; Order of the Function Modules3SEQNUMnvarchar20
79DMC_STREEDMC: Tree Structure for Administration of Structures4SEQNUMDMC: Position in Tree Depth-Firstnvarchar40
TOPEvent Management
80/SAPTRX/AOTYPESApplication object types4SEQNUMSequential Number of Length 4nvarchar40
81/SAPTRX/EVTYPESEvent Types4SEQNUMSequential Number of Length 4nvarchar40
TOPImplementation Guide
82CHGRPSAPfind: character groups3SEQNUMSequence numbernvarchar10
TOPInventory Management
83MMIM_REP_CUSTCustomizing f. Inventory Mgmt Reporting6SEQNUMnvarchar40
TOPJoint Venture und Production Sharing Accounting
84T8J0OBilling form routines2SEQNUMJV Sequence Numbernvarchar20
85T8J0OTText table for billing form routines2SEQNUMJV Sequence Numbernvarchar20
86T8J8CStepped Rate Thresholds4SEQNUMJV Sequence Numbernvarchar20
87T8J8DProject Level Stepped Rate Parameters4SEQNUMJV Sequence Numbernvarchar20
88T8J8IAssigned Producing Statistical Ratio Thresholds5SEQNUMJV Sequence Numbernvarchar20
89T8J8JParent Company Overheads4SEQNUMJV Sequence Numbernvarchar20
TOPLocalization
90J_1BNFE_CCENF-e CCe Table4SEQNUMInternal Sequence Number for Eventnvarchar20
91J_1BNFE_EVENTNF-e Events Table4SEQNUMInternal Sequence Number for Eventnvarchar20
92J_1BNFFTXNota Fiscal header message3SEQNUMSequence numbernvarchar20
93J_1BNFREFNota Fiscal reference to header message4SEQNUMSequence numbernvarchar20
TOPLogistics - General
94/CEECV/RO_MM_REPCustomizing f. Inventory Mgmt Reporting6SEQNUMnvarchar40
TOPNursing
95N1NRSPENursing Plan: Entry6SEQNUMNursing Plan: Sequence Number of an Entrynvarchar50
96N1SNP2SNPOBSOLETE: Std. Nrs. Plan: Std. Nrs. Plan to Std. Nrs. Plan5SEQNUMOBSOLETEnvarchar50
97N1SNPEStandard Nursing Plan: Entry7SEQNUMStandard Nursing Plan: Sequence Numbernvarchar50
98N1SNPH2BCPStnd Nrs. Plan: Stnd Nrs. Plan to Basic Calog Item Asgmt6SEQNUMStandard Nursing Plan: Sequence Numbernvarchar50
99N1SNPH2SNPHStd.Nurs.Plan: Std.Nurs.Plan to Std.Nurs.Plan5SEQNUMStandard Nursing Plan: Sequence Numbernvarchar50
100N1SNPPOBSOLETE - Std. Nrs. Plan: Std. Nrs. Plan Item6SEQNUMOBSOLETEnvarchar50
TOPPatient Management
101N1CORDTYPAIS-H: Clinical Order Type - Order Type Structure8SEQNUMIS-H: CORD/PREG: CORD Type: Structure Element Sequencenvarchar50
TOPPayment Transactions
102FPRL_WARNINGSSystem Warning Messages3SEQNUMCount parametersnvarchar40
TOPTraders and Schedulers Workbench
103OIJNOMHATLOADNomination Hatch load sequence plan5SEQNUMHatch load sequence numbernvarchar50
TOPTranslation Tools
104SBRN_EXCLSBRN: Special Tables4SEQNUMSingle-Character Indicatornvarchar10