I_CADocumentBPItemLogicalEnhcd

DDL: I_CADOCUMENTBPITEMLOGICALENHCD Type: view_entity COMPOSITE

Enhanced Document Logical BP Item

I_CADocumentBPItemLogicalEnhcd is a Composite CDS View that provides data about "Enhanced Document Logical BP Item" in SAP S/4HANA. It reads from 1 data source (I_CADocumentBPItemLogical) and exposes 189 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. It has 1 association to related views.

1 data source(s) 189 fields

Data Sources (1)

SourceAliasJoin Type
I_CADocumentBPItemLogical I_CADocumentBPItemLogical from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_AdditionalCurrencyRoles _AddlCrcyRoles $projection.CompanyCode = _AddlCrcyRoles.CompanyCode and _AddlCrcyRoles.Ledger = '' and _AddlCrcyRoles.LedgerGroup = ''

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Enhanced Document Logical BP Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (189)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber
KEY CARepetitionItemNumber CARepetitionItemNumber
KEY CABPItemNumber CABPItemNumber
KEY CASubItemNumber CASubItemNumber
CompanyCode CompanyCode
BusinessArea BusinessArea
BusinessPlace BusinessPlace
Segment Segment
ProfitCenter ProfitCenter
Division Division
PersonnelNumber PersonnelNumber
PartnerCompany PartnerCompany
BusinessPartner BusinessPartner
CAContract CAContract
CAProviderContractItemNumber CAProviderContractItemNumber
CAAdditionalContract CAAdditionalContract
ContractAccount ContractAccount
CASubApplication CASubApplication
AltvContractAcctForCollvBills AltvContractAcctForCollvBills
CAReconciliationAccount CAReconciliationAccount
CAApplicationArea CAApplicationArea
CAMainTransaction CAMainTransaction
CASubTransaction CASubTransaction
CAAccountDeterminationCode CAAccountDeterminationCode
CADoubtfulOrValueAdjmtCode CADoubtfulOrValueAdjmtCode
CAAccountAssignmentCategory CAAccountAssignmentCategory
CAAccountAssignment CAAccountAssignment
CADocumentType CADocumentType
CAIsDownPaymentRequest CAIsDownPaymentRequest
CAItemIsOnlyForSettlement CAItemIsOnlyForSettlement
CABPItemText CABPItemText
CANumberOfRepetitionItems CANumberOfRepetitionItems
CARepetitionGroup CARepetitionGroup
CAEndDateOfBillingPeriod CAEndDateOfBillingPeriod
CAGroupingCodeForBPItems CAGroupingCodeForBPItems
CAPeriodCode CAPeriodCode
CAChangeIsForbidden CAChangeIsForbidden
CAInterestCode CAInterestCode
CARoundingItemCode CARoundingItemCode
CAReceivingCountry CAReceivingCountry
CAInternalPostingReasonCode CAInternalPostingReasonCode
CAWorkflowCheckReason CAWorkflowCheckReason
CAWorkflowCheckProcess CAWorkflowCheckProcess
CANegativePostingControlCode CANegativePostingControlCode
CAPartnerSettlementStatus CAPartnerSettlementStatus
CAIsPartOfJointLiability CAIsPartOfJointLiability
CADocumentOriginCode CADocumentOriginCode
CASubstituteDocumentNumber CASubstituteDocumentNumber
CASubstituteDocumentCategory CASubstituteDocumentCategory
CADocumentNumberOfOriginItem CADocumentNumberOfOriginItem
CAReferenceDocument CAReferenceDocument
DocumentDate DocumentDate
CAPostingDate CAPostingDate
CANetDueDate CANetDueDate
CADeferralDate CADeferralDate
TransactionCurrency TransactionCurrency
CompanyCodeCurrency CompanyCodeCurrency
AdditionalCurrency1
AdditionalCurrency2
CAExchangeRate CAExchangeRate
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation
CAAmountInLocalCurrency CAAmountInLocalCurrency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency
CAAmountInSecondCurrency CAAmountInSecondCurrency
CAAmountInThirdCurrency CAAmountInThirdCurrency
CADocBPItemTotalAmountInTC CADocBPItemTotalAmountInTC
CACashDiscountDueDate CACashDiscountDueDate
CACashDiscountRate CACashDiscountRate
CAEligibleAmountForCshDiscount CAEligibleAmountForCshDiscount
CACashDiscAmountInClearingCrcy CACashDiscAmountInClearingCrcy
TaxCode TaxCode
CASupplementaryTaxCode CASupplementaryTaxCode
CATaxAmountInLocalCurrency CATaxAmountInLocalCurrency
CATaxAmountInTransCurrency CATaxAmountInTransCurrency
CATaxAmountInSecondCurrency CATaxAmountInSecondCurrency
CATaxAmountInThirdCurrency CATaxAmountInThirdCurrency
CADownPaymentTaxAccount CADownPaymentTaxAccount
CADownPaymentOffsetTaxAccount CADownPaymentOffsetTaxAccount
TaxJurisdiction TaxJurisdiction
CATaxDate CATaxDate
WithholdingTaxCode WithholdingTaxCode
CAWithholdingTaxSupplement CAWithholdingTaxSupplement
CAWithholdingTaxCategory CAWithholdingTaxCategory
CABaseAmountForWithholdingTax CABaseAmountForWithholdingTax
CAWithholdingTaxAmount CAWithholdingTaxAmount
CAWithholdingTaxPercentage CAWithholdingTaxPercentage
WithholdingTaxCertificate WithholdingTaxCertificate
CAOtherTaxCode CAOtherTaxCode
CAGroupingCodeForTaxItems CAGroupingCodeForTaxItems
CATaxPortionInLocalCurrency CATaxPortionInLocalCurrency
CATaxPortionInTransCurrency CATaxPortionInTransCurrency
CATaxIsCalculatedExternally CATaxIsCalculatedExternally
CAPaymentMethod CAPaymentMethod
CAPaymentCompanyCode CAPaymentCompanyCode
CAGroupingForPayment CAGroupingForPayment
CAPaymentSpecificationCategory CAPaymentSpecificationCategory
CAClearingStatus CAClearingStatus
CAClearingDate CAClearingDate
CAClearingDocumentNumber CAClearingDocumentNumber
CAPostingDateOfClearingDoc CAPostingDateOfClearingDoc
CAClearingReason CAClearingReason
CAClearingCurrency CAClearingCurrency
CAClearingAmountInClearingCrcy CAClearingAmountInClearingCrcy
CATaxAmountInClearingCrcy CATaxAmountInClearingCrcy
CAValueDateForClearing CAValueDateForClearing
CAClearingRestrictionCode CAClearingRestrictionCode
CAClearingPostingIsReset CAClearingPostingIsReset
CAItemIsWithdrawn CAItemIsWithdrawn
CAItemIsExcludedFromDunning CAItemIsExcludedFromDunning
CADunningProcedure CADunningProcedure
CAGrpgCodeForTransfToCollAgcy CAGrpgCodeForTransfToCollAgcy
CAIsIncludedInCollectionCase CAIsIncludedInCollectionCase
CashPlanningGroup CashPlanningGroup
PlanningLevel PlanningLevel
CAAdditionalDaysForCashMgmt CAAdditionalDaysForCashMgmt
PlannedAmtInTransactionCrcy PlannedAmtInTransactionCrcy
CAAltvBPForPayment CAAltvBPForPayment
CABankOfAltvBPForPayment CABankOfAltvBPForPayment
CAAddressOfAltvBPForPayment CAAddressOfAltvBPForPayment
CACardOfAltvBPForPayment CACardOfAltvBPForPayment
CAGLPostingCurrency CAGLPostingCurrency
CAGLPostingAmount CAGLPostingAmount
CAGLPostingTaxAmount CAGLPostingTaxAmount
CAIsSeparateLineItemInGL CAIsSeparateLineItemInGL
CAIsCashFlowItem CAIsCashFlowItem
CACashFlowAccount CACashFlowAccount
CACashFlowCompanyCode CACashFlowCompanyCode
CAPaymentPreNotificationCode CAPaymentPreNotificationCode
CASEPAPreNotificationNumber CASEPAPreNotificationNumber
CASEPAPreNotifOriginCode CASEPAPreNotifOriginCode
CASEPAPreNotifExecutionDate CASEPAPreNotifExecutionDate
CASEPAPreNotificationRqmtCode CASEPAPreNotificationRqmtCode
CARevenueDistrFinalRecipient CARevenueDistrFinalRecipient
CARevenueDistrCurrentStatus CARevenueDistrCurrentStatus
CARevenueDistrLastStatus CARevenueDistrLastStatus
CACurrentFactoringStatusOfRbl CACurrentFactoringStatusOfRbl
CAFactoringCheckStsForClrgInfo CAFactoringCheckStsForClrgInfo
ControllingArea ControllingArea
ChartOfAccounts ChartOfAccounts
Country Country
TaxCalculationProcedure TaxCalculationProcedure
SEPAMandateCAInternalID SEPAMandateCAInternalID
_CompCode _CompCode
_CompCodePayt _CompCodePayt
_DocHeader _DocHeader
_SubstitDocHeader _SubstitDocHeader
_ClearingDocHeader _ClearingDocHeader
_OriginDocHeader _OriginDocHeader
_BusinessArea _BusinessArea
_Segment _Segment
_ProfitCenter _ProfitCenter
_ReconAccount _ReconAccount
_TaxAccount _TaxAccount
_OffsetTaxAccount _OffsetTaxAccount
_Division _Division
_BusinessPartner _BusinessPartner
_AltvBPForPayment _AltvBPForPayment
_CAPartner _CAPartner
_CAHeader _CAHeader
_CAHeaderCollvBills _CAHeaderCollvBills
_CAHeaderFinalRec _CAHeaderFinalRec
_ProviderContract _ProviderContract
_DocType _DocType
_MainTransaction _MainTransaction
_SubTransaction _SubTransaction
_CompCodeCashFlow _CompCodeCashFlow
_CashFlowAccount _CashFlowAccount
_Currency _Currency
_ClearingCurrency _ClearingCurrency
_GLPostingCurrency _GLPostingCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_PaytMethod _PaytMethod
_InterestCode _InterestCode
_DunningProcedure _DunningProcedure
_PartnerCompany _PartnerCompany
_Country _Country
_ReceivingCountry _ReceivingCountry
_WithholdingTaxCode _WithholdingTaxCode
_WorkflowCheckReason _WorkflowCheckReason
_WorkflowCheckProcess _WorkflowCheckProcess
_PeriodCode _PeriodCode
_ClearingReason _ClearingReason
_AcctAssgmtCat _AcctAssgmtCat
_WhldgTaxSuplmnt _WhldgTaxSuplmnt
_OtherTaxCode _OtherTaxCode
_ControllingArea _ControllingArea
_ClrgRstrcnCode _ClrgRstrcnCode
_AdditionalCurrency1
_AdditionalCurrency2 
@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData: { blocking: #REQUIRED,
                                  blockingIndicator: ['_BusinessPartner.IsBusinessPurposeCompleted'] } }

