R_ConditionDocument

DDL: R_CONDITIONDOCUMENT Type: view_entity BASIC

Condition Document

R_ConditionDocument is a Basic CDS View that provides data about "Condition Document" in SAP S/4HANA. It reads from 1 data source (wcocoh) and exposes 133 fields with key field ConditionDocument. It has 52 associations to related views.

Data Sources (1)

SourceAliasJoin Type
wcocoh wcocoh from

Associations (52)

CardinalityTargetAliasCondition
[0..*] R_CndnDocBusVolSelCriteria _CndnDocBusVolSelCriteria $projection.ConditionDocument = _CndnDocBusVolSelCriteria.ConditionDocument
[0..*] R_CndnDocSettlmtCal _CndnDocSettlmtCal $projection.ConditionDocument = _CndnDocSettlmtCal.ConditionDocument
[0..*] R_ConditionDocumentItem _ConditionDocumentItem $projection.ConditionDocument = _ConditionDocumentItem.ConditionDocument
[0..*] R_CndnDocConditionUsage _CndnDocConditionUsage $projection.ConditionDocument = _CndnDocConditionUsage.ConditionDocument
[0..1] R_CndnContrType _CndnContrType $projection.CndnContrType = _CndnContrType.CndnContrType
[0..1] I_CndnContrClassfctnType _CndnContrClassfctnType $projection.CndnContrClassfctnType = _CndnContrClassfctnType.CndnContrClassfctnType
[0..1] I_CndnContrProcVar _CndnContrProcVar $projection.CndnContrProcVar = _CndnContrProcVar.CndnContrProcVar
[0..1] I_CndnContrActvtnStatus _CndnDocActivationStatus $projection.CndnDocActivationStatus = _CndnDocActivationStatus.CndnContrActvtnStatus
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Supplier _PriorSupplier $projection.PriorSupplier = _PriorSupplier.Supplier
[0..1] I_PersonWorkAgreement_1 _PersonWorkAgreement $projection.PersonWorkAgreement = _PersonWorkAgreement.PersonWorkAgreement
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_PurchasingOrganization _PurchasingOrganization $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
[0..1] I_PurchasingGroup _PurchasingGroup $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup
[0..1] I_SalesOrganization _SalesOrganization $projection.SalesOrganization = _SalesOrganization.SalesOrganization
[0..1] I_DistributionChannel _DistributionChannel $projection.DistributionChannel = _DistributionChannel.DistributionChannel
[0..1] I_Division _Division $projection.Division = _Division.Division
[0..1] I_SalesGroup _SalesGroup $projection.SalesGroup = _SalesGroup.SalesGroup
[0..1] I_SalesOffice _SalesOffice $projection.SalesOffice = _SalesOffice.SalesOffice
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID
[0..1] I_Currency _ConditionDocumentCurrency $projection.ConditionDocumentCurrency = _ConditionDocumentCurrency.Currency
[0..1] I_ExchangeRateType _ExchangeRateType $projection.ExchangeRateType = _ExchangeRateType.ExchangeRateType
[0..1] I_CndnContrSuplrSettlmtCat _CndnDocSuplrSettlmtCat $projection.CndnDocSuplrSettlmtCat = _CndnDocSuplrSettlmtCat.CndnContrSuplrSettlmtCat
[0..1] I_CndnContrCustSettlmtCat _CndnDocCustSettlmtCat $projection.CndnDocCustSettlmtCat = _CndnDocCustSettlmtCat.CndnContrCustSettlmtCat
[0..1] I_Product _SettlmtProduct $projection.SettlmtProduct = _SettlmtProduct.Product
[0..1] I_FactoryCalendar _FinalSettlmtCalendar $projection.FinalSettlmtCalendar = _FinalSettlmtCalendar.FactoryCalendar
[0..1] I_FactoryCalendar _PartialSettlmtCalendar $projection.PartialSettlmtCalendar = _PartialSettlmtCalendar.FactoryCalendar
[0..1] I_FactoryCalendar _DeltaSettlmtCalendar $projection.DeltaSettlmtCalendar = _DeltaSettlmtCalendar.FactoryCalendar
[0..1] I_FactoryCalendar _DeltaAccrualSettlmtCalendar $projection.DeltaAccrualSettlmtCalendar = _DeltaAccrualSettlmtCalendar.FactoryCalendar
[0..1] I_FactoryCalendar _AccrualClearingSettlmtCal $projection.AccrualClearingSettlmtCalendar = _AccrualClearingSettlmtCal.FactoryCalendar
[0..1] I_FactoryCalendar _CndnContrExtensionCalendar $projection.CndnContrExtensionCalendar = _CndnContrExtensionCalendar.FactoryCalendar
[0..1] I_BusVolTableGroup _BusVolTableGroup $projection.BusVolTableGroup = _BusVolTableGroup.BusVolTableGroup
[0..1] I_AmountFieldGroup _AmountFieldGroup $projection.AmountFieldGroup = _AmountFieldGroup.AmountFieldGroup
[0..1] I_UnitOfMeasure _ConditionDocumentUnit $projection.ConditionDocumentUnit = _ConditionDocumentUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _ConditionDocumentWeightUnit $projection.ConditionDocumentWeightUnit = _ConditionDocumentWeightUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _ConditionDocumentVolumeUnit $projection.ConditionDocumentVolumeUnit = _ConditionDocumentVolumeUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _CndnDocPointsQuantityUnit $projection.CndnDocPointsQuantityUnit = _CndnDocPointsQuantityUnit.UnitOfMeasure
[0..1] R_ConditionDocument _PrecedingConditionDocument $projection.PrecedingConditionDocument = _PrecedingConditionDocument.ConditionDocument
[0..1] I_CndnContrPurposeCat _CndnDocPurposeCategory $projection.CndnDocPurposeCategory = _CndnDocPurposeCategory.CndnContrPurposeCat
[0..1] I_CndnContrSourceDocCat _CndnDocSourceDocumentCategory $projection.CndnDocSourceDocumentCategory = _CndnDocSourceDocumentCategory.CndnContrSourceDocCat
[0..1] I_CndnDocWorkerSettlmtCat _CndnDocWorkerSettlmtCat $projection.CndnDocWorkerSettlmtCat = _CndnDocWorkerSettlmtCat.CndnDocWorkerSettlmtCat
[0..1] I_CndnContrPrcgDetnRlvnceCat _CndnDocPrcgDetnRlvnceCat $projection.CndnDocPrcgDetnRlvnceCat = _CndnDocPrcgDetnRlvnceCat.CndnContrPrcgDetnRlvnceCat
[0..1] R_BusVolTotAmtSpltCritraGrp _BusVolTotAmtSpltCritraGrp $projection.BusVolTotAmtSpltCritraGrp = _BusVolTotAmtSpltCritraGrp.BusVolTotAmtSpltCritraGrp
[0..1] I_Country _TaxCountry $projection.TaxCountry = _TaxCountry.Country
[0..1] I_Country _SettlmtPartTxRegnCntry $projection.SettlmtPartTxRegnCntry = _SettlmtPartTxRegnCntry.Country
[0..1] I_CndnContrPartnerCat _CndnContrPartnerCat $projection.CndnContrPartnerCat = _CndnContrPartnerCat.CndnContrPartnerCat
[0..1] I_CndnContrSettlmtType _CndnContrSettlmtType $projection.CndnContrSettlmtType = _CndnContrSettlmtType.CndnContrSettlmtType
[0..1] I_CndnContrProcessCategory _CndnContrProcessCategory $projection.CndnContrProcessCategory = _CndnContrProcessCategory.CndnContrProcessCategory
[0..1] I_CostCenter _CndnDocWorkerCostCenter $projection.CndnDocWorkerCostCenter = _CndnDocWorkerCostCenter.CostCenter and $projection.CndnDocWrkrControllingArea = _CndnDocWorkerCostCenter.ControllingArea and _CndnDocWorkerCostCenter.ValidityEndDate >= $projection.ConditionDocumentValidToDate and _CndnDocWorkerCostCenter.ValidityStartDate <= $projection.ConditionDocumentValidToDate
[0..1] I_ControllingArea _CndnDocWrkrControllingArea $projection.CndnDocWrkrControllingArea = _CndnDocWrkrControllingArea.ControllingArea

