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______078
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______078621BP At/Rel BP_HEADER / HAS_CENTR
SQL:  selectupdate insert create

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

SELECT MANDT, USMDKBPBP_HEADER, USMD_ACTIVE, /1MD/BPREF_CEN, /1MD/BPOBJHASBP, /1MD/BPREF_CENTR, /1MD/BPREFCENTRL, USMD_O_BP_CENTRL, /1MD/BPBIRTHDT, /1MD/BPBIRTHPL, /1MD/BPBPEXT, /1MD/BPBPKIND, /1MD/BPBU_LANGU, /1MD/BPBU_SORT1, /1MD/BPBU_SORT2, /1MD/BPCNDSC, /1MD/BPCONTACT, /1MD/BPDEATHDT, /1MD/BPEMPLO, /1MD/BPFOUND_DAT, /1MD/BPGENDER, /1MD/BPINITIALSB, /1MD/BPJOBGR, /1MD/BPLEGAL_ORG, /1MD/BPLGAL_ENTY, /1MD/BPLNGU_CORR, /1MD/BPLOCATION1, /1MD/BPLOCATION2, /1MD/BPLOCATION3, /1MD/BPLQUID_DAT, /1MD/BPMARST, /1MD/BPMCNAME1, /1MD/BPMCNAME2, /1MD/BPNAME_GRP1, /1MD/BPNAME_GRP2, /1MD/BPNAME_LAST, /1MD/BPNAME_LST2, /1MD/BPNAME_ORG1, /1MD/BPNAME_ORG2, /1MD/BPNAME_ORG3, /1MD/BPNAME_ORG4, /1MD/BPNAM_FIRST, /1MD/BPNAM_LAST2, /1MD/BPNANMIDDLE, /1MD/BPNATIO, /1MD/BPNATPERS, /1MD/BPNICK_NAME, /1MD/BPNME1_TEXT, /1MD/BPNTRLEASED, /1MD/BPPREFIX1_B, /1MD/BPPREFIX2_B, /1MD/BPPRINT_MOD, /1MD/BPPRTGRPTYP, /1MD/BPSOURCE, /1MD/BPTITLE_BP, /1MD/BPTITLE_LET, /1MD/BPTTLE_ACA1, /1MD/BPTTLE_ACA2, /1MD/BPTTLE_ROYL, /1MD/BPXBLCK, /1MD/BPXDELE, /1MD/BPZZ_FUL FROM /1MD/MD______078
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2USMDKBPBP_HEADERTechnical Keyint100 Allow NULL? 
3USMD_ACTIVEActive/Inactive Data Recordchar10 Allow NULL? 
4/1MD/BPREF_CENAuthorization Groupnvarchar40 Allow NULL? 
5/1MD/BPOBJHASBPAuthorization Group Objectnvarchar100 Allow NULL? 
6/1MD/BPREF_CENTRCountry Keynvarchar30 Allow NULL? 
7/1MD/BPREFCENTRLName formatnvarchar20 Allow NULL? 
8USMD_O_BP_CENTRLObsolete Data Recordchar10 Allow NULL? 
9/1MD/BPBIRTHDTDate of Birth of Business Partnernvarchar80 Allow NULL? 
10/1MD/BPBIRTHPLBirthplace of business partnernvarchar400 Allow NULL? 
11/1MD/BPBPEXTBusiness Partner Number in External Systemnvarchar200 Allow NULL? 
12/1MD/BPBPKINDBusiness Partner Typenvarchar40 Allow NULL? 
13/1MD/BPBU_LANGUBusiness partner: Languagechar10 Allow NULL? 
14/1MD/BPBU_SORT1Search term 1 for business partnernvarchar200 Allow NULL? 
15/1MD/BPBU_SORT2Search term 2 for business partnernvarchar200 Allow NULL? 
16/1MD/BPCNDSCCtry of Origin: Non-Res. Companiesnvarchar30 Allow NULL? 
17/1MD/BPCONTACTBusiness Partner: Contact Permissionchar10 Allow NULL? 
18/1MD/BPDEATHDTDate of death of business partnernvarchar80 Allow NULL? 
19/1MD/BPEMPLOName of Employer of a Natural Personnvarchar350 Allow NULL? 
20/1MD/BPFOUND_DATDate organization foundednvarchar80 Allow NULL? 
21/1MD/BPGENDERSex of business partner (person)char10 Allow NULL? 
22/1MD/BPINITIALSB"Middle Initial" or personal initialsnvarchar100 Allow NULL? 
23/1MD/BPJOBGROccupation/groupnvarchar40 Allow NULL? 
24/1MD/BPLEGAL_ORGLegal Entity of Organizationnvarchar20 Allow NULL? 
25/1MD/BPLGAL_ENTYBP: Legal form of organizationnvarchar20 Allow NULL? 
26/1MD/BPLNGU_CORRBusiness Partner: Correspondence Languagechar10 Allow NULL? 
27/1MD/BPLOCATION1International location number (part 1)nvarchar70 Allow NULL? 
28/1MD/BPLOCATION2International location number (Part 2)nvarchar50 Allow NULL? 
29/1MD/BPLOCATION3Check digit for the international location numberchar10 Allow NULL? 
30/1MD/BPLQUID_DATLiquidation date of organizationnvarchar80 Allow NULL? 
31/1MD/BPMARSTMarital Status of Business Partnerchar10 Allow NULL? 
32/1MD/BPMCNAME1Search Help Field 1 (Name 1/Last Name)nvarchar350 Allow NULL? 
33/1MD/BPMCNAME2Search Help Field 2 (Name 2/First Name)nvarchar350 Allow NULL? 
34/1MD/BPNAME_GRP1First Name of Groupnvarchar400 Allow NULL? 
35/1MD/BPNAME_GRP2Second Name of Groupnvarchar400 Allow NULL? 
36/1MD/BPNAME_LASTLast name of business partner (person)nvarchar400 Allow NULL? 
37/1MD/BPNAME_LST2Other Last Name of a Personnvarchar400 Allow NULL? 
38/1MD/BPNAME_ORG1First Name of Organizationnvarchar400 Allow NULL? 
39/1MD/BPNAME_ORG2Second Name of Organizationnvarchar400 Allow NULL? 
40/1MD/BPNAME_ORG3Third Name of Organizationnvarchar400 Allow NULL? 
41/1MD/BPNAME_ORG4Fourth Name of Organizationnvarchar400 Allow NULL? 
42/1MD/BPNAM_FIRSTFirst name of business partner (person)nvarchar400 Allow NULL? 
43/1MD/BPNAM_LAST2Name at birth of business partnernvarchar400 Allow NULL? 
44/1MD/BPNANMIDDLEMiddle name or second forename of a personnvarchar400 Allow NULL? 
45/1MD/BPNATIONationalitynvarchar30 Allow NULL? 
46/1MD/BPNATPERSBusiness Partner Is a Natural Person Under the Tax Lawschar10 Allow NULL? 
47/1MD/BPNICK_NAMENickname of Business Partner (Person)nvarchar400 Allow NULL? 
48/1MD/BPNME1_TEXTFull Namenvarchar800 Allow NULL? 
49/1MD/BPNTRLEASEDIndicator: Not Releasedchar10 Allow NULL? 
50/1MD/BPPREFIX1_B1st Name Prefix (Key)nvarchar40 Allow NULL? 
51/1MD/BPPREFIX2_B2nd Name Prefix (Key)nvarchar40 Allow NULL? 
52/1MD/BPPRINT_MODBusiness Partner Print Formatchar10 Allow NULL? 
53/1MD/BPPRTGRPTYPGroup typenvarchar40 Allow NULL? 
54/1MD/BPSOURCEData Origin Typesnvarchar40 Allow NULL? 
55/1MD/BPTITLE_BPForm-of-Address Keynvarchar40 Allow NULL? 
56/1MD/BPTITLE_LETSalutationnvarchar500 Allow NULL? 
57/1MD/BPTTLE_ACA1First Academic Title (Key)nvarchar40 Allow NULL? 
58/1MD/BPTTLE_ACA2Second academic title (key)nvarchar40 Allow NULL? 
59/1MD/BPTTLE_ROYLName supplement, e.g. noble title (key)nvarchar40 Allow NULL? 
60/1MD/BPXBLCKCentral Block for Business Partnerchar10 Allow NULL? 
61/1MD/BPXDELECentral Archiving Flagchar10 Allow NULL? 
62/1MD/BPZZ_FULFull Addressnvarchar2550 Allow NULL? 
NamePrimaryUniqueTypeColumns
/1MD/MD______078~0YesYesCLUSTEREDUSMD_ACTIVE, 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