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

27 columns | Print definition?B1 8.8  | MODEL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1NFN1Not a Fiscal Sequence19ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=NF Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 36=Model 2
2NFN4Manual Nota Fiscal Number8ModelNota Fiscal ModelnVarChar100
TOPInventory and Production
3OIGEGoods Issue236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
4OIGNGoods Receipt236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
5OWTRInventory Transfer236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
TOPMarketing Documents
6ADOCInvoice - History236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
7OCINA/R Correction Invoice236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
8OCPIA/P Correction Invoice236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
9OCPVA/P Correction Invoice Reversal236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
10OCSIA/R Correction Invoice236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
11OCSVA/R Correction Invoice Reversal236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
12ODLNDelivery236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
13ODPIA/R Down Payment236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
14ODPOA/P Down Payment236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
15ODRFDrafts236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
16OIEIIncoming Excise Invoice236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
17OINVA/R Invoice236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
18OOEIOutgoing Excise Invoice236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
19OPCHA/P Invoice236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
20OPDNGoods Receipt PO236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
21OPORPurchase Order236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
22OQUTSales Quotation236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
23ORDNReturns236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
24ORDRSales Order236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
25ORINA/R Credit Memo236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
26ORPCA/P Credit Memo236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3
27ORPDGoods Return236ModelNota Fiscal ModelnVarChar100010=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 3