C_OIL_ExchFeeConditionRecdDEX

DDL: C_OIL_EXCHFEECONDITIONRECDDEX Type: view_entity CONSUMPTION
92 Fields 1 Data Sources

Fee Condition Records

C_OIL_ExchFeeConditionRecdDEX is a Consumption CDS View that provides data about "Fee Condition Records" in SAP S/4HANA. It reads from 1 data source (I_OIL_ExchFeeConditionRecord) and exposes 92 fields with key fields SalesDocumentCondition, ConditionItem, ConditionStep, ConditionCount.

Data Sources (1)

SourceAliasJoin Type
I_OIL_ExchFeeConditionRecord I_OIL_ExchFeeConditionRecord from

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Analytics.technicalName COILExchFeeConditionRecdDEX view
EndUserText.label Fee Condition Records view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey SalesDocumentCondition view
ObjectModel.sapObjectNodeType.name OIL_ExchangeFeeConditionRecord view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (92)

KeyFieldSource TableSource FieldDescription
KEY SalesDocumentCondition SalesDocumentCondition Doc. Condition
KEY ConditionItem ConditionItem Number
KEY ConditionStep ConditionStep Step Number
KEY ConditionCount ConditionCount Counter
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
PriceConditionDeterminationDte PriceConditionDeterminationDte Condition Pricing Date
ConditionCalculationTypeShort ConditionCalculationTypeShort Calculat.Type
CndnBaseAmountInCoCodeCrcy CndnBaseAmountInCoCodeCrcy Cond.Basis
OIL_ConditionRateAmount OIL_ConditionRateAmount Tax Rate
SalesCurrency SalesCurrency Trans. Currency
LoclCrcyCnvrsnExchRate LoclCrcyCnvrsnExchRate
ConditionPricingQuantity ConditionPricingQuantity Pricing Unit
VarConfignConditionRefUoM VarConfignConditionRefUoM Unit of Measure
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr Denominator
ConditionCategory ConditionCategory Condit.Category
ConditionIsForStatistics ConditionIsForStatistics Statistical
PricingType PricingType Pricing Type
IsRelevantForAccrual IsRelevantForAccrual Accruals
CndnIsRelevantForInvoiceList CndnIsRelevantForInvoiceList Settlement Document List Condition
ConditionOrigin ConditionOrigin Condit.Origin
IsGroupCondition IsGroupCondition Group Condition
CndnIsRelevantForLimitValue CndnIsRelevantForLimitValue Condit. Update
AccessNumberOfAccessSequence AccessNumberOfAccessSequence Access
ConditionRecord ConditionRecord Cond.Record No.
PricingFormulaTermItemNumber PricingFormulaTermItemNumber SequNo of Cond.
AccountKeyForGLAccount AccountKeyForGLAccount Account Key
ActiveGLAccount ActiveGLAccount G/L Account
AcctKeyForAccrualsGLAccount AcctKeyForAccrualsGLAccount Accruals
PRAOwnrPyblSuspenseAcctNumber PRAOwnrPyblSuspenseAcctNumber G/L Account
SupplierNumberDisplay SupplierNumberDisplay Vendor no.
CustomerRebateRecipient CustomerRebateRecipient Customer
CndnRoundingOffDiffAmount CndnRoundingOffDiffAmount CondRoundDiff.
ConditionAmountInAltvCrcy ConditionAmountInAltvCrcy Condition Value
ConditionControl ConditionControl Cond.Control
ConditionIsActive ConditionIsActive Inactive
ConditionClass ConditionClass Condition Class
CndnCounterHeaderConditions CndnCounterHeaderConditions HdCond.Counter
ConditionBasisLimitExceeded ConditionBasisLimitExceeded Max Basis Value
ConditionAmountLimitExceeded ConditionAmountLimitExceeded Maximum Amount
FeeExpenseAccountingCostCenter FeeExpenseAccountingCostCenter Exg cost center
IndicatorForFeeAccountPolicy IndicatorForFeeAccountPolicy Acct. Policy
IndicatorHasFeeRate IndicatorHasFeeRate Fee rate ind.
ExchangeFeeClearingAmount ExchangeFeeClearingAmount Clearing amount
ExchangeConditionPrintItemLvl ExchangeConditionPrintItemLvl Print.cond
IndicatorGrossPricing IndicatorGrossPricing Gr/net ind.
ExchangeGrossPricingStrategy ExchangeGrossPricingStrategy Gr/net strategy
CarryOutGrossUnitCheck CarryOutGrossUnitCheck Unit check
InvoiceCycle InvoiceCycle Invoice cycle
IndicatorHasActiveInvoiceCycle IndicatorHasActiveInvoiceCycle Inv.CycleInd
CndnStstclInvcCyc CndnStstclInvcCyc Cond.stat.
IndHasSpltInvcVerify IndHasSpltInvcVerify Split IV
SlsOrdCustomerPaymentTerms SlsOrdCustomerPaymentTerms Pyt Terms
FactorForConditionBasisValue FactorForConditionBasisValue Factor for Condition Basis Value
StructureCondition StructureCondition Structure Cond.
PeriodFactorForCndnBasisValue PeriodFactorForCndnBasisValue Period Factor for Condition Basis Value
InternalLicenseNumberExciseTax InternalLicenseNumberExciseTax Internal lic.no
LicenseTypeFeeCondition LicenseTypeFeeCondition License type
ReportNumberFeeCondition ReportNumberFeeCondition Report number
DataCaptureRoutineNumber DataCaptureRoutineNumber Data capture
HeaderFormatRoutineSecondLevel HeaderFormatRoutineSecondLevel Header format
ItemRoutineSecondLevelReport ItemRoutineSecondLevelReport Item format
RoutineErrorHandleSecondLevel RoutineErrorHandleSecondLevel Error handling
ScaleBaseType ScaleBaseType Scale Basis
ScaleBaseValueConditionAmount ScaleBaseValueConditionAmount Scale Base Val.
ConditionScaleBasisUnit ConditionScaleBasisUnit Scale UoM
ConditionScaleAmountCurrency ConditionScaleAmountCurrency Scale Currency
OIL_CndnBaseAmtInCntryCrcy OIL_CndnBaseAmtInCntryCrcy Cond.Basis
ConditionAlternativeCurrency ConditionAlternativeCurrency Cndn Currency
ConditionAmountInCoCodeCrcy ConditionAmountInCoCodeCrcy Condition Value
PrmtHbSchedDtaAgingFltrDte PrmtHbSchedDtaAgingFltrDte Data Aging
_ConditionApplication _ConditionApplication
_PricingConditionType _PricingConditionType
_CndnCalculationTypeVH _CndnCalculationTypeVH
_Currency _Currency
_UnitOfMeasure _UnitOfMeasure
_ConditionCategoryVH _ConditionCategoryVH
_PricingTypeVH _PricingTypeVH
_ConditionOrigin _ConditionOrigin
_Supplier _Supplier
_Customer _Customer
_ConditionControl _ConditionControl
_ConditionInactiveReason _ConditionInactiveReason
_ConditionClass _ConditionClass
_ConditionBasisLimitExceeded _ConditionBasisLimitExceeded
_FeeAcctPolicyIndicatorVH _FeeAcctPolicyIndicatorVH
_ConditionAmountLimitExceeded _ConditionAmountLimitExceeded
_ExchIndForGrssPrcgVH _ExchIndForGrssPrcgVH
_InvoiceCycleVH _InvoiceCycleVH
_StructureConditions _StructureConditions
_PricingScale _PricingScale

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 C_OIL_ExchFeeConditionRecdDEX.
-- 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 C_OIL_ExchFeeConditionRecdDEX AS
SELECT
  SalesDocumentCondition,
  ConditionItem,
  ConditionStep,
  ConditionCount,
  ConditionApplication,
  ConditionType,
  PriceConditionDeterminationDte,
  ConditionCalculationTypeShort,
  CndnBaseAmountInCoCodeCrcy,
  OIL_ConditionRateAmount,
  SalesCurrency,
  LoclCrcyCnvrsnExchRate,
  ConditionPricingQuantity,
  VarConfignConditionRefUoM,
  ConditionToBaseQtyNmrtr,
  ConditionToBaseQtyDnmntr,
  ConditionCategory,
  ConditionIsForStatistics,
  PricingType,
  IsRelevantForAccrual,
  CndnIsRelevantForInvoiceList,
  ConditionOrigin,
  IsGroupCondition,
  CndnIsRelevantForLimitValue,
  AccessNumberOfAccessSequence,
  ConditionRecord,
  PricingFormulaTermItemNumber,
  AccountKeyForGLAccount,
  ActiveGLAccount,
  AcctKeyForAccrualsGLAccount,
  PRAOwnrPyblSuspenseAcctNumber,
  SupplierNumberDisplay,
  CustomerRebateRecipient,
  CndnRoundingOffDiffAmount,
  ConditionAmountInAltvCrcy,
  ConditionControl,
  ConditionIsActive,
  ConditionClass,
  CndnCounterHeaderConditions,
  ConditionBasisLimitExceeded,
  ConditionAmountLimitExceeded,
  FeeExpenseAccountingCostCenter,
  IndicatorForFeeAccountPolicy,
  IndicatorHasFeeRate,
  ExchangeFeeClearingAmount,
  ExchangeConditionPrintItemLvl,
  IndicatorGrossPricing,
  ExchangeGrossPricingStrategy,
  CarryOutGrossUnitCheck,
  InvoiceCycle,
  IndicatorHasActiveInvoiceCycle,
  CndnStstclInvcCyc,
  IndHasSpltInvcVerify,
  SlsOrdCustomerPaymentTerms,
  FactorForConditionBasisValue,
  StructureCondition,
  PeriodFactorForCndnBasisValue,
  InternalLicenseNumberExciseTax,
  LicenseTypeFeeCondition,
  ReportNumberFeeCondition,
  DataCaptureRoutineNumber,
  HeaderFormatRoutineSecondLevel,
  ItemRoutineSecondLevelReport,
  RoutineErrorHandleSecondLevel,
  ScaleBaseType,
  ScaleBaseValueConditionAmount,
  ConditionScaleBasisUnit,
  ConditionScaleAmountCurrency,
  OIL_CndnBaseAmtInCntryCrcy,
  ConditionAlternativeCurrency,
  ConditionAmountInCoCodeCrcy,
  PrmtHbSchedDtaAgingFltrDte
FROM I_OIL_ExchFeeConditionRecord
;

Learn More