R_ConditionDocument

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_ConditionDocument.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_ConditionDocument AS
SELECT
  cast( num as wcb_condition_document preserving type ) AS ConditionDocument,
  contract_type AS CndnContrType,
  category AS CndnContrClassfctnType,
  process_variant AS CndnContrProcVar,
  reference AS DocumentReferenceID,
  assignment AS CndnDocAssignmentReference,
  ext_num AS ExternalDocumentReferenceID,
  ext_partner AS CndnDocExternalPartner,
  cast( deact as wcb_cc_state preserving type ) AS CndnDocActivationStatus,
  date_from AS ConditionDocumentValidFromDate,
  date_to AS ConditionDocumentValidToDate,
  vend_owner AS Supplier,
  cust_owner AS Customer,
  kolif AS PriorSupplier,
  person_owner AS PersonWorkAgreement,
  bukrs AS CompanyCode,
  ekorg AS PurchasingOrganization,
  ekgrp AS PurchasingGroup,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  vkgrp AS SalesGroup,
  vkbur AS SalesOffice,
  created_by AS CreatedByUser,
  created_on AS CreationDate,
  rec_time AS CreationTime,
  zonlo AS CreationTimeZone,
  created_on_tstmp AS CreationUTCDateTime,
  ch_name AS LastChangedByUser,
  ch_date AS LastChangedDate,
  ch_time AS LastChangeTime,
  ch_tstmp AS LastChangeUTCDateTime,
  cast( cc_curr as wcb_cndn_doc_curr preserving type ) AS ConditionDocumentCurrency,
  cast( rate as wlf_wcb_wkurs_no_cnext preserving type ) AS ExchangeRate,
  rate_type AS ExchangeRateType,
  rate_date AS ExchangeRateDate,
  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,
  cast( settl_type_vend as wb2_supplier_settlement_cat preserving type ) AS CndnDocSuplrSettlmtCat,
  cast( settl_type_cust as wb2_customer_settlement_cat preserving type ) AS CndnDocCustSettlmtCat,
  cast( settl_matnr as wb2_settlement_product preserving type ) AS SettlmtProduct,
  settl_cal_final AS FinalSettlmtCalendar,
  settl_cal_part AS PartialSettlmtCalendar,
  settl_cal_delta AS DeltaSettlmtCalendar,
  settl_cal_accr AS DeltaAccrualSettlmtCalendar,
  settl_cal_accr_rollo AS AccrualClearingSettlmtCalendar,
  extension_cal AS CndnContrExtensionCalendar,
  pred_cc AS PrecedingConditionDocument,
  cc_purpose AS CndnDocPurposeCategory,
  ext_ref_cat AS CndnDocSourceDocumentCategory,
  ext_ref AS CndnDocSourceDocument,
  ext_ref_item AS CndnDocSourceDocumentItem,
  bvtab_group AS BusVolTableGroup,
  af_group AS AmountFieldGroup,
  settl_meins AS ConditionDocumentUnit,
  settl_gewei AS ConditionDocumentWeightUnit,
  settl_voleh AS ConditionDocumentVolumeUnit,
  settl_punei AS CndnDocPointsQuantityUnit,
  accruals_upd_req AS AccrualUpdateIsRequired,
  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_reporting_country AS TaxCountry,
  tax_country AS SettlmtPartTxRegnCntry,
  stceg AS SettlmtPartTxRegnNmbr,
  coco_det_rel_contr AS CndnDocPrcgDetnRlvnceCat,
  afsc_group AS BusVolTotAmtSpltCritraGrp,
  settl_variant AS CndnDocSettlementVariant,
  num_basic_contract AS BasicConditionContract,
  owner_type AS CndnContrPartnerCat,
  process_category AS CndnContrProcessCategory,
  cast( rebate_type as wb2_rebate_type_fio preserving type ) AS CndnContrSettlmtType,
  settlmt_calc_method AS CndnContrSettlmtCalcMethod,
  pers_kostl AS CndnDocWorkerCostCenter,
  pers_kokrs AS CndnDocWrkrControllingArea,
  settl_type_person AS CndnDocWorkerSettlmtCat,
  data_controller AS DataController,
  sont_abbrv_h AS CndnDocObjNodeTypeAbbr,
  semantic_type_h AS CndnDocSemanticCode
