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

42 columns | Print definition?ERP 6.0  | USMDKBPBP_HEADER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1MD/MD______06UBP Mapping Table BP_HEADER2USMDKBPBP_HEADERTechnical Keyint100
2/1MD/MD______06VBP Check Table BP_HEADER2USMDKBPBP_HEADERTechnical Keyint100
3/1MD/MD______06WBP At/Rel BP_HEADER / ASSGN_VEN2USMDKBPBP_HEADERTechnical Keyint100
4/1MD/MD______06XBP At/Rel BP_HEADER / HAS_INDST2USMDKBPBP_HEADERTechnical Keyint100
5/1MD/MD______06YBP At/Rel BP_HEADER / HASURL2USMDKBPBP_HEADERTechnical Keyint100
6/1MD/MD______070BP At/Rel BP_HEADER / HAS_TAX2USMDKBPBP_HEADERTechnical Keyint100
7/1MD/MD______071BP At/Rel BP_HEADER / HAS_PORG2USMDKBPBP_HEADERTechnical Keyint100
8/1MD/MD______072BP At/Rel BP_HEADER / HAS_ADDR2USMDKBPBP_HEADERTechnical Keyint100
9/1MD/MD______073BP At/Rel BP_HEADER / HASNAME_O2USMDKBPBP_HEADERTechnical Keyint100
10/1MD/MD______074BP At/Rel BP_HEADER / HAS_ROLE2USMDKBPBP_HEADERTechnical Keyint100
11/1MD/MD______075BP At/Rel BP_HEADER / HASNAME_P2USMDKBPBP_HEADERTechnical Keyint100
12/1MD/MD______077BP Texts BP_HEADER2USMDKBPBP_HEADERTechnical Keyint100
13/1MD/MD______078BP At/Rel BP_HEADER / HAS_CENTR2USMDKBPBP_HEADERTechnical Keyint100
14/1MD/MD______079BP At/Rel BP_HEADER / HAS_IDNUM2USMDKBPBP_HEADERTechnical Keyint100
15/1MD/MD______07ABP At/Rel BP_HEADER / HASPOSTAL2USMDKBPBP_HEADERTechnical Keyint100
16/1MD/MD______07BBP At/Rel BP_HEADER / HAS_ADRE2USMDKBPBP_HEADERTechnical Keyint100
17/1MD/MD______07CBP At/Rel BP_HEADER / HAS_ADUSG2USMDKBPBP_HEADERTechnical Keyint100
18/1MD/MD______07DBP At/Rel BP_HEADER / HAS_CMPNY2USMDKBPBP_HEADERTechnical Keyint100
19/1MD/MD______07EBP At/Rel BP_HEADER / HASFAX2USMDKBPBP_HEADERTechnical Keyint100
20/1MD/MD______07FBP At/Rel BP_HEADER / HASEMAIL2USMDKBPBP_HEADERTechnical Keyint100
21/1MD/MD______07GBP At/Rel BP_HEADER / HAS_BKDTL2USMDKBPBP_HEADERTechnical Keyint100
22/1MD/MD______07HBP At/Rel BP_HEADER / HASTEL2USMDKBPBP_HEADERTechnical Keyint100
23/1MD/MD______07IBP At/Rel BP_HEADER / LIFNR_TAX2USMDKBPBP_HEADERTechnical Keyint100
24/1MD/MD______07JBP At/Rel BP_HEADER / EKORG2USMDKBPBP_HEADERTechnical Keyint100
25/1MD/MD______07KBP At/Rel BP_HEADER / BUKRS_WT2USMDKBPBP_HEADERTechnical Keyint100
26/1MD/MD______07LBP At/Rel BP_HEADER / BUKRS2USMDKBPBP_HEADERTechnical Keyint100
27/1MD/MD______07MBP At/Rel BP_HEADER / ASSGNMNT2USMDKBPBP_HEADERTechnical Keyint100
28/1MD/MD______07NBP At/Rel BP_HEADER / LIFNRVSUB2USMDKBPBP_HEADERTechnical Keyint100
29/1MD/MD______07OBP At/Rel BP_HEADER / ASSGN_CUS2USMDKBPBP_HEADERTechnical Keyint100
30/1MD/MD______09RBP At/Rel BP_HEADER / CDD_BUKRS2USMDKBPBP_HEADERTechnical Keyint100
31/1MD/MD______09TBP At/Rel BP_HEADER / CUSPAFUNC2USMDKBPBP_HEADERTechnical Keyint100
32/1MD/MD______09UBP At/Rel BP_HEADER / VENPAFUNC2USMDKBPBP_HEADERTechnical Keyint100
33/1MD/MD______09VBP At/Rel BP_HEADER / CWT_BUKRS2USMDKBPBP_HEADERTechnical Keyint100
34/1MD/MD______09WBP At/Rel BP_HEADER / COMPNY2USMDKBPBP_HEADERTechnical Keyint100
35/1MD/MD______09XBP At/Rel BP_HEADER / CUSTAX2USMDKBPBP_HEADERTechnical Keyint100
36/1MD/MD______09ZBP At/Rel BP_HEADER / SALES_L2USMDKBPBP_HEADERTechnical Keyint100
37/1MD/MD______0A3BP At/Rel BP_HEADER / ZZDUN2USMDKBPBP_HEADERTechnical Keyint100
38/1MD/MD______0A4BP Check Table ZDUN12USMDKBPBP_HEADERTechnical Keyint100
39/1MD/MD______0A5BP Check Table BP_HEADER2USMDKBPBP_HEADERTechnical Keyint100
40/1MD/MD______0B4BP Check Table BP_HEADER2USMDKBPBP_HEADERTechnical Keyint100
41/SMD/MD_____00N5SID-Tabelle fuer USMDKBPBP_HEADER3USMDKBPBP_HEADERTechnical Keyint100
42/SMD/MD_____012JSID-Tabelle fuer Duns Number3USMDKBPBP_HEADERTechnical Keyint100