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 I_SlsPrcgCndnRecdTemplate.
-- 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.
-- SQL view name: ISLSPRCGRECDTMP
CREATE VIEW I_SlsPrcgCndnRecdTemplate AS
SELECT
_SlsPrcgConditionRecord.ConditionRecord AS ConditionRecord,
_SlsPrcgConditionRecord.ConditionValidityEndDate AS ConditionValidityEndDate,
_SlsPrcgConditionRecord.ConditionType AS ConditionType,
cast ( '' as vtxtm ) AS ConditionTypeName,
_SlsPrcgConditionRecord.ConditionTable AS ConditionTable,
cast('' as kolnr) AS AccessNumberOfAccessSequence,
cast('' as kopos_long) AS ConditionSequentialNumber,
cast('' as kostkz) AS ConditionHasScales,
_SlsPrcgConditionRecord.ConditionTaxCode AS ConditionTaxCode,
cast ( '' as text1_007s ) AS ConditionTaxCodeName,
_SlsPrcgConditionRecord.ConditionWithholdingTaxCode AS ConditionWithholdingTaxCode,
_SlsPrcgCndnRecdValidity.ConditionValidityStartDate AS ConditionValidityStartDate,
_SlsPrcgConditionRecord.ConditionRateValue AS ConditionRateValue,
cast( '' as char30) AS ConditionRateValueText,
_SlsPrcgConditionRecord.ConditionRateValueUnit AS ConditionRateValueUnit,
_SlsPrcgConditionRecord.ConditionQuantity AS ConditionQuantity,
_SlsPrcgConditionRecord.ConditionQuantityUnit AS ConditionQuantityUnit,
cast( '' as char30) AS ConditionLowerLimitText,
_SlsPrcgConditionRecord.ConditionLowerLimit AS ConditionLowerLimit,
_SlsPrcgConditionRecord.ConditionUpperLimit AS ConditionUpperLimit,
cast( '' as char30) AS ConditionUpperLimitText,
_SlsPrcgConditionRecord.ConditionScaleQuantity AS ConditionScaleQuantity,
_SlsPrcgConditionRecord.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
_SlsPrcgConditionRecord.ConditionScaleAmount AS ConditionScaleAmount,
_SlsPrcgConditionRecord.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
cast ( '' as bezei40 ) AS ConditionText,
_SlsPrcgConditionRecord.PaymentTerms AS PaymentTerms,
cast ( '' as dzterm_bez ) AS PaymentTermsName,
_SlsPrcgConditionRecord.FixedValueDate AS FixedValueDate,
_SlsPrcgConditionRecord.AdditionalValueDays AS AdditionalValueDays,
cast('' as krech_long) AS ConditionCalculationType,
cast ( '' as prct_calculation_type_descr ) AS ConditionCalculationTypeName,
_SlsPrcgConditionRecord.PricingScaleType AS PricingScaleType,
cast ( '' as price_element_scale_type_descr ) AS PricingScaleTypeName,
cast('' as kzbzg_long) AS PricingScaleBasis,
cast(_SlsPrcgConditionRecord.ConditionRateValue as vfprc_element_amount) AS ConditionScaleRateValue,
cast('' as condition_is_scale) AS ConditionIsScale,
_SlsPrcgCndnRecdValidity.DepartureCountry AS DepartureCountry,
cast( '' as landx50 ) AS DepartureCountryName,
_SlsPrcgCndnRecdValidity.SalesDocument AS SalesDocument,
_SlsPrcgCndnRecdValidity.SalesDocumentItem AS SalesDocumentItem,
cast( '' as arktx ) AS SalesDocumentItemText,
_SlsPrcgCndnRecdValidity.BillableControl AS BillableControl,
cast( '' as bemot_txt ) AS BillableControlName,
_SlsPrcgCndnRecdValidity.Industry AS Industry,
cast( '' as text1_016t ) AS IndustryKeyText,
_SlsPrcgCndnRecdValidity.CityCode AS CityCode,
cast( '' as bezei20 ) AS CityCodeName,
_SlsPrcgCndnRecdValidity.ConditionContract AS ConditionContract,
_SlsPrcgCndnRecdValidity.County AS County,
cast( '' as bezei20 ) AS CountyName,
_SlsPrcgCndnRecdValidity.EngagementProject AS EngagementProject,
cast( '' as /cpd/short_text ) AS EngagementProjectName,
_SlsPrcgCndnRecdValidity.ConfigurationNumber AS ConfigurationNumber,
_SlsPrcgCndnRecdValidity.InternationalArticleNumber AS InternationalArticleNumber,
_SlsPrcgCndnRecdValidity.TechnicalObjectType AS TechnicalObjectType,
cast( '' as eartx ) AS TechnicalObjectTypeDesc,
_SlsPrcgCndnRecdValidity.Equipment AS Equipment,
cast( '' as ktx01 ) AS EquipmentName,
_SlsPrcgCndnRecdValidity.CustomerHierarchy AS CustomerHierarchy,
_SlsPrcgCndnRecdValidity.IncotermsClassification AS IncotermsClassification,
cast( '' as bezei30 ) AS IncotermsClassificationName,
_SlsPrcgCndnRecdValidity.IncotermsTransferLocation AS IncotermsTransferLocation,
_SlsPrcgCndnRecdValidity.LocalSalesTaxApplicabilityCode AS LocalSalesTaxApplicabilityCode,
_SlsPrcgCndnRecdValidity.CustomerGroup AS CustomerGroup,
cast( '' as vtxtk ) AS CustomerGroupName,
_SlsPrcgCndnRecdValidity.CustomerPriceGroup AS CustomerPriceGroup,
cast( '' as bezei20 ) AS CustomerPriceGroupName,
cast (_SlsPrcgCndnRecdValidity.MaterialPricingGroup as pricespecificationproductgroup preserving type ) AS MaterialPricingGroup,
cast( '' as bezei20 ) AS MaterialPricingGroupName,
_SlsPrcgCndnRecdValidity.SoldToParty AS SoldToParty,
cast( '' as md_customer_name ) AS SoldToPartyName,
_SlsPrcgCndnRecdValidity.BPForSoldToParty AS BPForSoldToParty,
_SlsPrcgCndnRecdValidity.Customer AS Customer,
cast( '' as md_customer_name ) AS CustomerName,
_SlsPrcgCndnRecdValidity.BPForCustomer AS BPForCustomer,
_SlsPrcgCndnRecdValidity.PayerParty AS PayerParty,
cast( '' as md_customer_name ) AS PayerPartyName,
_SlsPrcgCndnRecdValidity.BPForPayerParty AS BPForPayerParty,
_SlsPrcgCndnRecdValidity.ShipToParty AS ShipToParty,
cast( '' as md_customer_name ) AS ShipToPartyName,
_SlsPrcgCndnRecdValidity.BPForShipToParty AS BPForShipToParty,
_SlsPrcgCndnRecdValidity.Supplier AS Supplier,
cast( '' as md_supplier_name ) AS SupplierName,
_SlsPrcgCndnRecdValidity.BPForSupplier AS BPForSupplier,
_SlsPrcgCndnRecdValidity.DestinationCountry AS DestinationCountry,
cast( '' as landx50 ) AS DestinationCountryName,
_SlsPrcgCndnRecdValidity.Country AS Country,
cast( '' as landx50 ) AS CountryName,
cast (_SlsPrcgCndnRecdValidity.MaterialGroup as productgroup preserving type ) AS MaterialGroup,
cast( '' as wgbez ) AS MaterialGroupName,
cast (_SlsPrcgCndnRecdValidity.Material as productnumber preserving type ) AS Material,
cast( '' as maktx ) AS MaterialName,
_SlsPrcgCndnRecdValidity.ReturnsRefundExtent AS ReturnsRefundExtent,
cast( '' as msr_refund_code_text ) AS ReturnsRefundExtentDesc,
cast (_SlsPrcgCndnRecdValidity.AdditionalMaterialGroup1 as firstsalesspecproductgroup preserving type ) AS AdditionalMaterialGroup1,
cast( '' as bezei40 ) AS AdditionalMaterialGroup1Name,
cast (_SlsPrcgCndnRecdValidity.AdditionalMaterialGroup2 as secondsalesspecproductgroup preserving type ) AS AdditionalMaterialGroup2,
cast( '' as bezei40 ) AS AdditionalMaterialGroup2Name,
cast (_SlsPrcgCndnRecdValidity.AdditionalMaterialGroup3 as thirdsalesspecproductgroup preserving type ) AS AdditionalMaterialGroup3,
cast( '' as bezei40 ) AS AdditionalMaterialGroup3Name,
cast (_SlsPrcgCndnRecdValidity.AdditionalMaterialGroup4 as fourthsalesspecproductgroup preserving type ) AS AdditionalMaterialGroup4,
cast( '' as bezei40 ) AS AdditionalMaterialGroup4Name,
cast (_SlsPrcgCndnRecdValidity.AdditionalMaterialGroup5 as fifthsalesspecproductgroup preserving type ) AS AdditionalMaterialGroup5,
cast( '' as bezei40 ) AS AdditionalMaterialGroup5Name,
_SlsPrcgCndnRecdValidity.Personnel AS Personnel,
cast( '' as bu_name1tx ) AS PersonFullName,
_SlsPrcgCndnRecdValidity.PriceListType AS PriceListType,
cast( '' as text20 ) AS PriceListTypeName,
_SlsPrcgCndnRecdValidity.PostalCode AS PostalCode,
_SlsPrcgCndnRecdValidity.Region AS Region,
cast( '' as bezei20 ) AS RegionName,
_SlsPrcgCndnRecdValidity.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
cast( '' as /cpd/pws_ws_org_unit_id_desc ) AS EngmtProjectServiceOrgName,
_SlsPrcgCndnRecdValidity.RequirementSegment AS RequirementSegment,
_SlsPrcgCndnRecdValidity.StockSegment AS StockSegment,
_SlsPrcgCndnRecdValidity.Division AS Division,
cast( '' as divisionname ) AS DivisionName,
cast('' as /sapsll/comco) AS CommodityCode,
cast( '' as bezei40 ) AS CommodityCodeText,
_SlsPrcgCndnRecdValidity.ConsumptionTaxCtrlCode AS ConsumptionTaxCtrlCode,
cast( '' as bezei60 ) AS ConsumptionTaxCntrlCodeDesc,
_SlsPrcgCndnRecdValidity.CustomerTaxClassification1 AS CustomerTaxClassification1,
cast( '' as vtext ) AS CustomerTaxClassification1Name,
_SlsPrcgCndnRecdValidity.CustomerTaxClassification2 AS CustomerTaxClassification2,
cast( '' as vtext ) AS CustomerTaxClassification2Name,
_SlsPrcgCndnRecdValidity.CustomerTaxClassification3 AS CustomerTaxClassification3,
cast( '' as vtext ) AS CustomerTaxClassification3Name,
_SlsPrcgCndnRecdValidity.CustomerTaxClassification4 AS CustomerTaxClassification4,
cast( '' as vtext ) AS CustomerTaxClassification4Name,
_SlsPrcgCndnRecdValidity.CustomerTaxClassification5 AS CustomerTaxClassification5,
cast( '' as vtext ) AS CustomerTaxClassification5Name,
_SlsPrcgCndnRecdValidity.CustomerTaxClassification6 AS CustomerTaxClassification6,
cast( '' as vtext ) AS CustomerTaxClassification6Name,
_SlsPrcgCndnRecdValidity.CustomerTaxClassification7 AS CustomerTaxClassification7,
cast( '' as vtext ) AS CustomerTaxClassification7Name,
_SlsPrcgCndnRecdValidity.CustomerTaxClassification8 AS CustomerTaxClassification8,
cast( '' as vtext ) AS CustomerTaxClassification8Name,
_SlsPrcgCndnRecdValidity.CustomerTaxClassification9 AS CustomerTaxClassification9,
cast( '' as vtext ) AS CustomerTaxClassification9Name,
_SlsPrcgCndnRecdValidity.ProductTaxClassification1 AS ProductTaxClassification1,
cast( '' as vtext ) AS ProductTaxClassification1Name,
_SlsPrcgCndnRecdValidity.ProductTaxClassification2 AS ProductTaxClassification2,
cast( '' as vtext ) AS ProductTaxClassification2Name,
_SlsPrcgCndnRecdValidity.ProductTaxClassification3 AS ProductTaxClassification3,
cast( '' as vtext ) AS ProductTaxClassification3Name,
_SlsPrcgCndnRecdValidity.ProductTaxClassification4 AS ProductTaxClassification4,
cast( '' as vtext ) AS ProductTaxClassification4Name,
_SlsPrcgCndnRecdValidity.ProductTaxClassification5 AS ProductTaxClassification5,
cast( '' as vtext ) AS ProductTaxClassification5Name,
_SlsPrcgCndnRecdValidity.ProductTaxClassification6 AS ProductTaxClassification6,
cast( '' as vtext ) AS ProductTaxClassification6Name,
_SlsPrcgCndnRecdValidity.ProductTaxClassification7 AS ProductTaxClassification7,
cast( '' as vtext ) AS ProductTaxClassification7Name,
_SlsPrcgCndnRecdValidity.ProductTaxClassification8 AS ProductTaxClassification8,
cast( '' as vtext ) AS ProductTaxClassification8Name,
_SlsPrcgCndnRecdValidity.ProductTaxClassification9 AS ProductTaxClassification9,
cast( '' as vtext ) AS ProductTaxClassification9Name,
_SlsPrcgCndnRecdValidity.TradingContract AS TradingContract,
_SlsPrcgCndnRecdValidity.TradingContractItem AS TradingContractItem,
_SlsPrcgCndnRecdValidity.TaxJurisdiction AS TaxJurisdiction,
cast( '' as text1_txjt ) AS TaxJurisdictionName,
_SlsPrcgCndnRecdValidity.CndnBillingDocumentCategory AS CndnBillingDocumentCategory,
cast( '' as billingdocumentcategoryname ) AS BillingDocumentCategoryName,
_SlsPrcgCndnRecdValidity.MainItemMaterialPricingGroup AS MainItemMaterialPricingGroup,
cast( '' as bezei20 ) AS MainItmMatlPricingGroupName,
_SlsPrcgCndnRecdValidity.MainItemPricingRefMaterial AS MainItemPricingRefMaterial,
cast( '' as maktx ) AS MainItemPricingRefMaterialName,
_SlsPrcgCndnRecdValidity.VariantCondition AS VariantCondition,
cast( '' as varcond ) AS VariantConditionName,
_SlsPrcgCndnRecdValidity.ValueAddedServiceChargeCode AS ValueAddedServiceChargeCode,
_SlsPrcgCndnRecdValidity.SDDocument AS SDDocument,
_SlsPrcgCndnRecdValidity.ReferenceSDDocument AS ReferenceSDDocument,
_SlsPrcgCndnRecdValidity.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
_SlsPrcgCndnRecdValidity.SalesOffice AS SalesOffice,
cast( '' as bezei20 ) AS SalesOfficeName,
_SlsPrcgCndnRecdValidity.SalesGroup AS SalesGroup,
cast( '' as bezei20 ) AS SalesGroupName,
_SlsPrcgCndnRecdValidity.SalesOrganization AS SalesOrganization,
cast( '' as vtext ) AS SalesOrganizationName,
_SlsPrcgCndnRecdValidity.SalesOrderSalesOrganization AS SalesOrderSalesOrganization,
cast( '' as vtxtk ) AS SlsOrderSalesOrganizationName,
_SlsPrcgCndnRecdValidity.OrderQuantityUnit AS OrderQuantityUnit,
cast( '' as msehl ) AS OrderQuantityUnitName,
_SlsPrcgCndnRecdValidity.DistributionChannel AS DistributionChannel,
cast( '' as vtext ) AS DistributionChannelName,
_SlsPrcgCndnRecdValidity.TransactionCurrency AS TransactionCurrency,
cast( '' as ltext ) AS TransactionCurrencyName,
_SlsPrcgCndnRecdValidity.WBSElementInternalID AS WBSElementInternalID,
cast( '' as ps_post1 ) AS WBSDescription,
_SlsPrcgCndnRecdValidity.WBSElementExternalID AS WBSElementExternalID,
cast('' as /cpd/plan_item_id) AS WorkPackage,
cast( '' as ps_post1 ) AS WorkPackageName,
_SlsPrcgCndnRecdValidity.Plant AS Plant,
cast( '' as name1 ) AS PlantName,
_SlsPrcgCndnRecdValidity.PlantRegion AS PlantRegion,
cast( '' as bezei20 ) AS PlantRegionName,
_SlsPrcgCndnRecdValidity.WorkItem AS WorkItem,
cast( '' as /cpd/pfp_workitem_name ) AS WorkItemName,
_SlsPrcgCndnRecdValidity.ConditionProcessingStatus AS ConditionProcessingStatus,
cast( '' as vtxtk ) AS ConditionProcessingStatusText,
_SlsPrcgCndnRecdValidity.PricingDate AS PricingDate,
_SlsPrcgCndnRecdValidity.ConditionIsExclusive AS ConditionIsExclusive,
_SlsPrcgCndnRecdValidity.ConditionScaleBasisValue AS ConditionScaleBasisValue,
_SlsPrcgCndnRecdValidity.TaxCode AS TaxCode,
_SlsPrcgCndnRecdValidity.ServiceDocument AS ServiceDocument,
_SlsPrcgCndnRecdValidity.ServiceDocumentItem AS ServiceDocumentItem,
_SlsPrcgCndnRecdValidity.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
cast( '' as cats_ssc_overtimecattext) AS TimeSheetOvertimeCategoryText,
_SlsPrcgCndnRecdValidity.SalesSDDocumentCategory AS SalesSDDocumentCategory,
cast( '' as val_text ) AS SDDocumentCategoryName,
_SlsPrcgCndnRecdValidity.ReturnReason AS ReturnReason,
_SlsPrcgCndnRecdValidity.ProdUnivHierarchyNode AS ProdUnivHierarchyNode,
cast( '' as prod_hier_node_value_text ) AS ProdUnivHierarchyNodeText,
cast( '' as prodh_d) AS ProductHierarchyNode,
cast( '' as prod_hier_node_value_text ) AS ProductHierarchyNodeText,
_SlsPrcgCndnRecdValidity.CustomerConditionGroup AS CustomerConditionGroup,
_SlsPrcgCndnRecdValidity.ShippingType AS ShippingType,
cast( '' as versartbez ) AS ShippingTypeName,
_SlsPrcgCndnRecdValidity.SubscriptionContractDuration AS SubscriptionContractDuration,
cast('' as crms4_som_ctr_term_unit) AS SubscrpnContrDurationUnit,
_SlsPrcgCndnRecdValidity.SubscriptionContractLockReason AS SubscriptionContractLockReason,
_SlsPrcgCndnRecdValidity.CrsCtlgMappgPriceVersionNumber AS CrsCtlgMappgPriceVersionNumber,
_SlsPrcgCndnRecdValidity.OrderType AS OrderType,
cast( '' as pph_auarttext ) AS OrderTypeName,
_SlsPrcgCndnRecdValidity.SalesDocumentType AS SalesDocumentType,
cast( '' as bezei ) AS SalesDocumentTypeName,
_SlsPrcgCndnRecdValidity.SDDocumentReason AS SDDocumentReason,
cast( '' as bezei ) AS SDDocumentReasonText,
_SlsPrcgCndnRecdValidity.VolumeRebateGroup AS VolumeRebateGroup,
cast( '' as vtext ) AS VolumeRebateGroupName,
_SlsPrcgCndnRecdValidity.ValuationType AS ValuationType,
_SlsPrcgCndnRecdValidity.SalesDistrict AS SalesDistrict,
cast( '' as bztxt ) AS SalesDistrictName,
_SlsPrcgCndnRecdValidity.Batch AS Batch,
_SlsPrcgCndnRecdValidity.PurgDocSupplyingPlant AS PurgDocSupplyingPlant,
cast( '' as werks_name ) AS SupplyingPlantName,
_SlsPrcgCndnRecdValidity.MatUsageIndicator AS MatUsageIndicator,
cast( '' as bezei20 ) AS MatlUsageIndicatorText,
_SlsPrcgCndnRecdValidity.ShippingCondition AS ShippingCondition,
cast( '' as vsbed_bez ) AS ShippingConditionName,
_SlsPrcgCndnRecdValidity.PlantCounty AS PlantCounty,
cast( '' as ad_county ) AS PlantCountyName,
_SlsPrcgCndnRecdValidity.PlantCity AS PlantCity,
cast( '' as ort01 ) AS PlantCityName,
_SlsPrcgCndnRecdValidity.MaterialExternalGroup AS MaterialExternalGroup,
cast( '' as ewbez ) AS ExternalProductGroupName,
_SlsPrcgCndnRecdValidity.CustomerHierarchyRootNode AS CustomerHierarchyRootNode,
cast( '' as hrytxt ) AS CustomerUniversalHierarchyText,
_SlsPrcgCndnRecdValidity.CustomerHierarchyNodeID AS CustomerHierarchyNodeID,
cast( '' as cust_hier_node_value_text ) AS CustUnivHierarchyNodeText,
_SlsPrcgCndnRecdValidity.CustomerHierarchyNodeType AS CustomerHierarchyNodeType,
_SlsPrcgCndnRecdValidity.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
cast( '' as bezei20 ) AS AdditionalCustomerGroup1Name,
_SlsPrcgCndnRecdValidity.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
cast( '' as bezei20 ) AS AdditionalCustomerGroup2Name,
_SlsPrcgCndnRecdValidity.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
cast( '' as bezei20 ) AS AdditionalCustomerGroup3Name,
_SlsPrcgCndnRecdValidity.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
cast( '' as bezei20 ) AS AdditionalCustomerGroup4Name,
_SlsPrcgCndnRecdValidity.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
cast( '' as bezei20 ) AS AdditionalCustomerGroup5Name,
_SlsPrcgCndnRecdValidity.SDDocumentItem AS SDDocumentItem,
_SlsPrcgCndnRecdValidity.ConditionReleaseStatus AS ConditionReleaseStatus,
cast('' as ddtext) AS ConditionReleaseStatusText,
cast('' as esh_e_fl_filename) AS PhysDocFileName,
cast('' as char40) AS ETag,
cast('' as boole_d) AS ConditionIsWithholdingTax
FROM P_SlsPrcgConditionRecord AS _SlsPrcgConditionRecord
LEFT OUTER JOIN I_SlsPrcgCndnRecdValidity AS _SlsPrcgCndnRecdValidity ON ConditionRecord = _SlsPrcgCndnRecdValidity.ConditionRecord -- association [0..*]
LEFT OUTER JOIN E_SlsPrcgCndnRecdValidity AS _Extension ON ConditionRecord = _Extension.ConditionRecord AND ConditionValidityEndDate = _Extension.ConditionValidityEndDate -- association [0..1]
;