I_FBO

DDL: I_FBO SQL: PFBO_DET Type: view COMPOSITE

FBO Details

I_FBO is a Composite CDS View that provides data about "FBO Details" in SAP S/4HANA. It reads from 2 data sources (I_ContractHead, P_ACMFIRMBIDOFFERDETAILS) and exposes 26 fields.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
I_ContractHead CONT_HEADER from
P_ACMFIRMBIDOFFERDETAILS fbo inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PFBO_DET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label FBO Details view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (26)

KeyFieldSource TableSource FieldDescription
CONTRACT_NUMBER P_ACMFIRMBIDOFFERDETAILS CONTRACT_NUMBER
TARGET_PRICE_TYPE P_ACMFIRMBIDOFFERDETAILS TARGET_PRICE_TYPE
STRIKE_PRICE_AMOUNT P_ACMFIRMBIDOFFERDETAILS STRIKE_PRICE_AMOUNT
STRIKE_PRICE_CURRENCY P_ACMFIRMBIDOFFERDETAILS STRIKE_PRICE_CURRENCY
STRIKE_PRICE_PER_UNIT P_ACMFIRMBIDOFFERDETAILS STRIKE_PRICE_PER_UNIT
STRIKE_PRICE_UOM P_ACMFIRMBIDOFFERDETAILS STRIKE_PRICE_UOM
DCSID P_ACMFIRMBIDOFFERDETAILS DCSID
MATURITY_CODE P_ACMFIRMBIDOFFERDETAILS MATURITY_CODE
FBO_EXPIRY_DATE P_ACMFIRMBIDOFFERDETAILS FBO_EXPIRY_DATE
TARGET_CONTRACT_TYPE P_ACMFIRMBIDOFFERDETAILS TARGET_CONTRACT_TYPE
AUTOMATIC_CONVERT_TO_CONTRACT P_ACMFIRMBIDOFFERDETAILS AUTOMATIC_CONVERT_TO_CONTRACT
LOCK_INSTRUCTION_TYPE P_ACMFIRMBIDOFFERDETAILS LOCK_INSTRUCTION_TYPE
LOCK_PRICE P_ACMFIRMBIDOFFERDETAILS LOCK_PRICE
LOCK_CURRENCY P_ACMFIRMBIDOFFERDETAILS LOCK_CURRENCY
LOCK_FX P_ACMFIRMBIDOFFERDETAILS LOCK_FX
LOCK_FX_CURRENCY_FROM P_ACMFIRMBIDOFFERDETAILS LOCK_FX_CURRENCY_FROM
LOCK_FX_CURRENCY_TO P_ACMFIRMBIDOFFERDETAILS LOCK_FX_CURRENCY_TO
FUTURE_LOCK_INSTRUCTION_TYPE P_ACMFIRMBIDOFFERDETAILS FUTURE_LOCK_INSTRUCTION_TYPE
FUTURE_LOCK_PRICE P_ACMFIRMBIDOFFERDETAILS FUTURE_LOCK_PRICE
FUTURE_LOCK_CURRENCY P_ACMFIRMBIDOFFERDETAILS FUTURE_LOCK_CURRENCY
FUTURE_LOCK_FX P_ACMFIRMBIDOFFERDETAILS FUTURE_LOCK_FX
FUTURE_LOCK_FX_CURRENCY_FROM P_ACMFIRMBIDOFFERDETAILS FUTURE_LOCK_FX_CURRENCY_FROM
FUTURE_LOCK_FX_CURRENCY_TO P_ACMFIRMBIDOFFERDETAILS FUTURE_LOCK_FX_CURRENCY_TO
FUTURE_CHECK P_ACMFIRMBIDOFFERDETAILS FUTURE_CHECK
BASIS_CHECK P_ACMFIRMBIDOFFERDETAILS BASIS_CHECK
BASIS_ID P_ACMFIRMBIDOFFERDETAILS BASIS_ID 
@AbapCatalog.sqlViewName: 'PFBO_DET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
--@EndUserText.label: 'FBO Details'
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

define view I_FBO as select from I_ContractHead as CONT_HEADER 
                      inner join P_ACMFIRMBIDOFFERDETAILS as fbo
                      on CONT_HEADER.tkonn = fbo.CONTRACT_NUMBER 
{
  
  fbo.CONTRACT_NUMBER, 
  fbo.TARGET_PRICE_TYPE, 
  fbo.STRIKE_PRICE_AMOUNT, 
  fbo.STRIKE_PRICE_CURRENCY, 
  fbo.STRIKE_PRICE_PER_UNIT, 
  fbo.STRIKE_PRICE_UOM, 
  fbo.DCSID, 
  fbo.MATURITY_CODE, 
  fbo.FBO_EXPIRY_DATE, 
  fbo.TARGET_CONTRACT_TYPE, 
  fbo.AUTOMATIC_CONVERT_TO_CONTRACT, 
  fbo.LOCK_INSTRUCTION_TYPE, 
  fbo.LOCK_PRICE, 
  fbo.LOCK_CURRENCY, 
  fbo.LOCK_FX, 
  fbo.LOCK_FX_CURRENCY_FROM, 
  fbo.LOCK_FX_CURRENCY_TO, 
  fbo.FUTURE_LOCK_INSTRUCTION_TYPE, 
  fbo.FUTURE_LOCK_PRICE, 
  fbo.FUTURE_LOCK_CURRENCY, 
  fbo.FUTURE_LOCK_FX, 
  fbo.FUTURE_LOCK_FX_CURRENCY_FROM, 
  fbo.FUTURE_LOCK_FX_CURRENCY_TO, 
  fbo.FUTURE_CHECK, 
  fbo.BASIS_CHECK, 
  fbo.BASIS_ID
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONTRACTHEAD",
"P_ACMFIRMBIDOFFERDETAILS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More