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  | CMS_AST
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Services :: Collateral Management System :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CMS_AST665Asset DetailsMaster Data
SQL:  selectupdate insert create

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

SELECT MANDT, AST_GUID, AST_ID, AST_TYP, PARENT_GUID, SUBAST_ID, SUBAST_TYP, DESCRIPTION, OBJECT_REF_ID, OBJECT_TYP, COUNTRY_KEY, RISK_CODE, SFTY_IND, SFTY_DSCNT, SFTY_AMOUNT, SFTY_AMT_CURR, OBJSYSID, VALUATION_TYP, UNIT_VALN_FREQ, PERIOD_VALN_FREQ, PAST_VALUED_DATE, START_DATE, END_DATE, LENDING_RATE_IND, LENDING_RATE1, LENDING_RATE2, LENDING_RATE3, LENDING_RATE4, LENDING_RATE5, LIQD_TYP, LIQD_REASON, LIQD_DATE, LIQD_AMT, LIQD_CURR, EXP_PRCD_AMNT, EXP_PRCD_CURR, EXP_ACC_DATE, ACC_NUMBER_LIQ, BANK_CNTRY_LIQ, BANK_KEY_LIQ, BANK_CTRLKEY_LIQ, UNIT_VERF_FREQ, PERIOD_VERF_FREQ, LAST_VERF_DATE, NOM_VALUE, NOM_VALUE_CURR, AST_VALUE, AST_VALUE_CURR, QUANTITY, UNIT_OF_MEASURE, REC_AT, PUR_PRICE, PUR_PRICE_CURR, PUR_DATE, ADMIN_ORG_UNIT, BANKAREA, ORG_UNIT1, ORG_UNIT2, ORG_UNIT3, ORG_UNIT4, ORG_UNIT5, CREATED_BY, CREATED_AT, CHANGED_BY, CHANGED_AT, SOURCEOFENTRY FROM CMS_AST
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2AST_GUIDGUID for Table CMS_ASTvarbinary160RAWNoCMS_DTE_AST_GUID
3AST_IDAsset IDnvarchar400CHAR(N' ')YesCMS_DTE_AST_ID Allow NULL? 
4AST_TYPAsset Typenvarchar60CHAR(N' ')YesTCMS_AST_TYPCMS_DTE_AST_TYP Allow NULL? 
5PARENT_GUIDAsset Guid as a parent GUID for a sub-assetvarbinary160RAWYesCMS_DTE_SAS_PAR_GUID
6SUBAST_IDSub-asset IDnvarchar40NUMC(N'0000')YesCMS_DTE_SAS_ID Allow NULL? 
7SUBAST_TYPSub-asset Typenvarchar60CHAR(N' ')YesCMS_DTE_SAS_TYP Allow NULL? 
8DESCRIPTIONDescriptionnvarchar300CHAR(N' ')YesCMS_DTE_AST_DESC Allow NULL? 
9OBJECT_REF_IDReference ID for the objectnvarchar400CHAR(N' ')YesCMS_DTE_OBJ_REFID Allow NULL? 
10OBJECT_TYPNot usednvarchar320CHAR(N' ')YesCMS_DTE_OBJ_TYP Allow NULL? 
11COUNTRY_KEYIdentification Key for Countrynvarchar30CHAR(N' ')YesT005CMS_DTE_AST_COUNTRY_KEY Allow NULL? 
12RISK_CODERisk Codenvarchar60CHAR(N' ')Yes*CMS_DTE_RISK_CODE Allow NULL? 
13SFTY_INDIndicates if the Asset has a Default Safety Discountnvarchar20CHAR(N' ')YesCMS_DTE_IND_SFTY_DISC Allow NULL? 
14SFTY_DSCNTPercentage of Safety Discountdecimal106DEC((0))YesCMS_DTE_SAFETY_DSCNT
15SFTY_AMOUNTAmount of Safety Discountdecimal172CURR((0))YesCMS_DTE_SAFETY_AMT
16SFTY_AMT_CURRCurrency of the Safety Discount Amountnvarchar50CUKY(N' ')YesTCURCCMS_DTE_SAFETY_AMT_CURR Allow NULL? 
17OBJSYSIDObject System Reference IDnvarchar60CHAR(N' ')YesCMS_DTE_OBJ_SYSID Allow NULL? 
18VALUATION_TYPType of Valuation Check performed on Collateral Objectnvarchar20CHAR(N' ')YesCMS_DTE_IND_VALN_TYP Allow NULL? 
19UNIT_VALN_FREQIndicator: Units of time for revaluation of an assetnvarchar20CHAR(N' ')YesCMS_DTE_IND_AST_VALN_FREQ_UNIT Allow NULL? 
20PERIOD_VALN_FREQRevaluation Period for an Assetnvarchar40NUMC(N'0000')YesCMS_DTE_AST_VALN_FREQ_PERIOD Allow NULL? 
21PAST_VALUED_DATELast Date on which the Asset was Valuednvarchar80DATS(N'00000000')YesCMS_DTE_VALN_DATE Allow NULL? 
22START_DATEDate on which the First Valuation is Performed on the Assetnvarchar80DATS(N'00000000')YesCMS_DTE_START_DATE Allow NULL? 
23END_DATEDate on which the Last Valuation is Performed on the Assetnvarchar80DATS(N'00000000')YesCMS_DTE_END_DATE Allow NULL? 
24LENDING_RATE_INDIndicator to specify if Asset has a Default Lending Ratenvarchar20CHAR(N' ')YesCMS_DTE_IND_LND_RTE Allow NULL? 
25LENDING_RATE1Lending Rate 1decimal106DEC((0))YesCMS_DTE_LRTE_PCT1
26LENDING_RATE2Lending Rate 2decimal106DEC((0))YesCMS_DTE_LRTE_PCT2
27LENDING_RATE3Lending Rate 3decimal106DEC((0))YesCMS_DTE_LRTE_PCT3
28LENDING_RATE4Lending Rate 4decimal106DEC((0))YesCMS_DTE_LRTE_PCT4
29LENDING_RATE5Lending Rate 5decimal106DEC((0))YesCMS_DTE_LRTE_PCT5
30LIQD_TYPLiquidation Typenvarchar60CHAR(N' ')YesTCMS_AST_LTYPCMS_DTE_LIQD_TYP Allow NULL? 
31LIQD_REASONLiquidation Reasonnvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_ATT_ID_TY_AST004 Allow NULL? 
32LIQD_DATEDate on which the Collateral was Liquidatednvarchar80DATS(N'00000000')YesCMS_DTE_LIQD_DATE Allow NULL? 
33LIQD_AMTReturns from the Liquidation of Collateraldecimal172CURR((0))YesCMS_DTE_LIQD_VALUE
34LIQD_CURRCurrency of Liquidation Valuenvarchar50CUKY(N' ')YesTCURCCMS_DTE_LIQD_CURR Allow NULL? 
35EXP_PRCD_AMNTExpected Proceed Amountdecimal172CURR((0))YesCMS_DTE_LIQ_EXP_PRCD_AMOUNT
36EXP_PRCD_CURRCurrency: Expected Proceednvarchar50CUKY(N' ')YesTCURCCMS_DTE_LIQ_EXP_PRCD_CURR Allow NULL? 
37EXP_ACC_DATEExpected accrual datenvarchar80DATS(N'00000000')YesCMS_DTE_LIQ_EXP_ACCRUAL_DATE Allow NULL? 
38ACC_NUMBER_LIQAccount number for liquidation proceedsnvarchar350CHAR(N' ')YesCMS_DTE_LIQ_ACC_NUMBER Allow NULL? 
39BANK_CNTRY_LIQBank country keynvarchar30CHAR(N' ')YesT005CMS_DTE_LIQ_BNK_CTRY_KY Allow NULL? 
40BANK_KEY_LIQBank Keynvarchar150CHAR(N' ')YesCMS_DTE_LIQ_BNK_KEY Allow NULL? 
41BANK_CTRLKEY_LIQBank Control Keynvarchar20CHAR(N' ')YesBKONT Allow NULL? 
42UNIT_VERF_FREQIndicator: Units of time for verification of an assetnvarchar20CHAR(N' ')YesCMS_DTE_IND_AST_VERF_FREQ_UNIT Allow NULL? 
43PERIOD_VERF_FREQStatement Period for an Assetnvarchar40NUMC(N'0000')YesCMS_DTE_AST_VERF_FREQ_PERIOD Allow NULL? 
44LAST_VERF_DATELast Verification Datenvarchar80DATS(N'00000000')YesCMS_DTE_AST_VERF_DATE Allow NULL? 
45NOM_VALUENominal Value of the Assetdecimal172CURR((0))YesCMS_DTE_AST_NOMINAL_VALUE
46NOM_VALUE_CURRCurrency of Nominal valuenvarchar50CUKY(N' ')YesTCURCCMS_DTE_AST_NOMINAL_VALUE_CURR Allow NULL? 
47AST_VALUEFinal Asset Valuedecimal172CURR((0))YesCMS_DTE_AST_VALUE
48AST_VALUE_CURRCurrency of the Final Asset Valuenvarchar50CUKY(N' ')YesTCURCCMS_DTE_AST_VALUE_CURR Allow NULL? 
49QUANTITYQuantitydecimal133QUAN((0))YesCMS_DTE_QTY
50UNIT_OF_MEASUREUnit of Measure of Quantitynvarchar30UNIT(N' ')YesT006CMS_DTE_UNIT Allow NULL? 
51REC_ATAsset Value Recording Timestampdecimal150DEC((0))YesCMS_DTE_REC_AT
52PUR_PRICEPurchase Price of the Assetdecimal172CURR((0))YesCMS_DTE_AST_PURCHASE_PRICE
53PUR_PRICE_CURRCurrency of Purchase Pricenvarchar50CUKY(N' ')YesTCURCCMS_DTE_AST_PUR_PRICE_CURR Allow NULL? 
54PUR_DATEDate of Purchasenvarchar80DATS(N'00000000')YesCMS_DTE_AST_PUR_PRICE_DATE Allow NULL? 
55ADMIN_ORG_UNITAdministration Organizational Unitnvarchar120CHAR(N' ')YesCMS_DTE_ADMINORG Allow NULL? 
56BANKAREABank Area in Collateral Managementnvarchar40CHAR(N' ')Yes*CMS_DTE_BANKAREA Allow NULL? 
57ORG_UNIT1Organizational Unit 1 of an Assetnvarchar100CHAR(N' ')Yes*CMS_DTE_AST_ORG_UNIT1 Allow NULL? 
58ORG_UNIT2Organizational Unit 2 of an Assetnvarchar100CHAR(N' ')Yes*CMS_DTE_AST_ORG_UNIT2 Allow NULL? 
59ORG_UNIT3Organizational Unit 3 of an Assetnvarchar100CHAR(N' ')Yes*CMS_DTE_AST_ORG_UNIT3 Allow NULL? 
60ORG_UNIT4Organizational Unit 4 of an Assetnvarchar100CHAR(N' ')Yes*CMS_DTE_AST_ORG_UNIT4 Allow NULL? 
61ORG_UNIT5Organizational Unit 5 of an Assetnvarchar100CHAR(N' ')Yes*CMS_DTE_AST_ORG_UNIT5 Allow NULL? 
62CREATED_BYLogin ID of the User who created the Recordnvarchar120CHAR(N' ')YesCMS_DTE_USER Allow NULL? 
63CREATED_ATCreation Timestampdecimal150DEC((0))YesCMS_DTE_CREATED_AT
64CHANGED_BYLast Changed Bynvarchar120CHAR(N' ')YesCMS_DTE_LAST_CHNG_USER Allow NULL? 
65CHANGED_ATChange Timestampdecimal150DEC((0))YesCMS_DTE_CHANGED_AT
66SOURCEOFENTRYSource of Entrynvarchar320CHAR(N' ')YesCMS_DTE_SOURCE_OF_ENTRY Allow NULL? 
NamePrimaryUniqueTypeColumns
CMS_AST~0YesYesCLUSTEREDAST_GUID, MANDT
CMS_AST~OBJNoNoNONCLUSTEREDOBJECT_REF_ID, OBJSYSID, MANDT
CMS_AST~ORINoNoNONCLUSTEREDOBJECT_REF_ID, MANDT
CMS_AST~PGDNoNoNONCLUSTEREDPARENT_GUID, MANDT
CMS_AST~SKYNoNoNONCLUSTEREDAST_TYP, AST_ID, 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