P_CmmdtyPrcgTrmInptGenDat

DDL: P_CMMDTYPRCGTRMINPTGENDAT SQL: PTRMINPUTGEN Type: view BASIC

P_CmmdtyPrcgTrmInptGenDat is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (cped_terminput) and exposes 13 fields with key field ACMPrcgTermInputUUID.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
cped_terminput cped_terminput from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PTRMINPUTGEN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ACMPrcgTermInputUUID terminput_guid
DerivativeContrSpecification dcsid
MarketIdentifierCode mic
ACMPrcgTermInputCndnPrc fixtermrate_df34
PrcgConditionTermFixedRateCrcy fixtermcurr
PrcgConditionTermFixedRateQty fixtermprun
PrcgCndnTermFixedRateQtyUnit fixtermuom
QuotationKeyType quotkey
MaturityKeyDate keydate
CmmdtyOrdReqDocExternalID psmguid
BasisType basis_type
ACMPrcgCndnTermInputPrice fixtermrate
ACMTermCalcType termtype 
@AbapCatalog.sqlViewName: 'PTRMINPUTGEN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'CPE Term Changed  Input for General Data'

@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
//@VDM.lifecycle.status: #DEPRECATED

//@VDM.lifecycle.successor: 'P_CMMDTYPRCGTRMINPTGENDATA'

define view P_CmmdtyPrcgTrmInptGenDat
  as select from cped_terminput // cped_terminput


{
  key terminput_guid   as ACMPrcgTermInputUUID,
      dcsid            as DerivativeContrSpecification,
      mic              as MarketIdentifierCode,
      fixtermrate_df34 as ACMPrcgTermInputCndnPrc,
      fixtermcurr      as PrcgConditionTermFixedRateCrcy,
      fixtermprun      as PrcgConditionTermFixedRateQty,
      fixtermuom       as PrcgCndnTermFixedRateQtyUnit,
      quotkey          as QuotationKeyType,
      keydate          as MaturityKeyDate,
      psmguid          as CmmdtyOrdReqDocExternalID,
      basis_type       as BasisType,
      fixtermrate      as ACMPrcgCndnTermInputPrice,
      termtype         as ACMTermCalcType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CPED_TERMINPUT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More