Annotations (10)

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

Fields (133)

KeyFieldSource TableSource FieldDescription
KEY ConditionDocument
CndnContrType
CndnContrClassfctnType category
CndnContrProcVar process_variant
DocumentReferenceID reference
CndnDocAssignmentReference assignment
ExternalDocumentReferenceID ext_num
CndnDocExternalPartner ext_partner
CndnDocActivationStatus
ConditionDocumentValidFromDate date_from
ConditionDocumentValidToDate date_to
Supplier
Customer
PriorSupplier kolif
PersonWorkAgreement person_owner
CompanyCode
PurchasingOrganization ekorg
PurchasingGroup ekgrp
SalesOrganization
DistributionChannel
Division
SalesGroup vkgrp
SalesOffice vkbur
CreatedByUser created_by
CreationDate created_on
CreationTime rec_time
CreationTimeZone zonlo
CreationUTCDateTime created_on_tstmp
LastChangedByUser ch_name
LastChangedDate ch_date
LastChangeTime ch_time
LastChangeUTCDateTime ch_tstmp
ConditionDocumentCurrency
ExchangeRate
ExchangeRateType rate_type
ExchangeRateDate rate_date
PaymentTerms zterm
CashDiscount1Days
CashDiscount1Percent
CashDiscount2Days
CashDiscount2Percent
NetPaymentDays
PaymentMethod zlsch
CndnDocSuplrSettlmtCat
CndnDocCustSettlmtCat
SettlmtProduct
FinalSettlmtCalendar settl_cal_final
PartialSettlmtCalendar settl_cal_part
DeltaSettlmtCalendar settl_cal_delta
DeltaAccrualSettlmtCalendar settl_cal_accr
AccrualClearingSettlmtCalendar settl_cal_accr_rollo
CndnContrExtensionCalendar extension_cal
PrecedingConditionDocument pred_cc
CndnDocPurposeCategory cc_purpose
CndnDocSourceDocumentCategory ext_ref_cat
CndnDocSourceDocument ext_ref
CndnDocSourceDocumentItem ext_ref_item
BusVolTableGroup bvtab_group
AmountFieldGroup af_group
ConditionDocumentUnit settl_meins
ConditionDocumentWeightUnit settl_gewei
ConditionDocumentVolumeUnit settl_voleh
CndnDocPointsQuantityUnit settl_punei
AccrualUpdateIsRequired accruals_upd_req
ConditionDocumentUUID
ConditionDocumentSourceUUID
TaxCountry tax_reporting_country
SettlmtPartTxRegnCntry tax_country
SettlmtPartTxRegnNmbr stceg
CndnDocPrcgDetnRlvnceCat coco_det_rel_contr
BusVolTotAmtSpltCritraGrp afsc_group
BasicConditionContract num_basic_contract
CndnContrPartnerCat owner_type
CndnContrProcessCategory process_category
CndnContrSettlmtType
CndnDocWorkerCostCenter pers_kostl
CndnDocWrkrControllingArea pers_kokrs
CndnDocWorkerSettlmtCat settl_type_person
CndnDocObjNodeTypeAbbr sont_abbrv_h
CndnDocSemanticCode semantic_type_h
DataController data_controller
_CndnDocBusVolSelCriteria _CndnDocBusVolSelCriteria
_CndnDocSettlmtCal _CndnDocSettlmtCal
_ConditionDocumentItem _ConditionDocumentItem
_CndnDocConditionUsage _CndnDocConditionUsage
_CndnContrType _CndnContrType
_CndnContrClassfctnType _CndnContrClassfctnType
_CndnContrProcVar _CndnContrProcVar
_CndnDocActivationStatus _CndnDocActivationStatus
_Supplier _Supplier
_Customer _Customer
_PriorSupplier _PriorSupplier
_PersonWorkAgreement _PersonWorkAgreement
_CompanyCode _CompanyCode
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesGroup _SalesGroup
_SalesOffice _SalesOffice
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_ConditionDocumentCurrency _ConditionDocumentCurrency
_ExchangeRateType _ExchangeRateType
_CndnDocSuplrSettlmtCat _CndnDocSuplrSettlmtCat
_CndnDocCustSettlmtCat _CndnDocCustSettlmtCat
_SettlmtProduct _SettlmtProduct
_FinalSettlmtCalendar _FinalSettlmtCalendar
_PartialSettlmtCalendar _PartialSettlmtCalendar
_DeltaSettlmtCalendar _DeltaSettlmtCalendar
_DeltaAccrualSettlmtCalendar _DeltaAccrualSettlmtCalendar
_AccrualClearingSettlmtCal _AccrualClearingSettlmtCal
_CndnContrExtensionCalendar _CndnContrExtensionCalendar
_PrecedingConditionDocument _PrecedingConditionDocument
_CndnDocPurposeCategory _CndnDocPurposeCategory
_CndnDocSourceDocumentCategory _CndnDocSourceDocumentCategory
_BusVolTableGroup _BusVolTableGroup
_AmountFieldGroup _AmountFieldGroup
_ConditionDocumentUnit _ConditionDocumentUnit
_ConditionDocumentWeightUnit _ConditionDocumentWeightUnit
_ConditionDocumentVolumeUnit _ConditionDocumentVolumeUnit
_CndnDocPointsQuantityUnit _CndnDocPointsQuantityUnit
_TaxCountry _TaxCountry
_SettlmtPartTxRegnCntry _SettlmtPartTxRegnCntry
_CndnDocPrcgDetnRlvnceCat _CndnDocPrcgDetnRlvnceCat
_BusVolTotAmtSpltCritraGrp _BusVolTotAmtSpltCritraGrp
_CndnContrPartnerCat _CndnContrPartnerCat
_CndnContrProcessCategory _CndnContrProcessCategory
_CndnContrSettlmtType _CndnContrSettlmtType
_CndnDocWorkerCostCenter _CndnDocWorkerCostCenter
_CndnDocWrkrControllingArea _CndnDocWrkrControllingArea
_CndnDocWorkerSettlmtCat _CndnDocWorkerSettlmtCat
@EndUserText.label: 'Condition Document'
@AccessControl: {
    authorizationCheck:     #MANDATORY,
    personalData.blocking:  #('TRANSACTIONAL_DATA'),
    privilegedAssociations: [  '_LastChangedByUser', '_CreatedByUser'  ]
    }
