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  | /RPM/ITEM_D
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
Portfolio and Project Management :: Portfolio Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/RPM/ITEM_D907Operational item persisted dataPortfolio Management
SQL:  selectupdate insert create

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

SELECT CLIENT, GUID, EXTERNAL_ID, PORTFOLIO_GUID, PARENT_GUID, CATEGORY, SUBCATEGORY, PHASE, PTYPE, TTYPE, RISKA, PROBT, PROBC, HEADC, COSTD, COSTL, NPV, CURRENCY, LOCATION, GEOGRAPHY, RPM_CHANGED_ON, PERIODTYPE, UNIT, FORECAST_START, PLANNED_START, ACTUAL_START, FORECAST_FINISH, PLANNED_FINISH, ACTUAL_FINISH, ESCALATION, ITEM_TYPE, PORTFL_ITEM_GUID, ECV, PRIORITY_GROUP, CHANGED_BY, VERSION_ITEM, ITEM_CLASS, MASTER_ITEM_GUID, STATUS, CAP_PERIODTYPE, INITIATIVE_GUID, DISCOUNT_RATE, ACT_DPCPT_GUID, FRCST_BGT_TOTAL, FRCST_BGTANNUAL, FRCST_COSTTOTAL, FRCST_COST_YTD, TEMPLATE_GUID, IS_GLOBAL, EA_DUMMY, ZZNPDI_SCORE, ZZNPDI_DP, ZZNPDI_DP_STATUS, ZZ_NPDI_NEXTRVW, ZZ_NPDI_REVGRWTH, ZZ_NPDI_SCHEDVAR, ZZ_NPDI_PROFIMP, ZZ_NPDI_BDGTSTRT, ZZ_HER_PA, ZZ_HER_IC, ZZ_HER_SAG, ZZ_PS_AC, ZZ_HER_IR, ZZ_HER_CSR, ZRDS_BUDGET, ZRDS_STRATFIT, ZRDS_TECHRISK, ZRDS_SOCRISK, ZRDS_OVSCORE, ZRDS_BUDGET_S, ZRDS_OVASCORE, ZANUAL_ES, ZANUAL_CS, ZIMP_COST, ZANNUAL_COST, ZSPEND_CAT, ZROI, ZPAYBK, ZAPPROVER, ZTEST, ZACTROI, ZANUAL_ACTES, ZIMP_ACOST, ZACRPAYBK, ZANUAL_ACTCS, ZITSPONSOR, ZBS, ZERMOVRSCORE, ZNUM, ZOEM FROM /RPM/ITEM_D
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2GUIDGuid for application objectsvarbinary160RAWNo/RPM/TV_GUID
3EXTERNAL_IDBusiness Object IDnvarchar240CHAR(N' ')Yes/RPM/TV_EXTID Allow NULL? 
4PORTFOLIO_GUIDGuid for application objectsvarbinary160RAWYes/RPM/TV_GUID
5PARENT_GUIDGuid for application objectsvarbinary160RAWYes/RPM/TV_GUID
6CATEGORYCategorynvarchar40NUMC(N'0000')Yes*RPM_PROJECT_CATEGORY Allow NULL? 
7SUBCATEGORYSubcategorynvarchar40NUMC(N'0000')Yes*RPM_PROJ_SUBCATEGORY Allow NULL? 
8PHASEStagenvarchar40NUMC(N'0000')Yes*RPM_PROJECT_PHASE Allow NULL? 
9PTYPEGroupnvarchar40NUMC(N'0000')Yes*RPM_PROJECTTYPE Allow NULL? 
10TTYPETechnology Typenvarchar40NUMC(N'0000')Yes*RPM_PROJECT_TECHTYPE Allow NULL? 
11RISKAAssessed Project Risknvarchar30NUMC(N'000')YesRPM_PROJECT_RISK_ASSESED Allow NULL? 
12PROBTProbability of Technical Successnvarchar30NUMC(N'000')YesRPM_PROJECT_PROB_TECH Allow NULL? 
13PROBCProbability of Commercial Successnvarchar30NUMC(N'000')YesRPM_PROJECT_PROB_COMM Allow NULL? 
14HEADCActual Headcountdecimal102DEC((0))YesRPM_PROJECT_HEADCOUNT
15COSTDDevelopment Costdecimal162CURR((0))YesRPM_PROJECT_COST_DEVELOPMENT
16COSTLLaunch Costdecimal162CURR((0))YesRPM_PROJECT_COST_LAUNCH
17NPVNet Present Value (manual)decimal162CURR((0))YesRPM_PROJECT_NPV
18CURRENCYCurrency keynvarchar50CUKY(N' ')Yes*RPM_TV_CURRENCY Allow NULL? 
19LOCATIONProject Locationnvarchar40CHAR(N' ')Yes*RPM_TV_PROJECT_LOCATION Allow NULL? 
20GEOGRAPHYProject Geographynvarchar40CHAR(N' ')Yes*RPM_TV_PROJECT_GEOGRAPHY Allow NULL? 
21RPM_CHANGED_ONTime Stampdecimal150DEC((0))YesRPM_TV_TIMESTAMP
22PERIODTYPEFinancial Period Breakdownnvarchar20NUMC(N'00')Yes*/RPM/TV_PERIOD_TYPE Allow NULL? 
23UNITUnitnvarchar30UNIT(N' ')Yes*RPM_TV_UNIT Allow NULL? 
24FORECAST_STARTForecasted Startnvarchar80DATS(N'00000000')YesRPM_TV_FORECAST_START Allow NULL? 
25PLANNED_STARTPlanned Start Datenvarchar80DATS(N'00000000')YesRPM_TV_PLAN_START Allow NULL? 
26ACTUAL_STARTActual Start Datenvarchar80DATS(N'00000000')YesRPM_TV_ACTUAL_START Allow NULL? 
27FORECAST_FINISHForecasted Finish Datenvarchar80DATS(N'00000000')YesRPM_TV_FORECAST_FINISH Allow NULL? 
28PLANNED_FINISHPlanned Finish Datenvarchar80DATS(N'00000000')YesRPM_TV_PLAN_FINISH Allow NULL? 
29ACTUAL_FINISHActual Finish Datenvarchar80DATS(N'00000000')YesRPM_TV_ACTUAL_FINISH Allow NULL? 
30ESCALATIONEscalation Flagchar10CHAR(N' ')YesRPM_TV_ESCALATION Allow NULL? 
31ITEM_TYPETypenvarchar150CHAR(N' ')Yes*/RPM/TV_ITEM_ID Allow NULL? 
32PORTFL_ITEM_GUIDGuid for application objectsvarbinary160RAWYesRPM_TV_GUID
33ECVExpected Commercial Value (manual)decimal162CURR((0))YesRPM_TV_ECV
34PRIORITY_GROUPPriority Groupnvarchar20NUMC(N'00')Yes*RPM_PRIORITY_GROUP Allow NULL? 
35CHANGED_BYLast Changed Bynvarchar120CHAR(N' ')Yes*RPM_TV_CHANGED_BY Allow NULL? 
36VERSION_ITEMProject Version Flagchar10CHAR(N' ')YesRPM_TV_VERSION_FLAG Allow NULL? 
37ITEM_CLASSItem Classificationchar10CHAR(N' ')Yes/RPM/TV_ITEM_CLASS Allow NULL? 
38MASTER_ITEM_GUIDGuid for application objectsvarbinary160RAWYesRPM_TV_GUID
39STATUSStatusnvarchar50CHAR(N' ')Yes*/RPM/TV_STATUS_COMMON Allow NULL? 
40CAP_PERIODTYPECapacity Period Breakdownnvarchar20NUMC(N'00')Yes*/RPM/TV_CAP_PERIOD_TYPE Allow NULL? 
41INITIATIVE_GUIDGuid for application objectsvarbinary160RAWYesRPM_TV_GUID
42DISCOUNT_RATEDiscount Ratedecimal52DEC((0))Yes/RPM/TV_DISCOUNT_RATE
43ACT_DPCPT_GUIDGuid for application objectsvarbinary160RAWYes/RPM/TV_GUID
44FRCST_BGT_TOTALPortfolio Item Forecasted Budget Totaldecimal162CURR((0))Yes/RPM/TV_FORECASTED_BUDGT_TOTAL
45FRCST_BGTANNUALPortfolio Item Forecasted Budget Annualdecimal162CURR((0))Yes/RPM/TV_FORECASTED_BUDGT_ANNL
46FRCST_COSTTOTALPortfolio Item Forecasted Cost Totaldecimal162CURR((0))Yes/RPM/TV_FORECASTED_COST_TOTAL
47FRCST_COST_YTDPortfolio Item Forecasted Cost YTDdecimal162CURR((0))Yes/RPM/TV_FORECASTED_COST_YTD
48TEMPLATE_GUIDGuid for application objectsvarbinary160RAWYes/RPM/TV_GUID
49IS_GLOBALGlobal Templatechar10CHAR(N' ')Yes/RPM/TV_GLOBAL Allow NULL? 
50EA_DUMMYDummy Data Element for Enhanced xRPM Attributeschar10CHAR(N' ')Yes/RPM/TV_EA_DUMMY Allow NULL? 
51ZZNPDI_SCOREScorenvarchar40NUMC(N'0000')YesZ_TV_SCORE Allow NULL? 
52ZZNPDI_DPCurrent DecPointnvarchar800CHAR(N' ')YesZ_TV_DECPOINT Allow NULL? 
53ZZNPDI_DP_STATUSDecision Statusnvarchar400CHAR(N' ')YesZ_TV_DECPOINT_STATUS Allow NULL? 
54ZZ_NPDI_NEXTRVWnvarchar80(N'00000000')Yes Allow NULL? 
55ZZ_NPDI_REVGRWTHnvarchar30(N'000')Yes Allow NULL? 
56ZZ_NPDI_SCHEDVARnvarchar50(N' ')Yes Allow NULL? 
57ZZ_NPDI_PROFIMPnvarchar30(N'000')Yes Allow NULL? 
58ZZ_NPDI_BDGTSTRTBudget Data Elementnvarchar600CHAR(N' ')YesZZBUDGET_DE Allow NULL? 
59ZZ_HER_PAnvarchar50(N' ')Yes Allow NULL? 
60ZZ_HER_ICnvarchar50(N' ')Yes Allow NULL? 
61ZZ_HER_SAGnvarchar50(N' ')Yes Allow NULL? 
62ZZ_PS_ACnvarchar50(N' ')Yes Allow NULL? 
63ZZ_HER_IRnvarchar30(N'000')Yes Allow NULL? 
64ZZ_HER_CSRnvarchar30(N'000')Yes Allow NULL? 
65ZRDS_BUDGETCustom Field Budget Status (RDS)nvarchar20CHAR(N' ')YesZRDS_BUDGETSTATUS Allow NULL? 
66ZRDS_STRATFITKPI Strategic Fit Questionnaire (RDS)tinyint30INT1((0))YesZRDS_STRATFIT
67ZRDS_TECHRISKKPI Technological Risk Questionnaire (RDS)tinyint30INT1((0))YesZRDS_TECHRISK
68ZRDS_SOCRISKKPI Social Risk Questionnaire (RDS)tinyint30INT1((0))YesZRDS_SOCRISK
69ZRDS_OVSCOREKPI Overall Score (RDS)tinyint30INT1((0))YesZRDS_OVSCORE
70ZRDS_BUDGET_SCustom Field Budget Status (RDS PPM)nvarchar20CHAR(N' ')YesZRDS_BUDGET_STATUS Allow NULL? 
71ZRDS_OVASCOREKPI Overall Score Scoring Model (RDS PPM)tinyint30INT1((0))YesZRDS_OVALLSCORE
72ZANUAL_ESEstimated Energy Savings/year(GJ)nvarchar50NUMC(N'00000')YesZANUAL_ES Allow NULL? 
73ZANUAL_CSEstimated Savings $decimal162CURR((0))YesZANUAL_CS
74ZIMP_COSTEstimated Costs $decimal162CURR((0))YesZIMP_COST
75ZANNUAL_COSTAnnual Costs $decimal162CURR((0))YesZANNUAL_COST
76ZSPEND_CATSpend Categorynvarchar600CHAR(N' ')YesZPEND_CAT Allow NULL? 
77ZROI3-Year ROI %int100INT4((0))YesZROI Allow NULL? 
78ZPAYBKEstimated Payback Period (months)nvarchar50NUMC(N'00000')YesZPAYBK Allow NULL? 
79ZAPPROVERAPPROVERnvarchar600CHAR(N' ')YesZAPPROVER Allow NULL? 
80ZTESTApprovernvarchar600CHAR(N' ')YesZTEST Allow NULL? 
81ZACTROI3-Year Actual ROI %int100INT4((0))YesZACTROI Allow NULL? 
82ZANUAL_ACTESActual Energy Savings/Year (GJ)nvarchar50NUMC(N'00000')YesZANUAL_ACTES Allow NULL? 
83ZIMP_ACOSTActual Costs $decimal162CURR((0))YesZIMP_ACTCOST
84ZACRPAYBKActual Payback Period (months)nvarchar50NUMC(N'00000')YesZACRPAYBK Allow NULL? 
85ZANUAL_ACTCSActual Savings $decimal162CURR((0))YesZANUAL_ACTCS
86ZITSPONSORIT Sponsornvarchar400CHAR(N' ')YesZITSPONSOR Allow NULL? 
87ZBSBusiness Sponsornvarchar400CHAR(N' ')YesZBS Allow NULL? 
88ZERMOVRSCOREOverall Score (EERM)nvarchar30NUMC(N'000')YesZERMOVRSCORE Allow NULL? 
89ZNUMNumber of Changesnvarchar100CHAR(N' ')YesZNUM Allow NULL? 
90ZOEMOEM Projectnvarchar100CHAR(N' ')YesZOEM Allow NULL? 
NamePrimaryUniqueTypeColumns
/RPM/ITEM_D~0YesYesCLUSTEREDGUID, CLIENT
/RPM/ITEM_D~1NoNoNONCLUSTEREDPORTFL_ITEM_GUID, PARENT_GUID, PORTFOLIO_GUID
/RPM/ITEM_D~2NoNoNONCLUSTEREDPORTFL_ITEM_GUID
/RPM/ITEM_D~3NoNoNONCLUSTEREDMASTER_ITEM_GUID, ITEM_CLASS
/RPM/ITEM_D~CATNoNoNONCLUSTEREDCATEGORY
/RPM/ITEM_D~EIDNoNoNONCLUSTEREDEXTERNAL_ID
/RPM/ITEM_D~VERNoNoNONCLUSTEREDVERSION_ITEM

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