R_ConditionContractDEX

DDL: R_CONDITIONCONTRACTDEX Type: view_entity COMPOSITE Package: WCB_AIL_VDM_DEX

Condition Contract Extraction

R_ConditionContractDEX is a Composite CDS View that provides data about "Condition Contract Extraction" in SAP S/4HANA. It reads from 1 data source (R_ConditionContract) and exposes 79 fields with key field ConditionContract. Part of development package WCB_AIL_VDM_DEX.

1 data source(s) 79 fields

Data Sources (1)

SourceAliasJoin Type
R_ConditionContract ConditionContract from

Annotations (9)

NameValueLevelField
EndUserText.label Condition Contract Extraction view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (79)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract R_ConditionContract ConditionContract
CndnContrType R_ConditionContract CndnContrType
CndnContrClassfctnType R_ConditionContract CndnContrClassfctnType
CndnContrProcVar R_ConditionContract CndnContrProcVar
DocumentReferenceID R_ConditionContract DocumentReferenceID
CndnContrAssgmtRef R_ConditionContract CndnContrAssgmtRef
ExternalDocumentReferenceID R_ConditionContract ExternalDocumentReferenceID
CndnContrExternalPartner R_ConditionContract CndnContrExternalPartner
CndnContrActvtnStatus R_ConditionContract CndnContrActvtnStatus
CndnContrValidFrom R_ConditionContract CndnContrValidFrom
CndnContrValidTo R_ConditionContract CndnContrValidTo
Supplier R_ConditionContract Supplier
Customer R_ConditionContract Customer
PriorSupplier R_ConditionContract PriorSupplier
PersonWorkAgreement R_ConditionContract PersonWorkAgreement
CompanyCode R_ConditionContract CompanyCode
PurchasingOrganization R_ConditionContract PurchasingOrganization
PurchasingGroup R_ConditionContract PurchasingGroup
SalesOrganization R_ConditionContract SalesOrganization
DistributionChannel R_ConditionContract DistributionChannel
Division R_ConditionContract Division
SalesGroup R_ConditionContract SalesGroup
SalesOffice R_ConditionContract SalesOffice
CreatedByUser R_ConditionContract CreatedByUser
CreationDate R_ConditionContract CreationDate
CreationTime R_ConditionContract CreationTime
CreationTimeZone R_ConditionContract CreationTimeZone
CreationUTCDateTime R_ConditionContract CreationUTCDateTime
LastChangedByUser R_ConditionContract LastChangedByUser
LastChangedDate R_ConditionContract LastChangedDate
LastChangeTime R_ConditionContract LastChangeTime
LastChangeUTCDateTime R_ConditionContract LastChangeUTCDateTime
CndnContrCurrency R_ConditionContract CndnContrCurrency
ExchangeRate R_ConditionContract ExchangeRate
ExchangeRateType R_ConditionContract ExchangeRateType
ExchangeRateDate R_ConditionContract ExchangeRateDate
PaymentTerms R_ConditionContract PaymentTerms
CashDiscount1Days R_ConditionContract CashDiscount1Days
CashDiscount1Percent R_ConditionContract CashDiscount1Percent
CashDiscount2Days R_ConditionContract CashDiscount2Days
CashDiscount2Percent R_ConditionContract CashDiscount2Percent
NetPaymentDays R_ConditionContract NetPaymentDays
PaymentMethod R_ConditionContract PaymentMethod
CndnContrSuplrSettlmtCat R_ConditionContract CndnContrSuplrSettlmtCat
CndnContrCustSettlmtCat R_ConditionContract CndnContrCustSettlmtCat
SettlmtProduct R_ConditionContract SettlmtProduct
FinalSettlmtCalendar R_ConditionContract FinalSettlmtCalendar
PartialSettlmtCalendar R_ConditionContract PartialSettlmtCalendar
DeltaSettlmtCalendar R_ConditionContract DeltaSettlmtCalendar
DeltaAccrualSettlmtCalendar R_ConditionContract DeltaAccrualSettlmtCalendar
AccrualClearingSettlmtCalendar R_ConditionContract AccrualClearingSettlmtCalendar
CndnContrExtensionCalendar R_ConditionContract CndnContrExtensionCalendar
PrecedingConditionDocument R_ConditionContract PrecedingConditionDocument
CndnContrPurposeCat R_ConditionContract CndnContrPurposeCat
CndnContrSourceDocCat R_ConditionContract CndnContrSourceDocCat
CndnContrSourceDoc R_ConditionContract CndnContrSourceDoc
CndnContrSourceDocItem R_ConditionContract CndnContrSourceDocItem
BusVolTableGroup R_ConditionContract BusVolTableGroup
AmountFieldGroup R_ConditionContract AmountFieldGroup
CndnContrUnit R_ConditionContract CndnContrUnit
CndnContrWeightUnit R_ConditionContract CndnContrWeightUnit
CndnContrVolumeUnit R_ConditionContract CndnContrVolumeUnit
CndnContrPointsQtyUnit R_ConditionContract CndnContrPointsQtyUnit
AccrualUpdateIsRequired R_ConditionContract AccrualUpdateIsRequired
TaxCountry R_ConditionContract TaxCountry
SettlmtPartTxRegnCntry R_ConditionContract SettlmtPartTxRegnCntry
SettlmtPartTxRegnNmbr R_ConditionContract SettlmtPartTxRegnNmbr
BasicConditionContract R_ConditionContract BasicConditionContract
CndnContrWorkerCostCenter R_ConditionContract CndnContrWorkerCostCenter
CndnContrSemanticCode R_ConditionContract CndnContrSemanticCode
_Customer R_ConditionContract _Customer
_PriorSupplier R_ConditionContract _PriorSupplier
_Supplier R_ConditionContract _Supplier
_PersonWorkAgreement R_ConditionContract _PersonWorkAgreement
_CndnContrCurrency R_ConditionContract _CndnContrCurrency
_CndnContrUnit R_ConditionContract _CndnContrUnit
_CndnContrWeightUnit R_ConditionContract _CndnContrWeightUnit
_CndnContrVolumeUnit R_ConditionContract _CndnContrVolumeUnit
_CndnContrPointsQtyUnit R_ConditionContract _CndnContrPointsQtyUnit 
@EndUserText.label: 'Condition Contract Extraction'
@AccessControl: {
    authorizationCheck:     #MANDATORY,
    personalData.blocking:  #('TRANSACTIONAL_DATA')
    }

