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  | TCNT
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
Project System :: Information System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TCNT751Project Information System: PS Info ProfileInformation System
SQL:  selectupdate insert create

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

SELECT MANDT, PROFID, AENAM, PROTECT, CUSTOM, PROF_DB, PROF_ST, PROF_PD, PROF_PE, PROF_VB, PROF_VP, PROF_PL, PROF_AF, PROF_NZ, PROF_VG, PROF_AB, PROF_MS, PROF_FH, PROF_KB, PROF_MR, PROF_RM, PROF_ZV, PROF_EG, KPRF_PD, KPRF_PE, KPRF_PX, KPRF_PL, KPRF_AF, KPRF_NZ, KPRF_VE, KPRF_AB, KPRF_MS, KPRF_FH, KPRF_KB, KPRF_MR, KPRF_RM, TITLETEXT, TOPTEXT, TOP_LSTVAR, POS_LSTVAR, PICKUP_KEY, PICKUP_FLD, FLG_CSVRMK, PROF_UC, STRGR_GRUP, STRGR_NAME, STRGR_INDX, PROF_EL, PROF_FD, PROF_GR, PSRLV_MIT, PSRLV_ERL, PSRLV_FIN, FLG_OTX, FLG_OTP, FLG_PSP, WRT_OBJ, WRT_FLD, SELSET_FLT, SELID, SELSET_OFT, SEL_FLG_PD, SEL_FLG_PE, SEL_FLG_PX, SEL_FLG_PL, SEL_FLG_AF, SEL_FLG_NZ, SEL_FLG_VW, SEL_FLG_VE, SEL_FLG_VC, SEL_FLG_EW, SEL_FLG_EE, SEL_FLG_EC, SEL_FLG_FH, SEL_FLG_MR FROM TCNT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PROFIDProject Info System overall profilenvarchar120CHAR(N' ')NoPS_PROF_GS Allow NULL? 
3AENAMLast changed bynvarchar120CHAR(N' ')YesPS_AENAM Allow NULL? 
4PROTECTIndicator: Protected entrychar10CHAR(N' ')YesPS_PROTECT Allow NULL? 
5CUSTOMIndicator: Maintenance only allowed from initial menuchar10CHAR(N' ')YesPS_CUSTOM Allow NULL? 
6PROF_DBProfile for logical database PSJnvarchar120CHAR(N' ')YesTCNDBPS_PROF_DB Allow NULL? 
7PROF_STInformation system profile: Structure overviewnvarchar120CHAR(N' ')YesTCNDPS_PROF_ST Allow NULL? 
8PROF_PDInformation System Profile: Project Definition Overviewnvarchar120CHAR(N' ')YesTCNDPS_PROF_PD Allow NULL? 
9PROF_PEInformation System profile: List of WBS elementsnvarchar120CHAR(N' ')YesTCNDPS_PROF_PE Allow NULL? 
10PROF_VBProject Information System Profile: Sales Document Overviewnvarchar120CHAR(N' ')YesTCNDPS_PROF_VB Allow NULL? 
11PROF_VPProject Information System Profile: Sales Doc.Item Overviewnvarchar120CHAR(N' ')YesTCNDPS_PROF_VP Allow NULL? 
12PROF_PLInformation system profile: List of planned ordersnvarchar120CHAR(N' ')YesTCNDPS_PROF_PL Allow NULL? 
13PROF_AFInformation System profile: List of ordersnvarchar120CHAR(N' ')YesTCNDPS_PROF_AF Allow NULL? 
14PROF_NZInformation System profile: List of networksnvarchar120CHAR(N' ')YesTCNDPS_PROF_NZ Allow NULL? 
15PROF_VGInformation System profile: Activity Overviewnvarchar120CHAR(N' ')YesTCNDPS_PROF_VG Allow NULL? 
16PROF_ABInformation System profile: List of relationshipsnvarchar120CHAR(N' ')YesTCNDPS_PROF_AB Allow NULL? 
17PROF_MSProject Info System profile: Milestone overviewnvarchar120CHAR(N' ')YesTCNDPS_PROF_MS Allow NULL? 
18PROF_FHInformation System profile: List of PRTsnvarchar120CHAR(N' ')YesTCNDPS_PROF_FH Allow NULL? 
19PROF_KBInformation System profile: List of capacity requirementsnvarchar120CHAR(N' ')YesTCNDPS_PROF_KB Allow NULL? 
20PROF_MRInformation System profile: Component overviewnvarchar120CHAR(N' ')YesTCNDPS_PROF_MR Allow NULL? 
21PROF_RMProfile Info System: Confirmation Overviewnvarchar120CHAR(N' ')YesTCNDPS_PROF_RM Allow NULL? 
22PROF_ZVProject Info System profile: period breakdownnvarchar120CHAR(N' ')YesTCNDPS_PROF_ZV Allow NULL? 
23PROF_EGProject information system profile: graphic field selectionnvarchar120CHAR(N' ')YesTCNDPS_PROF_EG Allow NULL? 
24KPRF_PDMain profile for resouces: Project definitionsnvarchar100CHAR(N' ')YesTCY06PS_KPRF_PD Allow NULL? 
25KPRF_PEMain profile for resources: WBS elementsnvarchar100CHAR(N' ')YesTCY06PS_KPRF_PE Allow NULL? 
26KPRF_PXMain profile for resources: PS textsnvarchar100CHAR(N' ')YesTCY06PS_KPRF_PX Allow NULL? 
27KPRF_PLMain profile for resources: Planned ordersnvarchar100CHAR(N' ')YesTCY06PS_KPRF_PL Allow NULL? 
28KPRF_AFMain profile for resources: Ordersnvarchar100CHAR(N' ')YesTCY06PS_KPRF_AF Allow NULL? 
29KPRF_NZMain profile for resources: Networksnvarchar100CHAR(N' ')YesTCY06PS_KPRF_NZ Allow NULL? 
30KPRF_VEMain profile for resources: Activities/elementsnvarchar100CHAR(N' ')YesTCY06PS_KPRF_VE Allow NULL? 
31KPRF_ABMain profile for resources: Relationshipsnvarchar100CHAR(N' ')YesTCY06PS_KPRF_AB Allow NULL? 
32KPRF_MSMain profile for resources: Milestonesnvarchar100CHAR(N' ')YesTCY06PS_KPRF_MS Allow NULL? 
33KPRF_FHMain profile for resources: Production resources/toolsnvarchar100CHAR(N' ')YesTCY06PS_KPRF_FH Allow NULL? 
34KPRF_KBMain profile for resources: Capacity requirementsnvarchar100CHAR(N' ')YesTCY06PS_KPRF_KB Allow NULL? 
35KPRF_MRMain profile for resources: Componentsnvarchar100CHAR(N' ')YesTCY06PS_KPRF_MR Allow NULL? 
36KPRF_RMMain profile for resources: Confirmationsnvarchar100CHAR(N' ')YesTCY06PS_KPRF_RM Allow NULL? 
37TITLETEXTProject Info System: Text module name for titlenvarchar600CHAR(N' ')YesRTXTHPS_TITLTXT Allow NULL? 
38TOPTEXTProject Info System: Text module name for headernvarchar600CHAR(N' ')YesRTXTHPS_TOPTEXT Allow NULL? 
39TOP_LSTVARProject Info System: Overview variants for headersnvarchar120CHAR(N' ')YesTCNVLPS_TOPLVAR Allow NULL? 
40POS_LSTVARProject Info System: Overview variants for item linesnvarchar120CHAR(N' ')YesTCNVLPS_POSLVAR Allow NULL? 
41PICKUP_KEYProject Info System: Action when selecting keysnvarchar20NUMC(N'00')YesPS_PCKPKEY Allow NULL? 
42PICKUP_FLDProject Info System: Action when selecting fieldsnvarchar20NUMC(N'00')YesPS_PCKPFLD Allow NULL? 
43FLG_CSVRMKIndicator: Cursor has higher priority than selectionchar10CHAR(N' ')YesPS_FLG_CVM Allow NULL? 
44PROF_UCProject Information System Profile: Unit Conversionnvarchar120CHAR(N' ')YesTCNUPS_PROF_UC Allow NULL? 
45STRGR_GRUPProfile group (sort graphics profiles)nvarchar40CHAR(N' ')YesTCNGNETPRFGRUP Allow NULL? 
46STRGR_NAMEName of graphic profile in Network/Hierarchy Graphicsnvarchar120CHAR(N' ')YesNETPRFNAME Allow NULL? 
47STRGR_INDXProfile index for graphics profileschar10CHAR(N' ')YesNETPRFINDX Allow NULL? 
48PROF_ELProject Info System profile: Element overviewnvarchar120CHAR(N' ')YesTCNDPS_PROF_EL Allow NULL? 
49PROF_FDInformation System Profile: Displayed Fieldsnvarchar120CHAR(N' ')YesTCNFPS_PROF_FD Allow NULL? 
50PROF_GRProject info system profile: Graphicsnvarchar120CHAR(N' ')YesTCNBPS_PROF_GR Allow NULL? 
51PSRLV_MITInformation system: line variant, funds overviewnvarchar30CHAR(N' ')YesPSRLV_MIT Allow NULL? 
52PSRLV_ERLReport version for revenue overviewnvarchar30CHAR(N' ')YesPSRLV_ERL Allow NULL? 
53PSRLV_FINInformation system: Line version of the financial overviewnvarchar30CHAR(N' ')YesPSRLV_FIN Allow NULL? 
54FLG_OTXIndicator: Object is displayed by its short textchar10CHAR(N' ')YesPS_FLG_OTX Allow NULL? 
55FLG_OTPIndicator: Object is displayed by object typechar10CHAR(N' ')YesPS_FLG_OTP Allow NULL? 
56FLG_PSPIndicator: WBS elements are indented according to WBS hier.char10CHAR(N' ')YesPS_FLG_PSP Allow NULL? 
57WRT_OBJWidth of the object columnnvarchar20NUMC(N'00')YesPS_WRT_OBJ Allow NULL? 
58WRT_FLDWidth of the field columnsnvarchar20NUMC(N'00')YesPS_WRT_FLD Allow NULL? 
59SELSET_FLTVariant for general filternvarchar140CHAR(N' ')YesVARIDSELSET_FLT Allow NULL? 
60SELIDSelection ID for status filternvarchar70CHAR(N' ')YesTJ48PS_SELID Allow NULL? 
61SELSET_OFTVariants for object filternvarchar140CHAR(N' ')YesVARIDSELSET_OFT Allow NULL? 
62SEL_FLG_PDIndicator: Display project definitionschar10CHAR(N' ')YesSEL_FLG_PD Allow NULL? 
63SEL_FLG_PEIndicator: Display WBS elementschar10CHAR(N' ')YesSEL_FLG_PE Allow NULL? 
64SEL_FLG_PXIndicator: Display PS textschar10CHAR(N' ')YesSEL_FLG_PX Allow NULL? 
65SEL_FLG_PLIndicator: Display planned orderschar10CHAR(N' ')YesSEL_FLG_PL Allow NULL? 
66SEL_FLG_AFIndicator: Display orderschar10CHAR(N' ')YesSEL_FLG_AF Allow NULL? 
67SEL_FLG_NZIndicator: Display networkschar10CHAR(N' ')YesSEL_FLG_NZ Allow NULL? 
68SEL_FLG_VWIndicator: Display activities processed internallychar10CHAR(N' ')YesSEL_FLG_VW Allow NULL? 
69SEL_FLG_VEIndicator: Display activities processed externallychar10CHAR(N' ')YesSEL_FLG_VE Allow NULL? 
70SEL_FLG_VCIndicator: Display cost activitieschar10CHAR(N' ')YesSEL_FLG_VC Allow NULL? 
71SEL_FLG_EWIndicator: Display work elementschar10CHAR(N' ')YesSEL_FLG_EW Allow NULL? 
72SEL_FLG_EEIndicator: Display external elementschar10CHAR(N' ')YesSEL_FLG_EE Allow NULL? 
73SEL_FLG_ECIndicator: Display cost componentschar10CHAR(N' ')YesSEL_FLG_EC Allow NULL? 
74SEL_FLG_FHIndicator: Display production resources and toolschar10CHAR(N' ')YesSEL_FLG_FH Allow NULL? 
75SEL_FLG_MRIndicator: Display componentschar10CHAR(N' ')YesSEL_FLG_MR Allow NULL? 
NamePrimaryUniqueTypeColumns
TCNT~0YesYesCLUSTEREDPROFID, 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