R_CndnContrCndnRecordTP

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_CndnContrCndnRecordTP.
-- 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_CndnContrCndnRecordTP AS
SELECT
  ConditionContract,
  cast( '' as knumh ) AS ConditionRecord,
  cast( '' as kotabnr_char ) AS ConditionTable,
  cast( '' as kappl ) AS ConditionApplication,
  cast( '' as kscha ) AS ConditionType,
  cast( '00000000' as kodatab ) AS ConditionValidityStartDate,
  cast( '00000000' as kodatbi ) AS ConditionValidityEndDate,
  cast( '' as krech_long ) AS ConditionCalculationType,
  cast( '' as kzbzg_long ) AS PricingScaleBasis,
  cast( 0 as wcb_cond_amount_tp ) AS ConditionRateAmount,
  cast( 0 as wcb_cond_accruals_amount_tp ) AS ConditionAccrualsAmount,
  cast( '' as konwa ) AS ConditionCurrency,
  cast( 0 as kpein ) AS ConditionQuantity,
  cast( '' as kmein ) AS ConditionQuantityUnit,
  cast( 0 as wcb_cond_percentage_tp ) AS ConditionRateRatio,
  cast( 0 as wcb_cond_accr_percentage_tp ) AS ConditionAccrualsRatio,
  cast( '' as wcb_cond_percent_sign_tp ) AS ConditionRateRatioUnit,
  cast( '' as stfkz ) AS PricingScaleType,
  cast( '' as konms ) AS ConditionScaleQuantityUnit,
  cast( '' as konws ) AS ConditionScaleAmountCurrency,
  cast( '' as loevm_ko ) AS ConditionIsDeleted,
  cast( '' as productnumber ) AS Product,
  cast( '' as kunnr ) AS Customer,
  cast( '' as kunre ) AS BillToParty,
  cast( '' as kunrg ) AS PayerParty,
  cast( '' as kunwe ) AS ShipToParty,
  cast( '' as md_supplier ) AS Supplier,
  cast( '' as lifre ) AS InvoicingParty,
  cast( '' as kolif ) AS PriorSupplier,
  cast( '' as llief ) AS SupplyingSupplier,
  cast( '' as fis_bukrs ) AS CompanyCode,
  cast( '' as vkorg ) AS SalesOrganization,
  cast( '' as vtweg ) AS DistributionChannel,
  cast( '' as spart ) AS Division,
  cast( '' as vkbur ) AS SalesOffice,
  cast( '' as vkgrp ) AS SalesGroup,
  cast( '' as ekorg ) AS PurchasingOrganization,
  cast( '' as werks_d ) AS Plant,
  cast( '' as productgroup ) AS ProductGroup,
  cast( '' as wlf_salesspcfcproductgroup1 ) AS SalesSpcfcProductGroup1,
  cast( '' as wlf_salesspcfcproductgroup2 ) AS SalesSpcfcProductGroup2,
  cast( '' as wlf_salesspcfcproductgroup3 ) AS SalesSpcfcProductGroup3,
  cast( '' as wlf_salesspcfcproductgroup4 ) AS SalesSpcfcProductGroup4,
  cast( '' as wlf_salesspcfcproductgroup5 ) AS SalesSpcfcProductGroup5
FROM R_ConditionContract
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionQuantityUnit ON ConditionQuantityUnit = _ConditionQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ConditionCurrency ON ConditionCurrency = _ConditionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionScaleQuantityUnit ON ConditionScaleQuantityUnit = _ConditionScaleQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ConditionScaleAmountCurrency ON ConditionScaleAmountCurrency = _ConditionScaleAmountCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionRateRatioUnit ON ConditionRateRatioUnit = _ConditionRateRatioUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN R_CndnContrCndnRecdValidityTP AS _CndnContrCndnRecdValidity ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CndnContrScCndnRecordTP AS _CndnContrScCndnRecord ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CndnContrCndnRecdTextTP AS _TextTP ON /* condition not available in parsed metadata */  -- association [0..*]
;