/pra/ofs_V_owner_Transfer_Det

Owner Transfer Details | view: /PRA/OFS_CDS_TR | Extraction: Not supported | Component: Ownership
Tables used: OIUOW_DTCS, OIUOW_DTD, OIUOW_DTCH, /PRA/BP_VEND_MD, LFA1, KNA1, OIUOW_DOC_TYPE_T, OIUOW_TRSFER_TX, OIU_CM_SUSP_TX, OIU_DO_DI, OIUOW_DORH
Column Name Description
doc_no Request doc. number
doc_year Document year
item_no Request item number
eff_from_dt Effective from date
bukrs FK Company Code
vname FK Joint venture
doi_no FK Division of interest (DOI)
old_own_no FK Transferor - Owner
old_own_int_type_cd Transferor Participant Interest Type
old_own_isq_no Transferor Owner Interest Sequence Number
Column Name Description
Column Name Description
Column Name Description
eff_from_dt Effective from date
eff_to_dt Effective To Date
document_dt Document Date
Column Name Description
status_cd Request status Show values
transfer_type Transfer type Show values
genr_ppa_fl Corrections Allowed Flag Show values
ovrd_jib_fl Joint Interest Billing Offset Flag Show values
ovrd_pay_cd Pay Code Show values
Column Name Description Domain name
doc_type_nm Document type description OIU_TEXT50
doc_desc Request description OIU_TEXT50
status_cd_nm Request Status Description DDTEXT
process_dt Request process date TZNTSTMPS
process_uname User who last processed the document UNAME
tfch_rsn_cd_nm Transfer Reason Description OIU_TEXT50
accum_interest Accumulated interest OIU_PERCENT98
transfer_type_nm Transfer Type Description DDTEXT
document_timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
old_own_nm Transferor Name NAME
old_owner Transferor
new_own_nm Transferee Name NAME
new_owner Transferee
new_own_isq_no Transferee Owner Interest Sequence Number OIUOW_NW_OWN_ISQ_NO
interest Interest OIU_PERCENT98
ovrd_jib_partnr_nm JIB Partner Name NAME
ovrd_pyout_cd Payout Code OIU_PYOUT_CD
ovrd_pay_cd_nm Pay Code Description DDTEXT
ovrd_susp_cd_nm Suspense Reason Description OIU_TEXT40
doi_nm Division of Interest Name OIU_TEXT30
venture_doi Venture/DOI
xfer_exec_datetime Transfer Execution Time TZNTSTMPS
Master Data Relations Join Conditions
Company
  • Company Code
  • Client
  • /PRA/OFS_V_OWNER_TRANSFER_DET.BUKRS == T001.BUKRS
  • /PRA/OFS_V_OWNER_TRANSFER_DET.MANDT == T001.MANDT
Request document type
  • Request document type
  • Client
Division of Interest
  • Division of interest (DOI)
  • Joint venture
  • Company Code
  • Client
  • /PRA/OFS_V_OWNER_TRANSFER_DET.DOI_NO == OIU_DO_DI.DOI_NO
  • /PRA/OFS_V_OWNER_TRANSFER_DET.VNAME == OIU_DO_DI.VNAME
  • /PRA/OFS_V_OWNER_TRANSFER_DET.BUKRS == OIU_DO_DI.BUKRS
  • /PRA/OFS_V_OWNER_TRANSFER_DET.MANDT == OIU_DO_DI.MANDT
OIU_CM_PINTTY /PRA/OFS_V_OWNER_TRANSFER_DET.NEW_OWN_INT_TYPE_CD == OIU_CM_PINTTY.OWN_INT_TYPE_CD
Transferee - Owner
  • Transferee - Owner
  • Client
  • /PRA/OFS_V_OWNER_TRANSFER_DET.NEW_OWN_NO == LFA1.LIFNR
  • /PRA/OFS_V_OWNER_TRANSFER_DET.MANDT == LFA1.MANDT
Transferor - Owner
  • Transferor - Owner
  • Client
  • /PRA/OFS_V_OWNER_TRANSFER_DET.OLD_OWN_NO == LFA1.LIFNR
  • /PRA/OFS_V_OWNER_TRANSFER_DET.MANDT == LFA1.MANDT
JIB Partner
  • Client
  • JIB Partner
  • /PRA/OFS_V_OWNER_TRANSFER_DET.MANDT == KNA1.MANDT
  • /PRA/OFS_V_OWNER_TRANSFER_DET.OVRD_JIB_PARTNR == KNA1.KUNNR
Suspense Reason Code
  • Suspense Reason Code
  • Client
  • /PRA/OFS_V_OWNER_TRANSFER_DET.OVRD_SUSP_CD == OIU_CM_SUSP.SUSP_CD
  • /PRA/OFS_V_OWNER_TRANSFER_DET.MANDT == OIU_CM_SUSP.MANDT
Transfer Change Reason Code
  • Client
  • Transfer Change Reason Code
  • /PRA/OFS_V_OWNER_TRANSFER_DET.MANDT == OIUOW_TRSFER.MANDT
  • /PRA/OFS_V_OWNER_TRANSFER_DET.TFCH_RSN_CD == OIUOW_TRSFER.TRSFER_CD
Venture
  • Joint venture
  • Company Code
  • Client
  • /PRA/OFS_V_OWNER_TRANSFER_DET.VNAME == OIU_DO_JV.VNAME
  • /PRA/OFS_V_OWNER_TRANSFER_DET.BUKRS == OIU_DO_JV.BUKRS
  • /PRA/OFS_V_OWNER_TRANSFER_DET.MANDT == OIU_DO_JV.MANDT