A_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 A_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 A_ConditionContract AS
SELECT
  ConditionContract,
  CndnContrType,
  CndnContrProcVar,
  Supplier,
  Customer,
  CndnContrActvtnStatus,
  CndnContrValidFrom,
  CndnContrValidTo,
  CndnContrClassfctnType,
  DocumentReferenceID,
  CndnContrAssgmtRef,
  ExternalDocumentReferenceID,
  CndnContrExternalPartner,
  CndnContrSourceDocCat,
  CndnContrSourceDoc,
  CndnContrSourceDocItem,
  CndnContrSourceUUID,
  CreationUTCDateTime,
  LastChangeUTCDateTime,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesGroup,
  SalesOffice,
  CndnContrSuplrSettlmtCat,
  CndnContrCustSettlmtCat,
  SettlmtProduct,
  CndnContrExtensionCalendar,
  PriorSupplier,
  BusVolTableGroup,
  AmountFieldGroup,
  FinalSettlmtCalendar,
  PartialSettlmtCalendar,
  DeltaSettlmtCalendar,
  DeltaAccrualSettlmtCalendar,
  AccrualClearingSettlmtCalendar,
  PrecedingConditionDocument AS PrecedingConditionContract,
  CndnContrUUID,
  CndnContrPurposeCat,
  CndnContrCurrency,
  CndnContrUnit,
  cast( _CndnContrUnit.UnitOfMeasureISOCode as wcb_settlement_meins_iso preserving type ) AS CndnContrUnitISOCode,
  cast( _CndnContrUnit.UnitOfMeasureSAPCode as wcb_settlement_meins_sapcode preserving type ) AS CndnContrUnitSAPCode,
  CndnContrWeightUnit,
  cast( _CndnContrWeightUnit.UnitOfMeasureISOCode as wcb_settlement_gewei_iso preserving type ) AS CndnContrWeightUnitISOCode,
  cast( _CndnContrWeightUnit.UnitOfMeasureSAPCode as wcb_settlement_gewei_sapcode preserving type ) AS CndnContrWeightUnitSAPCode,
  CndnContrVolumeUnit,
  cast( _CndnContrVolumeUnit.UnitOfMeasureISOCode as wcb_settlement_voleh_iso preserving type ) AS CndnContrVolumeUnitISOCode,
  cast( _CndnContrVolumeUnit.UnitOfMeasureSAPCode as wcb_settlement_voleh_sapcode preserving type ) AS CndnContrVolumeUnitSAPCode,
  CndnContrPointsQtyUnit,
  cast( _CndnContrPointsQtyUnit.UnitOfMeasureISOCode as wcb_settlement_punei_iso preserving type ) AS CndnContrPointsQtyUnitISOCode,
  cast( _CndnContrPointsQtyUnit.UnitOfMeasureSAPCode as wcb_settlement_punei_sapcode preserving type ) AS CndnContrPointsQtyUnitSAPCode,
  ExchangeRate,
  ExchangeRateDate,
  ExchangeRateType,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  PaymentMethod,
  AccrualUpdateIsRequired,
  SettlmtPartTxRegnNmbr,
  TaxCountry,
  SettlmtPartTxRegnCntry,
  PersonWorkAgreement,
  CndnContrWorkerCostCenter,
  CndnContrWorkerSettlmtCat
FROM R_ConditionContractTP
;