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
1ERP EHP76.0/1MD/MD______07O781BP At/Rel BP_HEADER / ASSGN_CUS
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, USMDKBPBP_HEADER, /1MD/BPASSGNM_ID, USMD_ACTIVE, /1MD/BPAUFSD, /1MD/BPBEGRU, /1MD/BPBROBJ, /1MD/BPCITYC, /1MD/BPCOUNC, /1MD/BPCOUNTRY, /1MD/BPCUS_LANGU, /1MD/BPDTAWS, /1MD/BPLAND1, /1MD/BPPYMT_METH, /1MD/BPREGION, USMD_O_BP_CUSGEN, /1MD/BPBAHNE, /1MD/BPBRAN1, /1MD/BPBRAN2, /1MD/BPBRAN3, /1MD/BPBRAN4, /1MD/BPBRAN5, /1MD/BPCASSD, /1MD/BPCCC01, /1MD/BPCCC02, /1MD/BPCCC03, /1MD/BPCCC04, /1MD/BPCFOPC, /1MD/BPCIVVE, /1MD/BPCUS_BAHNS, /1MD/BPCUS_DTAMS, /1MD/BPCUS_FISKN, /1MD/BPCUS_KONZS, /1MD/BPCUS_LIFNR, /1MD/BPCUS_LOEVM, /1MD/BPCUS_NODEL, /1MD/BPCUS_SPERR, /1MD/BPCUS_STKZA, /1MD/BPCUS_STKZU, /1MD/BPCUS_VBUND, /1MD/BPCUS_XZEMP, /1MD/BPFAKSD, /1MD/BPFITYP, /1MD/BPJMJAH, /1MD/BPJMZAH, /1MD/BPJ_1KFREPR, /1MD/BPJ_1KFTBUS, /1MD/BPJ_1KFTIND, /1MD/BPKATR1, /1MD/BPKATR10, /1MD/BPKATR2, /1MD/BPKATR3, /1MD/BPKATR4, /1MD/BPKATR5, /1MD/BPKATR6, /1MD/BPKATR7, /1MD/BPKATR8, /1MD/BPKATR9, /1MD/BPKDKG1, /1MD/BPKDKG2, /1MD/BPKDKG3, /1MD/BPKDKG4, /1MD/BPKDKG5, /1MD/BPKNRZA, /1MD/BPKTOKD, /1MD/BPKUKLA, /1MD/BPKUNNR, /1MD/BPLIFSD, /1MD/BPLOCCO, /1MD/BPMILVE, /1MD/BPNIELS, /1MD/BPPERIV, /1MD/BPUMJAH, /1MD/BPUMSA1, /1MD/BPUWAER, /1MD/BPXICMS, /1MD/BPXSUBT, /1MD/BPXXIPI FROM /1MD/MD______07O
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2USMDKBPBP_HEADERTechnical Keyint100INT4((0))No/1MD/MD______0B4USMD_TECH_KEY Allow NULL? 
3/1MD/BPASSGNM_IDMultiple Assignment ID (Number)nvarchar120NUMC(N'000000000000')NoMDG_BP_ASSIGNMENT_ID Allow NULL? 
4USMD_ACTIVEActive/Inactive Data Recordchar10CHAR(N' ')NoUSMD_ACTIVE Allow NULL? 
5/1MD/BPAUFSDCentral order block for customernvarchar20CHAR(N' ')Yes*AUFSD_X Allow NULL? 
6/1MD/BPBEGRUAuthorization Groupnvarchar40CHAR(N' ')Yes*BRGRU Allow NULL? 
7/1MD/BPBROBJAuthorization objectnvarchar100CHAR(N' ')Yes*BROBJ Allow NULL? 
8/1MD/BPCITYCCity Codenvarchar40CHAR(N' ')Yes*CITYC Allow NULL? 
9/1MD/BPCOUNCCounty Codenvarchar30CHAR(N' ')Yes*COUNC Allow NULL? 
10/1MD/BPCOUNTRYCountry Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
11/1MD/BPCUS_LANGULanguage Key (Technical)char10CHAR(N' ')Yes*SPRAST Allow NULL? 
12/1MD/BPDTAWSInstruction key for data medium exchangenvarchar20CHAR(N' ')Yes*DTAWS Allow NULL? 
13/1MD/BPLAND1Country Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
14/1MD/BPPYMT_METHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
15/1MD/BPREGIONRegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
16USMD_O_BP_CUSGENObsolete Data Recordchar10CHAR(N' ')YesUSMD_OBSOLETE Allow NULL? 
17/1MD/BPBAHNEExpress train stationnvarchar250CHAR(N' ')YesBAHNE Allow NULL? 
18/1MD/BPBRAN1Industry Code 1nvarchar100CHAR(N' ')Yes*BRAN1_D Allow NULL? 
19/1MD/BPBRAN2Industry code 2nvarchar100CHAR(N' ')Yes*BRAN2 Allow NULL? 
20/1MD/BPBRAN3Industry code 3nvarchar100CHAR(N' ')Yes*BRAN3 Allow NULL? 
21/1MD/BPBRAN4Industry code 4nvarchar100CHAR(N' ')Yes*BRAN4 Allow NULL? 
22/1MD/BPBRAN5Industry code 5nvarchar100CHAR(N' ')Yes*BRAN5 Allow NULL? 
23/1MD/BPCASSDCentral sales block for customernvarchar20CHAR(N' ')YesCASSD_X Allow NULL? 
24/1MD/BPCCC01Indicator for biochemical warfare for legal controlchar10CHAR(N' ')YesCCC01 Allow NULL? 
25/1MD/BPCCC02Indicator for nuclear nonproliferation for legal controlchar10CHAR(N' ')YesCCC02 Allow NULL? 
26/1MD/BPCCC03Indicator for national security for legal controlchar10CHAR(N' ')YesCCC03 Allow NULL? 
27/1MD/BPCCC04Indicator for missile technology for legal controlchar10CHAR(N' ')YesCCC04 Allow NULL? 
28/1MD/BPCFOPCCustomer's CFOP categorynvarchar20CHAR(N' ')YesJ_1BINDUS1 Allow NULL? 
29/1MD/BPCIVVEID for mainly non-military usechar10CHAR(N' ')YesCIVVE Allow NULL? 
30/1MD/BPCUS_BAHNSTrain stationnvarchar250CHAR(N' ')YesBAHNS Allow NULL? 
31/1MD/BPCUS_DTAMSIndicator for Data Medium Exchangechar10CHAR(N' ')YesDTAMS Allow NULL? 
32/1MD/BPCUS_FISKNAccount number of the master record with the fiscal addressnvarchar100CHAR(N' ')Yes*FISKN_D Allow NULL? 
33/1MD/BPCUS_KONZSGroup keynvarchar100CHAR(N' ')YesKONZS Allow NULL? 
34/1MD/BPCUS_LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
35/1MD/BPCUS_LOEVMCentral Deletion Flag for Master Recordchar10CHAR(N' ')YesLOEVM_X Allow NULL? 
36/1MD/BPCUS_NODELCentral deletion block for master recordchar10CHAR(N' ')YesNODEL_X Allow NULL? 
37/1MD/BPCUS_SPERRCentral posting blockchar10CHAR(N' ')YesSPERB_X Allow NULL? 
38/1MD/BPCUS_STKZAIndicator: Business Partner Subject to Equalization Tax?char10CHAR(N' ')YesSTKZA Allow NULL? 
39/1MD/BPCUS_STKZULiable for VATchar10CHAR(N' ')YesSTKZU Allow NULL? 
40/1MD/BPCUS_VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
41/1MD/BPCUS_XZEMPIndicator: Is an alternative payer allowed in document?char10CHAR(N' ')YesXREGU Allow NULL? 
42/1MD/BPFAKSDCentral billing block for customernvarchar20CHAR(N' ')Yes*FAKSD_X Allow NULL? 
43/1MD/BPFITYPTax typenvarchar20CHAR(N' ')Yes*J_1AFITP_D Allow NULL? 
44/1MD/BPJMJAHYear for which the number of employees is givennvarchar40NUMC(N'0000')YesJMJAH Allow NULL? 
45/1MD/BPJMZAHYearly number of employeesnvarchar60NUMC(N'000000')YesJMZAH Allow NULL? 
46/1MD/BPJ_1KFREPRName of Representativenvarchar100CHAR(N' ')YesREPRES Allow NULL? 
47/1MD/BPJ_1KFTBUSType of Businessnvarchar300CHAR(N' ')Yes*GESTYP Allow NULL? 
48/1MD/BPJ_1KFTINDType of Industrynvarchar300CHAR(N' ')Yes*INDTYP Allow NULL? 
49/1MD/BPKATR1Attribute 1nvarchar20CHAR(N' ')Yes*KATR1 Allow NULL? 
50/1MD/BPKATR10Attribute 10nvarchar30CHAR(N' ')Yes*KATR10 Allow NULL? 
51/1MD/BPKATR2Attribute 2nvarchar20CHAR(N' ')Yes*KATR2 Allow NULL? 
52/1MD/BPKATR3Attribute 3nvarchar20CHAR(N' ')Yes*KATR3 Allow NULL? 
53/1MD/BPKATR4Attribute 4nvarchar20CHAR(N' ')Yes*KATR4 Allow NULL? 
54/1MD/BPKATR5Attribute 5nvarchar20CHAR(N' ')Yes*KATR5 Allow NULL? 
55/1MD/BPKATR6Attribute 6nvarchar30CHAR(N' ')Yes*KATR6 Allow NULL? 
56/1MD/BPKATR7Attribute 7nvarchar30CHAR(N' ')Yes*KATR7 Allow NULL? 
57/1MD/BPKATR8Attribute 8nvarchar30CHAR(N' ')Yes*KATR8 Allow NULL? 
58/1MD/BPKATR9Attribute 9nvarchar30CHAR(N' ')Yes*KATR9 Allow NULL? 
59/1MD/BPKDKG1Customer condition group 1nvarchar20CHAR(N' ')Yes*KDKG1 Allow NULL? 
60/1MD/BPKDKG2Customer condition group 2nvarchar20CHAR(N' ')Yes*KDKG2 Allow NULL? 
61/1MD/BPKDKG3Customer condition group 3nvarchar20CHAR(N' ')Yes*KDKG3 Allow NULL? 
62/1MD/BPKDKG4Customer condition group 4nvarchar20CHAR(N' ')Yes*KDKG4 Allow NULL? 
63/1MD/BPKDKG5Customer condition group 5nvarchar20CHAR(N' ')Yes*KDKG5 Allow NULL? 
64/1MD/BPKNRZAAccount number of an alternative payernvarchar100CHAR(N' ')Yes*KNRZA Allow NULL? 
65/1MD/BPKTOKDCustomer Account Groupnvarchar40CHAR(N' ')Yes*KTOKD Allow NULL? 
66/1MD/BPKUKLACustomer classificationnvarchar20CHAR(N' ')Yes*KUKLA Allow NULL? 
67/1MD/BPKUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
68/1MD/BPLIFSDCentral delivery block for the customernvarchar20CHAR(N' ')Yes*LIFSD_X Allow NULL? 
69/1MD/BPLOCCOCity Coordinatesnvarchar100CHAR(N' ')YesLOCCO Allow NULL? 
70/1MD/BPMILVEID for mainly military usechar10CHAR(N' ')YesMILVE Allow NULL? 
71/1MD/BPNIELSNielsen IDnvarchar20CHAR(N' ')Yes*NIELS Allow NULL? 
72/1MD/BPPERIVFiscal Year Variantnvarchar20CHAR(N' ')Yes*PERIV Allow NULL? 
73/1MD/BPUMJAHYear For Which Sales are Givennvarchar40NUMC(N'0000')YesUMJAH Allow NULL? 
74/1MD/BPUMSA1Annual salesdecimal152CURR((0))YesUMSA1
75/1MD/BPUWAERCurrency of sales figurenvarchar50CUKY(N' ')Yes*UWAER Allow NULL? 
76/1MD/BPXICMSCustomer is ICMS-exemptchar10CHAR(N' ')YesJ_1BTCICMS Allow NULL? 
77/1MD/BPXSUBTCustomer group for Substituiçao Tributária calculationnvarchar30CHAR(N' ')Yes*J_1BTCST Allow NULL? 
78/1MD/BPXXIPICustomer is IPI-exemptchar10CHAR(N' ')YesJ_1BTCIPI Allow NULL? 
NamePrimaryUniqueTypeColumns
/1MD/MD______07O~0YesYesCLUSTEREDUSMD_ACTIVE, /1MD/BPASSGNM_ID, USMDKBPBP_HEADER, MANDT