A_ConditionContract

DDL: A_CONDITIONCONTRACT Type: view_entity CONSUMPTION

Condition Contract

A_ConditionContract is a Consumption CDS View that provides data about "Condition Contract" in SAP S/4HANA. It reads from 1 data source (R_ConditionContractTP) and exposes 76 fields with key field ConditionContract.

Data Sources (1)

SourceAliasJoin Type
R_ConditionContractTP R_ConditionContractTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Condition Contract view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.representativeKey ConditionContract view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract ConditionContract
CndnContrType CndnContrType
CndnContrProcVar CndnContrProcVar
Supplier Supplier
Customer Customer
CndnContrActvtnStatus CndnContrActvtnStatus
CndnContrValidFrom CndnContrValidFrom
CndnContrValidTo CndnContrValidTo
CndnContrClassfctnType CndnContrClassfctnType
DocumentReferenceID DocumentReferenceID
CndnContrAssgmtRef CndnContrAssgmtRef
ExternalDocumentReferenceID ExternalDocumentReferenceID
CndnContrExternalPartner CndnContrExternalPartner
CndnContrSourceDocCat CndnContrSourceDocCat
CndnContrSourceDoc CndnContrSourceDoc
CndnContrSourceDocItem CndnContrSourceDocItem
CndnContrSourceUUID CndnContrSourceUUID
CreationUTCDateTime CreationUTCDateTime
LastChangeUTCDateTime LastChangeUTCDateTime
CompanyCode CompanyCode
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Division Division
SalesGroup SalesGroup
SalesOffice SalesOffice
CndnContrSuplrSettlmtCat CndnContrSuplrSettlmtCat
CndnContrCustSettlmtCat CndnContrCustSettlmtCat
SettlmtProduct SettlmtProduct
CndnContrExtensionCalendar CndnContrExtensionCalendar
PriorSupplier PriorSupplier
BusVolTableGroup BusVolTableGroup
AmountFieldGroup AmountFieldGroup
FinalSettlmtCalendar FinalSettlmtCalendar
PartialSettlmtCalendar PartialSettlmtCalendar
DeltaSettlmtCalendar DeltaSettlmtCalendar
DeltaAccrualSettlmtCalendar DeltaAccrualSettlmtCalendar
AccrualClearingSettlmtCalendar AccrualClearingSettlmtCalendar
PrecedingConditionContract PrecedingConditionDocument
CndnContrUUID CndnContrUUID
CndnContrPurposeCat CndnContrPurposeCat
CndnContrCurrency CndnContrCurrency
CndnContrUnit CndnContrUnit
CndnContrUnitISOCode
CndnContrUnitSAPCode
CndnContrWeightUnit CndnContrWeightUnit
CndnContrWeightUnitISOCode
CndnContrWeightUnitSAPCode
CndnContrVolumeUnit CndnContrVolumeUnit
CndnContrVolumeUnitISOCode
CndnContrVolumeUnitSAPCode
CndnContrPointsQtyUnit CndnContrPointsQtyUnit
CndnContrPointsQtyUnitISOCode
CndnContrPointsQtyUnitSAPCode
ExchangeRate ExchangeRate
ExchangeRateDate ExchangeRateDate
ExchangeRateType ExchangeRateType
PaymentTerms PaymentTerms
CashDiscount1Days CashDiscount1Days
CashDiscount1Percent CashDiscount1Percent
CashDiscount2Days CashDiscount2Days
CashDiscount2Percent CashDiscount2Percent
NetPaymentDays NetPaymentDays
PaymentMethod PaymentMethod
AccrualUpdateIsRequired AccrualUpdateIsRequired
SettlmtPartTxRegnNmbr SettlmtPartTxRegnNmbr
TaxCountry TaxCountry
SettlmtPartTxRegnCntry SettlmtPartTxRegnCntry
PersonWorkAgreement PersonWorkAgreement
CndnContrWorkerCostCenter CndnContrWorkerCostCenter
CndnContrWorkerSettlmtCat CndnContrWorkerSettlmtCat
_Customer _Customer
_PriorSupplier _PriorSupplier
_Supplier _Supplier
_PersonWorkAgreement _PersonWorkAgreement
@EndUserText.label: 'Condition Contract'
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  usageType.serviceQuality: #C,
  usageType.dataClass: #TRANSACTIONAL,
  usageType.sizeCategory: #XXL,
  representativeKey: 'ConditionContract'
  }
@VDM: {
  viewType: #CONSUMPTION,
  lifecycle.contract.type: #PUBLIC_REMOTE_API,
  usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
  }

