I_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 I_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 I_SlsPrcgCndnRecdValidity AS
SELECT
  ConditionRecord,
  ConditionValidityEndDate,
  ConditionValidityStartDate,
  ConditionApplication,
  ConditionType,
  ConditionReleaseStatus,
  DepartureCountry,
  SalesDocument,
  SalesDocumentItem,
  BillableControl,
  Industry,
  CityCode,
  ConditionContract,
  County,
  EngagementProject,
  ConfigurationNumber,
  BR_NFDocumentType,
  BRSpcfcFreeDefinedField1,
  BRSpcfcFreeDefinedField2,
  BRSpcfcFreeDefinedField3,
  InternationalArticleNumber,
  TechnicalObjectType,
  Equipment,
  CustomerHierarchy,
  IncotermsClassification,
  IncotermsTransferLocation,
  AccountTaxType,
  TxRlvnceClassfctnForArgentina,
  BR_TaxCode,
  LocalSalesTaxApplicabilityCode,
  CustomerGroup,
  CustomerPriceGroup,
  MaterialPricingGroup,
  SoldToParty,
  BPForSoldToParty,
  Customer,
  BPForCustomer,
  PayerParty,
  BPForPayerParty,
  ShipToParty,
  BPForShipToParty,
  Supplier,
  BPForSupplier,
  DestinationCountry,
  MaterialGroup,
  Material,
  ReturnsRefundExtent,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  Personnel,
  PersonWorkAgreement,
  PriceListType,
  PostalCode,
  Region,
  EngagementProjectServiceOrg,
  RequirementSegment,
  StockSegment,
  Division,
  CommodityCode,
  ConsumptionTaxCtrlCode,
  BRSpcfcTaxBasePercentageCode,
  BRSpcfcTxGrpDynTaxExceptions,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  ProductTaxClassification1,
  ProductTaxClassification2,
  ProductTaxClassification3,
  ProductTaxClassification4,
  ProductTaxClassification5,
  ProductTaxClassification6,
  ProductTaxClassification7,
  ProductTaxClassification8,
  ProductTaxClassification9,
  TradingContract,
  TradingContractItem,
  TaxJurisdiction,
  BRSpcfcTaxDepartureRegion,
  BRSpcfcTaxDestinationRegion,
  MainItemMaterialPricingGroup,
  MainItemPricingRefMaterial,
  VariantCondition,
  ValueAddedServiceChargeCode,
  SDDocument,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  SalesOffice,
  SalesGroup,
  SalesOrganization,
  SalesOrderSalesOrganization,
  OrderQuantityUnit,
  DistributionChannel,
  TransactionCurrency,
  WBSElementInternalID,
  WBSElementExternalID,
  WorkPackage,
  WorkPackageInternalID,
  Plant,
  PlantRegion,
  WorkItem,
  ConditionProcessingStatus,
  PricingDate,
  ConditionIsExclusive,
  ConditionScaleBasisValue,
  TaxCode,
  ServiceDocument,
  ServiceDocumentItem,
  TimeSheetOvertimeCategory,
  SalesSDDocumentCategory,
  ReturnReason,
  ProdUnivHierarchyNode,
  ProductHierarchyNode,
  CustomerConditionGroup,
  ShippingType,
  SubscriptionContractDuration,
  SubscrpnContrDurationUnit,
  SubscriptionContractLockReason,
  CrsCtlgMappgPriceVersionNumber,
  OrderType,
  SalesDocumentType,
  SDDocumentReason,
  VolumeRebateGroup,
  ValuationType,
  SalesDistrict,
  Batch,
  PurgDocSupplyingPlant,
  MatUsageIndicator,
  ShippingCondition,
  PlantCounty,
  PlantCity,
  MaterialExternalGroup,
  CustomerHierarchyRootNode,
  CustomerHierarchyNodeID,
  CustomerHierarchyNodeType,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  SDDocumentItem,
  CndnBillingDocumentCategory,
  Country,
  CustomerPurchaseOrderType,
  CountryOfOrigin,
  SalesDocumentItemCategory,
  BillToParty,
  BusinessPartnerIndustryCode,
  BillingDocumentType,
  MatlAccountAssignmentGroup,
  Route
FROM P_SlsPrcgCndnRecdValidity
LEFT OUTER JOIN I_SlsPrcgConditionRecord AS _SlsPrcgConditionRecord ON ConditionRecord = _SlsPrcgConditionRecord.ConditionRecord  -- association [0..1]
LEFT OUTER JOIN I_SlsPrcgCndnRecdSuplmnt AS _SlsPrcgCndnRecdSuplmnt ON ConditionRecord = _SlsPrcgCndnRecdSuplmnt.ConditionRecord  -- association [0..*]
;