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

52 columns | Print definition?ERP 6.0  | VARIANT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PLMB/EXP_LAYOUTDownload Data: Selection Layout6VARIANT_IDVariantnvarchar300
2/SAPSRM/C_VIEW_MTable to switch FPM Main View6VARIANT_IDVariant IDnvarchar200
3/XLSO/ALWD_PYMTSTable to store allowed payments.3VARIANT_IDProduct catalog variantnvarchar30
4/XLSO/SHOP_DETTable to maintain shop related information3VARIANT_IDProduct catalog variantnvarchar30
5BTP_DL_BPPIFDBTP Assignment of PIFD Interfaces to Blueprints3VARIANT_IDPIFD Variant IDnvarchar320
6BTP_DL_PPHITAVARBTP PIFD Variants on Step Level4VARIANT_IDPIFD Variant IDnvarchar320
7BTP_DL_PPIFDVARBTP PIFD Variants on Project Level3VARIANT_IDPIFD Variant IDnvarchar320
8CNVMBTACTPARLOGMBT PCL - Activity execution log8VARIANT_IDName for Set of Activity Parametersnvarchar140
9CNVMBTCHKLOGPROFCheck Framework: Log Profile Executions5VARIANT_IDPIFD Variant IDnvarchar320
10CNVMBTGLBVARCONTContents of PIFD Global Variant4VARIANT_IDPIFD Variant IDnvarchar320
11CNVMBTVARCLUPIFD Variant Cluster2VARIANT_IDPIFD Variant IDnvarchar320
12CNVMBTVARIANTTPIFD Variant Descriptions1VARIANT_IDPIFD Variant IDnvarchar320
13CNVMBTVARPARAMPIFD Parameters contained in an Interface1VARIANT_IDPIFD Variant IDnvarchar320
14DVM_BOF_PACKSBusiness Object Footprint packages for PPF2VARIANT_IDGUID in 'RAW' formatvarbinary160
15DVM_BOF_RUNSBusiness Objects Footprint runs2VARIANT_IDGUID in 'RAW' formatvarbinary160
16DVM_BOF_STATSBusiness Objects Footprint statistics2VARIANT_IDGUID in 'RAW' formatvarbinary160
17GRFNREPUSRVARReporting: Reports users variants4VARIANT_IDReport variant IDnvarchar320
TOPBusiness Context Viewer
18/BCV/D_CP_VARInput Parameter Sets to execute objects from BCV Cockpit2VARIANT_IDGlobally Unique Identifier for BCV Variantvarbinary160
19/BCV/D_CP_VARDEFDefault variant to execute objects from BCV Cockpit5VARIANT_IDGlobally Unique Identifier for BCV Variantvarbinary160
20/BCV/D_CP_VARTDescriptions of BCV Cockpit Variants2VARIANT_IDGlobally Unique Identifier for BCV Variantvarbinary160
21/BCV/D_CP_VARVALVariant Values for execution from BCV Cockpit2VARIANT_IDGlobally Unique Identifier for BCV Variantvarbinary160
TOPBusiness Navigator
22DF50LVariants1VARIANT_IDVariantnvarchar200
23DF50OVariant objects1VARIANT_IDVariantnvarchar200
24DF50TVariant descriptions2VARIANT_IDVariantnvarchar200
TOPEnd User Technology
25RSKPI_VNTKPI Variant: Header Data2VARIANT_IDTechnical Name of Variant of KPInvarchar300
26RSKPI_VNTTKPI Variant: Header Data Texts2VARIANT_IDTechnical Name of Variant of KPInvarchar300
27RSKPI_VNT_INVALKPI Variant: Input Parameter Values2VARIANT_IDTechnical Name of Variant of KPInvarchar300
28RSKPI_VNT_THDKPI Variant: Threshold Values2VARIANT_IDTechnical Name of Variant of KPInvarchar300
29RSKPI_WL_ENTRYKPI Watchlist: Entry4VARIANT_IDTechnical Name of Variant of KPInvarchar300
TOPMedia Product Sales and Distribution
30JKSDCONTRACTCHARAdditional Fields for Sales Quantity Planning14VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
31JKSDFCHEADIS-M: Reference Issue Header Data3VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
32JKSDFCHEADPOIS-M: Header Data for Ref. Issues with Planning Organization4VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
33JKSDFCITEMIS-M: Media Issue Item Data3VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
34JKSDFCITEMPOIS-M: Media Issue Item Data with Planning Organization4VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
35JKSDFCSEGVARAREAAssignment of Segmentation Variant to a Planning Area (FC)2VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
36JKSDFCSEGVARIANTAssign Segments to Segmentation Variant3VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
37JKSDFCVARIANTIS-M: Reference Issue Header Data3VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
38JKSDFCVARIANTPOIS-M: Header Data for Ref. Issues with Planning Organization4VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
39TJKSDFCSEGVARSegmentation Variant2VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
40TJKSDFCSEGVARTText Table for TJKSDFCSEGVAR2VARIANT_IDSegmentation Variant in Forecast Planningnvarchar180
TOPRisk Assessment
41EHHSSC_RASSTEPAssessment Steps3VARIANT_IDVariant of Risk Assessment Stepnvarchar600
TOPService Implementation Workbench
42TSIW_TESTDATATest data2VARIANT_IDvariant idnvarchar500
TOPService Mapping Tool
43TSMT_VARIANTNot Used: (Results Variant)2VARIANT_IDVariant of an Eventnvarchar100
TOPUser Interface
44/PLMPCV/D_CHARTChart Output Appearance for Query Views3VARIANT_IDID of Query Viewnvarchar320
45/PLMPCV/D_CHARTTChart Output Text Table3VARIANT_IDID of Query Viewnvarchar320
46/PLMPCV/D_DASHBDashboards for PCV Content6VARIANT_IDID of Query Viewnvarchar320
47/PLMPCV/D_GROUPGrouping for PCV Queries and Variants5VARIANT_IDID of Query Viewnvarchar320
48/PLMPCV/D_PRVIEWPreview Defintions5VARIANT_IDID of Query Viewnvarchar320
49/PLMPCV/D_STRUCQuery Variant Structure Defintion3VARIANT_IDID of Query Viewnvarchar320
50/PLMPCV/D_VARBQuery View Variables3VARIANT_IDID of Query Viewnvarchar320
51/PLMPCV/D_VARTQuery Views3VARIANT_IDID of Query Viewnvarchar320
52/PLMPCV/D_VARTTQuery Variant Texts3VARIANT_IDID of Query Viewnvarchar320