define root view entity A_ConditionContract
  provider contract transactional_query
  as projection on R_ConditionContractTP
{
  key ConditionContract,
      CndnContrType,
      CndnContrProcVar,
      Supplier,
      Customer,
      CndnContrActvtnStatus,
      @Semantics.businessDate.from: true
      CndnContrValidFrom,
      @Semantics.businessDate.to: true
      CndnContrValidTo,
      CndnContrClassfctnType,
      DocumentReferenceID,
      CndnContrAssgmtRef,
      ExternalDocumentReferenceID,
      CndnContrExternalPartner,
      CndnContrSourceDocCat,
      CndnContrSourceDoc,
      CndnContrSourceDocItem,
      CndnContrSourceUUID,
      //      CreatedByUser,

      CreationUTCDateTime,
      //      LastChangedByUser,

      LastChangeUTCDateTime,
      CompanyCode,
      PurchasingOrganization,
      PurchasingGroup,
      SalesOrganization,
      DistributionChannel,
      Division,
      SalesGroup,
      SalesOffice,
      CndnContrSuplrSettlmtCat,
      CndnContrCustSettlmtCat,
      SettlmtProduct,
      CndnContrExtensionCalendar,
      PriorSupplier,
      BusVolTableGroup,
      AmountFieldGroup,
      FinalSettlmtCalendar,
      PartialSettlmtCalendar,
      DeltaSettlmtCalendar,
      DeltaAccrualSettlmtCalendar,
      AccrualClearingSettlmtCalendar,
      PrecedingConditionDocument                                                                           as PrecedingConditionContract,
      CndnContrUUID,
      CndnContrPurposeCat,
      @Semantics.currencyCode: true
      CndnContrCurrency,
      @Semantics.unitOfMeasure: true
      CndnContrUnit,
      cast( _CndnContrUnit.UnitOfMeasureISOCode as wcb_settlement_meins_iso preserving type )              as CndnContrUnitISOCode,
      cast( _CndnContrUnit.UnitOfMeasureSAPCode as wcb_settlement_meins_sapcode preserving type )          as CndnContrUnitSAPCode,
      @Semantics.unitOfMeasure: true
      CndnContrWeightUnit,
      cast( _CndnContrWeightUnit.UnitOfMeasureISOCode as wcb_settlement_gewei_iso preserving type )        as CndnContrWeightUnitISOCode,
      cast( _CndnContrWeightUnit.UnitOfMeasureSAPCode as wcb_settlement_gewei_sapcode preserving type )    as CndnContrWeightUnitSAPCode,
      @Semantics.unitOfMeasure: true
      CndnContrVolumeUnit,
      cast( _CndnContrVolumeUnit.UnitOfMeasureISOCode as wcb_settlement_voleh_iso preserving type )        as CndnContrVolumeUnitISOCode,
      cast( _CndnContrVolumeUnit.UnitOfMeasureSAPCode as wcb_settlement_voleh_sapcode preserving type )    as CndnContrVolumeUnitSAPCode,
      @Semantics.unitOfMeasure: true
      CndnContrPointsQtyUnit,
      cast( _CndnContrPointsQtyUnit.UnitOfMeasureISOCode as wcb_settlement_punei_iso preserving type )     as CndnContrPointsQtyUnitISOCode,
      cast( _CndnContrPointsQtyUnit.UnitOfMeasureSAPCode as wcb_settlement_punei_sapcode preserving type ) as CndnContrPointsQtyUnitSAPCode,
      ExchangeRate,
      ExchangeRateDate,
      ExchangeRateType,
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount1Percent,
      CashDiscount2Days,
      CashDiscount2Percent,
      NetPaymentDays,
      PaymentMethod,
      AccrualUpdateIsRequired,
      SettlmtPartTxRegnNmbr,
      TaxCountry,
      SettlmtPartTxRegnCntry,

      /* Worker related fields */
      PersonWorkAgreement,
      CndnContrWorkerCostCenter,
      CndnContrWorkerSettlmtCat,

      /* --- Compositions --- */
      @ObjectModel.filter.enabled: false
      _CndnContrCndnRecord        : redirected to composition child A_CndnContrCndnRecord,
      _CndnContrBusVolSelCriteria : redirected to composition child A_CndnContrBusVolSelCriteria,
      _CndnContrSettlmtCal        : redirected to composition child A_CndnContrSettlmtCal,
      _CndnContrActiveStatus      : redirected to composition child A_CndnContrActiveStatus,

      /* --- Associations required for DCL --- */
      @Consumption.hidden: true
      _Customer,
      @Consumption.hidden: true
      _PriorSupplier,
      @Consumption.hidden: true
      _Supplier,
      @Consumption.hidden: true
      _PersonWorkAgreement

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UNITOFMEASURE",
"R_CONDITIONCONTRACTTP"
],
"ASSOCIATED":
[
"A_CNDNCONTRACTIVESTATUS",
"A_CNDNCONTRBUSVOLSELCRITERIA",
"A_CNDNCONTRCNDNRECORD",
"A_CNDNCONTRSETTLMTCAL",
"I_CUSTOMER",
"I_PERSONWORKAGREEMENT_1",
"I_SUPPLIER",
"R_CNDNCONTRACTIVESTATUSTP",
"R_CNDNCONTRBUSVOLSELCRITERIATP",
"R_CNDNCONTRCNDNRECORDTP",
"R_CNDNCONTRSETTLMTCALTP"
],
"BASE":
[
"R_CONDITIONCONTRACTTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/