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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

54 columns | Print definition?ERP 6.0  | INVOICE_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD030MIItems for Class SD03 - Raw Data33INVOICE_TYPEInvoice Typenvarchar20
2/1RA/0SD032MIItems for Class SD03 - Processable34INVOICE_TYPEInvoice Typenvarchar20
3/1RA/0SD034MIItems for Class SD03 - Processed33INVOICE_TYPEInvoice Typenvarchar20
4/OPT/VIM_IDX_C_HMaintain Characteristic Specific Index Header Fields5INVOICE_TYPEApplicable Invoice Typesnvarchar10
5/OPT/VIM_IDX_C_IMaintain Characteristic Specific Index Item Fields5INVOICE_TYPEApplicable Invoice Typesnvarchar10
6/OPT/X002Configuration table for Coder & Approver options3INVOICE_TYPE5.1 Baseline: Invoice typenvarchar40
7/OPT/X068Country Specific Process Types Confugration4INVOICE_TYPEApplicable Invoice Typesnvarchar10
8/OPT/X143Reqisitioner Request table2INVOICE_TYPEReference Transactionnvarchar50
9/OPT/X149OPENTEXT: Approval Diagnostic data3INVOICE_TYPEReference Transactionnvarchar50
10/OPT/X150OPENTEXT: Approval Diagnostic Container2INVOICE_TYPEReference Transactionnvarchar50
11/OPT/X151OPENTEXT: Approval Diagnostic Log Data2INVOICE_TYPEReference Transactionnvarchar50
12/OPT/Y002Configuration table for Coder & Approver options3INVOICE_TYPE5.1 Baseline: Invoice typenvarchar40
13/OPT/Y068Country Specific Process Types Confugration4INVOICE_TYPEApplicable Invoice Typesnvarchar10
14/OPT/Y143Reqisitioner Request table2INVOICE_TYPEReference Transactionnvarchar50
15/OPT/Y149OPENTEXT: Approval Diagnostic data3INVOICE_TYPEReference Transactionnvarchar50
16/OPT/Y150OPENTEXT: Approval Diagnostic Container2INVOICE_TYPEReference Transactionnvarchar50
17/OPT/Y151OPENTEXT: Approval Diagnostic Log Data2INVOICE_TYPEReference Transactionnvarchar50
18/OPT/Z002Configuration table for Coder & Approver options3INVOICE_TYPE5.1 Baseline: Invoice typenvarchar40
19/OPT/Z068Country Specific Process Types Confugration4INVOICE_TYPEApplicable Invoice Typesnvarchar10
20/OPT/Z143Reqisitioner Request table2INVOICE_TYPEReference Transactionnvarchar50
21/OPT/Z149OPENTEXT: Approval Diagnostic data3INVOICE_TYPEReference Transactionnvarchar50
22/OPT/Z150OPENTEXT: Approval Diagnostic Container2INVOICE_TYPEReference Transactionnvarchar50
23/OPT/Z151OPENTEXT: Approval Diagnostic Log Data2INVOICE_TYPEReference Transactionnvarchar50
24/ORS/7_2_APB_REQReqisitioner Request table2INVOICE_TYPEReference Transactionnvarchar50
25/ORS/DIAGNOSTICSOPENTEXT: Approval Diagnostic data3INVOICE_TYPEReference Transactionnvarchar50
26/ORS/DIAG_CONTOPENTEXT: Approval Diagnostic Container2INVOICE_TYPEReference Transactionnvarchar50
27/ORS/DIAG_LOGSOPENTEXT: Approval Diagnostic Log Data2INVOICE_TYPEReference Transactionnvarchar50
28/ORS/INV_ADDInvoice Add2INVOICE_TYPEReference Transactionnvarchar50
29/ORS/INV_DATAAdditional Invoice Data Storage2INVOICE_TYPEReference Transactionnvarchar50
30/ORS/INV_LOCKInvoice Locking Table2INVOICE_TYPEReference Transactionnvarchar50
31DFKKSAFTINV_HSAF-T Source Document: Header21INVOICE_TYPEPortugal: SAF-T Invoice typenvarchar20
32FARR_D_INVOICEInvoice Entries7INVOICE_TYPEInvoice Typenvarchar20
33FIEUD_SBINV_HSAFT: Self Billing Invoices (Header)- (MM)25INVOICE_TYPESAFT: Invoice Typenvarchar20
34FIEUD_SDINV_HSAFT: Invoices from SD module(Header)23INVOICE_TYPESAFT: Invoice Typenvarchar20
TOPCross-Application Components
35/OPT/S_INV_HDRVSS Staging Table: Invoice Header2INVOICE_TYPEInvoice Typenvarchar50
36/OPT/S_INV_LINVSS Staging Table: Invoice lines2INVOICE_TYPEInvoice Typenvarchar50
TOPFinancial Accounting
37/OPT/BL_AP_CONFConfiguration table for Coder & Approver options3INVOICE_TYPE5.1 Baseline: Invoice typenvarchar40
38/OPT/VIM_T005ACharacteristic Specific Process Types Confugration4INVOICE_TYPEApplicable Invoice Typesnvarchar10
TOPFinancial Supply Chain Management
39EDX_INBOUNDEDX: Inbound Messages (Processed Messages)19INVOICE_TYPEEDX: Billing Categorynvarchar30
TOPIntercompany Data Exchange
40TINV_C_DOCTLINETCustomizing: Permissability of Line Type per Bill Type2INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
41TINV_C_FM_ACTNCustomizing: Definition of Action Modules2INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
42TINV_C_FM_ACTNTCustomizing: Definition of Action Modules - TEXT2INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
43TINV_C_INCHCKAPermitted Check Values for Bill/PAN Receipt3INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
44TINV_C_INCHCKGCombination of PoD Group, Bill/PAN Type, Document Type3INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
45TINV_C_INCHCKSIDCombination: PoD Group, Bill/PAN Type, Document Type, ID3INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
46TINV_C_INVTYPECustomizing: Bill Type2INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
47TINV_C_INVTYPETCustomizing: Bill Type - Text2INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
48TINV_C_ITYPEDOCTCustomizing: Permissibility of Document Type per Bill Type2INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
49TINV_C_PROCCNTRCustomizing: Definition of Processes for Each Bill2INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
50TINV_C_PROCCNTRACustomizing: Definition of Permitted Processes per Bill2INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
51TINV_DOC_SHORTExtract of Bill Receipt (Evaluation System): Bill Document18INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
52TINV_HEAD_SHORTExtract of Bill Receipt (Evaluation System): Bill Header3INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
53TINV_INV_DOCBilling Doc. Data29INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30
54TINV_INV_HEADBill Header5INVOICE_TYPEType of Bill / Type of Payment Advice Notenvarchar30