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

92 columns | Print definition?ERP 6.0  | PARTNER_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/LOCSRM/BID_CHRSBusiness Partner: Localization Bidder Characterisitc2PARTNER_GUIDBusiness Partner GUIDvarbinary160
2/LOCSRM/T_LAW_BRLAW 123 Bidders and corresponding Item line for an auction4PARTNER_GUIDGlobally Unique Identifiervarbinary160
3/SAPSRM/QST_STATAccumulated questionnaire status for a given supplier2PARTNER_GUIDBusiness Partner GUIDvarbinary160
4ACO000SAP_GP: Communication Data Set Bidder/Vendor/Portal2PARTNER_GUIDBusiness Partner GUIDvarbinary160
5ACO001Classification 'Is Portal' for Communication Data ACO0002PARTNER_GUIDBusiness Partner GUIDvarbinary160
6BBPD_ES_EEWAEmployee Workplace: Org. Address References (NW710: MOM052)2PARTNER_GUIDBusiness Partner GUIDvarbinary160
7BBPD_ES_EEWA_FSEmployee Workplace: Address Usages (NW710: MOM052_FS)2PARTNER_GUIDBusiness Partner GUIDvarbinary160
8BBPD_LA_BIDHISTBid history8PARTNER_GUIDBusiness Partner IDvarbinary160
9BBPD_LA_CLTSTATClient status5PARTNER_GUIDGlobally Unique identifiervarbinary160
10BBPD_LA_PALASTBBidders' best bid3PARTNER_GUIDBusiness Partner IDvarbinary160
11BBPD_LA_PARTNERBBest bid per bidder and auction item3PARTNER_GUIDBusiness Partner IDvarbinary160
12BBPD_LA_PROXYBIDProxy bid status5PARTNER_GUIDBusiness Partner IDvarbinary160
13BBPD_PD_INDEX_HIndex Table for a Selective First Access in GetList4PARTNER_GUIDGUID for an Individual Partnervarbinary160
14BBPM_BUT_FRG0010Business Partner: General BBP Data (Administration)3PARTNER_GUIDBusiness Partner GUIDvarbinary160
15BBPM_BUT_FRG0011Business Partner: General BBP Data4PARTNER_GUIDBusiness Partner GUIDvarbinary160
16BBPM_BUT_FRG0020Business Partner: Bidder Characteristic (Administration)3PARTNER_GUIDBusiness Partner GUIDvarbinary160
17BBPM_BUT_FRG0021Business Partner: Bidder Characterisitc4PARTNER_GUIDBusiness Partner GUIDvarbinary160
18BBPM_BUT_FRG0030Business Partner: Quality Standards (Administration)3PARTNER_GUIDBusiness Partner GUIDvarbinary160
19BBPM_BUT_FRG0031Business Partner: Quality Standards4PARTNER_GUIDBusiness Partner GUIDvarbinary160
20BBPM_BUT_FRG0040Business Partner: Accepted Payment Card Types (Admin.)3PARTNER_GUIDBusiness Partner GUIDvarbinary160
21BBPM_BUT_FRG0041Business Partner: Accepted Payment Card Types4PARTNER_GUIDBusiness Partner GUIDvarbinary160
22BBPM_BUT_FRG0060Business Partner: Purchasing Data (Administration)3PARTNER_GUIDBusiness Partner GUIDvarbinary160
23BBPM_BUT_FRG0061Business Partner: Purchasing Data4PARTNER_GUIDBusiness Partner GUIDvarbinary160
24BBP_CT_MAPPARTMapping Partner5PARTNER_GUIDBusiness Partner GUIDvarbinary160
25BBP_CT_PARTNERPartner2PARTNER_GUIDGUID Partnervarbinary160
26BBP_CT_PPRODUCTPartner Product5PARTNER_GUIDGUID Partnervarbinary160
27BBP_CT_PRDPRICEProduct Price5PARTNER_GUIDGUID Partnervarbinary160
28BBP_CT_SCHEMAImported Schemata5PARTNER_GUIDContent Provider GUIDvarbinary160
29BBP_PDBGPPartner Extension Gen. Purchasing Data2PARTNER_GUIDGlobally Unique identifiervarbinary160
30BBP_RET_BLKDPP EOP Table7PARTNER_GUIDBusiness Partner GUIDvarbinary160
31BBP_SENDMEDIUMBusiness Partner, Transmission Medium2PARTNER_GUIDBusiness Partner GUIDvarbinary160
32BBP_SUS_BPCMPMAPMapping Table for Business Partner (Buyer; Goods Recipient)2PARTNER_GUIDBusiness Partner GUIDvarbinary160
33BBP_SUS_BPSETTNGSUS-Specific Data Stored in Business Partner2PARTNER_GUIDBusiness Partner GUIDvarbinary160
34BID000Business Partner: Bidder General Data2PARTNER_GUIDBusiness Partner GUIDvarbinary160
35BIDCCBusiness Partner: Assigned Categories2PARTNER_GUIDBusiness Partner GUIDvarbinary160
36BIDQMSBusiness Partner: Quality Management System2PARTNER_GUIDBusiness Partner GUIDvarbinary160
37CNVTDMSIS_BPGUIDTDMS IS U: Stores BP Guids for selected BPs3PARTNER_GUIDBusiness Partner GUIDvarbinary160
38CNVTDMS_05_GUIDFill Header table to store Business Partner GUIDs3PARTNER_GUIDGUID of a Business Partnervarbinary160
39CNVTDMS_CRP_GUIDTDMS CRM: All the PARTNER_GUID'S4PARTNER_GUIDBusiness Partner GUIDvarbinary160
40REQADDRESSDelivery Address for Requirement Coverage Request Lines5PARTNER_GUIDGUID for an Individual Partnervarbinary160
41REQHEADSTemporary Header Data: Requirement Coverage Request (Limit)76PARTNER_GUIDBusiness Partner GUIDvarbinary160
42REQLINEMATemporary Line Data: Requirement Coverage Request(MRO Lines)85PARTNER_GUIDBusiness Partner GUIDvarbinary160
43REQLINESRTemporary Line Data: Requirement Coverage Request (Services)87PARTNER_GUIDBusiness Partner GUIDvarbinary160
44ROS_BP_PC_SURVEYAssign Vendor, Product Category, Survey2PARTNER_GUIDBusiness Partner GUIDvarbinary160
45VEN000Business Partner: General Vendor Data2PARTNER_GUIDBusiness Partner GUIDvarbinary160
46VENMAPMapping Table Partner GUID - R/3 Number2PARTNER_GUIDBusiness Partner GUIDvarbinary160
47VENPCBusiness Partner: Assignment: Procurement Card - Vendor2PARTNER_GUIDBusiness Partner GUIDvarbinary160
TOPAudit Management
48PLMM_AUDIT_ROLESAudit Components-BP-Partner Role7PARTNER_GUIDBusiness Partner GUIDvarbinary160
TOPBank Customer Accounts
49BCA_US_BUT000US Specific Enhancements to BP3PARTNER_GUIDBusiness Partner GUIDvarbinary160
TOPBasic Data
50NGPAIS-H: Business Partners53PARTNER_GUIDIS-H: GUID of Business Partnervarbinary160
TOPBusiness Partners
51TNBPMIGFIASSNStore IS-H Object and FI Customer Assignment2PARTNER_GUIDvarbinary160
TOPChargeback
52WCOCOPCondition Contract: Partner Assignment3PARTNER_GUIDCondition Contract: Partner GUIDvarbinary160
TOPCommodity Pricing Engine
53CPED_COVDIFFPARTCoverage - Differing Partners4PARTNER_GUIDBusiness Partner GUIDvarbinary160
54CPED_COVERAGECoverage - General Master Data5PARTNER_GUIDBusiness Partner GUIDvarbinary160
TOPGeneral Application Functions
55CRMD_PARTNERPartners2PARTNER_GUIDGUID for an Individual Partnervarbinary160
TOPGroup Hierarchy
56BUT_HIER_NODE_BPBusiness Partner Hierarchy Group - Bus. Partner Assignment4PARTNER_GUIDBusiness Partner GUIDvarbinary160
TOPIntegration Customer Relationship Management
57EVER_CRMQISU Contract CRM-Entry Queue18PARTNER_GUIDBusiness Partner GUIDvarbinary160
TOPMaster Data Synchronization
58CVI_CUST_CT_LINKConnec. Between Relationship + Activity Partner for Customer2PARTNER_GUIDBusiness Partner GUIDvarbinary160
59CVI_CUST_LINKAssignment Between Customer and Business Partner2PARTNER_GUIDBusiness Partner GUIDvarbinary160
60CVI_VEND_CT_LINKConnec. Between Relationship + Activity Partner for Vendor2PARTNER_GUIDBusiness Partner GUIDvarbinary160
61CVI_VEND_LINKAssignment Between Vendor and Business Partner2PARTNER_GUIDBusiness Partner GUIDvarbinary160
TOPNetWeaver Demonstration
62SDEMO_BPSAP NetWeaver Demo Model - Business Partner2PARTNER_GUIDGUID in 'RAW' formatvarbinary160
63SDEMO_BP_EMSAP NetWeaver Demo Model - Business Partner E-Mail3PARTNER_GUIDGUID in 'RAW' formatvarbinary160
64SDEMO_BP_PHSAP NetWeaver Demo Model - Business Partner Telephone3PARTNER_GUIDGUID in 'RAW' formatvarbinary160
65SDEMO_BP_RRSAP NetWeaver Demo Model - Business Partner Role Relation3PARTNER_GUIDGUID in 'RAW' formatvarbinary160
66SDEMO_BP_WASAP NetWeaver Demo Model - Business Partner Web Address3PARTNER_GUIDGUID in 'RAW' formatvarbinary160
67SDEMO_LINKNW Demo Model - Link between Business Partner and Address2PARTNER_GUIDGUID in 'RAW' formatvarbinary160
68SNWD_BP_EMObsolete - Do Not Use3PARTNER_GUIDEPM: Generic Node Keyvarbinary160
69SNWD_BP_PHObsolete - Do Not Use3PARTNER_GUIDEPM: Generic Node Keyvarbinary160
70SNWD_BP_RRObsolete - Do Not Use3PARTNER_GUIDEPM: Generic Node Keyvarbinary160
71SNWD_BP_WAObsolete - Do Not Use3PARTNER_GUIDEPM: Generic Node Keyvarbinary160
72SNWD_CONTACTObsolete - Do Not Use3PARTNER_GUIDEPM: Generic Node Keyvarbinary160
73SNWD_GRObsolete - Do Not Use10PARTNER_GUIDEPM: Generic Node Keyvarbinary160
74SNWD_GR_HEADEPM: Goods Received Header Table9PARTNER_GUIDEPM: Generic Node Keyvarbinary160
75SNWD_POEPM: Purchase Order Header Table9PARTNER_GUIDEPM: Generic Node Keyvarbinary160
76SNWD_PO_INV_HEADEPM: Purchase Order Invoice Header Table13PARTNER_GUIDEPM: Generic Node Keyvarbinary160
TOPSAP Business Partner
77BUT_FRG0010Business Partner: Tax Classification2PARTNER_GUIDBusiness Partner GUIDvarbinary160
78BUT_FRG0011Business Partner: Tax Classification2PARTNER_GUIDBusiness Partner GUIDvarbinary160
79CRMM_BUT_FRG0060Business Partner Business Hours2PARTNER_GUIDBusiness Partner GUIDvarbinary160
80CRMM_BUT_FRG0061Business Partner Business Hours Interval2PARTNER_GUIDBusiness Partner GUIDvarbinary160
TOPSAP Multiresource Scheduling
81/MRSS/D_RES_DETDetails of internal and external resource2PARTNER_GUIDBusiness Partner GUIDvarbinary160
82/MRSS/D_RES_EXTExternal resource on Maximum orders validity details3PARTNER_GUIDBusiness Partner GUIDvarbinary160
83/MRSS/D_RES_FRZNFrozen period of resource2PARTNER_GUIDBusiness Partner GUIDvarbinary160
84/MRSS/D_RES_SP_DSpare parts delivery pattern of resource2PARTNER_GUIDBusiness Partner GUIDvarbinary160
TOPSocial Services and Social Security
85PSSCD_SXP_PARTNRSXP Partner4PARTNER_GUIDBusiness Partner GUIDvarbinary160
86PSSCD_SXP_PAYM_RSXP Additional Payment Recipients4PARTNER_GUIDBusiness Partner GUIDvarbinary160
TOPUse AP-MD-BP Components
87BUT000BP: General data I82PARTNER_GUIDBusiness Partner GUIDvarbinary160
88BUT000_TDBP: General Data I, Shadow Table Time Dependency83PARTNER_GUIDBusiness Partner GUIDvarbinary160
89BUT000_TDSBP: General Data I, Shadow Table Time Dependency84PARTNER_GUIDBusiness Partner GUIDvarbinary160
90BUTADRSEARCHMass Search Help: Business Partner25PARTNER_GUIDBusiness Partner GUIDvarbinary160
91MOM052Workplace Addresses2PARTNER_GUIDBusiness Partner GUIDvarbinary160
92MOM052_FSWorkplace Address Usages2PARTNER_GUIDBusiness Partner GUIDvarbinary160