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

Home | ERP 6.0  | /1MD/MD______09W
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
1ERP EHP76.0/1MD/MD______09W751BP At/Rel BP_HEADER / COMPNY
SQL:  selectupdate insert create

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

SELECT MANDT, USMDKBPBP_HEADER, /1MD/BPCOMPANY, /1MD/BPASSGNM_ID, USMD_ACTIVE, /1MD/BPCUS_AKONT, /1MD/BPCUS_BEGRU, /1MD/BPCUS_BROBJ, /1MD/BPCUS_BUSAB, /1MD/BPCUS_BWBER, /1MD/BPCUS_CESSN, /1MD/BPCUS_FUTUR, /1MD/BPCUS_HBKID, /1MD/BPCUS_KTOPL, /1MD/BPCUS_LAND1, /1MD/BPLOCKB, /1MD/BPCUS_OVDUE, /1MD/BPCUS_TOGRU, /1MD/BPWBRSL, USMD_O_BP_CUS_CC, /1MD/BPCUS_ALTKN, /1MD/BPCUS_BLNKZ, /1MD/BPCUS_DATLZ, /1MD/BPCUS_EIKTO, /1MD/BPCUS_FDGRV, /1MD/BPCUS_FRGRP, /1MD/BPCUS_GUZTE, /1MD/BPCUS_HWAER, /1MD/BPCUS_INTAD, /1MD/BPCUS_KULTG, /1MD/BPCUS_KVERM, /1MD/BPCUS_LOEVB, /1MD/BPCUS_MGRUP, /1MD/BPCUS_NDELC, /1MD/BPCUS_PERNR, /1MD/BPCUS_SPERB, /1MD/BPCUS_TLFNS, /1MD/BPCUS_TLFXS, /1MD/BPCUS_UZAWE, /1MD/BPCUS_VZSKZ, /1MD/BPCUS_WEBTR, /1MD/BPCUS_XAUSZ, /1MD/BPCUS_XDEZV, /1MD/BPCUS_XEDIP, /1MD/BPCUS_XPORE, /1MD/BPCUS_XVERR, /1MD/BPCUS_ZAHLS, /1MD/BPCUS_ZGRUP, /1MD/BPCUS_ZINDT, /1MD/BPCUS_ZINRT, /1MD/BPCUS_ZSABE, /1MD/BPCUS_ZTERM, /1MD/BPCUS_ZUAWA, /1MD/BPCUS_ZWELS, /1MD/BPEKVBD, /1MD/BPKNRZB, /1MD/BPKNRZE, /1MD/BPPERKZ, /1MD/BPREMIT, /1MD/BPSREGL, /1MD/BPURLID, /1MD/BPVERDT, /1MD/BPVLIBB, /1MD/BPVRBKZ, /1MD/BPVRSDG, /1MD/BPVRSNR, /1MD/BPVRSPR, /1MD/BPVRSZL, /1MD/BPWAKON, /1MD/BPXZVER, /1MD/BPZAMIB, /1MD/BPZAMIM, /1MD/BPZAMIO, /1MD/BPZAMIR, /1MD/BPZAMIV FROM /1MD/MD______09W
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2USMDKBPBP_HEADERTechnical Keyint100 Allow NULL? 
3/1MD/BPCOMPANYCompany Codenvarchar40 Allow NULL? 
4/1MD/BPASSGNM_IDMultiple Assignment ID (Number)nvarchar120 Allow NULL? 
5USMD_ACTIVEActive/Inactive Data Recordchar10 Allow NULL? 
6/1MD/BPCUS_AKONTReconciliation Account in General Ledgernvarchar100 Allow NULL? 
7/1MD/BPCUS_BEGRUAuthorization Groupnvarchar40 Allow NULL? 
8/1MD/BPCUS_BROBJAuthorization objectnvarchar100 Allow NULL? 
9/1MD/BPCUS_BUSABAccounting clerknvarchar20 Allow NULL? 
10/1MD/BPCUS_BWBERValuation Area for FI Year-End Closingnvarchar20 Allow NULL? 
11/1MD/BPCUS_CESSNAccounts Receivable Pledging Indicatornvarchar20 Allow NULL? 
12/1MD/BPCUS_FUTURFuturechar10 Allow NULL? 
13/1MD/BPCUS_HBKIDShort Key for a House Banknvarchar50 Allow NULL? 
14/1MD/BPCUS_KTOPLChart of Accountsnvarchar40 Allow NULL? 
15/1MD/BPCUS_LAND1Country Keynvarchar30 Allow NULL? 
16/1MD/BPLOCKBKey of the Lockbox to Which the Customer Is To Paynvarchar70 Allow NULL? 
17/1MD/BPCUS_OVDUEDays Overduenvarchar30 Allow NULL? 
18/1MD/BPCUS_TOGRUTolerance group for the business partner/G/L accountnvarchar40 Allow NULL? 
19/1MD/BPWBRSLValue Adjustment Keynvarchar20 Allow NULL? 
20USMD_O_BP_CUS_CCObsolete Data Recordchar10 Allow NULL? 
21/1MD/BPCUS_ALTKNPrevious Master Record Numbernvarchar100 Allow NULL? 
22/1MD/BPCUS_BLNKZ(Obsolete) Subsidy Ind. for Determining the Reduction Ratenvarchar20 Allow NULL? 
23/1MD/BPCUS_DATLZDate of the last interest calculation runnvarchar80 Allow NULL? 
24/1MD/BPCUS_EIKTOOur account number at customernvarchar120 Allow NULL? 
25/1MD/BPCUS_FDGRVPlanning groupnvarchar100 Allow NULL? 
26/1MD/BPCUS_FRGRPRelease Approval Groupnvarchar40 Allow NULL? 
27/1MD/BPCUS_GUZTEPayment Terms Key for Credit Memosnvarchar40 Allow NULL? 
28/1MD/BPCUS_HWAERCurrency Keynvarchar50 Allow NULL? 
29/1MD/BPCUS_INTADInternet address of partner company clerknvarchar1300 Allow NULL? 
30/1MD/BPCUS_KULTGProbable time until check is paiddecimal30
31/1MD/BPCUS_KVERMMemonvarchar300 Allow NULL? 
32/1MD/BPCUS_LOEVBDeletion Flag for Master Record (Company Code Level)char10 Allow NULL? 
33/1MD/BPCUS_MGRUPKey for dunning notice groupingnvarchar20 Allow NULL? 
34/1MD/BPCUS_NDELCDeletion bock for master record (company code level)char10 Allow NULL? 
35/1MD/BPCUS_PERNRPersonnel Numbernvarchar80 Allow NULL? 
36/1MD/BPCUS_SPERBPosting block for company codechar10 Allow NULL? 
37/1MD/BPCUS_TLFNSAccounting clerk's telephone number at business partnernvarchar300 Allow NULL? 
38/1MD/BPCUS_TLFXSAccounting clerk's fax number at the customer/vendornvarchar310 Allow NULL? 
39/1MD/BPCUS_UZAWEPayment Method Supplementnvarchar20 Allow NULL? 
40/1MD/BPCUS_VZSKZInterest calculation indicatornvarchar20 Allow NULL? 
41/1MD/BPCUS_WEBTRBill of exchange limit (in local currency)decimal132
42/1MD/BPCUS_XAUSZIndicator for periodic account statementschar10 Allow NULL? 
43/1MD/BPCUS_XDEZVIndicator: Local processing?char10 Allow NULL? 
44/1MD/BPCUS_XEDIPIndicator: Send Payment Advices by EDIchar10 Allow NULL? 
45/1MD/BPCUS_XPOREIndicator: Pay all items separately ?char10 Allow NULL? 
46/1MD/BPCUS_XVERRIndicator: Clearing between customer and vendor ?char10 Allow NULL? 
47/1MD/BPCUS_ZAHLSBlock Key for Paymentchar10 Allow NULL? 
48/1MD/BPCUS_ZGRUPKey for Payment Groupingnvarchar20 Allow NULL? 
49/1MD/BPCUS_ZINDTKey date of the last interest calculationnvarchar80 Allow NULL? 
50/1MD/BPCUS_ZINRTInterest calculation frequency in monthsnvarchar20 Allow NULL? 
51/1MD/BPCUS_ZSABEUser at customernvarchar150 Allow NULL? 
52/1MD/BPCUS_ZTERMTerms of Payment Keynvarchar40 Allow NULL? 
53/1MD/BPCUS_ZUAWAKey for sorting according to assignment numbersnvarchar30 Allow NULL? 
54/1MD/BPCUS_ZWELSList of the Payment Methods to be Considerednvarchar100 Allow NULL? 
55/1MD/BPEKVBDAccount Number of Buying Groupnvarchar100 Allow NULL? 
56/1MD/BPKNRZBAccount number of an alternative payernvarchar100 Allow NULL? 
57/1MD/BPKNRZEHead office account number (in branch accounts)nvarchar100 Allow NULL? 
58/1MD/BPPERKZCollective invoice variantchar10 Allow NULL? 
59/1MD/BPREMITNext payeenvarchar100 Allow NULL? 
60/1MD/BPSREGLSelection Rule for Payment Advicesnvarchar30 Allow NULL? 
61/1MD/BPURLIDShort Key for Known/Negotiated Leavenvarchar40 Allow NULL? 
62/1MD/BPVERDTInsurance validity datenvarchar80 Allow NULL? 
63/1MD/BPVLIBBAmount Insureddecimal132
64/1MD/BPVRBKZExport credit insurance institution numbernvarchar20 Allow NULL? 
65/1MD/BPVRSDGReason Code Conversion Versionnvarchar30 Allow NULL? 
66/1MD/BPVRSNRInsurance numbernvarchar100 Allow NULL? 
67/1MD/BPVRSPRDeductible percentage ratedecimal30
68/1MD/BPVRSZLInsurance lead monthsdecimal30
69/1MD/BPWAKONTerms of payment key for bill of exchange chargesnvarchar40 Allow NULL? 
70/1MD/BPXZVERIndicator: Record Payment History ?char10 Allow NULL? 
71/1MD/BPZAMIBIndicator: Payment notice to the accounting department ?char10 Allow NULL? 
72/1MD/BPZAMIMIndicator: Payment notice to customer (with cleared items)?char10 Allow NULL? 
73/1MD/BPZAMIOIndicator: payment notice to customer (w/o cleared items)?char10 Allow NULL? 
74/1MD/BPZAMIRIndicator: payment notice to legal department?char10 Allow NULL? 
75/1MD/BPZAMIVIndicator: payment notice to sales department?char10 Allow NULL? 
NamePrimaryUniqueTypeColumns
/1MD/MD______09W~0YesYesCLUSTEREDUSMD_ACTIVE, /1MD/BPASSGNM_ID, /1MD/BPCOMPANY, USMDKBPBP_HEADER, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy