I_OIL_EXGFeeConditionRecords

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_OIL_EXGFeeConditionRecords.
-- 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_OIL_EXGFeeConditionRecords AS
SELECT
  knumv AS PricingDocument,
  kposn AS ConditionItem,
  stunr AS ConditionStep,
  zaehk AS ConditionCount,
  kappl AS ConditionApplication,
  kschl AS ConditionType,
  kdatu AS PriceConditionDeterminationDte,
  krech AS ConditionCalculationTypeShort,
  kawrt AS OIL_CndnBaseAmtInCntryCrcy,
  kbetr AS OIL_ConditionRateAmount,
  waers AS PurgDocConditionCurrency,
  kkurs AS LoclCrcyCnvrsnExchRate,
  kpein AS ConditionPricingQuantity,
  kmein AS SrvcDocItmFutrPriceCndnQtyUnit,
  kumza AS ConditionToBaseQtyNmrtr,
  kumne AS ConditionToBaseQtyDnmntr,
  kntyp AS ConditionCategory,
  kstat AS ConditionIsForStatistics,
  knprs AS PricingType,
  kruek AS IsRelevantForAccrual,
  kreli AS CndnIsRelevantForInvoiceList,
  kherk AS ConditionOrigin,
  kgrpe AS IsGroupCondition,
  koupd AS CndnIsRelevantForLimitValue,
  kolnr AS AccessNumberOfAccessSequence,
  knumh AS ConditionRecord,
  kopos AS ConditionSequentialNumberShort,
  kvsl1 AS AccountKeyForGLAccount,
  sakn1 AS ActiveGLAccount,
  mwsk1 AS ConditionTaxCode,
  kvsl2 AS AcctKeyForAccrualsGLAccount,
  sakn2 AS AccrualsGLAccount,
  mwsk2 AS TaxCodeWithholding,
  lifnr AS TicketSupplier,
  kunnr AS CustomerRebateRecipient,
  kdiff AS CndnRoundingOffDiffAmount,
  kwert AS ConditionSimulationAmount,
  ksteu AS ConditionControl,
  kinak AS ConditionInactiveReason,
  koaid AS ConditionClass,
  zaeko AS CndnCounterHeaderConditions,
  kmxaw AS ConditionBasisLimitExceeded,
  kmxwr AS ConditionAmountLimitExceeded,
  oikostl AS FeeExpenseAccountingCostCenter,
  oiacpol AS IndicatorForFeeAccountPolicy,
  oifeeman AS IndicatorHasFeeRate,
  oikwert AS ExchangeFeeClearingAmount,
  oifeeprt AS ExchangeConditionPrintItemLvl,
  oigrnet AS IndicatorGrossPricing,
  oignstra AS ExchangeGrossPricingStrategy,
  oigrchk AS CarryOutGrossUnitCheck,
  oiinvcyc AS InvoiceCycle,
  oiinvcyact AS IndicatorHasActiveInvoiceCycle,
  oiincyst AS CndnStstclInvcCyc,
  oia_spltiv AS IndHasSpltInvcVerify,
  oia_zterm AS PaymentTerms,
  kfaktor AS FactorForConditionBasisValue,
  kdupl AS StructureCondition,
  kfaktor1 AS PeriodFactorForCndnBasisValue,
  oilicin AS InternalLicenseNumberExciseTax,
  oilictp AS LicenseTypeFeeCondition,
  oireport AS ReportNumberFeeCondition,
  oidata AS DataCaptureRoutineNumber,
  oihead AS HeaderFormatRoutineSecondLevel,
  oiitem AS ItemRoutineSecondLevelReport,
  oierrhan AS RoutineErrorHandleSecondLevel,
  kzbzg AS ScaleBaseType,
  kstbs AS ScaleBaseValueConditionAmount,
  konms AS ConditionScaleQuantityUnit,
  konws AS ConditionScaleBasisCurrency,
  kawrt_k AS CndnBaseAmountInCoCodeCrcy,
  kwaeh AS ConditionAlternativeCurrency,
  kwert_k AS ConditionAmountInCoCodeCrcy
FROM oianf
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON _ConditionApplication.ConditionApplication = ConditionApplication  -- association [1..1]
LEFT OUTER JOIN I_PricingConditionType AS _PricingConditionType ON _PricingConditionType.ConditionApplication = ConditionApplication AND _PricingConditionType.ConditionType = ConditionType  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = PurgDocConditionCurrency  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = SrvcDocItmFutrPriceCndnQtyUnit  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ScaleUnitOfMeasure ON _ScaleUnitOfMeasure.UnitOfMeasure = ConditionScaleQuantityUnit  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON _GLAccountInChartOfAccounts.GLAccount = ActiveGLAccount  -- association [1..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccount ON _GLAccount.GLAccount = AccrualsGLAccount  -- association [1..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = TicketSupplier  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = CustomerRebateRecipient  -- association [1..1]
LEFT OUTER JOIN I_OIL_InvoiceCycleVH AS _InvoiceCycleVH ON _InvoiceCycleVH.InvoiceCycle = InvoiceCycle  -- association [1..1]
LEFT OUTER JOIN I_ConditionCategory AS _ConditionCategory ON _ConditionCategory.ConditionCategory = ConditionCategory  -- association [1..1]
LEFT OUTER JOIN I_OIL_CndnCalculationTypeVH AS _CndnCalculationTypeVH ON _CndnCalculationTypeVH.ConditionCalculationTypeShort = ConditionCalculationTypeShort  -- association [1..1]
LEFT OUTER JOIN I_PricingType AS _PricingType ON _PricingType.PricingType = PricingType  -- association [1..1]
LEFT OUTER JOIN I_ConditionOrigin AS _ConditionOrigin ON _ConditionOrigin.ConditionOrigin = ConditionOrigin  -- association [1..1]
LEFT OUTER JOIN I_ConditionControl AS _ConditionControl ON _ConditionControl.ConditionControl = ConditionControl  -- association [1..1]
LEFT OUTER JOIN I_ConditionInactiveReason AS _ConditionInactiveReason ON _ConditionInactiveReason.ConditionInactiveReason = ConditionInactiveReason  -- association [1..1]
LEFT OUTER JOIN I_ConditionClass AS _ConditionClass ON _ConditionClass.ConditionClass = ConditionClass  -- association [1..1]
LEFT OUTER JOIN I_ConditionBasisLimitExceeded AS _ConditionBasisLimitExceeded ON _ConditionBasisLimitExceeded.ConditionBasisLimitExceeded = ConditionBasisLimitExceeded  -- association [1..1]
LEFT OUTER JOIN I_ConditionBasisLimitExceeded AS _ConditionAmountLimitExceeded ON _ConditionAmountLimitExceeded.ConditionBasisLimitExceeded = ConditionAmountLimitExceeded  -- association [1..1]
LEFT OUTER JOIN I_StructureCondition AS _StructureCondition ON _StructureCondition.StructureCondition = StructureCondition  -- association [1..1]
LEFT OUTER JOIN I_PricingScaleBasisShort AS _PricingScaleBasisShort ON _PricingScaleBasisShort.PricingScaleBasisShort = ScaleBaseType  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency1 ON _Currency1.Currency = ConditionScaleBasisCurrency  -- association [1..1]
LEFT OUTER JOIN I_OIL_ExchIndForGrssPrcgVH AS _ExchIndForGrssPrcgVH ON _ExchIndForGrssPrcgVH.IndicatorGrossPricing = IndicatorGrossPricing  -- association [1..1]
;