R_ConditionContract

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_ConditionContract.
-- 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_ConditionContract AS
SELECT
  cast( ConditionDocument as wcb_coco_num preserving type ) AS ConditionContract,
  CndnContrType,
  CndnContrClassfctnType,
  CndnContrProcVar,
  DocumentReferenceID,
  CndnDocAssignmentReference AS CndnContrAssgmtRef,
  ExternalDocumentReferenceID,
  CndnDocExternalPartner AS CndnContrExternalPartner,
  CndnDocActivationStatus AS CndnContrActvtnStatus,
  ConditionDocumentValidFromDate AS CndnContrValidFrom,
  ConditionDocumentValidToDate AS CndnContrValidTo,
  Supplier,
  Customer,
  PriorSupplier,
  PersonWorkAgreement,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesGroup,
  SalesOffice,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationTimeZone,
  CreationUTCDateTime,
  LastChangedByUser,
  LastChangedDate,
  LastChangeTime,
  LastChangeUTCDateTime,
  cast( ConditionDocumentCurrency as wcb_cc_curr preserving type ) AS CndnContrCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  PaymentMethod,
  CndnDocSuplrSettlmtCat AS CndnContrSuplrSettlmtCat,
  CndnDocCustSettlmtCat AS CndnContrCustSettlmtCat,
  SettlmtProduct,
  FinalSettlmtCalendar,
  PartialSettlmtCalendar,
  DeltaSettlmtCalendar,
  DeltaAccrualSettlmtCalendar,
  AccrualClearingSettlmtCalendar,
  CndnContrExtensionCalendar,
  PrecedingConditionDocument,
  CndnDocPurposeCategory AS CndnContrPurposeCat,
  CndnDocSourceDocumentCategory AS CndnContrSourceDocCat,
  CndnDocSourceDocument AS CndnContrSourceDoc,
  CndnDocSourceDocumentItem AS CndnContrSourceDocItem,
  BusVolTableGroup,
  AmountFieldGroup,
  ConditionDocumentUnit AS CndnContrUnit,
  ConditionDocumentWeightUnit AS CndnContrWeightUnit,
  ConditionDocumentVolumeUnit AS CndnContrVolumeUnit,
  CndnDocPointsQuantityUnit AS CndnContrPointsQtyUnit,
  AccrualUpdateIsRequired,
  cast( ConditionDocumentUUID as wcb_guid preserving type ) AS CndnContrUUID,
  cast( ConditionDocumentSourceUUID as wcb_ext_guid_cc preserving type ) AS CndnContrSourceUUID,
  TaxCountry,
  SettlmtPartTxRegnCntry,
  SettlmtPartTxRegnNmbr,
  CndnDocPrcgDetnRlvnceCat AS CndnContrPrcgDetnRlvnceCat,
  BusVolTotAmtSpltCritraGrp,
  BasicConditionContract,
  CndnContrPartnerCat,
  CndnContrProcessCategory,
  CndnContrSettlmtType,
  CndnDocWorkerCostCenter AS CndnContrWorkerCostCenter,
  CndnDocWrkrControllingArea AS CndnContrWrkrControllingArea,
  CndnDocWorkerSettlmtCat AS CndnContrWorkerSettlmtCat,
  CndnDocSemanticCode AS CndnContrSemanticCode
FROM R_ConditionDocument
LEFT OUTER JOIN R_CndnContrBusVolSelCriteria AS _CndnContrBusVolSelCriteria ON ConditionContract = _CndnContrBusVolSelCriteria.ConditionContract  -- association [0..*]
LEFT OUTER JOIN R_CndnContrSettlmtCal AS _CndnContrSettlmtCal ON ConditionContract = _CndnContrSettlmtCal.ConditionContract  -- association [0..*]
LEFT OUTER JOIN R_CndnContrConditionUsage AS _CndnContrConditionUsage ON ConditionContract = _CndnContrConditionUsage.ConditionContract  -- association [0..*]
LEFT OUTER JOIN I_CndnContrActvtnStatus AS _CndnContrActvtnStatus ON CndnContrActvtnStatus = _CndnContrActvtnStatus.CndnContrActvtnStatus  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CndnContrCurrency ON CndnContrCurrency = _CndnContrCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSuplrSettlmtCat AS _CndnContrSuplrSettlmtCat ON CndnContrSuplrSettlmtCat = _CndnContrSuplrSettlmtCat.CndnContrSuplrSettlmtCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrCustSettlmtCat AS _CndnContrCustSettlmtCat ON CndnContrCustSettlmtCat = _CndnContrCustSettlmtCat.CndnContrCustSettlmtCat  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CndnContrUnit ON CndnContrUnit = _CndnContrUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CndnContrWeightUnit ON CndnContrWeightUnit = _CndnContrWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CndnContrVolumeUnit ON CndnContrVolumeUnit = _CndnContrVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CndnContrPointsQtyUnit ON CndnContrPointsQtyUnit = _CndnContrPointsQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CndnContrPurposeCat AS _CndnContrPurposeCat ON CndnContrPurposeCat = _CndnContrPurposeCat.CndnContrPurposeCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSourceDocCat AS _CndnContrSourceDocCat ON CndnContrSourceDocCat = _CndnContrSourceDocCat.CndnContrSourceDocCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrPrcgDetnRlvnceCat AS _CndnContrPrcgDetnRlvnceCat ON CndnContrPrcgDetnRlvnceCat = _CndnContrPrcgDetnRlvnceCat.CndnContrPrcgDetnRlvnceCat  -- association [0..1]
LEFT OUTER JOIN E_ConditionContract AS _Extension ON ConditionContract = _Extension.ConditionContract  -- association [1..1]
;