@ObjectModel: {
   usageType.serviceQuality: #B,
   usageType.dataClass:      #TRANSACTIONAL,
   usageType.sizeCategory:   #XXL
   } 
@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #SAP_INTERNAL_API
    } 
@Metadata: {
    ignorePropagatedAnnotations: true,
    allowExtensions: false
    }

define view entity R_ConditionContractDEX
  as select from R_ConditionContract as ConditionContract
{
  key ConditionContract.ConditionContract,
      ConditionContract.CndnContrType,
      ConditionContract.CndnContrClassfctnType,
      ConditionContract.CndnContrProcVar,
      ConditionContract.DocumentReferenceID,
      ConditionContract.CndnContrAssgmtRef,
      ConditionContract.ExternalDocumentReferenceID,
      ConditionContract.CndnContrExternalPartner,
      ConditionContract.CndnContrActvtnStatus,

      /* Validity */
      ConditionContract.CndnContrValidFrom,
      ConditionContract.CndnContrValidTo,

      /* Partners */
      ConditionContract.Supplier,
      ConditionContract.Customer,
      ConditionContract.PriorSupplier,
      ConditionContract.PersonWorkAgreement,

      /* Organizational Data */
      ConditionContract.CompanyCode,
      ConditionContract.PurchasingOrganization,
      ConditionContract.PurchasingGroup,
      ConditionContract.SalesOrganization,
      ConditionContract.DistributionChannel,
      ConditionContract.Division,
      ConditionContract.SalesGroup,
      ConditionContract.SalesOffice,

      /*Administrative Data */
      ConditionContract.CreatedByUser,
      ConditionContract.CreationDate,
      ConditionContract.CreationTime,
      ConditionContract.CreationTimeZone,
      ConditionContract.CreationUTCDateTime,
      ConditionContract.LastChangedByUser,
      ConditionContract.LastChangedDate,
      ConditionContract.LastChangeTime,
      ConditionContract.LastChangeUTCDateTime,

      /* Currency and Exchange Rate */
      ConditionContract.CndnContrCurrency,
      ConditionContract.ExchangeRate,
      ConditionContract.ExchangeRateType,
      ConditionContract.ExchangeRateDate,

      /* Payment terms and method */
      ConditionContract.PaymentTerms,
      ConditionContract.CashDiscount1Days,
      ConditionContract.CashDiscount1Percent,
      ConditionContract.CashDiscount2Days,
      ConditionContract.CashDiscount2Percent,
      ConditionContract.NetPaymentDays,
      ConditionContract.PaymentMethod,
      ConditionContract.CndnContrSuplrSettlmtCat,
      ConditionContract.CndnContrCustSettlmtCat,
      ConditionContract.SettlmtProduct,

      /* Calendars */
      ConditionContract.FinalSettlmtCalendar,
      ConditionContract.PartialSettlmtCalendar,
      ConditionContract.DeltaSettlmtCalendar,
      ConditionContract.DeltaAccrualSettlmtCalendar,
      ConditionContract.AccrualClearingSettlmtCalendar,
      ConditionContract.CndnContrExtensionCalendar,
      ConditionContract.PrecedingConditionDocument,
      ConditionContract.CndnContrPurposeCat,

      /* Source Document */
      ConditionContract.CndnContrSourceDocCat,
      ConditionContract.CndnContrSourceDoc,
      ConditionContract.CndnContrSourceDocItem,
      ConditionContract.BusVolTableGroup,
      ConditionContract.AmountFieldGroup,

      /* Units */
      ConditionContract.CndnContrUnit,
      ConditionContract.CndnContrWeightUnit,
      ConditionContract.CndnContrVolumeUnit,
      ConditionContract.CndnContrPointsQtyUnit,

      ConditionContract.AccrualUpdateIsRequired,

      /* Tax */
      ConditionContract.TaxCountry,
      ConditionContract.SettlmtPartTxRegnCntry,

      /* VAT Registration */
      ConditionContract.SettlmtPartTxRegnNmbr,
      ConditionContract.BasicConditionContract,

      /* Worker related fields */
      ConditionContract.CndnContrWorkerCostCenter,

      /* Semantic Code */
      ConditionContract.CndnContrSemanticCode,

      @Consumption.hidden: true
      ConditionContract._Customer,
      @Consumption.hidden: true
      ConditionContract._PriorSupplier,
      @Consumption.hidden: true
      ConditionContract._Supplier,
      @Consumption.hidden: true
      ConditionContract._PersonWorkAgreement,

      /* Associations */
      ConditionContract._CndnContrCurrency,
      ConditionContract._CndnContrUnit,
      ConditionContract._CndnContrWeightUnit,
      ConditionContract._CndnContrVolumeUnit,
      ConditionContract._CndnContrPointsQtyUnit
}

Learn More