R_BasicConditionContract

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_BasicConditionContract.
-- 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_BasicConditionContract AS
SELECT
  cast( ConditionDocument as wcb_num_basic_contract preserving type ) AS BasicConditionContract,
  CndnContrType,
  CndnContrClassfctnType,
  CndnContrProcVar,
  DocumentReferenceID,
  CndnDocAssignmentReference AS BscCndnContrAssgmtReference,
  ExternalDocumentReferenceID,
  CndnDocExternalPartner AS BscCndnContrExternalPartner,
  CndnDocActivationStatus AS BscCndnContrActivationStatus,
  ConditionDocumentValidFromDate AS BscCndnContrValidFromDate,
  ConditionDocumentValidToDate AS BscCndnContrValidToDate,
  Supplier,
  Customer,
  PriorSupplier,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesGroup,
  SalesOffice,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationTimeZone,
  CreationUTCDateTime,
  LastChangedByUser,
  LastChangedDate,
  LastChangeTime,
  LastChangeUTCDateTime,
  cast( ConditionDocumentCurrency as wcb_bsc_cndn_contr_curr preserving type ) AS BscConditionContractCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  PaymentMethod,
  CndnDocSuplrSettlmtCat AS BscCndnContrSuplrSettlmtCat,
  CndnDocCustSettlmtCat AS BscCndnContrCustSettlmtCat,
  SettlmtProduct,
  FinalSettlmtCalendar,
  PartialSettlmtCalendar,
  DeltaSettlmtCalendar,
  DeltaAccrualSettlmtCalendar,
  AccrualClearingSettlmtCalendar,
  CndnContrExtensionCalendar,
  PrecedingConditionDocument,
  CndnDocPurposeCategory AS BscCndnContrPurposeCategory,
  CndnDocSourceDocumentCategory AS BscCndnContrSrceDocCategory,
  CndnDocSourceDocument AS BscCndnContrSourceDocument,
  CndnDocSourceDocumentItem AS BscCndnContrSourceDocumentItem,
  BusVolTableGroup,
  AmountFieldGroup,
  ConditionDocumentUnit AS BasicConditionContractUnit,
  ConditionDocumentWeightUnit AS BscCndnContrWeightUnit,
  ConditionDocumentVolumeUnit AS BscCndnContrVolumeUnit,
  CndnDocPointsQuantityUnit AS BscCndnContrPtsQuantityUnit,
  AccrualUpdateIsRequired,
  cast( ConditionDocumentUUID as wcb_bsc_cndn_contr_uuid preserving type ) AS BasicConditionContractUUID,
  cast( ConditionDocumentSourceUUID as wcb_bsc_cndn_contr_srce_uuid preserving type ) AS BscCndnContrSourceUUID,
  TaxCountry,
  SettlmtPartTxRegnCntry,
  SettlmtPartTxRegnNmbr,
  CndnDocPrcgDetnRlvnceCat AS BscCndnContrPrcgDetnRlvnceCat,
  BusVolTotAmtSpltCritraGrp,
  CndnContrPartnerCat,
  CndnContrProcessCategory,
  CndnContrSettlmtType
FROM R_ConditionDocument
LEFT OUTER JOIN R_BscCndnContrRefcdCndnContr AS _BscCndnContrRefcdCndnContr ON BasicConditionContract = _BscCndnContrRefcdCndnContr.BasicConditionContract  -- association [0..*]
LEFT OUTER JOIN I_CndnContrActvtnStatus AS _BscCndnContrActivationStatus ON BscCndnContrActivationStatus = _BscCndnContrActivationStatus.CndnContrActvtnStatus  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BscConditionContractCurrency ON BscConditionContractCurrency = _BscConditionContractCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSuplrSettlmtCat AS _BscCndnContrSuplrSettlmtCat ON BscCndnContrSuplrSettlmtCat = _BscCndnContrSuplrSettlmtCat.CndnContrSuplrSettlmtCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrCustSettlmtCat AS _BscCndnContrCustSettlmtCat ON BscCndnContrCustSettlmtCat = _BscCndnContrCustSettlmtCat.CndnContrCustSettlmtCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrPurposeCat AS _BscCndnContrPurposeCategory ON BscCndnContrPurposeCategory = _BscCndnContrPurposeCategory.CndnContrPurposeCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSourceDocCat AS _BscCndnContrSrceDocCategory ON BscCndnContrSrceDocCategory = _BscCndnContrSrceDocCategory.CndnContrSourceDocCat  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BasicConditionContractUnit ON BasicConditionContractUnit = _BasicConditionContractUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BscCndnContrWeightUnit ON BscCndnContrWeightUnit = _BscCndnContrWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BscCndnContrVolumeUnit ON BscCndnContrVolumeUnit = _BscCndnContrVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BscCndnContrPtsQuantityUnit ON BscCndnContrPtsQuantityUnit = _BscCndnContrPtsQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CndnContrPrcgDetnRlvnceCat AS _BscCndnContrPrcgDetnRlvnceCat ON BscCndnContrPrcgDetnRlvnceCat = _BscCndnContrPrcgDetnRlvnceCat.CndnContrPrcgDetnRlvnceCat  -- association [0..1]
;