R_SlsPrcgCndnRecord_3

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_SlsPrcgCndnRecord_3.
-- 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_SlsPrcgCndnRecord_3 AS
SELECT
  _RecordDB.knumh AS ConditionRecord,
  cast( '' as kopos_long ) AS ConditionSequentialNumber,
  cast( '' as kotabnr_char ) AS ConditionTable,
  cast( '' as kappl ) AS ConditionApplication,
  cast( '' as kscha ) AS ConditionType,
  cast( '' as ernam ) AS CreatedByUser,
  cast( '' as erdat ) AS CreationDate,
  cast( '' as stfkz ) AS PricingScaleType,
  cast ( '' as kzbzg_long ) AS PricingScaleBasis,
  cast ( '' as kstpr ) AS PricingScaleCheckingRule,
  cast ( 0 as kstbm ) AS ConditionScaleQuantity,
  cast ( '' as konms ) AS ConditionScaleQuantityUnit,
  cast ( 0 as kstbw ) AS ConditionScaleAmount,
  cast ( '' as konws ) AS ConditionScaleAmountCurrency,
  cast ( '' as krech_long ) AS ConditionCalculationType,
  cast ( 0 as vfprc_element_ratio ) AS ConditionRateRatio,
  cast ( '' as msehiunit ) AS ConditionRateRatioUnit,
  cast ( 0 as vfprc_element_amount ) AS ConditionRateAmount,
  cast ( '' as waers ) AS ConditionCurrency,
  cast ( 0 as kpein ) AS ConditionQuantity,
  cast ( '' as kmein ) AS ConditionQuantityUnit,
  cast ( 0 as kumza ) AS ConditionToBaseQtyNmrtr,
  cast ( 0 as kumne ) AS ConditionToBaseQtyDnmntr,
  cast ( '' as meins ) AS BaseUnit,
  cast ( '' as text60 ) AS ConditionUnitConversionText,
  cast ( 0 as vfprc_element_amount ) AS ConditionLowerLimitAmount,
  cast ( 0 as vfprc_element_ratio ) AS ConditionLowerLimitRatio,
  cast ( 0 as vfprc_element_amount ) AS ConditionUpperLimitAmount,
  cast ( 0 as vfprc_element_ratio ) AS ConditionUpperLimitRatio,
  cast ( '' as kwaeh ) AS ConditionAlternativeCurrency,
  cast ( '' as kznep ) AS ConditionExclusion,
  cast ( '' as loevm_ko ) AS ConditionIsDeleted,
  cast ( '' as valtg ) AS AdditionalValueDays,
  cast ( '' as valdt ) AS FixedValueDate,
  cast ( '' as dzterm ) AS PaymentTerms,
  cast ( '' as anzauf ) AS CndnMaxNumberOfSalesOrders,
  cast ( 0 as mikbas ) AS MinimumConditionBasisValue,
  cast ( 0 as mxkbas ) AS MaximumConditionBasisValue,
  cast ( 0 as komxwrt ) AS MaximumConditionAmount,
  cast ( '' as klf_stg ) AS IncrementalScale,
  cast ( '' as klf_kal ) AS PricingScaleLine,
  cast( '' as datbi ) AS NewValueOfCndnValidityEndDate,
  _Validity.ConditionValidityEndDate AS ConditionValidityEndDate,
  _Validity.ConditionValidityStartDate AS ConditionValidityStartDate,
  _Validity.ConditionReleaseStatus AS ConditionReleaseStatus,
  cast( '0' as eve_tv_criticality ) AS Criticality,
  _Validity.DepartureCountry AS DepartureCountry,
  _Validity.SalesDocument AS SalesDocument,
  _Validity.SalesDocumentItem AS SalesDocumentItem,
  _Validity.BillableControl AS BillableControl,
  _Validity.Industry AS Industry,
  _Validity.CityCode AS CityCode,
  _Validity.ConditionContract AS ConditionContract,
  _Validity.County AS County,
  _Validity.TechnicalObjectType AS TechnicalObjectType,
  _Validity.Equipment AS Equipment,
  _Validity.CustomerHierarchy AS CustomerHierarchy,
  _Validity.IncotermsClassification AS IncotermsClassification,
  _Validity.IncotermsTransferLocation AS IncotermsTransferLocation,
  _Validity.AccountTaxType AS AccountTaxType,
  _Validity.CustomerGroup AS CustomerGroup,
  _Validity.CustomerPriceGroup AS CustomerPriceGroup,
  _Validity.MaterialPricingGroup AS MaterialPricingGroup,
  _Validity.SoldToParty AS SoldToParty,
  _Validity.Customer AS Customer,
  _Validity.PayerParty AS PayerParty,
  _Validity.ShipToParty AS ShipToParty,
  _Validity.Supplier AS Supplier,
  _Validity.DestinationCountry AS DestinationCountry,
  _Validity.MaterialGroup AS MaterialGroup,
  _Validity.ReturnsRefundExtent AS ReturnsRefundExtent,
  _Validity.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  _Validity.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  _Validity.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  _Validity.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  _Validity.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  _Validity.PriceListType AS PriceListType,
  _Validity.PostalCode AS PostalCode,
  _Validity.Region AS Region,
  _Validity.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  _Validity.RequirementSegment AS RequirementSegment,
  _Validity.StockSegment AS StockSegment,
  _Validity.Division AS Division,
  cast( '' as /sapsll/comco ) AS CommodityCode,
  _Validity.ProdUnivHierarchyNode AS ProdUnivHierarchyNode,
  _Validity.TradingContract AS TradingContract,
  _Validity.TradingContractItem AS TradingContractItem,
  _Validity.MainItemMaterialPricingGroup AS MainItemMaterialPricingGroup,
  _Validity.MainItemPricingRefMaterial AS MainItemPricingRefMaterial,
  _Validity.VariantCondition AS VariantCondition,
  _Validity.ValueAddedServiceChargeCode AS ValueAddedServiceChargeCode,
  _Validity.SDDocument AS SDDocument,
  _Validity.ReferenceSDDocument AS ReferenceSDDocument,
  _Validity.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  _Validity.SalesOffice AS SalesOffice,
  _Validity.SalesGroup AS SalesGroup,
  _Validity.SalesOrderSalesOrganization AS SalesOrderSalesOrganization,
  _Validity.OrderQuantityUnit AS OrderQuantityUnit,
  _Validity.SalesOrganization AS SalesOrganization,
  _Validity.DistributionChannel AS DistributionChannel,
  _Validity.Material AS Material,
  _Validity.TransactionCurrency AS TransactionCurrency,
  _Validity.Plant AS Plant,
  _Validity.PlantRegion AS PlantRegion,
  _Validity.WorkItem AS WorkItem,
  _Validity.ConditionProcessingStatus AS ConditionProcessingStatus,
  _Validity.PricingDate AS PricingDate,
  _Validity.ConditionIsExclusive AS ConditionIsExclusive,
  _Validity.ConditionScaleBasisValue AS ConditionScaleBasisValue,
  _Validity.EngagementProject AS EngagementProject,
  _Validity.ConfigurationNumber AS ConfigurationNumber,
  _Validity.BR_NFDocumentType AS BR_NFDocumentType,
  _Validity.TaxCode AS TaxCode,
  _Validity.InternationalArticleNumber AS InternationalArticleNumber,
  _Validity.TxRlvnceClassfctnForArgentina AS TxRlvnceClassfctnForArgentina,
  _Validity.ServiceDocument AS ServiceDocument,
  _Validity.ServiceDocumentItem AS ServiceDocumentItem,
  _Validity.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  _Validity.SalesSDDocumentCategory AS SalesSDDocumentCategory,
  _Validity.ReturnReason AS ReturnReason,
  _Validity.CustomerConditionGroup AS CustomerConditionGroup,
  _Validity.ShippingType AS ShippingType,
  _Validity.SubscriptionContractDuration AS SubscriptionContractDuration,
  cast( '' as crms4_som_ctr_term_unit ) AS SubscrpnContrDurationUnit,
  _Validity.SubscriptionContractLockReason AS SubscriptionContractLockReason,
  _Validity.OrderType AS OrderType,
  _Validity.SalesDocumentType AS SalesDocumentType,
  _Validity.SDDocumentReason AS SDDocumentReason,
  _Validity.VolumeRebateGroup AS VolumeRebateGroup,
  _Validity.ValuationType AS ValuationType,
  _Validity.SalesDistrict AS SalesDistrict,
  _Validity.Batch AS Batch,
  _Validity.PurgDocSupplyingPlant AS PurgDocSupplyingPlant,
  _Validity.MatUsageIndicator AS MatUsageIndicator,
  _Validity.ShippingCondition AS ShippingCondition,
  _Validity.PlantCounty AS PlantCounty,
  _Validity.PlantCity AS PlantCity,
  _Validity.MaterialExternalGroup AS MaterialExternalGroup,
  _Validity.CustomerHierarchyRootNode AS CustomerHierarchyRootNode,
  _Validity.CustomerHierarchyNodeID AS CustomerHierarchyNodeID,
  _Validity.CustomerHierarchyNodeType AS CustomerHierarchyNodeType,
  _Validity.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  _Validity.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  _Validity.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  _Validity.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  _Validity.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  _Validity.SDDocumentItem AS SDDocumentItem,
  _Validity.CndnBillingDocumentCategory AS CndnBillingDocumentCategory,
  _Validity.Country AS Country,
  _Validity.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  _Validity.CountryOfOrigin AS CountryOfOrigin,
  _Validity.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  _Validity.BillToParty AS BillToParty,
  _Validity.BusinessPartnerIndustryCode AS BusinessPartnerIndustryCode,
  _Validity.BillingDocumentType AS BillingDocumentType,
  _Validity.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  cast( '000' as kolnr ) AS AccessNumberOfAccessSequence,
  cast( '' as condition_is_deleted ) AS ResultsHaveDeletedCondition,
  cast( '' as kostkz ) AS ConditionHasScale,
  cast( '' as kostkz ) AS ConditionHasScales,
  cast( '' as boolean) AS ConditionScaleIsValueScale,
  cast( '' as boolean) AS ConditionScaleIsQuantityScale,
  cast ( '' as bezei40 ) AS ConditionText,
  cast ( '' as licdt ) AS LicenseGrantDate,
  cast( '' as sap_object_node_type_raw ) AS SAPObjectNodeType,
  cast ( 0 as timestampl ) AS LastChangeDateTime
FROM a000 AS _RecordDB
INNER JOIN I_SlsPrcgCndnRecdValidity AS _Validity ON /* join condition not captured in parsed metadata */
;