@ObjectModel: {
    representativeKey:        'ConditionDocument',
    usageType.serviceQuality: #B,
    usageType.dataClass:      #TRANSACTIONAL,
    usageType.sizeCategory:   #XXL
    }
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #SAP_INTERNAL_API
    }
@Metadata: {
    ignorePropagatedAnnotations: true,
    allowExtensions: false
    }

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view entity R_ConditionDocument
  as select from wcocoh

  association [0..*] to R_CndnDocBusVolSelCriteria   as _CndnDocBusVolSelCriteria      on  $projection.ConditionDocument = _CndnDocBusVolSelCriteria.ConditionDocument
  association [0..*] to R_CndnDocSettlmtCal          as _CndnDocSettlmtCal             on  $projection.ConditionDocument = _CndnDocSettlmtCal.ConditionDocument
  association [0..*] to R_ConditionDocumentItem      as _ConditionDocumentItem         on  $projection.ConditionDocument = _ConditionDocumentItem.ConditionDocument
  association [0..*] to R_CndnDocConditionUsage      as _CndnDocConditionUsage         on  $projection.ConditionDocument = _CndnDocConditionUsage.ConditionDocument

  association [0..1] to R_CndnContrType              as _CndnContrType                 on  $projection.CndnContrType = _CndnContrType.CndnContrType
  association [0..1] to I_CndnContrClassfctnType     as _CndnContrClassfctnType        on  $projection.CndnContrClassfctnType = _CndnContrClassfctnType.CndnContrClassfctnType
  association [0..1] to I_CndnContrProcVar           as _CndnContrProcVar              on  $projection.CndnContrProcVar = _CndnContrProcVar.CndnContrProcVar
  association [0..1] to I_CndnContrActvtnStatus      as _CndnDocActivationStatus       on  $projection.CndnDocActivationStatus = _CndnDocActivationStatus.CndnContrActvtnStatus

  /* Partners */
  association [0..1] to I_Supplier                   as _Supplier                      on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_Customer                   as _Customer                      on  $projection.Customer = _Customer.Customer
  association [0..1] to I_Supplier                   as _PriorSupplier                 on  $projection.PriorSupplier = _PriorSupplier.Supplier
  association [0..1] to I_PersonWorkAgreement_1      as _PersonWorkAgreement           on  $projection.PersonWorkAgreement = _PersonWorkAgreement.PersonWorkAgreement

  /* Organizational Data */
  association [0..1] to I_CompanyCode                as _CompanyCode                   on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_PurchasingOrganization     as _PurchasingOrganization        on  $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
  association [0..1] to I_PurchasingGroup            as _PurchasingGroup               on  $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup
  association [0..1] to I_SalesOrganization          as _SalesOrganization             on  $projection.SalesOrganization = _SalesOrganization.SalesOrganization
  association [0..1] to I_DistributionChannel        as _DistributionChannel           on  $projection.DistributionChannel = _DistributionChannel.DistributionChannel
  association [0..1] to I_Division                   as _Division                      on  $projection.Division = _Division.Division
  association [0..1] to I_SalesGroup                 as _SalesGroup                    on  $projection.SalesGroup = _SalesGroup.SalesGroup
  association [0..1] to I_SalesOffice                as _SalesOffice                   on  $projection.SalesOffice = _SalesOffice.SalesOffice

  /* Administrative Data */
  association [0..1] to I_User                       as _CreatedByUser                 on  $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                       as _LastChangedByUser             on  $projection.LastChangedByUser = _LastChangedByUser.UserID

  /* Currency and Exchange Rate */
  association [0..1] to I_Currency                   as _ConditionDocumentCurrency     on  $projection.ConditionDocumentCurrency = _ConditionDocumentCurrency.Currency
  association [0..1] to I_ExchangeRateType           as _ExchangeRateType              on  $projection.ExchangeRateType = _ExchangeRateType.ExchangeRateType

  association [0..1] to I_CndnContrSuplrSettlmtCat   as _CndnDocSuplrSettlmtCat        on  $projection.CndnDocSuplrSettlmtCat = _CndnDocSuplrSettlmtCat.CndnContrSuplrSettlmtCat
  association [0..1] to I_CndnContrCustSettlmtCat    as _CndnDocCustSettlmtCat         on  $projection.CndnDocCustSettlmtCat = _CndnDocCustSettlmtCat.CndnContrCustSettlmtCat
  association [0..1] to I_Product                    as _SettlmtProduct                on  $projection.SettlmtProduct = _SettlmtProduct.Product

  /* Calendars */
  association [0..1] to I_FactoryCalendar            as _FinalSettlmtCalendar          on  $projection.FinalSettlmtCalendar = _FinalSettlmtCalendar.FactoryCalendar
  association [0..1] to I_FactoryCalendar            as _PartialSettlmtCalendar        on  $projection.PartialSettlmtCalendar = _PartialSettlmtCalendar.FactoryCalendar
  association [0..1] to I_FactoryCalendar            as _DeltaSettlmtCalendar          on  $projection.DeltaSettlmtCalendar = _DeltaSettlmtCalendar.FactoryCalendar
  association [0..1] to I_FactoryCalendar            as _DeltaAccrualSettlmtCalendar   on  $projection.DeltaAccrualSettlmtCalendar = _DeltaAccrualSettlmtCalendar.FactoryCalendar
  association [0..1] to I_FactoryCalendar            as _AccrualClearingSettlmtCal     on  $projection.AccrualClearingSettlmtCalendar = _AccrualClearingSettlmtCal.FactoryCalendar
  association [0..1] to I_FactoryCalendar            as _CndnContrExtensionCalendar    on  $projection.CndnContrExtensionCalendar = _CndnContrExtensionCalendar.FactoryCalendar

  association [0..1] to I_BusVolTableGroup           as _BusVolTableGroup              on  $projection.BusVolTableGroup = _BusVolTableGroup.BusVolTableGroup
  association [0..1] to I_AmountFieldGroup           as _AmountFieldGroup              on  $projection.AmountFieldGroup = _AmountFieldGroup.AmountFieldGroup
  association [0..1] to I_UnitOfMeasure              as _ConditionDocumentUnit         on  $projection.ConditionDocumentUnit = _ConditionDocumentUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _ConditionDocumentWeightUnit   on  $projection.ConditionDocumentWeightUnit = _ConditionDocumentWeightUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _ConditionDocumentVolumeUnit   on  $projection.ConditionDocumentVolumeUnit = _ConditionDocumentVolumeUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _CndnDocPointsQuantityUnit     on  $projection.CndnDocPointsQuantityUnit = _CndnDocPointsQuantityUnit.UnitOfMeasure

  association [0..1] to R_ConditionDocument          as _PrecedingConditionDocument    on  $projection.PrecedingConditionDocument = _PrecedingConditionDocument.ConditionDocument
  association [0..1] to I_CndnContrPurposeCat        as _CndnDocPurposeCategory        on  $projection.CndnDocPurposeCategory = _CndnDocPurposeCategory.CndnContrPurposeCat
  association [0..1] to I_CndnContrSourceDocCat      as _CndnDocSourceDocumentCategory on  $projection.CndnDocSourceDocumentCategory = _CndnDocSourceDocumentCategory.CndnContrSourceDocCat
  association [0..1] to I_CndnDocWorkerSettlmtCat    as _CndnDocWorkerSettlmtCat       on  $projection.CndnDocWorkerSettlmtCat = _CndnDocWorkerSettlmtCat.CndnDocWorkerSettlmtCat
  
  association [0..1] to I_CndnContrPrcgDetnRlvnceCat as _CndnDocPrcgDetnRlvnceCat      on  $projection.CndnDocPrcgDetnRlvnceCat = _CndnDocPrcgDetnRlvnceCat.CndnContrPrcgDetnRlvnceCat
  association [0..1] to R_BusVolTotAmtSpltCritraGrp  as _BusVolTotAmtSpltCritraGrp     on  $projection.BusVolTotAmtSpltCritraGrp = _BusVolTotAmtSpltCritraGrp.BusVolTotAmtSpltCritraGrp

  /* Tax */
  association [0..1] to I_Country                    as _TaxCountry                    on  $projection.TaxCountry = _TaxCountry.Country
  association [0..1] to I_Country                    as _SettlmtPartTxRegnCntry        on  $projection.SettlmtPartTxRegnCntry = _SettlmtPartTxRegnCntry.Country

  association [0..1] to I_CndnContrPartnerCat        as _CndnContrPartnerCat           on  $projection.CndnContrPartnerCat = _CndnContrPartnerCat.CndnContrPartnerCat
  association [0..1] to I_CndnContrSettlmtType       as _CndnContrSettlmtType          on  $projection.CndnContrSettlmtType = _CndnContrSettlmtType.CndnContrSettlmtType
  association [0..1] to I_CndnContrProcessCategory   as _CndnContrProcessCategory      on  $projection.CndnContrProcessCategory = _CndnContrProcessCategory.CndnContrProcessCategory

  /* Worker related fields */
  association [0..1] to I_CostCenter                 as _CndnDocWorkerCostCenter       on  $projection.CndnDocWorkerCostCenter        = _CndnDocWorkerCostCenter.CostCenter
                                                                                       and $projection.CndnDocWrkrControllingArea     = _CndnDocWorkerCostCenter.ControllingArea
                                                                                       and _CndnDocWorkerCostCenter.ValidityEndDate   >= $projection.ConditionDocumentValidToDate
                                                                                       and _CndnDocWorkerCostCenter.ValidityStartDate <= $projection.ConditionDocumentValidToDate
  association [0..1] to I_ControllingArea            as _CndnDocWrkrControllingArea    on  $projection.CndnDocWrkrControllingArea = _CndnDocWrkrControllingArea.ControllingArea

