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_service_type ) AS ServiceTransactionChargeType,
cast( '' as crmt_valuation_type) AS SrvcTransactionValuationType,
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 cndn_agreement_source ) AS ConditionAgreementSource,
cast( '' as cndn_agreement_id ) AS ConditionAgreement,
cast( '' as cndn_agreement_item_id ) AS ConditionAgreementItem,
cast( '' as kunre ) AS BillToParty,
cast( '' as vstel ) AS ShippingPoint,
cast( '' as provg ) AS MaterialCommissionGroup,
cast('' as kosrt ) AS ConditionSearchTermValue,
cast('' as kzust ) AS ConditionResponsibility,
cast( '' as prodh1 ) AS ProductHierarchyNode1,
cast( '' as prodh2 ) AS ProductHierarchyNode2,
cast( '' as prodh3 ) AS ProductHierarchyNode3,
cast( '' as prodh4 ) AS ProductHierarchyNode4,
cast( '' as prodh5 ) AS ProductHierarchyNode5,
cast( '' as prodh6 ) AS ProductHierarchyNode6,
cast( '' as prodh7 ) AS ProductHierarchyNode7,
cast( '' as prodh8 ) AS ProductHierarchyNode8,
cast( '' as prodh9 ) AS ProductHierarchyNode9
FROM P_PrcgCndnRecdValidity
;