I_OIL_ExchFeeConditionRecord

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_ExchFeeConditionRecord.
-- 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_ExchFeeConditionRecord AS
SELECT
  knumv AS SalesDocumentCondition,
  kposn AS ConditionItem,
  stunr AS ConditionStep,
  zaehk AS ConditionCount,
  kappl AS ConditionApplication,
  kschl AS ConditionType,
  kdatu AS PriceConditionDeterminationDte,
  krech AS ConditionCalculationTypeShort,
  kawrt AS CndnBaseAmountInCoCodeCrcy,
  kbetr AS OIL_ConditionRateAmount,
  waers AS SalesCurrency,
  cast ( kkurs as wty_kkurs ) AS LoclCrcyCnvrsnExchRate,
  kpein AS ConditionPricingQuantity,
  kmein AS VarConfignConditionRefUoM,
  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 PricingFormulaTermItemNumber,
  kvsl1 AS AccountKeyForGLAccount,
  sakn1 AS ActiveGLAccount,
  kvsl2 AS AcctKeyForAccrualsGLAccount,
  sakn2 AS PRAOwnrPyblSuspenseAcctNumber,
  lifnr AS SupplierNumberDisplay,
  kunnr AS CustomerRebateRecipient,
  kdiff AS CndnRoundingOffDiffAmount,
  kwert AS ConditionAmountInAltvCrcy,
  ksteu AS ConditionControl,
  kinak AS ConditionIsActive,
  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 SlsOrdCustomerPaymentTerms,
  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 ConditionScaleBasisUnit,
  konws AS ConditionScaleAmountCurrency,
  kawrt_k AS OIL_CndnBaseAmtInCntryCrcy,
  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 = SalesCurrency  -- association [1..1]
LEFT OUTER JOIN I_OIL_CndnCalculationTypeVH AS _CndnCalculationTypeVH ON _CndnCalculationTypeVH.ConditionCalculationTypeShort = ConditionCalculationTypeShort  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = VarConfignConditionRefUoM  -- association [1..1]
LEFT OUTER JOIN I_OIL_ConditionCategoryVH AS _ConditionCategoryVH ON _ConditionCategoryVH.ConditionCategory = ConditionCategory  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = SupplierNumberDisplay  -- association [1..1]
LEFT OUTER JOIN I_OIL_InvoiceCycleVH AS _InvoiceCycleVH ON _InvoiceCycleVH.InvoiceCycle = InvoiceCycle  -- association [1..1]
LEFT OUTER JOIN I_PricingScaleBasisShort AS _PricingScale ON _PricingScale.PricingScaleBasisShort = ScaleBaseType  -- association [1..1]
LEFT OUTER JOIN I_StructureCondition AS _StructureConditions ON _StructureConditions.StructureCondition = StructureCondition  -- association [1..1]
LEFT OUTER JOIN I_OIL_ExchIndForGrssPrcgVH AS _ExchIndForGrssPrcgVH ON _ExchIndForGrssPrcgVH.IndicatorGrossPricing = IndicatorGrossPricing  -- association [0..1]
LEFT OUTER JOIN I_OIL_FeeAcctPolicyIndicatorVH AS _FeeAcctPolicyIndicatorVH ON _FeeAcctPolicyIndicatorVH.IndicatorForFeeAccountPolicy = IndicatorForFeeAccountPolicy  -- association [0..1]
LEFT OUTER JOIN I_ConditionBasisLimitExceeded AS _ConditionBasisLimitExceeded ON _ConditionBasisLimitExceeded.ConditionBasisLimitExceeded = ConditionBasisLimitExceeded  -- association [1..1]
LEFT OUTER JOIN I_ConditionAmountLimitExceeded AS _ConditionAmountLimitExceeded ON _ConditionAmountLimitExceeded.ConditionAmountLimitExceeded = ConditionAmountLimitExceeded  -- association [1..1]
LEFT OUTER JOIN I_ConditionClass AS _ConditionClass ON _ConditionClass.ConditionClass = ConditionClass  -- association [1..1]
LEFT OUTER JOIN I_ConditionInactiveReason AS _ConditionInactiveReason ON _ConditionInactiveReason.ConditionInactiveReason = ConditionIsActive  -- association [1..1]
LEFT OUTER JOIN I_ConditionControl AS _ConditionControl ON _ConditionControl.ConditionControl = ConditionControl  -- association [1..1]
LEFT OUTER JOIN I_ConditionOrigin AS _ConditionOrigin ON _ConditionOrigin.ConditionOrigin = ConditionOrigin  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = CustomerRebateRecipient  -- association [1..1]
LEFT OUTER JOIN I_OIL_PricingTypeVH AS _PricingTypeVH ON _PricingTypeVH.PricingType = PricingType  -- association [1..1]
;