A_LoanConditionItem

DDL: A_LOANCONDITIONITEM Type: view_entity CONSUMPTION
101 Fields 1 Data Sources

Loans Management Contract Condition Item

A_LoanConditionItem is a Consumption CDS View that provides data about "Loans Management Contract Condition Item" in SAP S/4HANA. It reads from 1 data source (R_LoanConditionItemTP) and exposes 101 fields with key fields CompanyCode, LoanProductCategory, LoanContractID, LoanCndnItemTechSupplement1, LoanCndnItemTechSupplement2.

Data Sources (1)

SourceAliasJoin Type
R_LoanConditionItemTP R_LoanConditionItemTP projection

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name LoansMgmtContractConditionItem_Type view
EndUserText.label Loans Management Contract Condition Item view

Fields (101)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY LoanProductCategory LoanProductCategory
KEY LoanContractID LoanContractID
KEY LoanCndnItemTechSupplement1 LoanCndnItemTechSupplement1
KEY LoanCndnItemTechSupplement2 LoanCndnItemTechSupplement2
KEY LoanCndnHdrValdtyStrtDte LoanCndnHdrValdtyStrtDte
KEY LoanConditionHeaderOfferNumber LoanConditionHeaderOfferNumber
KEY LoanConditionType LoanConditionType
KEY LoanConditionValidityStartDate LoanConditionValidityStartDate
KEY LoanConditionLevelNumber LoanConditionLevelNumber
LoanLifeCycleStatus LoanLifeCycleStatus
LoanConditionRateInPercent LoanConditionRateInPercent
LoanConditionAmount LoanConditionAmount
LoanConditionCurrency LoanConditionCurrency
LoanCndnCalcBaseReference LoanCndnCalcBaseReference
ReferenceInterestRate ReferenceInterestRate
InterestRefRateOptrSign InterestRefRateOptrSign
LoanCndnFluctuationMarginRate LoanCndnFluctuationMarginRate
LoanCndnPaytFrequencyInMonths LoanCndnPaytFrequencyInMonths
LoanCndnPaymentFrequencyInDays LoanCndnPaymentFrequencyInDays
LoanConditionPaymentForm LoanConditionPaymentForm
LoanCndnDividendCouponNumber LoanCndnDividendCouponNumber
LoanConditionForm LoanConditionForm
LoanCndnAmountMonthlyIndCode LoanCndnAmountMonthlyIndCode
LoanConditionCalculationDate LoanConditionCalculationDate
LoanConditionDueDate LoanConditionDueDate
Customer Customer Sold-to Party
BPPaymentMethod BPPaymentMethod
BankDetailsID BankDetailsID
DunningArea DunningArea Dunning Area
BusinessPartner BusinessPartner Issuing Authority
LoanConditionQuotaNumber LoanConditionQuotaNumber
LoanCndnCalcDateIsMonthEnd LoanCndnCalcDateIsMonthEnd
LoanConditionDueDateIsMonthEnd LoanConditionDueDateIsMonthEnd
LoanCndnCalcDteNmbrOfWrkgDay LoanCndnCalcDteNmbrOfWrkgDay
LoanCndnDueDteNmbrOfWorkingDay LoanCndnDueDteNmbrOfWorkingDay
LoanConditionFactoryCalendar LoanConditionFactoryCalendar
InterestCalculationMethod InterestCalculationMethod
LoanCndnRpaytSettlementType LoanCndnRpaytSettlementType
LoanConditionGeneralDate LoanConditionGeneralDate
LoanCndnIncgPaytGenerationType LoanCndnIncgPaytGenerationType
LoanConditionPostingControlKey LoanConditionPostingControlKey
LoanAlternativeConditionType LoanAlternativeConditionType
LoanCndnIntrstRateAdjmtCndnGrp LoanCndnIntrstRateAdjmtCndnGrp
LoanCndnCalcDateInclusiveCode LoanCndnCalcDateInclusiveCode
LoanConditionFormulaReference LoanConditionFormulaReference
LoanConditionFormulaVariable LoanConditionFormulaVariable
LoanCndnCalcDteWorkingDayShift LoanCndnCalcDteWorkingDayShift
LoanCndnCalcDateUpdateMethod LoanCndnCalcDateUpdateMethod
LoanCndnDueDateWorkingDayShift LoanCndnDueDateWorkingDayShift
LoanCndnDueDateUpdateMethod LoanCndnDueDateUpdateMethod
LoanCndnPctgRateFixingDate LoanCndnPctgRateFixingDate
LnCnIntrstFxngDteNmbrOfWrkgDay LnCnIntrstFxngDteNmbrOfWrkgDay
LoanConditionFactoryCalendar2 LoanConditionFactoryCalendar2
LoanConditionFactoryCalendar3 LoanConditionFactoryCalendar3
LoanConditionFactoryCalendar4 LoanConditionFactoryCalendar4
LoanConditionFactoryCalendar5 LoanConditionFactoryCalendar5
LoanCndnCalculationBaseAmount LoanCndnCalculationBaseAmount
LoanCndnDueDateInclusiveCode LoanCndnDueDateInclusiveCode
LoanCndnPrepaymentRoundingType LoanCndnPrepaymentRoundingType
LoanCndnPaytFmWthAdjmtDays LoanCndnPaytFmWthAdjmtDays
LoanConditionUpdateMethod LoanConditionUpdateMethod
LoanCndnPaytDateWrkgDayShift LoanCndnPaytDateWrkgDayShift
LoanCndnGrcePerdIntrstIsApplbl LoanCndnGrcePerdIntrstIsApplbl
LoanCndnPctgCalculationType LoanCndnPctgCalculationType
LoanCndnProRtTmpCalcType LoanCndnProRtTmpCalcType
LoanCndnCalctUsingDueDateCode LoanCndnCalctUsingDueDateCode
LoanConditionDueDateShift LoanConditionDueDateShift
LoanCndnCalcBaseFixingType LoanCndnCalcBaseFixingType
DunningBlockingReason DunningBlockingReason Set Dunning Block
PaymentBlockingReason PaymentBlockingReason Pmnt block
LoanCndnCalcDateShiftDirection LoanCndnCalcDateShiftDirection
LoanCndnDueDateShiftDirection LoanCndnDueDateShiftDirection
Creditor Creditor Supplier
LoanCndnCompndIntrstCalcType LoanCndnCompndIntrstCalcType
LoanCndnAmountRoundingCategory LoanCndnAmountRoundingCategory
LoanCndnValueAddedTaxAmount LoanCndnValueAddedTaxAmount
LoanConditionAmountIsGross LoanConditionAmountIsGross
LoanConditionPaymentRate LoanConditionPaymentRate
LoanConditionRate2InPercent LoanConditionRate2InPercent
LoanCndnFactorRoundingCategory LoanCndnFactorRoundingCategory
LoanCndnFactorRoundingDecimals LoanCndnFactorRoundingDecimals
LoanCndnExptlIntrstCalcType LoanCndnExptlIntrstCalcType
LoanCndnBaseFctrRndngCategory LoanCndnBaseFctrRndngCategory
LoanCndnBaseFctrRndngDecimals LoanCndnBaseFctrRndngDecimals
LoanCndnRateFctrRndngCategory LoanCndnRateFctrRndngCategory
LoanCndnRateFctrRndngDecimals LoanCndnRateFctrRndngDecimals
LoanCndnPaytDteNmbrOfWrkgDay LoanCndnPaytDteNmbrOfWrkgDay
LoanCndnPaytAmtCalcMethod LoanCndnPaytAmtCalcMethod
LoanCndnDayFracRndngCategory LoanCndnDayFracRndngCategory
LoanCndnDayFracRndngDecimals LoanCndnDayFracRndngDecimals
SEPAMandate SEPAMandate SEPA Mandate
LoanBusinessOperationID LoanBusinessOperationID
LnCnCalcPerdStrtDtExclvIndCode LnCnCalcPerdStrtDtExclvIndCode
LnCnCalcPerdStrtDtIsMnthEnd LnCnCalcPerdStrtDtIsMnthEnd
LoanCndnCaptlznMinimumAmount LoanCndnCaptlznMinimumAmount
LoanCndnCaptlznMaximumAmount LoanCndnCaptlznMaximumAmount
LoanCndnAutoDebitCalcMethod LoanCndnAutoDebitCalcMethod
LoanConditionAutoDebitAmount LoanConditionAutoDebitAmount
LoanCndnAccmlnActiveIndCode LoanCndnAccmlnActiveIndCode
_LoanContrCndnHdrData _LoanContrCndnHdrData

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 A_LoanConditionItem.
-- 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 A_LoanConditionItem AS
SELECT
  CompanyCode,
  LoanProductCategory,
  LoanContractID,
  LoanCndnItemTechSupplement1,
  LoanCndnItemTechSupplement2,
  LoanCndnHdrValdtyStrtDte,
  LoanConditionHeaderOfferNumber,
  LoanConditionType,
  LoanConditionValidityStartDate,
  LoanConditionLevelNumber,
  LoanLifeCycleStatus,
  LoanConditionRateInPercent,
  LoanConditionAmount,
  LoanConditionCurrency,
  LoanCndnCalcBaseReference,
  ReferenceInterestRate,
  InterestRefRateOptrSign,
  LoanCndnFluctuationMarginRate,
  LoanCndnPaytFrequencyInMonths,
  LoanCndnPaymentFrequencyInDays,
  LoanConditionPaymentForm,
  LoanCndnDividendCouponNumber,
  LoanConditionForm,
  LoanCndnAmountMonthlyIndCode,
  LoanConditionCalculationDate,
  LoanConditionDueDate,
  Customer,
  BPPaymentMethod,
  BankDetailsID,
  DunningArea,
  BusinessPartner,
  LoanConditionQuotaNumber,
  LoanCndnCalcDateIsMonthEnd,
  LoanConditionDueDateIsMonthEnd,
  LoanCndnCalcDteNmbrOfWrkgDay,
  LoanCndnDueDteNmbrOfWorkingDay,
  LoanConditionFactoryCalendar,
  InterestCalculationMethod,
  LoanCndnRpaytSettlementType,
  LoanConditionGeneralDate,
  LoanCndnIncgPaytGenerationType,
  LoanConditionPostingControlKey,
  LoanAlternativeConditionType,
  LoanCndnIntrstRateAdjmtCndnGrp,
  LoanCndnCalcDateInclusiveCode,
  LoanConditionFormulaReference,
  LoanConditionFormulaVariable,
  LoanCndnCalcDteWorkingDayShift,
  LoanCndnCalcDateUpdateMethod,
  LoanCndnDueDateWorkingDayShift,
  LoanCndnDueDateUpdateMethod,
  LoanCndnPctgRateFixingDate,
  LnCnIntrstFxngDteNmbrOfWrkgDay,
  LoanConditionFactoryCalendar2,
  LoanConditionFactoryCalendar3,
  LoanConditionFactoryCalendar4,
  LoanConditionFactoryCalendar5,
  LoanCndnCalculationBaseAmount,
  LoanCndnDueDateInclusiveCode,
  LoanCndnPrepaymentRoundingType,
  LoanCndnPaytFmWthAdjmtDays,
  LoanConditionUpdateMethod,
  LoanCndnPaytDateWrkgDayShift,
  LoanCndnGrcePerdIntrstIsApplbl,
  LoanCndnPctgCalculationType,
  LoanCndnProRtTmpCalcType,
  LoanCndnCalctUsingDueDateCode,
  LoanConditionDueDateShift,
  LoanCndnCalcBaseFixingType,
  DunningBlockingReason,
  PaymentBlockingReason,
  LoanCndnCalcDateShiftDirection,
  LoanCndnDueDateShiftDirection,
  Creditor,
  LoanCndnCompndIntrstCalcType,
  LoanCndnAmountRoundingCategory,
  LoanCndnValueAddedTaxAmount,
  LoanConditionAmountIsGross,
  LoanConditionPaymentRate,
  LoanConditionRate2InPercent,
  LoanCndnFactorRoundingCategory,
  LoanCndnFactorRoundingDecimals,
  LoanCndnExptlIntrstCalcType,
  LoanCndnBaseFctrRndngCategory,
  LoanCndnBaseFctrRndngDecimals,
  LoanCndnRateFctrRndngCategory,
  LoanCndnRateFctrRndngDecimals,
  LoanCndnPaytDteNmbrOfWrkgDay,
  LoanCndnPaytAmtCalcMethod,
  LoanCndnDayFracRndngCategory,
  LoanCndnDayFracRndngDecimals,
  SEPAMandate,
  LoanBusinessOperationID,
  LnCnCalcPerdStrtDtExclvIndCode,
  LnCnCalcPerdStrtDtIsMnthEnd,
  LoanCndnCaptlznMinimumAmount,
  LoanCndnCaptlznMaximumAmount,
  LoanCndnAutoDebitCalcMethod,
  LoanConditionAutoDebitAmount,
  LoanCndnAccmlnActiveIndCode
FROM R_LoanConditionItemTP
;

Learn More