{

  key cast( num as wcb_condition_document preserving type )                  as ConditionDocument,
      @ObjectModel.foreignKey.association: '_CndnContrType'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_CndnContrTypeStdVH', element: 'CndnContrType' } }]
      }
      cast( contract_type as wcb_contract_type preserving type )             as CndnContrType,
      @ObjectModel.foreignKey.association: '_CndnContrClassfctnType'
      category                                                               as CndnContrClassfctnType,
      @ObjectModel.foreignKey.association: '_CndnContrProcVar'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_CndnContrProcVarStdVH', element: 'CndnContrProcVar' } }]
      }
      process_variant                                                        as CndnContrProcVar,
      reference                                                              as DocumentReferenceID,
      assignment                                                             as CndnDocAssignmentReference,
      ext_num                                                                as ExternalDocumentReferenceID,
      ext_partner                                                            as CndnDocExternalPartner,
      @ObjectModel.foreignKey.association: '_CndnDocActivationStatus'
      cast( deact as wcb_cc_state preserving type )                          as CndnDocActivationStatus,

      /* Validity */
      @Semantics.businessDate.from: true
      date_from                                                              as ConditionDocumentValidFromDate,
      @Semantics.businessDate.to: true
      date_to                                                                as ConditionDocumentValidToDate,

      /* Partners */
      @ObjectModel.foreignKey.association: '_Supplier'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_Supplier_VH', element: 'Supplier' } }]
      }
      cast( vend_owner as wcb_vend_owner preserving type )                   as Supplier,
      @ObjectModel.foreignKey.association: '_Customer'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_Customer_VH', element: 'Customer' } }]
      }
      cast( cust_owner as wcb_cust_owner preserving type )                   as Customer,
      @ObjectModel.foreignKey.association: '_PriorSupplier'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_Supplier_VH', element: 'Supplier' } }]
      }
      kolif                                                                  as PriorSupplier,
      @Consumption:{
        valueHelpDefinition: [{ entity: { name:'I_PersWrkAgrmtSrchHelp_1' , element: 'PersonWorkAgreement' } }]
      }
      person_owner                                                           as PersonWorkAgreement,

      /* Organizational Data */
      @ObjectModel.foreignKey.association: '_CompanyCode'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } }]
      }
      cast( bukrs as bukrs preserving type )                                 as CompanyCode,
      @ObjectModel.foreignKey.association: '_PurchasingOrganization'
      ekorg                                                                  as PurchasingOrganization,
      @ObjectModel.foreignKey.association: '_PurchasingGroup'
      ekgrp                                                                  as PurchasingGroup,
      @ObjectModel.foreignKey.association: '_SalesOrganization'
      cast( vkorg as vkorg preserving type )                                 as SalesOrganization,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      cast( vtweg as vtweg  preserving type )                                as DistributionChannel,
      @ObjectModel.foreignKey.association: '_Division'
      cast( spart as spart preserving type )                                 as Division,
      @ObjectModel.foreignKey.association: '_Salesgroup'
      vkgrp                                                                  as SalesGroup,
      @ObjectModel.foreignKey.association: '_SalesOffice'
      vkbur                                                                  as SalesOffice,

      /* Administrative Data */
      @Semantics.user.createdBy: true
      created_by                                                             as CreatedByUser,
      @Semantics.systemDate.createdAt: true
      created_on                                                             as CreationDate,
      rec_time                                                               as CreationTime,
      zonlo                                                                  as CreationTimeZone,
      @Semantics.systemDateTime.createdAt: true
      created_on_tstmp                                                       as CreationUTCDateTime,
      @Semantics.user.lastChangedBy: true
      ch_name                                                                as LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      ch_date                                                                as LastChangedDate,
      ch_time                                                                as LastChangeTime,
      @Semantics.systemDateTime.lastChangedAt: true
      ch_tstmp                                                               as LastChangeUTCDateTime,

      /* Currency and Exchange Rate */
      @ObjectModel.foreignKey.association: '_ConditionDocumentCurrency'
      cast( cc_curr as wcb_cndn_doc_curr preserving type )                   as ConditionDocumentCurrency,
      cast( rate as wlf_wcb_wkurs_no_cnext preserving type )                 as ExchangeRate,
      @ObjectModel.foreignKey.association: '_ExchangeRateType'
      rate_type                                                              as ExchangeRateType,
      rate_date                                                              as ExchangeRateDate,

      /* Payment terms and method */
      zterm                                                                  as PaymentTerms,
      cast( zbd1t as wlf_dzbdet preserving type )                            as CashDiscount1Days,
      cast( zbd1p as wlf_dzbd1p preserving type )                            as CashDiscount1Percent,
      cast( zbd2t as wlf_dzbd2t preserving type )                            as CashDiscount2Days,
      cast( zbd2p as wlf_dzbd2p preserving type )                            as CashDiscount2Percent,
      cast( zbd3t as wlf_dzbd3t preserving type )                            as NetPaymentDays,
      zlsch                                                                  as PaymentMethod,

      @ObjectModel.foreignKey.association: '_CndnDocSuplrSettlmtCat'
      cast( settl_type_vend as wb2_supplier_settlement_cat preserving type ) as CndnDocSuplrSettlmtCat,
      @ObjectModel.foreignKey.association: '_CndnDocCustSettlmtCat'
      cast( settl_type_cust as wb2_customer_settlement_cat preserving type ) as CndnDocCustSettlmtCat,
      @ObjectModel.foreignKey.association: '_SettlmtProduct'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_ProductVH', element: 'Product' } }]
      }
      cast( settl_matnr as wb2_settlement_product preserving type )          as SettlmtProduct,

      /* Calendars */
      @ObjectModel.foreignKey.association: '_FinalSettlmtCalendar'
      settl_cal_final                                                        as FinalSettlmtCalendar,
      @ObjectModel.foreignKey.association: '_PartialSettlmtCalendar'
      settl_cal_part                                                         as PartialSettlmtCalendar,
      @ObjectModel.foreignKey.association: '_DeltaSettlmtCalendar'
      settl_cal_delta                                                        as DeltaSettlmtCalendar,
      @ObjectModel.foreignKey.association: '_DeltaAccrualSettlmtCalendar'
      settl_cal_accr                                                         as DeltaAccrualSettlmtCalendar,
      @ObjectModel.foreignKey.association: '_AccrualClearingSettlmtCal'
      settl_cal_accr_rollo                                                   as AccrualClearingSettlmtCalendar,
      @ObjectModel.foreignKey.association: '_CndnContrExtensionCalendar'
      extension_cal                                                          as CndnContrExtensionCalendar,

      @ObjectModel.foreignKey.association: '_PrecedingConditionDocument'
      pred_cc                                                                as PrecedingConditionDocument,
      @ObjectModel.foreignKey.association: '_CndnDocPurposeCategory'
      cc_purpose                                                             as CndnDocPurposeCategory,

      /* Source Document */
      @ObjectModel.foreignKey.association: '_CndnDocSourceDocumentCategory'
      ext_ref_cat                                                            as CndnDocSourceDocumentCategory,
      ext_ref                                                                as CndnDocSourceDocument,
      ext_ref_item                                                           as CndnDocSourceDocumentItem,

      @ObjectModel.foreignKey.association: '_BusVolTableGroup'
      bvtab_group                                                            as BusVolTableGroup,
      @ObjectModel.foreignKey.association: '_AmountFieldGroup'
      af_group                                                               as AmountFieldGroup,

      /* Units */
      @ObjectModel.foreignKey.association: '_ConditionDocumentUnit'
      settl_meins                                                            as ConditionDocumentUnit,
      @ObjectModel.foreignKey.association: '_ConditionDocumentWeightUnit'
      settl_gewei                                                            as ConditionDocumentWeightUnit,
      @ObjectModel.foreignKey.association: '_ConditionDocumentVolumeUnit'
      settl_voleh                                                            as ConditionDocumentVolumeUnit,
      @ObjectModel.foreignKey.association: '_CndnDocPointsQuantityUnit'
      settl_punei                                                            as CndnDocPointsQuantityUnit,

      accruals_upd_req                                                       as AccrualUpdateIsRequired,

      /* UUIDs */
      cast( guid as wcb_cndn_doc_uuid preserving type )                      as ConditionDocumentUUID,
      cast( ext_guid as wcb_cndn_doc_source_uuid preserving type )           as ConditionDocumentSourceUUID,

      /* Tax */
      @ObjectModel.foreignKey.association: '_TaxCountry'
      tax_reporting_country                                                  as TaxCountry,
      @ObjectModel.foreignKey.association: '_SettlmtPartTxRegnCntry'
      tax_country                                                            as SettlmtPartTxRegnCntry,

      /* VAT Registration */
      stceg                                                                  as SettlmtPartTxRegnNmbr,

      @ObjectModel.foreignKey.association: '_CndnDocPrcgDetnRlvnceCat'
      coco_det_rel_contr                                                     as CndnDocPrcgDetnRlvnceCat,
      @ObjectModel.foreignKey.association: '_BusVolTotAmtSpltCritraGrp'
      afsc_group                                                             as BusVolTotAmtSpltCritraGrp,

      num_basic_contract                                                     as BasicConditionContract,

      @ObjectModel.foreignKey.association: '_CndnContrPartnerCat'
      owner_type                                                             as CndnContrPartnerCat,
      @ObjectModel.foreignKey.association: '_CndnContrProcessCategory'
      process_category                                                       as CndnContrProcessCategory,
      @ObjectModel.foreignKey.association: '_CndnContrSettlmtType'
      cast( rebate_type as wb2_rebate_type_fio preserving type )             as CndnContrSettlmtType,

      /* Worker related fields */
      pers_kostl                                                             as CndnDocWorkerCostCenter,
      pers_kokrs                                                             as CndnDocWrkrControllingArea,
      settl_type_person                                                      as CndnDocWorkerSettlmtCat,

      /* SAP Object Node Type abbreviation and object semantics */
      sont_abbrv_h                                                           as CndnDocObjNodeTypeAbbr,
      semantic_type_h                                                        as CndnDocSemanticCode,

      data_controller                                                        as DataController,

      /* Associations */
      _CndnDocBusVolSelCriteria,
      _CndnDocSettlmtCal,
      _ConditionDocumentItem,
      _CndnDocConditionUsage,
      _CndnContrType,
      _CndnContrClassfctnType,
      _CndnContrProcVar,
      _CndnDocActivationStatus,
      _Supplier,
      _Customer,
      _PriorSupplier,
      _PersonWorkAgreement,
      _CompanyCode,
      _PurchasingOrganization,
      _PurchasingGroup,
      _SalesOrganization,
      _DistributionChannel,
      _Division,
      _SalesGroup,
      _SalesOffice,
      _CreatedByUser,
      _LastChangedByUser,
      _ConditionDocumentCurrency,
      _ExchangeRateType,
      _CndnDocSuplrSettlmtCat,
      _CndnDocCustSettlmtCat,
      _SettlmtProduct,
      _FinalSettlmtCalendar,
      _PartialSettlmtCalendar,
      _DeltaSettlmtCalendar,
      _DeltaAccrualSettlmtCalendar,
      _AccrualClearingSettlmtCal,
      _CndnContrExtensionCalendar,
      _PrecedingConditionDocument,
      _CndnDocPurposeCategory,
      _CndnDocSourceDocumentCategory,
      _BusVolTableGroup,
      _AmountFieldGroup,
      _ConditionDocumentUnit,
      _ConditionDocumentWeightUnit,
      _ConditionDocumentVolumeUnit,
      _CndnDocPointsQuantityUnit,
      _TaxCountry,
      _SettlmtPartTxRegnCntry,
      _CndnDocPrcgDetnRlvnceCat,
      _BusVolTotAmtSpltCritraGrp,
      _CndnContrPartnerCat,
      _CndnContrProcessCategory,
      _CndnContrSettlmtType,
      _CndnDocWorkerCostCenter,
      _CndnDocWrkrControllingArea,
      _CndnDocWorkerSettlmtCat      

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WCOCOH"
],
"ASSOCIATED":
[
"I_AMOUNTFIELDGROUP",
"I_BUSVOLTABLEGROUP",
"I_CNDNCONTRACTVTNSTATUS",
"I_CNDNCONTRCLASSFCTNTYPE",
"I_CNDNCONTRCUSTSETTLMTCAT",
"I_CNDNCONTRPARTNERCAT",
"I_CNDNCONTRPRCGDETNRLVNCECAT",
"I_CNDNCONTRPROCESSCATEGORY",
"I_CNDNCONTRPROCVAR",
"I_CNDNCONTRPURPOSECAT",
"I_CNDNCONTRSETTLMTTYPE",
"I_CNDNCONTRSOURCEDOCCAT",
"I_CNDNCONTRSUPLRSETTLMTCAT",
"I_CNDNDOCWORKERSETTLMTCAT",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COUNTRY",
"I_CURRENCY",
"I_CUSTOMER",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_EXCHANGERATETYPE",
"I_FACTORYCALENDAR",
"I_PERSONWORKAGREEMENT_1",
"I_PRODUCT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SALESORGANIZATION",
"I_SUPPLIER",
"I_UNITOFMEASURE",
"I_USER",
"R_BUSVOLTOTAMTSPLTCRITRAGRP",
"R_CNDNCONTRTYPE",
"R_CNDNDOCBUSVOLSELCRITERIA",
"R_CNDNDOCCONDITIONUSAGE",
"R_CNDNDOCSETTLMTCAL",
"R_CONDITIONDOCUMENT",
"R_CONDITIONDOCUMENTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/