@EndUserText.label: 'Enhanced Document Logical BP Item'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { modelingPattern: #NONE,
                //representativeKey: 'CABPItemNumber',

                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                         #SQL_DATA_SOURCE,
                                         #CDS_MODELING_DATA_SOURCE ],
                usageType: { serviceQuality: #C,
                             sizeCategory: #XXL,
                             dataClass: #TRANSACTIONAL } }

@VDM.viewType: #COMPOSITE

define view entity I_CADocumentBPItemLogicalEnhcd 
  as select from I_CADocumentBPItemLogical 

  association [1..1] to I_AdditionalCurrencyRoles as _AddlCrcyRoles on  $projection.CompanyCode    = _AddlCrcyRoles.CompanyCode
                                                                    and _AddlCrcyRoles.Ledger      = ''
                                                                    and _AddlCrcyRoles.LedgerGroup = ''


{
  key CADocumentNumber,
  key CARepetitionItemNumber,
  key CABPItemNumber,
  key CASubItemNumber,
      concat(CADocumentNumber, concat(CARepetitionItemNumber,
        concat (CABPItemNumber, CASubItemNumber))) as CAConcatenatedDocumentNumber,
      CompanyCode,
      BusinessArea,
      BusinessPlace,
      Segment,
      ProfitCenter,
      Division,
      PersonnelNumber,
      PartnerCompany,
      BusinessPartner,
      CAContract,
      CAProviderContractItemNumber,
      CAAdditionalContract,
      ContractAccount,
      CASubApplication,
      AltvContractAcctForCollvBills,
      CAReconciliationAccount,
      CAApplicationArea,
      CAMainTransaction,
      CASubTransaction,
      CAAccountDeterminationCode,
      CADoubtfulOrValueAdjmtCode,
      CAAccountAssignmentCategory,
      CAAccountAssignment,
      CADocumentType,
      CAIsDownPaymentRequest,
      @Semantics.booleanIndicator: true
      CAItemIsOnlyForSettlement,
      CAStatisticalItemCode,
      CABPItemText,
      CANumberOfRepetitionItems,
      CARepetitionGroup,
      CAStartDateOfBillingPeriod,
      CAEndDateOfBillingPeriod,
      CAGroupingCodeForBPItems,
      CAPeriodCode,
      CAChangeIsForbidden,
      CAInterestCode,
      CARoundingItemCode,
      CAReceivingCountry,
      CAInternalPostingReasonCode,
      CAWorkflowCheckReason,
      CAWorkflowCheckProcess,
      CANegativePostingControlCode,
      CAPartnerSettlementStatus,
      @Semantics.booleanIndicator: true
      CAIsPartOfJointLiability,
      CADocumentOriginCode,
      CASubstituteDocumentNumber,
      CASubstituteDocumentCategory,
      CAStatisticalCodeOfOriginItem,
      CADocumentNumberOfOriginItem,
      CAReferenceDocument,
      DocumentDate,
      CAPostingDate,
      CANetDueDate,
      CADeferralDate,
      TransactionCurrency,
      CompanyCodeCurrency,
      @ObjectModel.foreignKey.association: '_AdditionalCurrency1'
      cast(_AddlCrcyRoles._AdditionalCrcyRole1Currency.Currency as fis_hwae2 preserving type) as AdditionalCurrency1,
      @ObjectModel.foreignKey.association: '_AdditionalCurrency2'
      cast(_AddlCrcyRoles._AdditionalCrcyRole2Currency.Currency as fis_hwae3 preserving type) as AdditionalCurrency2,
      CAExchangeRate,
      ExchRateIsIndirectQuotation,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CAAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAAmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      CAAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      CAAmountInThirdCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CADocBPItemTotalAmountInTC,
      CACashDiscountDueDate,
      CACashDiscountRate,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAEligibleAmountForCshDiscount,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CACashDiscAmountInClearingCrcy,
      TaxCode,
      CASupplementaryTaxCode,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CATaxAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxAmountInTransCurrency,
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      CATaxAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      CATaxAmountInThirdCurrency,
      CADownPaymentTaxAccount,
      CADownPaymentOffsetTaxAccount,
      TaxJurisdiction,
      CATaxDate,
      WithholdingTaxCode,
      CAWithholdingTaxSupplement,
      CAWithholdingTaxCategory,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CABaseAmountForWithholdingTax,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAWithholdingTaxAmount,
      CAWithholdingTaxPercentage,
      WithholdingTaxCertificate,
      CAOtherTaxCode,
      CAGroupingCodeForTaxItems,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CATaxPortionInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxPortionInTransCurrency,
      CATaxIsCalculatedExternally,
      CAPaymentMethod,
      CAPaymentCompanyCode,
      CAGroupingForPayment,
      CAPaymentSpecificationCategory,
      CAClearingStatus,
      CAClearingDate,
      CAClearingDocumentNumber,
      CAPostingDateOfClearingDoc,
      CAClearingReason,
      CAClearingCurrency,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CAClearingAmountInClearingCrcy,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CATaxAmountInClearingCrcy,
      CAValueDateForClearing,
      CAClearingRestrictionCode,
      CAClearingPostingIsReset,
      CAItemIsWithdrawn,
      CAItemIsExcludedFromDunning,
      CADunningProcedure,
      CAGrpgCodeForTransfToCollAgcy,
      CAIsIncludedInCollectionCase,
      CashPlanningGroup,
      PlanningLevel,
      CAAdditionalDaysForCashMgmt,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      PlannedAmtInTransactionCrcy,
      CAAltvBPForPayment,
      CABankOfAltvBPForPayment,
      CAAddressOfAltvBPForPayment,
      CACardOfAltvBPForPayment,
      CAGLPostingCurrency,
      @Semantics.amount.currencyCode: 'CAGLPostingCurrency'
      CAGLPostingAmount,
      @Semantics.amount.currencyCode: 'CAGLPostingCurrency'
      CAGLPostingTaxAmount,
      CAIsSeparateLineItemInGL,
      CAIsCashFlowItem,
      CACashFlowAccount,
      CACashFlowCompanyCode,
      CAPaymentPreNotificationCode,
      CASEPAPreNotificationNumber,
      CASEPAPreNotifOriginCode,
      CASEPAPreNotifExecutionDate,
      CASEPAPreNotificationRqmtCode,
      CARevenueDistrFinalRecipient,
      CARevenueDistrCurrentStatus,
      CARevenueDistrLastStatus,
      CACurrentFactoringStatusOfRbl,
      CAFactoringCheckStsForClrgInfo,
      ControllingArea,
      ChartOfAccounts,
      Country,
      TaxCalculationProcedure,
      SEPAMandateCAInternalID,

      /* assciations */
      // associations from I_CADocumentBPItemLogical

      _CompCode,
      _CompCodePayt,
      _DocHeader,
      _SubstitDocHeader,
      _ClearingDocHeader,
      _OriginDocHeader,
      _BusinessArea,
      _Segment,
      _ProfitCenter,
      _ReconAccount,
      _TaxAccount,
      _OffsetTaxAccount,
      _Division,
      _BusinessPartner,
      _AltvBPForPayment,
      _CAPartner,
      _CAHeader,
      _CAHeaderCollvBills,
      _CAHeaderFinalRec,
      _ProviderContract,
      _DocType,
      _MainTransaction,
      _SubTransaction,
      _CompCodeCashFlow,
      _CashFlowAccount,
      _Currency,
      _ClearingCurrency,
      _GLPostingCurrency,
      _CompanyCodeCurrency,
      _PaytMethod,
      _InterestCode,
      _DunningProcedure,
      _PartnerCompany,
      _Country,
      _ReceivingCountry,
      _WithholdingTaxCode,
      _WorkflowCheckReason,
      _WorkflowCheckProcess,
      _PeriodCode,
      _ClearingReason,
      _AcctAssgmtCat,
      _WhldgTaxSuplmnt,
      _OtherTaxCode,
      _ControllingArea,
      _ClrgRstrcnCode,
      // associations from I_AdditionalCurrencyRoles

      _AddlCrcyRoles._AdditionalCrcyRole1Currency._Currency as _AdditionalCurrency1,
      _AddlCrcyRoles._AdditionalCrcyRole2Currency._Currency as _AdditionalCurrency2
 
}

Learn More