ARO_DDL_OBL_LDB

View for ARO Report Selection(LDB) | view: V_ARO_DDL_OBJ | Extraction: Not supported | Component: Asset Retirement Obligation Management for Oil & Gas
Tables used: ARO_HDR, ARO_OBLIGATION, ARO_OBL_INDEX, ARO_ASSIGNMENTS, ARO_TA, ARO_UO_HDR, ARO_TC_OBL_T_T, T001, TKA02, ANKT, FAAC_ACLS0_T, ARO_CEP_HDR
Column Name Description
obl_guid GUID of an Obligation
assign_validto Valid To Date
Column Name Description
Column Name Description
Column Name Description
assign_validto Valid To Date
aro_date_beg ARO Setup Date
aro_date_end ARO Current End Date
aro_date_end_1st ARO First End Date
aro_date_removal ARO Termination Date
aro_close_pdate Posting Date
creation_date First Entered On
creation_time Time of Creation
lastchange_date Last Edited On
lastchange_time Last Edited At
last_ta_ENTRY_date Date Data Created On
last_ta_ENTRY_time Time Data Created At
last_CEP_KEYDATE Processing Key Date
last_cep_TA_DATE Transaction Date
firstrel_ta_ENTRY_date Release Date
firstrel_ta_ENTRY_time Release Time
rele_ta_ENTRY_date Release Date
rele_ta_ENTRY_time Release Time
rele_CEP_KEYDATE Processing Key Date
rele_cep_TA_DATE Transaction Date
uo_creation_date First Entered On
uo_creation_time Time of Creation
uo_lastchange_date Last Edited On
uo_lastchange_time Last Edited At
Column Name Description
obl_status Obligation Status Show values
obl_lock Obligation lock for changes Show values
flag_use_subno Activate ARO on Asset Subnumber Show values
aro_int_cal_meth Interest Calculation Method Show values
last_cep_INFL_METH Interest Calculation Method Show values
firstrel_ta_ta_status Transaction Status Show values
rele_cep_INFL_METH Interest Calculation Method Show values
deleted Delete Obligation physically Show values
Column Name Description Domain name
obl_type_desc Description of Obligation Type TEXT30
obl_num Number of Obligation ARO_OBL_NUM
obl_desc Description of Obligation TEXT50
obl_short_desc Description of Obligation - Short TEXT20
obl_status_desc Description of Obligation Status TEXT30
langu Language Key SPRAS
obl_mco_desc ARO Search Terms CHAR50
aro_term_years Term of Asset Retirement Obligation (Years) ARO_DAUER_PERIOD
aro_term_months Term of Asset Retirement Obligation (Months) ARO_DAUER_PERIOD
master_data_guid ARO Underlying Object GUID SYSUUID_C
aro_assetclass Asset Class for ARO Assets ANLKL
last_ta_num_used Last ARO Transaction Number Used on Retirement Obligation
last_ta_num_rel Last Released / Active ARO Transaction Number
creation_user Entered By SYCHAR12
creation_orig Source of Initial Entry CHAR10
lastchange_user Employee ID SYCHAR12
lastchange_orig Editing Source CHAR10
bus_area Business Area GSBER
costcenter Cost Center KOSTL
resp_costcenter Responsible Cost Center KOSTL
acttype Activity Type LSTAR
room Room CHAR8
func_area Functional Area FKBER
profit_ctr Profit Center PRCTR
prof_segm Profitability Segment Number (CO-PA) RKEOBJNR
rl_est_key Internal Key for Real Estate Object IMKEY
external_id External ID
last_ta_ENTRY_by User ID of Person Who Creates the Data UNAME
last_CEP_NUM Number of Cost Estimation Plan ARO_CEP_NUM
last_CEP_DESC CEP Description TEXT50
last_cep_INFL_KEY Inflation Rate Key ARO_INFLATION_RATE_KEY
firstrel_ta_ta_num Transaction Number
firstrel_ta_ENTRY_by User ID of Person Who Triggered Release UNAME
rele_ta_ENTRY_by User ID of Person Who Triggered Release UNAME
rele_CEP_NUM Number of Cost Estimation Plan ARO_CEP_NUM
rele_CEP_DESC CEP Description TEXT50
rele_cep_INFL_KEY Inflation Rate Key ARO_INFLATION_RATE_KEY
UO_NUM Underlying Object Number ARO_OBJ_NUM
UO_DESC Underlying Object Description ARO_UNDL_OBJ_DESC
uo_adr_postal_code City postal code CHAR10
uo_adr_city City TEXT40
uo_adr_street Street TEXT60
uo_adr_house_no House Number TEXT10
uo_creation_user Entered By SYCHAR12
uo_creation_orig Source of Initial Entry CHAR10
uo_lastchange_user Employee ID SYCHAR12
uo_lastchange_orig Editing Source CHAR10
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • Client
  • Company Code
  • Company Code
  • ARO_DDL_OBL_LDB.MANDT == T001.MANDT
  • ARO_DDL_OBL_LDB.UO_COMP_CODE == T001.BUKRS
  • ARO_DDL_OBL_LDB.COMP_CODE == T001.BUKRS
