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

44 columns | Print definition?ERP 6.0  | HEADER_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/SOCO_DOCTable Containing Follow-on Documents Created in Background4HEADER_GUIDGlobally Unique identifiervarbinary160
2/SAPSRM/SOCO_ITTable for storing workarea items for requirement updates2HEADER_GUIDGlobally Unique identifiervarbinary160
3BBPD_PD_INDEX_HIndex Table for a Selective First Access in GetList3HEADER_GUIDGlobally Unique identifiervarbinary160
4BBPD_PD_INDEX_IIndex Table for a Selective First Access in GetList4HEADER_GUIDGlobally Unique identifiervarbinary160
5BBP_CT_ATTACHMAttachment3HEADER_GUIDGUID Headervarbinary160
6BBP_CT_ATTRAttributes3HEADER_GUIDGUID Headervarbinary160
7BBP_CT_ATTRDEFAttribute definitions3HEADER_GUIDGUID Headervarbinary160
8BBP_CT_ATTRDEF_TAttribute Definitions, Texts3HEADER_GUIDGUID Headervarbinary160
9BBP_CT_ATTRPVALPossible Attribute Values3HEADER_GUIDGUID Headervarbinary160
10BBP_CT_ATTRPVALTPossible Attribute Values, Texts3HEADER_GUIDGUID Headervarbinary160
11BBP_CT_ATTRTOCATLinks Attributes to Categories3HEADER_GUIDGUID Headervarbinary160
12BBP_CT_CATALOGCatalog3HEADER_GUIDGUID Headervarbinary160
13BBP_CT_CATALOG_TCatalog/Schema Texts3HEADER_GUIDGUID Headervarbinary160
14BBP_CT_CATEGORYCategory3HEADER_GUIDGUID Headervarbinary160
15BBP_CT_CATEGORYTCategory Texts3HEADER_GUIDGUID Headervarbinary160
16BBP_CT_CATMAPCategory Mapping3HEADER_GUIDGUID Headervarbinary160
17BBP_CT_DESCRDescription9HEADER_GUIDGUID Headervarbinary160
18BBP_CT_HEADERHeader2HEADER_GUIDGUID Headervarbinary160
19BBP_CT_LOADSTRUCStructure of Product Catalogs or Classification Schemas2HEADER_GUIDGUID Headervarbinary160
20BBP_CT_LONGTEXTLong Text3HEADER_GUIDGUID Headervarbinary160
21BBP_CT_PARTNERPartner3HEADER_GUIDGUID Headervarbinary160
22BBP_CT_PPRODUCTPartner Product3HEADER_GUIDGUID Headervarbinary160
23BBP_CT_PRDPRICEProduct Price3HEADER_GUIDGUID Headervarbinary160
24BBP_CT_PRODUCTProduct3HEADER_GUIDGUID Headervarbinary160
25BBP_CT_VALRESTRAttribute Value Restrictions3HEADER_GUIDGUID Headervarbinary160
26BBP_PDHIERContract Hierarchy Information3HEADER_GUIDHeader GUID of the Main Node of the Hierarchyvarbinary160
TOPActual Update and Commitment Update
27GTR_TRANSLATORGrantor: Translator of CRM and ERP Integration Attributes2HEADER_GUIDExternal Object Technical Keynvarchar340
TOPCollaborative Cross Applications
28/POA/D_CTX_ITEMPOA SBC Context Item2HEADER_GUIDHeader GUIDnvarchar320
TOPControl Plan
29DPR_CTRLPLAN_LControl Plan Links5HEADER_GUIDApplication Object GUID (Entity with Conversion Exit)varbinary160
TOPFunds Management
30IAOM_GTR_EXATGrantor: Account Assignment Manager External Characteristics3HEADER_GUIDGrantor: Header GUIDnvarchar320
TOPGoods Issue Process
31/SPE/CRMD_PO_MAPCorrelation Table Third Party PO <-> CRM Sales Order4HEADER_GUIDGUID of a CRM Order Objectvarbinary160
32/SPE/CRMD_PR_MAPMapping Table Purchase Requisition <-> CRM Sales Order4HEADER_GUIDGUID of a CRM Order Objectvarbinary160
TOPIntegration Customer Relationship Management
33ECONSEG_H_PARCustomer Consumption Segment Parameter2HEADER_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320
34ECONSEG_I_PARCustomer Consumption Segment Item Parameter5HEADER_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320
35EPPSIMRESULTProduct Proposal Simulation Results4HEADER_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPLogistics - General
36CRM_SRV_LOG_SCCRM Service: Logistics Scenarios2HEADER_GUIDExternal Object Technical Keynvarchar340
TOPMaintenance Orders
37/MRSS/D_DEM_SPLISplit Information of Demands5HEADER_GUIDGUIDvarbinary160
TOPRegulatory reporting for insurance companies
38TISSR_LT_BODYGespeicherte Listinhalte neues Meldewesen2HEADER_GUIDISSR: UUID für Basistabellenvarchar320
39TISSR_LT_HEADERKopftabelle zur Speicherung von Listinhalten im neuen Mw2HEADER_GUIDISSR: UUID für Basistabellenvarchar320
40TISSR_LT_HEADERTKopftabelle zur Speicherung von Listinhalten im neuen Mw3HEADER_GUIDISSR: UUID für Basistabellenvarchar320
TOPWarranty Claim Processing
41PNWTYVWarranty Claim Version (PVS Node)44HEADER_GUIDInternal Number of iPPE Nodevarbinary160
42PRWTYiPPE Relationship: Time-Ind. Ident./Attributes Warranty18HEADER_GUIDInternal Number of iPPE Nodevarbinary160
43WTY_PARTNER_TABPartner for Warranty Claim6HEADER_GUIDGUID Warranty Claimvarbinary160
TOPWorkforce Management Core
44WFDSD_DEMANDWork Force Deployment Demand7HEADER_GUIDGUIDvarbinary160