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  | PPEFILTEXPL
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
Application Platform :: Integrated Product and Process Engineering
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PPEFILTEXPL231This table is obsolete, use PPEFILTEXPLPARIntegrated Product and Process Engineering
SQL:  selectupdate insert create

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

SELECT EXPL_GUID, TECHS, CUOBJ, PPE_USE, LOCID, CMPID, PPEGUID, PPENAME, CLINT, MULTI_LEVEL_CONF, MULTI_LEVEL_ECM, ECM_ACTIVE, PRODVER_ACTIVE, CONF_DET_ACTIVE, AEFRK, AEFRP, AEFRF, AEFRS, DATE_FROM, DATE_TO, LASTNCHSTAT, CHSTAT_DET, DISP_NVALECM FROM PPEFILTEXPL
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1EXPL_GUIDInternal Identification for PVS Objectsvarbinary160RAWNoPVS_GUID
2TECHSParameter Variant/Standard Variantnvarchar120CHAR(N' ')YesPPE_TECHS Allow NULL? 
3CUOBJConfiguration (Internal Object Number)nvarchar180NUMC(N'000000000000000000')YesPPE_CUOBJ Allow NULL? 
4PPE_USEUsage in iPPEnvarchar30CHAR(N' ')Yes*PPE_USE Allow NULL? 
5LOCIDPlant/Location in iPPEnvarchar220CHAR(N' ')YesPPE_LOCID Allow NULL? 
6CMPIDInternal Identification of the Component (Material/Product)nvarchar320CHAR(N' ')YesPVS_CMPID Allow NULL? 
7PPEGUIDInternal Identification for PVS Objectsvarbinary160RAWYesPVS_GUID
8PPENAMEDescription of iPPE Access Objectnvarchar400CHAR(N' ')YesPPE_NAME Allow NULL? 
9CLINTInternal Class Numbernvarchar100NUMC(N'0000000000')Yes*PPE_CLINT Allow NULL? 
10MULTI_LEVEL_CONFAccess Configuration Valid on First Level Onlychar10CHAR(N' ')YesPPE_MULT_LEV_CONF Allow NULL? 
11MULTI_LEVEL_ECMParameter effectivity is only valid to the first levelchar10CHAR(N' ')YesPPE_MULT_LEV_ECM Allow NULL? 
12ECM_ACTIVEParameter Effectivity Activechar10CHAR(N' ')YesPVS_EFFFILT Allow NULL? 
13PRODVER_ACTIVEProduction version is activechar10CHAR(N' ')YesPPE_PRODVER_ACTIVE Allow NULL? 
14CONF_DET_ACTIVEActivate Configuration in the Detail Areachar10CHAR(N' ')YesPPE_CONF_DET_ACTIVE Allow NULL? 
15AEFRKRelease for Costingchar10CHAR(N' ')YesPPE_AFRK Allow NULL? 
16AEFRPRelease for Planningchar10CHAR(N' ')YesPPE_AEFRP Allow NULL? 
17AEFRFRelease for Productionchar10CHAR(N' ')YesPPE_AEFRF Allow NULL? 
18AEFRSRelease for Simulationchar10CHAR(N' ')YesPPE_AEFRS Allow NULL? 
19DATE_FROMEarliest Valid-From Datesnvarchar80DATS(N'00000000')YesPPE_DATE_FROM Allow NULL? 
20DATE_TOLatest Valid-To Datesnvarchar80DATS(N'00000000')YesPPE_DATE_TO Allow NULL? 
21LASTNCHSTATDisplay Last Change Statusesnvarchar30CHAR(N' ')YesPPE_LASTNCHSTAT Allow NULL? 
22CHSTAT_DETFilter Display in Detail Area According to Change Statechar10CHAR(N' ')YesPPE_CHSTAT_DET Allow NULL? 
23DISP_NVALECMDisplay Non-Valuated Change Numberchar10CHAR(N' ')YesPPE_NONVALECM Allow NULL? 
NamePrimaryUniqueTypeColumns
PPEFILTEXPL~0YesYesCLUSTEREDEXPL_GUID

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