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  | PHINT
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Plant Maintenance :: Technical Objects :: TakeoverHandover of Technical Objects
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PHINT612Phase In TableTakeoverHandover of Technical Objects
SQL:  selectupdate insert create

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

SELECT MANDT, PHIN_GUID, TL_KEY, KTX01, QUANT, QUNIT, IDATE, BAUJJ, BAUMM, PHIN_LOC, DOCNUM, EXTEQUI, H_EXTEQUI, TO_TYP, DD_TSTAMP, FUNCID, VALID_ON, EQUNR, MATNR, SERNR, REF_EQUNR, HEQUI, TPLNR, TPLMA, H_TL_KEY, TMPL_FL, NEW_H_TL_KEY, NH_MATNR, NH_SERNR, PARTNER_MATNR, RECENT_MATNR, UII, MD_TSN_TSTAMP, MD_TSN, MD_CSN_TSTAMP, MD_CSN, MD_DISN_TSTAMP, MD_DISN, MD_TSO_TSTAMP, MD_TSO, MD_CSO_TSTAMP, MD_CSO, MD_DISO_TSTAMP, MD_DISO, MD_TSR_TSTAMP, MD_TSR, MD_CSR_TSTAMP, MD_CSR, MD_DISR_TSTAMP, MD_DISR, IND_DEL, SOURCE, EQCAT, FLOCDELIND, OBJ_LEVEL, TPLKZ, STAT_CONS, STAT_EXIST, STAT_CREATED, STAT_UPDATED, STAT_FLOC FROM PHINT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PHIN_GUIDGeneric Key for Takeover/Handovernvarchar320CHAR(N' ')NoPHIN_D_PHINGUID Allow NULL? 
3TL_KEYKey (Numc 8) for Table PHINTnvarchar80NUMC(N'00000000')NoPHIN_D_GUID Allow NULL? 
4KTX01Description of technical objectnvarchar400CHAR(N' ')YesKTX01 Allow NULL? 
5QUANTQuantitydecimal133QUAN((0))YesPHIN_D_QTY
6QUNITUnit of Measurenvarchar30UNIT(N' ')Yes*PHIN_D_QUNIT Allow NULL? 
7IDATEInstallation Date (UTC Timestamp)decimal150DEC((0))YesPHIN_D_ID_TSTAMP
8BAUJJYear of constructionnvarchar40CHAR(N' ')YesBAUJJ Allow NULL? 
9BAUMMMonth of Constructionnvarchar20CHAR(N' ')YesPHIN_D_BAUMM Allow NULL? 
10PHIN_LOCAdditional Information (Example: ATA)nvarchar300CHAR(N' ')YesPHIN_D_LOC Allow NULL? 
11DOCNUMIDoc numbernvarchar160NUMC(N'0000000000000000')YesEDI_DOCNUM Allow NULL? 
12EXTEQUIExternal Equipment Numbernvarchar300CHAR(N' ')YesPHIN_D_EXTEQUI Allow NULL? 
13H_EXTEQUISuperior External Equipment Numbernvarchar300CHAR(N' ')YesPHIN_D_HEXTEQUI Allow NULL? 
14TO_TYPType Takeover / Handover Objectchar10CHAR(N' ')YesPHIN_D_TYPE Allow NULL? 
15DD_TSTAMPDismantle Date (UTC Timestamp)decimal150DEC((0))YesPHIN_D_DD_TSTAMP
16FUNCIDFID (Function Identifier)nvarchar400CHAR(N' ')YesPHIN_D_FUNCID Allow NULL? 
17VALID_ONValid Datenvarchar80DATS(N'00000000')YesPHIN_D_VALID_DATE Allow NULL? 
18EQUNREquipment Numbernvarchar180CHAR(N' ')Yes*EQUNR Allow NULL? 
19MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
20SERNRSerial Numbernvarchar180CHAR(N' ')YesGERNR Allow NULL? 
21REF_EQUNR'Copy Reference' for Equipmentnvarchar180CHAR(N' ')Yes*PHIN_D_REFE Allow NULL? 
22HEQUISuperordinate Equipmentnvarchar180CHAR(N' ')Yes*HEQUI Allow NULL? 
23TPLNRFunctional Locationnvarchar400CHAR(N' ')YesPHIN_D_TPLNR40 Allow NULL? 
24TPLMASuperior Functional locationnvarchar400CHAR(N' ')YesPHIN_D_TPLMA40 Allow NULL? 
25H_TL_KEYTable Line Key of Superior Objectnvarchar80NUMC(N'00000000')YesPHIN_D_HGUID Allow NULL? 
26TMPL_FL'Copy Reference' for Functional Locationnvarchar400CHAR(N' ')YesPHIN_D_TMPLFL40 Allow NULL? 
27NEW_H_TL_KEYTable Line Key of Superior Objectnvarchar80NUMC(N'00000000')YesPHIN_D_HGUID Allow NULL? 
28NH_MATNRSuperior Mat. Numbernvarchar180CHAR(N' ')Yes*PHIN_D_NH_MATNR Allow NULL? 
29NH_SERNRSuperior Serial Numbernvarchar180CHAR(N' ')YesPHIN_D_NH_SERNR Allow NULL? 
30PARTNER_MATNRMaterial number used by the business partnernvarchar400CHAR(N' ')YesPHIN_D_PARTNER_MATNR Allow NULL? 
31RECENT_MATNRMaterial Number Used During Last Takeovernvarchar400CHAR(N' ')YesPHIN_D_RECENT_MATNR Allow NULL? 
32UIIUnique Item Identifiernvarchar720CHAR(N' ')YesPHIN_D_UII Allow NULL? 
33MD_TSN_TSTAMPTime Since New: Measurement Date (UTC Timestamp)decimal150DEC((0))YesPHIN_D_MD_TSN_TZNTSTMPS
34MD_TSNTime Since Newnvarchar220CHAR(N' ')YesPHIN_D_MD_TSN Allow NULL? 
35MD_CSN_TSTAMPCycles Since New: Measurement Date (UTC Timestamp)decimal150DEC((0))YesPHIN_D_MD_CSN_TZNTSTMPS
36MD_CSNCycles Since Newnvarchar220CHAR(N' ')YesPHIN_D_MD_CSN Allow NULL? 
37MD_DISN_TSTAMPDays Installed Since New: Measurement Date (UTC Timestamp)decimal150DEC((0))YesPHIN_D_MD_DISN_TZNTSTMPS
38MD_DISNDays Installed Since Newnvarchar220CHAR(N' ')YesPHIN_D_MD_DISN Allow NULL? 
39MD_TSO_TSTAMPTime Since Overhaul: Measurement Date (UTC Timestamp)decimal150DEC((0))YesPHIN_D_MD_TSO_TZNTSTMPS
40MD_TSOTime Since Overhaulnvarchar220CHAR(N' ')YesPHIN_D_MD_TSO Allow NULL? 
41MD_CSO_TSTAMPCycles Since Overhaul: Measurement Date (UTC Timestamp)decimal150DEC((0))YesPHIN_D_MD_CSO_TZNTSTMPS
42MD_CSOCycles Since Overhaulnvarchar220CHAR(N' ')YesPHIN_D_MD_CSO Allow NULL? 
43MD_DISO_TSTAMPDays Installed Since Overhaul: MeasuremDate (UTC Timestamp)decimal150DEC((0))YesPHIN_D_MD_DISO_TZNTSTMPS
44MD_DISODays Installed Since Overhaulnvarchar220CHAR(N' ')YesPHIN_D_MD_DISO Allow NULL? 
45MD_TSR_TSTAMPTime Since Repair: Measurement Date (UTC Timestamp)decimal150DEC((0))YesPHIN_D_MD_TSR_TZNTSTMPS
46MD_TSRTime Since Repairnvarchar220CHAR(N' ')YesPHIN_D_MD_TSR Allow NULL? 
47MD_CSR_TSTAMPCycles Since Repair: Measurement Date (UTC Timestamp)decimal150DEC((0))YesPHIN_D_MD_CSR_TZNTSTMPS
48MD_CSRCycles Since Repairnvarchar220CHAR(N' ')YesPHIN_D_MD_CSR Allow NULL? 
49MD_DISR_TSTAMPDays Installed Since Repair: MeasuremDate (UTC Timestamp)decimal150DEC((0))YesPHIN_D_MD_DISR_TZNTSTMPS
50MD_DISRDays Installed Since Repairnvarchar220CHAR(N' ')YesPHIN_D_MD_DISR Allow NULL? 
51IND_DELDeletion Indicatorchar10CHAR(N' ')YesPHIN_D_DEL Allow NULL? 
52SOURCETakeover / Handover: Source Indicatorchar10CHAR(N' ')YesPHIN_D_SOURCE Allow NULL? 
53EQCATTechnical Object Categorychar10CHAR(N' ')YesPHIN_D_EQTYP Allow NULL? 
54FLOCDELINDDeletion Indicatorchar10CHAR(N' ')YesPHIN_D_DEL Allow NULL? 
55OBJ_LEVELLevel in Object Structuretinyint30INT1((0))YesPHIN_D_LEVEL
56TPLKZFunctional location structure indicatornvarchar50CHAR(N' ')Yes*TPLKZ Allow NULL? 
57STAT_CONSTakeover State Consistencychar10CHAR(N' ')YesPHIN_D_STATE_CONS Allow NULL? 
58STAT_EXISTTakeover State Existencechar10CHAR(N' ')YesPHIN_D_STATE_EXIST Allow NULL? 
59STAT_CREATEDTakeover State Object Createdchar10CHAR(N' ')YesPHIN_D_STATE_CREATE Allow NULL? 
60STAT_UPDATEDTakeover State Updatedchar10CHAR(N' ')YesPHIN_D_STATE_UPDATE Allow NULL? 
61STAT_FLOCTakeover / Handover State Functional Location Assignmentchar10CHAR(N' ')YesPHIN_D_STATE_FLOC Allow NULL? 
NamePrimaryUniqueTypeColumns
PHINT~0YesYesCLUSTEREDTL_KEY, PHIN_GUID, MANDT
PHINT~001NoNoNONCLUSTEREDEQUNR, 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