SAP CMS_STR_COR_RE_MAIN_OBJ_DET Real estate main object details Table data and field list

CMS_STR_COR_RE_MAIN_OBJ_DET is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Real estate main object details" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CMS_STR_COR_RE_MAIN_OBJ_DET TYPE CMS_STR_COR_RE_MAIN_OBJ_DET.

The CMS_STR_COR_RE_MAIN_OBJ_DET table consists of various fields, each holding specific information or linking keys about Real estate main object details data available in SAP. These include OBJ_GUID (GUID for Real Estate Object), OBJECT_ID (Object ID), OBJECT_TYPE (Real Estate Object Type ID), OBJ_PRT_GUID (GUID for Object part)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMS_STR_COR_RE_MAIN_OBJ_DET structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP CMS_STR_COR_RE_MAIN_OBJ_DET structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_STR_COR_RE_MAIN_OBJ_DET table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
WA_REOBJ_DET 0
OBJ_GUIDGUID for Real Estate Object CMS_RE_DTE_OBJ_GUIDRAW16SYSUUIDCMS_RE_OBJ_GUID
OBJECT_IDObject ID CMS_RE_DTE_OBJECT_IDCHAR20ALPHACMS_RE_OBJECT_IDCMS_RE_OBJECT_IDCMS_RE_SRCH_ALL
OBJECT_TYPEReal Estate Object Type ID CMS_RE_DTE_OBJ_TYPCHAR6CMS_RE_TYPCMS_RE_OBJECT_TYPE
OBJ_PRT_GUIDGUID for Object part CMS_RE_DTE_OBJ_PRT_GUIDRAW16SYSUUID
BLD_PART_TYPEBuilding Part Type CMS_RE_DTE_ATT_ID_TY_REO006CHAR6CMS_ATT_ID_TYP
PART_CONDObject condition CMS_RE_DTE_ATT_ID_TY_REO001CHAR6CMS_ATT_ID_TYP
MAIN_USAGEUsage Type CMS_RE_DTE_USG_TYPCHAR6CMS_RE_TYP
ADD_USAGE_1Additional Usage 1 CMS_RE_DTE_ADD1_USG_TYPCHAR6CMS_RE_TYP
ADD_USAGE_2Additional Usage 2 CMS_RE_DTE_ADD2_USG_TYPCHAR6CMS_RE_TYP
BLD_METHOD_ROOFBuilding method - Roof CMS_RE_DTE_ATT_ID_TY_REO007CHAR6CMS_ATT_ID_TYP
BLD_METHOD_BODYBuilding method - Body CMS_RE_DTE_ATT_ID_TY_REO008CHAR6CMS_ATT_ID_TYP
BLD_METD_CELLARBuilding method - Cellar CMS_RE_DTE_ATT_ID_TY_REO009CHAR6CMS_ATT_ID_TYP
UTILIZATIONUtilization of the Object CMS_RE_DTE_PRT_UTILIZATIONCHAR6CMS_RE_UTIL
PART_DESCDescription of Building Part CMS_RE_DTE_SPC_DESCCHAR30CMS_RE_DESC
COMM_USAGE_PCTCommercial Usage as a Percentage of Total Usage CMS_RE_DTE_COM_USE_PCTDEC10(6) CMS_RE_PCT
OTHER_USG_FLGIndicates if Usages in addition to Main Usage are Possible CMS_RE_DTE_OTH_USE_FLGCHAR1ALPHACMS_RE_OTH_USG_FLG
REF_OBJ_PRT_GUIDReference Object Part GUID CMS_RE_DTE_REF_OBJ_PRT_GUIDRAW16SYSUUID
IS_SUB_AST_CREAIndicates whether a Sub-asset is created for Building Part CMS_RE_DTE_CREATE_SUB_AST_FLGCHAR1ALPHACMS_RE_FLG
USEFUL_AREAUsable Area CMS_RE_DTE_AREA_USEFULQUAN13(3) CMS_RE_SIZE
USBL_AREA_UOMUnit of Measure for Usable Area CMS_RE_DTE_USBL_AREA_UOMUNIT3CUNITMEINSCMS_ELM_SURFACE_UOM
USEFUL_AREA_RENRented Usable Area CMS_RE_DTE_AREA_USEFUL_RENQUAN13(3) CMS_RE_SIZE
USBL_AR_REN_UOMUnit of Measure for Usable Rented Area CMS_RE_DTE_USBL_AREA_REN_UOMUNIT3CUNITMEINSCMS_ELM_SURFACE_UOM
USEFUL_VOLUsable Volume of Real Estate Building Parts CMS_RE_DTE_VOL_USEFULQUAN13(3) CMS_RE_SIZE
USBL_VOL_UOMUnit of Measure for Usable Volume of Real Estate CMS_RE_DTE_USBL_VOL_UOMUNIT3CUNITMEINSCMS_ELM_VOLUME_UOM
USEFUL_VOL_RENUsable Volume of the Rented Portions of Real Estate CMS_RE_DTE_VOL_USEFUL_RENQUAN13(3) CMS_RE_SIZE
USBL_VL_REN_UOMUnit of measure for usable volume of Rented Parts CMS_RE_DTE_USBL_VOL_REN_UOMUNIT3CUNITMEINSCMS_ELM_VOLUME_UOM
RESIDENTIAL_AREAResidential Area CMS_RE_DTE_AREA_RESIDENTIALQUAN13(3) CMS_RE_SIZE
RES_AR_UOMUnit of Measure for Residential Area CMS_RE_DTE_RES_AREA_UOMUNIT3CUNITMEINSCMS_ELM_SURFACE_UOM
SECONDARY_AREASecondary Area CMS_RE_DTE_AREA_SECONDARYQUAN13(3) CMS_RE_SIZE
SEC_AREA_UOMUnit of Measure for Secondary Area CMS_RE_DTE_SEC_AREA_UOMUNIT3CUNITMEINSCMS_ELM_SURFACE_UOM
OTHER_AREAOther Area CMS_RE_DTE_AREA_OTHERQUAN13(3) CMS_RE_SIZE
OTH_AREA_UOMUnit of Measure for Other Area CMS_RE_DTE_OTH_AREA_UOMUNIT3CUNITMEINSCMS_ELM_SURFACE_UOM
NO_PRT_UNITNumber of building part units CMS_RE_DTE_NO_PRT_UNITINT410CMS_RE_UNITS
NO_PRT_UNIT_RENNumber of building part units rented CMS_RE_DTE_NO_PRT_UNIT_RENINT410CMS_RE_UNITS
CONS_START_DATEStart Date of Construction CMS_RE_DTE_OBJ_CONS_ST_DATEDATS8CMS_RE_DATE
PERMSN_APPL_DATEBuilding Permssion applied date CMS_RE_DTE_OBJ_PMSN_APPL_DATEDATS8CMS_RE_DATE
PERMSN_OBTD_DATEBuilding Permssion obtained date CMS_RE_DTE_OBJ_PMSN_OBTD_DATEDATS8CMS_RE_DATE
OCCY_DATEOccupancy Date CMS_RE_DTE_OBJ_OCCY_DATEDATS8CMS_RE_DATE
COMP_DATECompletion Date CMS_RE_DTE_OBJ_COMP_DATEDATS8CMS_RE_DATE
FINAL_INSP_DATEDate of Final Inspection CMS_RE_DTE_OBJ_FINAL_INSP_DATEDATS8CMS_RE_DATE
RENT_AMT_PLANNEDPlanned Rent Amount CMS_RE_DTE_RENT_AMOUNTCURR17(2) CMS_RE_AMOUNT
RENT_AMT_ACTUALActual Rent Amount CMS_RE_DTE_RENT_AMOUNT_ACTCURR17(2) CMS_RE_AMOUNT
RENT_PLAN_CURRPlanned Rent Currency CMS_RE_DTE_RENT_PLANNED_CURRCUKY5WAERS
RENT_ACT_CURRActual Rent Currency CMS_RE_DTE_RENT_ACTUAL_CURRCUKY5WAERS
BASE_PERIODBase period for the rent CMS_RE_DTE_BASE_PERIODCHAR1CMS_RE_BASE_PERIOD
BASE_MEASUREBase Measure CMS_RE_DTE_BASE_MEASCHAR1CMS_RE_BASE_MEAS
VACANT_POSN_PCTRatio of Real Estate not rented to Total Real Estate Value CMS_RE_DTE_VACANT_POS_PCTDEC10(6) CMS_RE_PCT
RES_RENT_INDIndicator for Net or Gross Rent CMS_RE_DTE_RES_INDCHAR1CMS_RE_RENT_FLG
COMP_RENT_RESComparative Rent (Residential) CMS_RE_DTE_RENT_LEVELCURR17(2) CMS_RE_AMOUNT
COM_REN_RES_CURRComparative Rent Currency - Residential CMS_RE_DTE_COMP_RENT_RES_CURRCUKY5WAERS
LAND_AREALand Area of the Real Estate CMS_RE_DTE_LAND_AREAQUAN13(3) CMS_RE_SIZE
LAND_AREA_UOMUnit of Measure of Land Area CMS_RE_DTE_LAND_AREA_UOMUNIT3CUNITMEINSCMS_ELM_SURFACE_UOM
LAND_AREA_RENLand Area of the Real Estate which is Rented CMS_RE_DTE_LAND_AREA_RENQUAN13(3) CMS_RE_SIZE
LAND_AR_REN_UOMLand area unit of measure(rented) CMS_RE_DTE_LAND_AREA_REN_UOMUNIT3CUNITMEINS
NO_OF_UNITSNo of units in real estate object CMS_RE_DTE_NO_UNITINT410CMS_RE_UNITS
NO_OF_FLOORSNumber of Floors CMS_RE_DTE_NO_FLOORINT410CMS_RE_UNITS
NO_GARAGESNo of Garages in Real Estate Object CMS_RE_DTE_NO_GARINT410CMS_RE_UNITS
NO_GARAGES_RENNo of Garages Rented in Real Estate Object CMS_RE_DTE_NO_GAR_RENINT410CMS_RE_UNITS
NO_PARK_UNITNumber of Parking Units CMS_RE_DTE_NO_PARK_UNITINT410CMS_RE_UNITS
NO_PARK_UNIT_RENNumber of Parking Units Rented CMS_RE_DTE_NO_PARK_UNIT_RENINT410CMS_RE_UNITS
NO_PARK_UGNumber of Underground Parking Units CMS_RE_DTE_NO_PARK_UNIT_UGINT410CMS_RE_UNITS
NO_PARK_UG_RENNumber of Rented Underground Parking Units CMS_RE_DTE_NO_PARK_UNIT_UG_RENINT410CMS_RE_UNITS
NO_CUR_UNITSNo of current units in real estate object CMS_RE_DTE_NO_CUR_UNITINT410CMS_RE_UNITS
NO_CUR_UNITS_RENNo of Current Units Rented in Real Estate Object CMS_RE_DTE_NO_CUR_UNIT_RENINT410CMS_RE_UNITS
NO_OLD_UNITSNo of old units in real estate object CMS_RE_DTE_NO_OLD_UNITINT410CMS_RE_UNITS
NO_OLD_UNITS_RENNo of Old Units Rented in Real Estate Object CMS_RE_DTE_NO_OLD_UNIT_RENINT410CMS_RE_UNITS
NO_NEW_UNITSNo of new units in real estate object CMS_RE_DTE_NO_NEW_UNITINT410CMS_RE_UNITS
NO_NEW_UNITS_RENNo of New units Rented in Real Estate Object CMS_RE_DTE_NO_NEW_UNIT_RENINT410CMS_RE_UNITS
NO_ACCESS_STRNo of Access Structures CMS_RE_DTE_NO_ACCESS_STRINT410CMS_RE_UNITS
NO_SALE_LEVELNo of Sale levels in commercial building CMS_RE_DTE_NO_SALE_LEVELINT410CMS_RE_UNITS
NO_OF_ROOMSNo of rooms in the hotel/clinic CMS_RE_DTE_NO_ROOMSINT410CMS_RE_UNITS
NO_OF_BEDSNo of beds in the clinic/nursing home CMS_RE_DTE_NO_BEDSINT410CMS_RE_UNITS
OCCUPANCY_PCTOccupancy specified in Percentage Terms CMS_RE_DTE_OCCY_PCTDEC10(6) CMS_RE_PCT
TURNOVER_AMTTotal Amount of Turnover CMS_RE_DTE_TURNOVER_AMOUNTCURR17(2) CMS_RE_AMOUNT
TURNOVER_CURRCurrency CMS_RE_DTE_TURNOVER_CURRCUKY5WAERS
RENTAL_AGMT_TYPRental Agreement Type CMS_RE_DTE_ATT_ID_TY_REO014CHAR6CMS_ATT_ID_TYP
COMM_ENV_DESCDescription of the commercial environment CMS_RE_DTE_COMM_ENV_DESCCHAR30CMS_RE_DESC
ACCESS_STR_DESCDescription of the Access Structures CMS_RE_DTE_ACCESS_STR_DESCCHAR30CMS_RE_DESC
BLD_SECTION_DESCBuilding Section CMS_RE_DTE_ATT_ID_TY_REO015CHAR6CMS_ATT_ID_TYP
PRICE_CATEGORYPrice Category CMS_RE_DTE_ATT_ID_TY_REO013CHAR6CMS_ATT_ID_TYP
AVG_PRICEAverage Price per Day CMS_RE_DTE_AVG_PRICECURR17(2) CMS_RE_AMOUNT
AVG_PRICE_CURRAverage Price Currency CMS_RE_DTE_AVG_PRICE_CURRCUKY5WAERS
LAST_REPORT_DATEDate of Last Constuction Report CMS_RE_DTE_LAST_CONST_REP_DATEDATS8CMS_RE_DATE
BLD_PROGRESS_AMTAmount Disbursed for Construction based on Building Progress CMS_RE_DTE_AMT_BLD_PROGRESSCURR17(2) CMS_RE_AMOUNT
BLD_AMT_CURRBuilding Progress Amount Curreny CMS_RE_DTE_BLD_PROGRESS_CURRCUKY5WAERS
PCT_COMPLETEDDegree of Completion of Construction CMS_RE_DTE_DEGREE_COMPLETEDEC10(6) CMS_RE_PCT
INSURANCE_TYPEInsurance Type CMS_RE_DTE_ATT_ID_TY_REO011CHAR6CMS_ATT_ID_TYP
INSURANCE_AMTInsurance Amount CMS_RE_DTE_INSURANCE_AMOUNTCURR17(2) CMS_RE_AMOUNT
INSURANCE_CURRInsurance Currency CMS_RE_DTE_INSURANCE_CURRCUKY5WAERS
INS_VALIDITYDate until which the Insurance Stands Valid CMS_RE_DTE_INS_VALID_TILLDATS8CMS_RE_DATE
RATIONING_COSTResidential Rationing Cost CMS_RE_DTE_RAT_COST_AMTCURR17(2) CMS_RE_AMOUNT
RTN_CST_PCTPercentage of Residential Rationing Cost CMS_RE_DTE_RAN_COST_PCTDEC10(6) CMS_RE_PCT
EXT_LAYOUT_COSTExternal Layout Cost CMS_RE_DTE_EXT_LAYOUT_COSTCURR17(2) CMS_RE_AMOUNT
EXT_LAY_CST_PCTExternal Layout Cost as Percentage of Total Cost CMS_RE_DTE_EXT_LAYOUT_COST_PCTDEC10(6) CMS_RE_PCT
RTN_CST_CURRRationing cost currency CMS_RE_DTE_RTN_CST_CURRCUKY5WAERS
EXT_RTN_CST_CURRExternal Layout cost currency CMS_RE_DTE_EXT_LAYOUT_CST_CURRCUKY5WAERS
RTN_CST_COMCommercial Rationing Cost CMS_RE_DTE_RAT_COST_AMT_COMCURR17(2) CMS_RE_AMOUNT
RTN_CST_COM_CURRRationing cost currency CMS_RE_DTE_RTN_CST_CURR_COMCUKY5WAERS
RTN_CST_COM_PCTPercentage of Commercial Rationing Cost CMS_RE_DTE_RAN_COST_PCT_COMDEC10(6) CMS_RE_PCT
GROSS_COLD_RENTGross Cold Rent CMS_RE_DTE_YRLY_GROSS_COLD_RENCURR17(2) CMS_RE_AMOUNT
GROSS_RENT_CURRGross Cold Rent Currency CMS_RE_DTE_GROSS_RENT_CURRCUKY5WAERS
NET_COLD_RENTNet Cold Rent CMS_RE_DTE_YRLY_NET_COLD_RENCURR17(2) CMS_RE_AMOUNT
NET_RENT_CURRNet Cold Rent Currency CMS_RE_DTE_NET_RENT_CURRCUKY5WAERS
NO_OF_YEARS_COMNo of years since Last Valuation of Commercial Real Estate CMS_RE_DTE_VAL_NO_YEARS_COMINT13CMS_RE_INT1
INT_RATE_COMInterest rate (Com) CMS_RE_DTE_VAL_INT_RATE_COMDEC10(6) CMS_RE_PCT
NO_OF_YEARSNo. of Years since Real Estate was last Valued CMS_RE_DTE_VALUATION_NO_YEARSINT13CMS_RE_INT1
INT_RATEInterest rate used in Valuation of Residential Real Estate CMS_RE_DTE_VALUATION_INT_RATEDEC10(6) CMS_RE_PCT
RENT_PLANNED_COMPlanned Rent Amount CMS_RE_DTE_RENT_AMOUNTCURR17(2) CMS_RE_AMOUNT
RENT_ACTUAL_COMActual Rent Amount CMS_RE_DTE_RENT_AMOUNT_ACTCURR17(2) CMS_RE_AMOUNT
PLAN_CURR_COMPlanned Rent Currency CMS_RE_DTE_RENT_PLANNED_CURRCUKY5WAERS
ACT_CURR_COMActual Rent Currency CMS_RE_DTE_RENT_ACTUAL_CURRCUKY5WAERS
BASE_PERIOD_COMBase period for the rent CMS_RE_DTE_BASE_PERIODCHAR1CMS_RE_BASE_PERIOD
BASE_MEAS_COMBase Measure CMS_RE_DTE_BASE_MEASCHAR1CMS_RE_BASE_MEAS
COM_RENT_INDIndicator for Rent Type CMS_RE_DTE_COM_INDCHAR1CMS_RE_RENT_FLG
COMP_RENT_COMComparative Rent (Commercial) CMS_RE_DTE_RENT_LEVEL_COMCURR17(2) CMS_RE_AMOUNT
COMP_REN_COM_CURComparative Rent Currency (Commercial) CMS_RE_DTE_COMP_RENT_COM_CURRCUKY5WAERS
PLAN_RENT_LANDPlanned Rent Amount CMS_RE_DTE_RENT_AMOUNTCURR17(2) CMS_RE_AMOUNT
ACTUAL_RENT_LANDActual Rent Amount CMS_RE_DTE_RENT_AMOUNT_ACTCURR17(2) CMS_RE_AMOUNT
PLAN_RENT_CURRPlanned Rent Currency CMS_RE_DTE_RENT_PLANNED_CURRCUKY5WAERS
ACTUAL_RENT_CURRActual Rent Currency CMS_RE_DTE_RENT_ACTUAL_CURRCUKY5WAERS
BASE_PERIOD_LANDBase period for the rent CMS_RE_DTE_BASE_PERIODCHAR1CMS_RE_BASE_PERIOD
BASE_MEAS_LANDBase Measure CMS_RE_DTE_BASE_MEASCHAR1CMS_RE_BASE_MEAS
DEPRDepriciation CMS_RE_DTE_DEPRDEC10(6) CMS_RE_PCT
LAND_COSTLand Cost Amount CMS_RE_DTE_LAND_COSTCURR17(2) CMS_RE_AMOUNT
LAND_COST_CURRLand Cost Currency CMS_RE_DTE_LAND_COST_CURRCUKY5WAERS
DEV_COSTDevelopment Cost Amount CMS_RE_DTE_DEV_COSTCURR17(2) CMS_RE_AMOUNT
DEV_COST_CURRDev Cost Currency CMS_RE_DTE_DEV_COST_CURRCUKY5WAERS
LAND_CST_BASEBase measure of Land CMS_RE_DTE_BASE_MEAS_LANDCHAR1CMS_RE_BASE_MEAS_LAND
DEV_CST_BASEBase measure of Land CMS_RE_DTE_BASE_MEAS_LANDCHAR1CMS_RE_BASE_MEAS_LAND
ADD_LAND_CSTAdditional Land Cost Amount CMS_RE_DTE_ADD_LAND_COSTCURR17(2) CMS_RE_AMOUNT
ADD_CST_CURRAdditional Land Cost Currency CMS_RE_DTE_ADD_LAND_COST_CURRCUKY5WAERS
ADD_CST_BASEBase measure of Land CMS_RE_DTE_BASE_MEAS_LANDCHAR1CMS_RE_BASE_MEAS_LAND
CONST_COSTConstruction Cost CMS_RE_DTE_CONS_COSTCURR17(2) CMS_RE_AMOUNT
CONST_COST_CURRConstruction cost currency CMS_RE_DTE_CONS_COST_CURRCUKY5WAERS
BASE_MEASBase Measure CMS_RE_DTE_BASE_MEASCHAR1CMS_RE_BASE_MEAS
GRS_PROFITYearly Gross Profit CMS_RE_DTE_GRS_PROFITCURR17(2) CMS_RE_AMOUNT
GRS_PROFIT_CURRYearly Gross Profit Currency CMS_RE_DTE_GRS_PROFIT_CURRCUKY5WAERS
AST_GUIDGUID for Table CMS_AST CMS_DTE_AST_GUIDRAW16SYSUUID
AST_TYPAsset Type CMS_DTE_AST_TYPCHAR6CMS_AST_TYPCMS_AST_TYPCMS_AST_TYP
PARENT_GUIDAsset Guid as a parent GUID for a sub-asset CMS_DTE_SAS_PAR_GUIDRAW16SYSUUID
RISK_CODERisk Code CMS_RE_DTE_RISK_CODECHAR6CMS_RISK_CODE
SFTY_INDIndicates that the asset has a default sfty discount or not CMS_RE_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTSafety discount CMS_RE_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTSafety discount as an amount CMS_RE_DTE_SAFETY_AMTCURR17(2) CMS_AMOUNT
SFTY_AMT_CURRCurrency of the Safety discount amount CMS_RE_DTE_SAFETY_AMT_CURRCUKY5WAERS
VALUATION_TYPType of Check conducted on the object CMS_RE_DTE_IND_VALN_TYPCHAR2CMS_VALN_TYP
UNIT_VALN_FREQIndicator : Valuation Period CMS_RE_DTE_IND_FREQUENCYCHAR2CMS_RE_IND_FREQUENCY
PERIOD_VALN_FREQPeriod of revaluation for a real estate CMS_RE_DTE_VALN_FREQ_PERIODNUMC4CMS_RE_VALN_FREQ_PERIOD
PAST_VALUED_DATEMost Recent Date on which the Real Estate was last Valued CMS_RE_DTE_VALN_DATEDATS8CMS_DATE
START_DATERevaluation Start date CMS_RE_DTE_START_DATEDATS8CMS_DATE
END_DATEEnd date for Revaluation of the Real Estate CMS_RE_DTE_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicates that the asset has a default lending rate or not CMS_RE_DTE_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending rate 1 CMS_RE_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LENDING_RATE2Lending rate 2 CMS_RE_DTE_LRTE_PCT2DEC10(6) CMS_PCT
LENDING_RATE3Lending rate 3 CMS_RE_DTE_LRTE_PCT3DEC10(6) CMS_PCT
LENDING_RATE4Lending rate 4 CMS_RE_DTE_LRTE_PCT4DEC10(6) CMS_PCT
LENDING_RATE5Lending rate 5 CMS_RE_DTE_LRTE_PCT5DEC10(6) CMS_PCT
ACC_NUMBER_LIQAccount number for liquidation proceeds CMS_DTE_LIQ_ACC_NUMBERCHAR35BANKN35
BANK_CNTRY_LIQBank country key CMS_DTE_LIQ_BNK_CTRY_KYCHAR3LAND1
BANK_KEY_LIQBank Key CMS_DTE_LIQ_BNK_KEYCHAR15BANKKBNK
BANK_CTRLKEY_LIQBank Control Key BKONTCHAR2BKONT
UNIT_VERF_FREQIndicator: Units of time for verification of an asset CMS_DTE_IND_AST_VERF_FREQ_UNITCHAR2CMS_IND_AST_VERF_FREQ_UNIT
PERIOD_VERF_FREQStatement Period for an Asset CMS_DTE_AST_VERF_FREQ_PERIODNUMC4CMS_AST_VERF_FREQ_PERIOD
LAST_VERF_DATELast Verification Date CMS_DTE_AST_VERF_DATEDATS8CMS_DATE
LIQD_TYPLiquidation Type CMS_DTE_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6CMS_ATT_ID_TYP
LIQD_DATEDate on which the Collateral was Liquidated CMS_DTE_LIQD_DATEDATS8CMS_DATE
LIQD_AMTReturns from the Liquidation of Collateral CMS_DTE_LIQD_VALUECURR17(2) CMS_AMOUNT
LIQD_CURRCurrency of Liquidation Value CMS_DTE_LIQD_CURRCUKY5WAERS
EXP_PRCD_AMNTExpected Proceed Amount CMS_DTE_LIQ_EXP_PRCD_AMOUNTCURR17(2) CMS_AMOUNT
EXP_PRCD_CURRCurrency: Expected Proceed CMS_DTE_LIQ_EXP_PRCD_CURRCUKY5WAERS
EXP_ACC_DATEExpected accrual date CMS_DTE_LIQ_EXP_ACCRUAL_DATEDATS8CMS_DATE
NOM_VALUENominal Value of the Asset CMS_DTE_AST_NOMINAL_VALUECURR17(2) CMS_AMOUNT
NOM_VALUE_CURRCurrency of Nominal value CMS_DTE_AST_NOMINAL_VALUE_CURRCUKY5WAERS
AST_VALUEFinal Asset Value CMS_DTE_AST_VALUECURR17(2) CMS_AMOUNT
AST_VALUE_CURRCurrency of the Final Asset Value CMS_DTE_AST_VALUE_CURRCUKY5WAERS
QUANTITYQuantity CMS_DTE_QTYQUAN13(3) CMS_QTY
UNIT_OF_MEASUREUnit of Measure of Quantity CMS_DTE_UNITUNIT3CUNITMEINS
REC_ATAsset Value Recording Timestamp CMS_DTE_REC_ATDEC15TZNTSTMPS
PUR_PRICEPurchase Price of the Asset CMS_DTE_AST_PURCHASE_PRICECURR17(2) CMS_AMOUNT
PUR_PRICE_CURRCurrency of Purchase Price CMS_DTE_AST_PUR_PRICE_CURRCUKY5WAERS
PUR_DATEDate of Purchase CMS_DTE_AST_PUR_PRICE_DATEDATS8CMS_DATE
ORG_UNIT1Organizational Unit 1 CMS_DTE_ORG_UNIT1CHAR10CMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2 CMS_DTE_ORG_UNIT2CHAR10CMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3 CMS_DTE_ORG_UNIT3CHAR10CMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4 CMS_DTE_ORG_UNIT4CHAR10CMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5 CMS_DTE_ORG_UNIT5CHAR10CMS_ORG_UNIT

Key field Non-key field



How do I retrieve data from SAP structure CMS_STR_COR_RE_MAIN_OBJ_DET using ABAP code?

As CMS_STR_COR_RE_MAIN_OBJ_DET is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CMS_STR_COR_RE_MAIN_OBJ_DET as there is no data to select.

How to access SAP table CMS_STR_COR_RE_MAIN_OBJ_DET

Within an ECC or HANA version of SAP you can also view further information about CMS_STR_COR_RE_MAIN_OBJ_DET and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).