CRMT_BSP_FSQ_CAG_RE_DET_UI SAP (FSQ Collateral Agreement and Real Estate) Structure details

Dictionary Type: Structure
Description: FSQ Collateral Agreement and Real Estate




ABAP Code to SELECT data from CRMT_BSP_FSQ_CAG_RE_DET_UI
Related tables to CRMT_BSP_FSQ_CAG_RE_DET_UI
Access table CRMT_BSP_FSQ_CAG_RE_DET_UI




Structure field list including key, data, relationships and ABAP select examples

CRMT_BSP_FSQ_CAG_RE_DET_UI 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 "FSQ Collateral Agreement and Real Estate" 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_CRMT_BSP_FSQ_CAG_RE_DET_UI TYPE CRMT_BSP_FSQ_CAG_RE_DET_UI.

The CRMT_BSP_FSQ_CAG_RE_DET_UI table consists of various fields, each holding specific information or linking keys about FSQ Collateral Agreement and Real Estate data available in SAP. These include OBJECT_KEY (Object Key), CAG_GUID (UUID in character form), RE_GUID (UUID in character form), CHARGE_GUID (UUID in character form).. 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. .

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


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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
OBJECT_KEYObject Key CRMT_BSP_OBJECTKEYCHAR100
CAG_GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
RE_GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
CHARGE_GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
TRANSFERRED_FLAGIndicates Whether Data Was Transferred CRMT_FS_CAG_TRANSF_FLAGCHAR1CRM_FS_CAG_FLAG
ITEM_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
COLLATERAL_TXTCollaterals: Text CRMT_FS_COLLATERAL_TXTCHAR40
SYSTEM_IDID of Logical Back End System CRMT_FS_SYSTEM_IDCHAR60
CAG_IDCollateral Agreement: ID CRMT_FS_CAG_IDCHAR40
CAG_TYPE_IDCollateral Agreement: Type ID CRMT_FS_CAG_TYPE_IDCHAR6CRM_FS_CAG_CUST_KEY
CAG_TYPECollateral Agreement: Type CRMT_FS_CAG_TYPECHAR30CRM_FS_CAG_CUST_DESCR
CAG_PORTION_IDCollateral Agreement: Portion ID CRMT_FS_CAG_PORTION_IDNUMC4
CAG_FREE_COLLCollateral Agreement: Free Collaterals CRMT_FS_CAG_FREE_COLL_AMTCURR23(2) CRM_FS_CAG_AMOUNT
CAG_FREE_COLL_CURRCollateral Agreement: Free Collaterals - Currency CRMT_FS_CAG_FREE_COLL_CURRCUKY5Assigned to domainWAERS
CAG_DESCRCollateral Agreement: Description CRMT_FS_CAG_DESCRCHAR30
CAG_ASMT_AMTCollateral Agreement: Assessment Amount CRMT_FS_CAG_ASMT_AMTCURR23(2) CRM_FS_CAG_AMOUNT
CAG_ASMT_CURRCollateral Agreement: Assessment Amount - Currency CRMT_FS_CAG_ASMT_CURRCUKY5Assigned to domainWAERS
CAG_COLL_LAND_CHARGECollateral Agreement: Collective Land Charge CRMT_FS_CAG_COLL_LAND_CHARGECHAR1CRM_FS_CAG_FLAG
CAG_SUBSCR_DATECollateral Agreement: Closing Date CRMT_FS_CAG_SUBSCR_DATEDATS8
CAG_VALID_FROMCollateral Agreement: Valid From CRMT_FS_CAG_VALID_FROMDATS8
CAG_VALID_TOCollateral Agreement: Valid To CRMT_FS_CAG_VALID_TODATS8
RE_IDReal Estate: ID CRMT_FS_RE_IDCHAR40
RE_DESCRReal Estate: Description CRMT_FS_RE_DESCRCHAR30
RE_TYPE_IDReal Estate: Type ID CRMT_FS_RE_TYPE_IDCHAR6CRM_FS_CAG_CUST_KEY
RE_TYPEReal Estate: Type CRMT_FS_RE_TYPECHAR30CRM_FS_CAG_CUST_DESCR
RE_COLL_VALUEReal Estate: Available Collateral Value CRMT_FS_RE_COLL_VALUECURR23(2) CRM_FS_CAG_AMOUNT
RE_COLL_VALUE_CURRReal Estate: Available Collateral Value - Currency CRMT_FS_RE_COLL_VALUE_CURRCUKY5Assigned to domainWAERS
RE_MARKET_VALUEReal Estate: Market Value CRMT_FS_RE_MARKET_VALCURR23(2) CRM_FS_CAG_AMOUNT
RE_MARKET_VALUE_CURRReal Estate: Market Value - Currency CRMT_FS_RE_MARKET_VAL_CURRCUKY5Assigned to domainWAERS
RE_NOMINAL_VALUEReal Estate: Nominal Value CRMT_FS_RE_NOMINAL_VALCURR23(2) CRM_FS_CAG_AMOUNT
RE_NOMINAL_VALUE_CURRReal Estate: Nominal Value - Currency CRMT_FS_RE_NOMINAL_VAL_CURRCUKY5Assigned to domainWAERS
RE_SAFE_DISCOUNT_PCTReal Estate: Safety Discount in Percent CRMT_FS_RE_SAFE_DISCOUNT_PCTDEC10(6) CRM_FS_CAG_PCT
RE_SAFE_DISCOUNT_AMTReal Estate: Safety Discount (Amount) CRMT_FS_RE_SAFE_DISCOUNT_AMTCURR23(2) CRM_FS_CAG_AMOUNT
RE_SAFE_DISCOUNT_CURRReal Estate: Safety Discount (Amount) - Currency CRMT_FS_RE_SAFE_DISCOUNT_CURRCUKY5Assigned to domainWAERS
RE_LENDING_VALUEReal Estate: Lending Value CRMT_FS_RE_LENDING_VALUECURR23(2) CRM_FS_CAG_AMOUNT
RE_LENDING_VALUE_CURRReal Estate: Lending Value - Currency CRMT_FS_RE_LENDING_VALUE_CURRCUKY5Assigned to domainWAERS
RE_LENDING_RATEReal Estate: Lending Rate CRMT_FS_RE_LENDING_RATEDEC10(6) CRM_FS_CAG_PCT
RE_LENDING_LIMITReal Estate: Lending Limit CRMT_FS_RE_LENDING_LIMITCURR23(2) CRM_FS_CAG_AMOUNT
RE_LENDING_LIMIT_CURRReal Estate: Lending Limit - Currency CRMT_FS_RE_LENDING_LIMIT_CURRCUKY5Assigned to domainWAERS
RE_UTILIZATION_IDReal Estate: Utilization ID CMRT_FS_RE_UTILIZATION_IDCHAR6CRM_FS_CAG_CUST_KEY
RE_UTILIZATIONReal Estate: Usage CRMT_FS_RE_UTILIZATIONCHAR30CRM_FS_CAG_CUST_DESCR
RE_PROP_SIZEReal Estate: Property Size CRMT_FS_RE_PROP_SIZEQUAN13(3) CRM_FS_RE_SIZE
RE_PROP_SIZE_UOMReal Estate: Property Size - UoM CRMT_FS_RE_PROP_SIZE_UOMUNIT3Assigned to domainCUNITMEINS
RE_RES_SPACEReal Estate: Living Area CRMT_FS_RE_RES_SPACEQUAN13(3) CRM_FS_RE_SIZE
RE_RES_SPACE_UOMReal Estate: Living Area - UoM CRMT_FS_RE_RES_SPACE_UOMUNIT3Assigned to domainCUNITMEINS
RE_COM_SPACEReal Estate: Commercial Space CRMT_FS_RE_COM_SPACEQUAN13(3) CRM_FS_RE_SIZE
RE_COM_SPACE_UOMReal Estate: Commercial Space - UoM CRMT_FS_RE_COM_SPACE_UOMUNIT3Assigned to domainCUNITMEINS
RE_CONSTR_YEARReal Estate: Construction Year CRMT_FS_RE_CONSTR_YEARNUMC4
RE_MACRO_LOCATION_IDReal Estate: Macro Location ID CRMT_FS_RE_MACRO_LOC_IDCHAR6CRM_FS_CAG_CUST_KEY
RE_MACRO_LOCATIONReal Estate: Macro Location CRMT_FS_RE_MACRO_LOCCHAR30CRM_FS_CAG_CUST_DESCR
RE_MICRO_LOCATION_IDReal Estate: Micro Location ID CRMT_FS_RE_MICRO_LOC_IDCHAR6CRM_FS_CAG_CUST_KEY
RE_MICRO_LOCATIONReal Estate: Micro Location CRMT_FS_RE_MICRO_LOCCHAR30CRM_FS_CAG_CUST_DESCR
RE_TRANSPORT_CON_IDReal Estate: Transport Connection ID CRMT_FS_RE_TRANS_CON_IDCHAR6CRM_FS_CAG_CUST_KEY
RE_TRANSPORT_CONReal Estate: Transport Connection CRMT_FS_RE_TRANSPORT_CONCHAR30CRM_FS_CAG_CUST_DESCR
RE_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
RE_HOUSE_NOHouse Number AD_HSNM1CHAR10TEXT10
RE_POST_CODECity postal code AD_PSTCD1CHAR10CHAR10
RE_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
RE_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
RE_REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
CHARGE_DESCRCollateral Charge: Description CRMT_FS_CHARGE_DESCRCHAR30
CHARGE_RANKCollateral Charge: Ranking CRMT_FS_CHARGE_RANKNUMC4
CHARGE_SEQCollateral Charge: Sequence CRMT_FS_CHARGE_SEQNUMC4
CHARGE_REG_NOCollateral Charge: Register Number CRMT_FS_CHARGE_REG_NOCHAR32
CHARGE_REG_DATECollateral Charge: Registration Date CRMT_FS_CHARGE_REG_DATEDATS8
CHARGE_USED_VALUECollateral Charge: Object Value Used CRMT_FS_CHARGE_USED_VALCURR23(2) CRM_FS_CAG_AMOUNT
CHARGE_USED_VALUE_CURRCollateral Charge: Object Value Used - Currency CRMT_FS_CHARGE_USED_VAL_CURRCUKY5Assigned to domainWAERS
CHARGE_USED_VALUE_PCTCollateral Charge: Object Value Used in Percent CRMT_FS_CHARGE_USED_VAL_PCTDEC10(6) CRM_FS_CAG_PCT
NUMBER_INTItem Number in Document CRMT_BSP_ITEM_NONUMC10ALPHACRM_BSP_ITEM_NO
PARENT_KEYObject Key CRMT_BSP_OBJECTKEYCHAR100
ICON 0
ICON_EXPANDED 0
IS_EXPANDEDCheckbox XFELDCHAR1XFELD
IS_LEAFCheckbox XFELDCHAR1XFELD
IS_HOTSPOTCheckbox XFELDCHAR1XFELD
TOOLTIP 0

Key field Non-key field



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

As CRMT_BSP_FSQ_CAG_RE_DET_UI 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 CRMT_BSP_FSQ_CAG_RE_DET_UI as there is no data to select.

How to access SAP table CRMT_BSP_FSQ_CAG_RE_DET_UI

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!