P_SlsPrcgCndnRecdValidity

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 P_SlsPrcgCndnRecdValidity.
-- 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 P_SlsPrcgCndnRecdValidity AS
SELECT
  ConditionRecord,
  ConditionValidityEndDate,
  ConditionValidityStartDate,
  ConditionApplication,
  ConditionType,
  cast( '' as kfrst ) AS ConditionReleaseStatus,
  cast( '' as aland ) AS DepartureCountry,
  cast( '' as vbeln_va ) AS SalesDocument,
  cast( '' as posnr_va ) AS SalesDocumentItem,
  cast( '' as bemot ) AS BillableControl,
  cast( '' as brsch ) AS Industry,
  cast( '' as cityc ) AS CityCode,
  cast( '' as wcb_coco_num ) AS ConditionContract,
  cast( '' as counc ) AS County,
  cast( '' as /cpd/mp_id ) AS EngagementProject,
  cast( '' as cuobj ) AS ConfigurationNumber,
  cast( '' as j_1bdoctyp ) AS BR_NFDocumentType,
  cast( '' as j_1bdynkey1 ) AS BRSpcfcFreeDefinedField1,
  cast( '' as j_1bdynkey2 ) AS BRSpcfcFreeDefinedField2,
  cast( '' as j_1bdynkey3 ) AS BRSpcfcFreeDefinedField3,
  cast( '' as ean11 ) AS InternationalArticleNumber,
  cast( '' as eqart ) AS TechnicalObjectType,
  cast( '' as equnr ) AS Equipment,
  cast( '' as kunnr_kh ) AS CustomerHierarchy,
  cast( '' as inco1 ) AS IncotermsClassification,
  cast( '' as inco2 ) AS IncotermsTransferLocation,
  cast( '' as j_1afitp_d ) AS AccountTaxType,
  cast( '' as j_1atxrel_ ) AS TxRlvnceClassfctnForArgentina,
  cast( '' as j_1btxsdc_ ) AS BR_TaxCode,
  cast( '' as j_1istcode ) AS LocalSalesTaxApplicabilityCode,
  cast( '' as kdgrp ) AS CustomerGroup,
  cast( '' as konda_v ) AS CustomerPriceGroup,
  cast( '' as kondm_v ) AS MaterialPricingGroup,
  cast( '' as kunag ) AS SoldToParty,
  cast( '' as bu_partner ) AS BPForSoldToParty,
  cast( '' as kunnr_v ) AS Customer,
  cast( '' as bu_partner ) AS BPForCustomer,
  cast( '' as kunrg ) AS PayerParty,
  cast( '' as bu_partner ) AS BPForPayerParty,
  cast( '' as kunwe ) AS ShipToParty,
  cast( '' as bu_partner ) AS BPForShipToParty,
  cast( '' as elifn ) AS Supplier,
  cast( '' as bu_partner ) AS BPForSupplier,
  cast( '' as lland ) AS DestinationCountry,
  cast( '' as matkl ) AS MaterialGroup,
  cast( '' as matnr ) AS Material,
  cast( '' as msr_returns_refund_code ) AS ReturnsRefundExtent,
  cast( '' as mvgr1 ) AS AdditionalMaterialGroup1,
  cast( '' as mvgr2 ) AS AdditionalMaterialGroup2,
  cast( '' as mvgr3 ) AS AdditionalMaterialGroup3,
  cast( '' as mvgr4 ) AS AdditionalMaterialGroup4,
  cast( '' as mvgr5 ) AS AdditionalMaterialGroup5,
  cast( '' as pernr_d ) AS Personnel,
  cast( '' as persno ) AS PersonWorkAgreement,
  cast( '' as pltyp ) AS PriceListType,
  cast( '' as pstlz ) AS PostalCode,
  cast( '' as regio ) AS Region,
  cast( '' as /cpd/pws_ws_org_unit_id ) AS EngagementProjectServiceOrg,
  cast( '' as sgt_rcat ) AS RequirementSegment,
  cast( '' as sgt_scat ) AS StockSegment,
  cast( '' as spart ) AS Division,
  cast( '' as stawn ) AS CommodityCode,
  cast( '' as steuc ) AS ConsumptionTaxCtrlCode,
  cast( '' as taxbs ) AS BRSpcfcTaxBasePercentageCode,
  cast( '' as j_1btxgrp ) AS BRSpcfcTxGrpDynTaxExceptions,
  cast( '' as taxk1 ) AS CustomerTaxClassification1,
  cast( '' as taxk2 ) AS CustomerTaxClassification2,
  cast( '' as taxk3 ) AS CustomerTaxClassification3,
  cast( '' as taxk4 ) AS CustomerTaxClassification4,
  cast( '' as taxk5 ) AS CustomerTaxClassification5,
  cast( '' as taxk6 ) AS CustomerTaxClassification6,
  cast( '' as taxk7 ) AS CustomerTaxClassification7,
  cast( '' as taxk8 ) AS CustomerTaxClassification8,
  cast( '' as taxk9 ) AS CustomerTaxClassification9,
  cast( '' as taxm1 ) AS ProductTaxClassification1,
  cast( '' as taxm2 ) AS ProductTaxClassification2,
  cast( '' as taxm3 ) AS ProductTaxClassification3,
  cast( '' as taxm4 ) AS ProductTaxClassification4,
  cast( '' as taxm5 ) AS ProductTaxClassification5,
  cast( '' as taxm6 ) AS ProductTaxClassification6,
  cast( '' as taxm7 ) AS ProductTaxClassification7,
  cast( '' as taxm8 ) AS ProductTaxClassification8,
  cast( '' as taxm9 ) AS ProductTaxClassification9,
  cast( '' as tkonn ) AS TradingContract,
  cast( '' as tposn ) AS TradingContractItem,
  cast( '' as txjcd ) AS TaxJurisdiction,
  cast( '' as j_1btxshpf ) AS BRSpcfcTaxDepartureRegion,
  cast( '' as j_1btxshpt ) AS BRSpcfcTaxDestinationRegion,
  cast( '' as ukonm ) AS MainItemMaterialPricingGroup,
  cast( '' as upmat ) AS MainItemPricingRefMaterial,
  cast( '' as varcond ) AS VariantCondition,
  cast( '' as fsh_vas_chrg_code ) AS ValueAddedServiceChargeCode,
  cast( '' as vbeln ) AS SDDocument,
  cast( '' as vgbel ) AS ReferenceSDDocument,
  cast( '' as vgpos ) AS ReferenceSDDocumentItem,
  cast( '' as vkbur ) AS SalesOffice,
  cast( '' as vkgrp ) AS SalesGroup,
  cast( '' as vkorg ) AS SalesOrganization,
  cast( '' as vkorg_auft ) AS SalesOrderSalesOrganization,
  cast( '' as vrkme ) AS OrderQuantityUnit,
  cast( '' as vtweg ) AS DistributionChannel,
  cast( '' as waerk ) AS TransactionCurrency,
  cast( '' as /cpd/s_sc_wbs_bill_element ) AS WBSElementInternalID,
  cast( '' as ps_posid_edit ) AS WBSElementExternalID,
  cast( '' as /cpd/s_sc_wbs_workpackage ) AS WorkPackage,
  cast( '' as ps_s4_pspnr ) AS WorkPackageInternalID,
  cast( '' as werks_d ) AS Plant,
  cast( '' as wkreg ) AS PlantRegion,
  cast( '' as /cpd/pfp_workitem_id ) AS WorkItem,
  cast( '' as kbstat ) AS ConditionProcessingStatus,
  cast( '' as kdatu ) AS PricingDate,
  cast( '' as kexcl ) AS ConditionIsExclusive,
  cast( '' as kstaf ) AS ConditionScaleBasisValue,
  cast( '' as mwskz ) AS TaxCode,
  cast( '' as crmt_object_id_db ) AS ServiceDocument,
  cast( '' as crms4_number_int ) AS ServiceDocumentItem,
  cast( '' as cats_overtime_category ) AS TimeSheetOvertimeCategory,
  cast( '' as vbtypl ) AS SalesSDDocumentCategory,
  cast( '' as msr_returns_reason ) AS ReturnReason,
  cast( '' as prod_hier_node_value) AS ProdUnivHierarchyNode,
  cast( '' as vkon_prod_hier_node_value) AS ProductHierarchyNode,
  cast( '' as kdkgr) AS CustomerConditionGroup,
  cast( '' as versart) AS ShippingType,
  cast( '' as crmt_prov_duration) AS SubscriptionContractDuration,
  cast( '' as crmt_prov_duration_unit) AS SubscrpnContrDurationUnit,
  cast( '' as ist_lock_reason) AS SubscriptionContractLockReason,
  cast( '' as ist_price_vrs) AS CrsCtlgMappgPriceVersionNumber,
  cast( '' as aufart ) AS OrderType,
  cast( '' as auart ) AS SalesDocumentType,
  cast( '' as augru ) AS SDDocumentReason,
  cast( '' as bonus ) AS VolumeRebateGroup,
  cast( '' as bwtar_d ) AS ValuationType,
  cast( '' as bzirk ) AS SalesDistrict,
  cast( '' as charg_d ) AS Batch,
  cast( '' as reswk ) AS PurgDocSupplyingPlant,
  cast( '' as abrvw ) AS MatUsageIndicator,
  cast( '' as vsbed ) AS ShippingCondition,
  cast( '' as wkcou ) AS PlantCounty,
  cast( '' as wkcty ) AS PlantCity,
  cast( '' as extwg ) AS MaterialExternalGroup,
  cast( '' as sd_custh_hier_id ) AS CustomerHierarchyRootNode,
  cast( '' as sd_custh_nodeid ) AS CustomerHierarchyNodeID,
  cast( '' as sd_custh_nodetype ) AS CustomerHierarchyNodeType,
  cast( '' as kvgr1 ) AS AdditionalCustomerGroup1,
  cast( '' as kvgr2 ) AS AdditionalCustomerGroup2,
  cast( '' as kvgr3 ) AS AdditionalCustomerGroup3,
  cast( '' as kvgr4 ) AS AdditionalCustomerGroup4,
  cast( '' as kvgr5 ) AS AdditionalCustomerGroup5,
  cast( '' as posnr ) AS SDDocumentItem,
  cast( '' as fktyp_2 ) AS CndnBillingDocumentCategory,
  cast( '' as land1_gp ) AS Country,
  cast( '' as bsark ) AS CustomerPurchaseOrderType,
  cast( '' as herkl ) AS CountryOfOrigin,
  cast( '' as pstyv ) AS SalesDocumentItemCategory,
  cast( '' as kunre ) AS BillToParty,
  cast( '' as braco ) AS BusinessPartnerIndustryCode,
  cast( '' as fkart ) AS BillingDocumentType,
  cast( '' as ktgrm ) AS MatlAccountAssignmentGroup,
  cast( '' as route ) AS Route
FROM P_PrcgCndnRecdValidity
;