Inflation Rate Key
  • Inflation Rate Key
  • Client
  • ARO_DDL_OBL_LDB.INF_RATE_KEY == ARO_TC_INF.INFL_RATE_KEY
  • ARO_DDL_OBL_LDB.MANDT == ARO_TC_INF.CLIENT
Interest Rate Key
  • Interest Rate Key
  • Client
Asset location
  • Plant
  • Client
  • Asset location
  • ARO_DDL_OBL_LDB.PLANT == T499S.WERKS
  • ARO_DDL_OBL_LDB.MANDT == T499S.MANDT
  • ARO_DDL_OBL_LDB.LOCATION == T499S.STAND
Type of Obligation
  • Type of Obligation
  • Client
Order Number
  • Order Number
  • Client
  • ARO_DDL_OBL_LDB.ORDERID == AUFK.AUFNR
  • ARO_DDL_OBL_LDB.MANDT == AUFK.MANDT
Plant
  • Plant
  • Client
  • ARO_DDL_OBL_LDB.PLANT == T001W.WERKS
  • ARO_DDL_OBL_LDB.MANDT == T001W.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • ARO_DDL_OBL_LDB.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • ARO_DDL_OBL_LDB.MANDT == TTXJ.MANDT
  • ARO_DDL_OBL_LDB.TAXJURCODE == TTXJ.TXJCD
Country/Region Key
  • Country/Region Key
  • Client
  • ARO_DDL_OBL_LDB.UO_ADR_COUNTRY == T005.LAND1
  • ARO_DDL_OBL_LDB.MANDT == T005.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Country/Region Key
  • Client
  • ARO_DDL_OBL_LDB.UO_ADR_REGION == T005S.BLAND
  • ARO_DDL_OBL_LDB.UO_ADR_COUNTRY == T005S.LAND1
  • ARO_DDL_OBL_LDB.MANDT == T005S.MANDT
Company Code
  • Client
  • Company Code
  • Company Code
  • ARO_DDL_OBL_LDB.MANDT == T001.MANDT
  • ARO_DDL_OBL_LDB.UO_COMP_CODE == T001.BUKRS
  • ARO_DDL_OBL_LDB.COMP_CODE == T001.BUKRS
Underlying Object Type
  • Underlying Object Type
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Cost Estimation Plan GUID
  • Cost Estimation Plan GUID
  • Cost Estimation Plan GUID
  • Cost Estimation Plan GUID
  • Client
Cost Estimation Plan GUID
  • Cost Estimation Plan GUID
  • Cost Estimation Plan GUID
  • Cost Estimation Plan GUID
  • Client
Cost Estimation Plan GUID
  • Cost Estimation Plan GUID
  • Cost Estimation Plan GUID
  • Cost Estimation Plan GUID
  • Client