I_SlsPricingConditionRecordTP

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_SlsPricingConditionRecordTP.
-- 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: ISLSPRCDCNDNRTP

CREATE VIEW I_SlsPricingConditionRecordTP AS
SELECT
  Record.conditionrecorduuid AS ConditionRecordUUID,
  Record.conditionrecord AS ConditionRecord,
  Record.conditionsequentialnumber AS ConditionSequentialNumber,
  Validity.ConditionValidityEndDate AS ConditionValidityEndDate,
  Validity.ConditionValidityStartDate AS ConditionValidityStartDate,
  Record.conditiontable AS ConditionTable,
  cast( '' as ddtext ) AS ConditionTableDescription,
  Record.conditionapplication AS ConditionApplication,
  Record.conditiontype AS ConditionType,
  cast ( '' as vtxtm ) AS ConditionTypeName,
  Record.createdbyuser AS CreatedByUser,
  Record.creationdate AS CreationDate,
  Record.conditionsearchtermvalue AS ConditionSearchTermValue,
  Record.conditiontextid AS ConditionTextID,
  Record.pricingscaletype AS PricingScaleType,
  cast ( '' as price_element_scale_type_descr ) AS PricingScaleTypeName,
  Record.pricingscalebasis AS PricingScaleBasis,
  cast ( '' as price_element_scbasetype_descr ) AS PricingScaleBasisName,
  Record.pricingscalecheckingrule AS PricingScaleCheckingRule,
  cast ( '' as price_element_description ) AS PricingScaleCheckingRuleName,
  Record.conditionscalequantity AS ConditionScaleQuantity,
  Record.conditionscalequantityunit AS ConditionScaleQuantityUnit,
  Record.conditionscaleamount AS ConditionScaleAmount,
  Record.conditionscaleamountcurrency AS ConditionScaleAmountCurrency,
  Record.conditioncalculationtype AS ConditionCalculationType,
  cast ( '' as prct_calculation_type_descr ) AS ConditionCalculationTypeName,
  Record.conditionratevalue AS ConditionRateValue,
  Record.conditionratevalueunit AS ConditionRateValueUnit,
  Record.conditionrateratio AS ConditionRateRatio,
  Record.conditionrateratiounit AS ConditionRateRatioUnit,
  Record.conditionrateamount AS ConditionRateAmount,
  Record.conditioncurrency AS ConditionCurrency,
  Record.conditionquantity AS ConditionQuantity,
  Record.conditionquantityunit AS ConditionQuantityUnit,
  Record.conditiontobaseqtynmrtr AS ConditionToBaseQtyNmrtr,
  Record.conditiontobaseqtydnmntr AS ConditionToBaseQtyDnmntr,
  Record.baseunit AS BaseUnit,
  cast ( '' as text60 ) AS ConditionUnitConversionText,
  Record.conditionlowerlimit AS ConditionLowerLimit,
  Record.conditionlowerlimitamount AS ConditionLowerLimitAmount,
  Record.conditionlowerlimitratio AS ConditionLowerLimitRatio,
  Record.conditionupperlimit AS ConditionUpperLimit,
  Record.conditionupperlimitamount AS ConditionUpperLimitAmount,
  Record.conditionupperlimitratio AS ConditionUpperLimitRatio,
  Record.conditionalternativecurrency AS ConditionAlternativeCurrency,
  Record.conditionexclusion AS ConditionExclusion,
  Record.conditionisdeleted AS ConditionIsDeleted,
  cast( '' as kostkz ) AS ConditionHasScales,
  Record.additionalvaluedays AS AdditionalValueDays,
  Record.fixedvaluedate AS FixedValueDate,
  Record.paymentterms AS PaymentTerms,
  cast ( '' as dzterm_bez ) AS PaymentTermsName,
  Record.cndnmaxnumberofsalesorders AS CndnMaxNumberOfSalesOrders,
  Record.minimumconditionbasisvalue AS MinimumConditionBasisValue,
  Record.maximumconditionbasisvalue AS MaximumConditionBasisValue,
  Record.maximumconditionamount AS MaximumConditionAmount,
  Record.incrementalscale AS IncrementalScale,
  Record.pricingscaleline AS PricingScaleLine,
  Validity.ConditionReleaseStatus AS ConditionReleaseStatus,
  cast( '' as ddtext ) AS ConditionReleaseStatusText,
  cast( '0' as eve_tv_criticality ) AS Criticality,
  Validity.DepartureCountry AS DepartureCountry,
  cast( '' as landx50 ) AS DepartureCountryName,
  Validity.SalesDocument AS SalesDocument,
  Validity.SalesDocumentItem AS SalesDocumentItem,
  cast( '' as arktx ) AS SalesDocumentItemText,
  Validity.BillableControl AS BillableControl,
  cast( '' as bemot_txt ) AS BillableControlName,
  Validity.Industry AS Industry,
  cast( '' as text1_016t ) AS IndustryKeyText,
  Validity.CityCode AS CityCode,
  cast( '' as bezei20 ) AS CityCodeName,
  Validity.ConditionContract AS ConditionContract,
  Validity.County AS County,
  cast( '' as bezei20 ) AS CountyName,
  Validity.TechnicalObjectType AS TechnicalObjectType,
  cast( '' as eartx ) AS TechnicalObjectTypeDesc,
  Validity.Equipment AS Equipment,
  cast( '' as ktx01 ) AS EquipmentName,
  Validity.CustomerHierarchy AS CustomerHierarchy,
  Validity.IncotermsClassification AS IncotermsClassification,
  cast( '' as bezei30 ) AS IncotermsClassificationName,
  Validity.IncotermsTransferLocation AS IncotermsTransferLocation,
  Validity.AccountTaxType AS AccountTaxType,
  Validity.CustomerGroup AS CustomerGroup,
  cast( '' as vtxtk ) AS CustomerGroupName,
  Validity.CustomerPriceGroup AS CustomerPriceGroup,
  cast( '' as bezei20 ) AS CustomerPriceGroupName,
  Validity.MaterialPricingGroup AS MaterialPricingGroup,
  cast( '' as bezei20 ) AS MaterialPricingGroupName,
  Validity.SoldToParty AS SoldToParty,
  cast( '' as md_customer_name ) AS SoldToPartyName,
  Validity.Customer AS Customer,
  cast( '' as md_customer_name ) AS CustomerName,
  Validity.PayerParty AS PayerParty,
  cast( '' as md_customer_name ) AS PayerPartyName,
  Validity.ShipToParty AS ShipToParty,
  cast( '' as md_customer_name ) AS ShipToPartyName,
  Validity.Supplier AS Supplier,
  cast( '' as md_supplier_name ) AS SupplierName,
  Validity.DestinationCountry AS DestinationCountry,
  cast( '' as landx50 ) AS DestinationCountryName,
  Validity.MaterialGroup AS MaterialGroup,
  cast( '' as wgbez ) AS MaterialGroupName,
  Validity.ReturnsRefundExtent AS ReturnsRefundExtent,
  cast( '' as msr_refund_code_text ) AS ReturnsRefundExtentDesc,
  Validity.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  cast( '' as bezei40 ) AS AdditionalMaterialGroup1Name,
  Validity.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  cast( '' as bezei40 ) AS AdditionalMaterialGroup2Name,
  Validity.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  cast( '' as bezei40 ) AS AdditionalMaterialGroup3Name,
  Validity.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  cast( '' as bezei40 ) AS AdditionalMaterialGroup4Name,
  Validity.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  cast( '' as bezei40 ) AS AdditionalMaterialGroup5Name,
  Validity.Personnel AS Personnel,
  cast( '' as bu_name1tx ) AS PersonFullName,
  Validity.PriceListType AS PriceListType,
  cast( '' as text20 ) AS PriceListTypeName,
  Validity.PostalCode AS PostalCode,
  Validity.Region AS Region,
  cast( '' as bezei20 ) AS RegionName,
  Validity.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  cast( '' as /cpd/pws_ws_org_unit_id_desc ) AS EngmtProjectServiceOrgName,
  Validity.RequirementSegment AS RequirementSegment,
  Validity.StockSegment AS StockSegment,
  Validity.Division AS Division,
  cast( '' as divisionname ) AS DivisionName,
  Validity.CommodityCode AS CommodityCode,
  cast( '' as bezei40 ) AS CommodityCodeText,
  Validity.ProdUnivHierarchyNode AS ProdUnivHierarchyNode,
  cast( '' as prod_hier_node_value_text ) AS ProdUnivHierarchyNodeText,
  Validity.ProductHierarchyNode AS ProductHierarchyNode,
  cast( '' as prod_hier_node_value_text ) AS ProductHierarchyNodeText,
  Validity.ConsumptionTaxCtrlCode AS ConsumptionTaxCtrlCode,
  cast( '' as bezei60 ) AS ConsumptionTaxCntrlCodeDesc,
  Validity.BRSpcfcTaxBasePercentageCode AS BRSpcfcTaxBasePercentageCode,
  Validity.BRSpcfcTxGrpDynTaxExceptions AS BRSpcfcTxGrpDynTaxExceptions,
  Validity.CustomerTaxClassification1 AS CustomerTaxClassification1,
  cast( '' as vtext ) AS CustomerTaxClassification1Name,
  Validity.CustomerTaxClassification2 AS CustomerTaxClassification2,
  cast( '' as vtext ) AS CustomerTaxClassification2Name,
  Validity.CustomerTaxClassification3 AS CustomerTaxClassification3,
  cast( '' as vtext ) AS CustomerTaxClassification3Name,
  Validity.CustomerTaxClassification4 AS CustomerTaxClassification4,
  cast( '' as vtext ) AS CustomerTaxClassification4Name,
  Validity.CustomerTaxClassification5 AS CustomerTaxClassification5,
  cast( '' as vtext ) AS CustomerTaxClassification5Name,
  Validity.CustomerTaxClassification6 AS CustomerTaxClassification6,
  cast( '' as vtext ) AS CustomerTaxClassification6Name,
  Validity.CustomerTaxClassification7 AS CustomerTaxClassification7,
  cast( '' as vtext ) AS CustomerTaxClassification7Name,
  Validity.CustomerTaxClassification8 AS CustomerTaxClassification8,
  cast( '' as vtext ) AS CustomerTaxClassification8Name,
  Validity.CustomerTaxClassification9 AS CustomerTaxClassification9,
  cast( '' as vtext ) AS CustomerTaxClassification9Name,
  Validity.ProductTaxClassification1 AS ProductTaxClassification1,
  cast( '' as vtext ) AS ProductTaxClassification1Name,
  Validity.ProductTaxClassification2 AS ProductTaxClassification2,
  cast( '' as vtext ) AS ProductTaxClassification2Name,
  Validity.ProductTaxClassification3 AS ProductTaxClassification3,
  cast( '' as vtext ) AS ProductTaxClassification3Name,
  Validity.ProductTaxClassification4 AS ProductTaxClassification4,
  cast( '' as vtext ) AS ProductTaxClassification4Name,
  Validity.ProductTaxClassification5 AS ProductTaxClassification5,
  cast( '' as vtext ) AS ProductTaxClassification5Name,
  Validity.ProductTaxClassification6 AS ProductTaxClassification6,
  cast( '' as vtext ) AS ProductTaxClassification6Name,
  Validity.ProductTaxClassification7 AS ProductTaxClassification7,
  cast( '' as vtext ) AS ProductTaxClassification7Name,
  Validity.ProductTaxClassification8 AS ProductTaxClassification8,
  cast( '' as vtext ) AS ProductTaxClassification8Name,
  Validity.ProductTaxClassification9 AS ProductTaxClassification9,
  cast( '' as vtext ) AS ProductTaxClassification9Name,
  Validity.TradingContract AS TradingContract,
  Validity.TradingContractItem AS TradingContractItem,
  Validity.TaxJurisdiction AS TaxJurisdiction,
  cast( '' as text1_txjt ) AS TaxJurisdictionName,
  Validity.BRSpcfcTaxDepartureRegion AS BRSpcfcTaxDepartureRegion,
  Validity.BRSpcfcTaxDestinationRegion AS BRSpcfcTaxDestinationRegion,
  Validity.MainItemMaterialPricingGroup AS MainItemMaterialPricingGroup,
  cast( '' as bezei20 ) AS MainItmMatlPricingGroupName,
  Validity.MainItemPricingRefMaterial AS MainItemPricingRefMaterial,
  cast( '' as maktx ) AS MainItemPricingRefMaterialName,
  Validity.VariantCondition AS VariantCondition,
  cast( '' as varcond ) AS VariantConditionName,
  Validity.ValueAddedServiceChargeCode AS ValueAddedServiceChargeCode,
  Validity.SDDocument AS SDDocument,
  Validity.ReferenceSDDocument AS ReferenceSDDocument,
  Validity.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  Validity.SalesOffice AS SalesOffice,
  cast( '' as bezei20 ) AS SalesOfficeName,
  Validity.SalesGroup AS SalesGroup,
  cast( '' as bezei20 ) AS SalesGroupName,
  Validity.SalesOrderSalesOrganization AS SalesOrderSalesOrganization,
  cast( '' as vtxtk ) AS SlsOrderSalesOrganizationName,
  Validity.OrderQuantityUnit AS OrderQuantityUnit,
  cast( '' as msehl ) AS OrderQuantityUnitName,
  Validity.SalesOrganization AS SalesOrganization,
  cast( '' as vtext ) AS SalesOrganizationName,
  Validity.DistributionChannel AS DistributionChannel,
  cast( '' as vtext ) AS DistributionChannelName,
  Validity.Material AS Material,
  cast( '' as maktx ) AS MaterialName,
  Validity.TransactionCurrency AS TransactionCurrency,
  cast( '' as ltext ) AS TransactionCurrencyName,
  cast( Validity.WBSElementInternalID as ps_posid ) AS WBSElementInternalID,
  cast( '' as ps_post1 ) AS WBSDescription,
  cast( Validity.WorkPackage as ps_posid ) AS WorkPackage,
  cast( '' as ps_post1 ) AS WorkPackageName,
  Validity.Plant AS Plant,
  cast( '' as name1 ) AS PlantName,
  Validity.PlantRegion AS PlantRegion,
  cast( '' as bezei20 ) AS PlantRegionName,
  Validity.WorkItem AS WorkItem,
  cast( '' as /cpd/pfp_workitem_name ) AS WorkItemName,
  Validity.ConditionProcessingStatus AS ConditionProcessingStatus,
  cast( '' as vtxtk ) AS ConditionProcessingStatusText,
  Validity.PricingDate AS PricingDate,
  Validity.ConditionIsExclusive AS ConditionIsExclusive,
  Validity.ConditionScaleBasisValue AS ConditionScaleBasisValue,
  Validity.TaxCode AS TaxCode,
  cast( '' as text1_007s ) AS TaxCodeName,
  Validity.EngagementProject AS EngagementProject,
  cast( '' as /cpd/short_text ) AS EngagementProjectName,
  Validity.ConfigurationNumber AS ConfigurationNumber,
  Validity.BR_NFDocumentType AS BR_NFDocumentType,
  Validity.BRSpcfcFreeDefinedField1 AS BRSpcfcFreeDefinedField1,
  Validity.BRSpcfcFreeDefinedField2 AS BRSpcfcFreeDefinedField2,
  Validity.BRSpcfcFreeDefinedField3 AS BRSpcfcFreeDefinedField3,
  Validity.InternationalArticleNumber AS InternationalArticleNumber,
  Validity.TxRlvnceClassfctnForArgentina AS TxRlvnceClassfctnForArgentina,
  Validity.BR_TaxCode AS BR_TaxCode,
  Validity.LocalSalesTaxApplicabilityCode AS LocalSalesTaxApplicabilityCode,
  Validity.ServiceDocument AS ServiceDocument,
  Validity.ServiceDocumentItem AS ServiceDocumentItem,
  Validity.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  cast( '' as cats_ssc_overtimecattext) AS TimeSheetOvertimeCategoryText,
  Validity.SalesSDDocumentCategory AS SalesSDDocumentCategory,
  cast( '' as val_text ) AS SDDocumentCategoryName,
  Validity.ReturnReason AS ReturnReason,
  Validity.CustomerConditionGroup AS CustomerConditionGroup,
  Validity.ShippingType AS ShippingType,
  cast( '' as versartbez ) AS ShippingTypeName,
  Validity.SubscriptionContractDuration AS SubscriptionContractDuration,
  Validity.SubscrpnContrDurationUnit AS SubscrpnContrDurationUnit,
  Validity.SubscriptionContractLockReason AS SubscriptionContractLockReason,
  Validity.OrderType AS OrderType,
  cast( '' as pph_auarttext ) AS OrderTypeName,
  Validity.SalesDocumentType AS SalesDocumentType,
  cast( '' as bezei ) AS SalesDocumentTypeName,
  Validity.SDDocumentReason AS SDDocumentReason,
  cast( '' as bezei ) AS SDDocumentReasonText,
  Validity.VolumeRebateGroup AS VolumeRebateGroup,
  cast( '' as vtext ) AS VolumeRebateGroupName,
  Validity.ValuationType AS ValuationType,
  Validity.SalesDistrict AS SalesDistrict,
  cast( '' as bztxt ) AS SalesDistrictName,
  Validity.Batch AS Batch,
  Validity.PurgDocSupplyingPlant AS PurgDocSupplyingPlant,
  cast( '' as werks_name ) AS SupplyingPlantName,
  Validity.MatUsageIndicator AS MatUsageIndicator,
  cast( '' as bezei20 ) AS MatlUsageIndicatorText,
  Validity.ShippingCondition AS ShippingCondition,
  cast( '' as vsbed_bez ) AS ShippingConditionName,
  Validity.PlantCounty AS PlantCounty,
  cast( '' as ad_county ) AS PlantCountyName,
  Validity.PlantCity AS PlantCity,
  cast( '' as ort01 ) AS PlantCityName,
  Validity.MaterialExternalGroup AS MaterialExternalGroup,
  cast( '' as ewbez ) AS ExternalProductGroupName,
  Validity.CustomerHierarchyRootNode AS CustomerHierarchyRootNode,
  cast( '' as hrytxt ) AS CustomerUniversalHierarchyText,
  Validity.CustomerHierarchyNodeID AS CustomerHierarchyNodeID,
  cast( '' as cust_hier_node_value_text ) AS CustUnivHierarchyNodeText,
  Validity.CustomerHierarchyNodeType AS CustomerHierarchyNodeType,
  cast( '' as mdbp_custh_nodetypet ) AS CustomerHierarchyNodeTypeText,
  Validity.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  cast( '' as bezei20 ) AS AdditionalCustomerGroup1Name,
  Validity.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  cast( '' as bezei20 ) AS AdditionalCustomerGroup2Name,
  Validity.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  cast( '' as bezei20 ) AS AdditionalCustomerGroup3Name,
  Validity.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  cast( '' as bezei20 ) AS AdditionalCustomerGroup4Name,
  Validity.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  cast( '' as bezei20 ) AS AdditionalCustomerGroup5Name,
  Validity.SDDocumentItem AS SDDocumentItem,
  Validity.CndnBillingDocumentCategory AS CndnBillingDocumentCategory,
  cast( '' as billingdocumentcategoryname ) AS BillingDocumentCategoryName,
  Validity.Country AS Country,
  cast( '' as landx50 ) AS CountryName,
  Validity.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  cast( '' as bsark_bez ) AS CustomerPurchaseOrderTypeDesc,
  Validity.CountryOfOrigin AS CountryOfOrigin,
  cast( '' as landx50 ) AS CountryOfOriginName,
  Validity.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  cast( '' as bezei20 ) AS SalesDocumentItemCategoryName,
  Validity.BillToParty AS BillToParty,
  cast( '' as md_customer_name ) AS BillToPartyName,
  Validity.BusinessPartnerIndustryCode AS BusinessPartnerIndustryCode,
  cast( '' as vtext ) AS CustomerIndustryCodeText,
  Validity.BillingDocumentType AS BillingDocumentType,
  cast( '' as vtext ) AS BillingDocumentTypeName,
  Validity.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  cast( '' as vtext ) AS MatlAccountAssignmentGroupName,
  Validity.Route AS Route,
  cast ( '' as routbez ) AS RouteName,
  cast( '00000000' as datam ) AS ValidOnDate,
  cast( '000' as kolnr ) AS AccessNumberOfAccessSequence,
  cast( '' as char40 ) AS ETag,
  cast( '' as boolean) AS ConditionRecordIsEditable,
  cast( '' as boolean) AS ConditionRecordIsDraft,
  cast( '' as char1) AS Status,
  Record.salespriceapprovalrequest AS SalesPriceApprovalRequest,
  Record.conditionchangereason AS ConditionChangeReason,
  cast ( '' as text ) AS ConditionChangeReasonText,
  cast ( '' as bezei40 ) AS ConditionText,
  Record.prevapprovedconditionrecord AS PrevApprovedConditionRecord,
  Record.conditiontaxcode AS ConditionTaxCode,
  cast ( '' as text1_007s ) AS ConditionTaxCodeName,
  Record.conditionwithholdingtaxcode AS ConditionWithholdingTaxCode,
  cast ( '' as text40 ) AS CndnWithholdingTaxCodeName,
  Record.taxexemptionlicense AS TaxExemptionLicense,
  Record.licensegrantdate AS LicenseGrantDate,
  Record.conditionistaxrate AS ConditionIsTaxRate,
  Record.conditioniswithholdingtax AS ConditionIsWithholdingTax,
  Record.conditionistaxwithexemption AS ConditionIsTaxWithExemption,
  Record.conditionclass AS ConditionClass,
  cast ( '' as price_element_class_descr ) AS ConditionClassName,
  Record.conditioncategory AS ConditionCategory,
  cast ( '' as price_element_category_descr ) AS ConditionCategoryName,
  cast ( '' as /ui2/ad_mm_fiori_id ) AS ConditionFioriID,
  Record.conditionrecorduuid AS ConditionJobUUID,
  cast ( '' as num03 ) AS ConditionJobItemNo,
  cast( '00000000' as datab ) AS ExpiringPricesQueryStartDate,
  cast( '00000000' as datbi ) AS ExpiringPricesQueryEndDate,
  cast( '' as abap_boolean ) AS ConditionHasSuccessor
FROM sdprcg_cndnr AS Record
INNER JOIN I_SlsPrcgCndnRecdValidity AS Validity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_SlsPrcgCndnRecdValidity AS _Extension ON ConditionRecord = _Extension.ConditionRecord AND ConditionValidityEndDate = _Extension.ConditionValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_SlsPrcgCndnRecordScaleTP AS _SlsPricingCndnRecdScaleTP ON ConditionRecordUUID = _SlsPricingCndnRecdScaleTP.ConditionRecordUUID  -- association [0..*]
;