FROM wcocoh
LEFT OUTER JOIN R_CndnDocBusVolSelCriteria AS _CndnDocBusVolSelCriteria ON ConditionDocument = _CndnDocBusVolSelCriteria.ConditionDocument  -- association [0..*]
LEFT OUTER JOIN R_CndnDocSettlmtCal AS _CndnDocSettlmtCal ON ConditionDocument = _CndnDocSettlmtCal.ConditionDocument  -- association [0..*]
LEFT OUTER JOIN R_ConditionDocumentItem AS _ConditionDocumentItem ON ConditionDocument = _ConditionDocumentItem.ConditionDocument  -- association [0..*]
LEFT OUTER JOIN R_CndnDocConditionUsage AS _CndnDocConditionUsage ON ConditionDocument = _CndnDocConditionUsage.ConditionDocument  -- association [0..*]
LEFT OUTER JOIN R_CndnContrType AS _CndnContrType ON CndnContrType = _CndnContrType.CndnContrType  -- association [0..1]
LEFT OUTER JOIN I_CndnContrClassfctnType AS _CndnContrClassfctnType ON CndnContrClassfctnType = _CndnContrClassfctnType.CndnContrClassfctnType  -- association [0..1]
LEFT OUTER JOIN I_CndnContrProcVar AS _CndnContrProcVar ON CndnContrProcVar = _CndnContrProcVar.CndnContrProcVar  -- association [0..1]
LEFT OUTER JOIN I_CndnContrActvtnStatus AS _CndnDocActivationStatus ON CndnDocActivationStatus = _CndnDocActivationStatus.CndnContrActvtnStatus  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PriorSupplier ON PriorSupplier = _PriorSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON PersonWorkAgreement = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ConditionDocumentCurrency ON ConditionDocumentCurrency = _ConditionDocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _ExchangeRateType ON ExchangeRateType = _ExchangeRateType.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSuplrSettlmtCat AS _CndnDocSuplrSettlmtCat ON CndnDocSuplrSettlmtCat = _CndnDocSuplrSettlmtCat.CndnContrSuplrSettlmtCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrCustSettlmtCat AS _CndnDocCustSettlmtCat ON CndnDocCustSettlmtCat = _CndnDocCustSettlmtCat.CndnContrCustSettlmtCat  -- association [0..1]
LEFT OUTER JOIN I_Product AS _SettlmtProduct ON SettlmtProduct = _SettlmtProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FinalSettlmtCalendar ON FinalSettlmtCalendar = _FinalSettlmtCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _PartialSettlmtCalendar ON PartialSettlmtCalendar = _PartialSettlmtCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _DeltaSettlmtCalendar ON DeltaSettlmtCalendar = _DeltaSettlmtCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _DeltaAccrualSettlmtCalendar ON DeltaAccrualSettlmtCalendar = _DeltaAccrualSettlmtCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _AccrualClearingSettlmtCal ON AccrualClearingSettlmtCalendar = _AccrualClearingSettlmtCal.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _CndnContrExtensionCalendar ON CndnContrExtensionCalendar = _CndnContrExtensionCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_BusVolTableGroup AS _BusVolTableGroup ON BusVolTableGroup = _BusVolTableGroup.BusVolTableGroup  -- association [0..1]
LEFT OUTER JOIN I_AmountFieldGroup AS _AmountFieldGroup ON AmountFieldGroup = _AmountFieldGroup.AmountFieldGroup  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionDocumentUnit ON ConditionDocumentUnit = _ConditionDocumentUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionDocumentWeightUnit ON ConditionDocumentWeightUnit = _ConditionDocumentWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionDocumentVolumeUnit ON ConditionDocumentVolumeUnit = _ConditionDocumentVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CndnDocPointsQuantityUnit ON CndnDocPointsQuantityUnit = _CndnDocPointsQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN R_ConditionDocument AS _PrecedingConditionDocument ON PrecedingConditionDocument = _PrecedingConditionDocument.ConditionDocument  -- association [0..1]
LEFT OUTER JOIN I_CndnContrPurposeCat AS _CndnDocPurposeCategory ON CndnDocPurposeCategory = _CndnDocPurposeCategory.CndnContrPurposeCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSourceDocCat AS _CndnDocSourceDocumentCategory ON CndnDocSourceDocumentCategory = _CndnDocSourceDocumentCategory.CndnContrSourceDocCat  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxCountry ON TaxCountry = _TaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SettlmtPartTxRegnCntry ON SettlmtPartTxRegnCntry = _SettlmtPartTxRegnCntry.Country  -- association [0..1]
LEFT OUTER JOIN I_CndnContrPrcgDetnRlvnceCat AS _CndnDocPrcgDetnRlvnceCat ON CndnDocPrcgDetnRlvnceCat = _CndnDocPrcgDetnRlvnceCat.CndnContrPrcgDetnRlvnceCat  -- association [0..1]
LEFT OUTER JOIN R_BusVolTotAmtSpltCritraGrp AS _BusVolTotAmtSpltCritraGrp ON BusVolTotAmtSpltCritraGrp = _BusVolTotAmtSpltCritraGrp.BusVolTotAmtSpltCritraGrp  -- association [0..1]
LEFT OUTER JOIN R_CndnDocSettlementVariant AS _CndnDocSettlementVariant ON CndnDocSettlementVariant = _CndnDocSettlementVariant.CndnDocSettlementVariant  -- association [0..1]
LEFT OUTER JOIN I_CndnContrPartnerCat AS _CndnContrPartnerCat ON CndnContrPartnerCat = _CndnContrPartnerCat.CndnContrPartnerCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSettlmtType AS _CndnContrSettlmtType ON CndnContrSettlmtType = _CndnContrSettlmtType.CndnContrSettlmtType  -- association [0..1]
LEFT OUTER JOIN I_CndnContrProcessCategory AS _CndnContrProcessCategory ON CndnContrProcessCategory = _CndnContrProcessCategory.CndnContrProcessCategory  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSettlmtCalcMethod AS _CndnContrSettlmtCalcMethod ON CndnContrSettlmtCalcMethod = _CndnContrSettlmtCalcMethod.CndnContrSettlmtCalcMethod  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CndnDocWorkerCostCenter ON CndnDocWorkerCostCenter = _CndnDocWorkerCostCenter.CostCenter AND CndnDocWrkrControllingArea = _CndnDocWorkerCostCenter.ControllingArea AND _CndnDocWorkerCostCenter.ValidityEndDate >= ConditionDocumentValidToDate AND _CndnDocWorkerCostCenter.ValidityStartDate <= ConditionDocumentValidToDate  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _CndnDocWrkrControllingArea ON CndnDocWrkrControllingArea = _CndnDocWrkrControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CndnDocWorkerSettlmtCat AS _CndnDocWorkerSettlmtCat ON CndnDocWorkerSettlmtCat = _CndnDocWorkerSettlmtCat.CndnDocWorkerSettlmtCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtSemanticCode AS _CndnDocSemanticCode ON CndnDocSemanticCode = _CndnDocSemanticCode.SettlmtMgmtSemanticCode  -- association [0..1]
;