Which tables does I_CADocumentBPItemTP use?

I_CADocumentBPItemTP reads from 1 data source(s): R_CADocumentBPItemTP.

I_CADocumentBPItemTP

Q: How many fields does I_CADocumentBPItemTP have?

I_CADocumentBPItemTP has 140 fields. Key fields: CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber.

DDL: I_CADOCUMENTBPITEMTP Type: view_entity TRANSACTIONAL

Document Business Partner Item - TP

I_CADocumentBPItemTP is a Transactional CDS View that provides data about "Document Business Partner Item - TP" in SAP S/4HANA. It reads from 1 data source (R_CADocumentBPItemTP) and exposes 140 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber.

Data Sources (1)

Source	Alias	Join Type
R_CADocumentBPItemTP	R_CADocumentBPItemTP	projection

Annotations (9)

Name	Value	Level
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.modelingPattern	#TRANSACTIONAL_INTERFACE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#C	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Document Business Partner Item - TP	view

Fields (140)

Key	Field	Source Field
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	AdditionalCurrency1
	AdditionalCurrency2	AdditionalCurrency2
	CAExchangeRate	CAExchangeRate
	ExchRateIsIndirectQuotation	ExchRateIsIndirectQuotation
	CAAmountInLocalCurrency	CAAmountInLocalCurrency
	CAAmountInTransactionCurrency	CAAmountInTransactionCurrency
	CAAmountInSecondCurrency	CAAmountInSecondCurrency
	CAAmountInThirdCurrency	CAAmountInThirdCurrency
	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
	SEPAMandateCAInternalID	SEPAMandateCAInternalID
	_BusinessPartner	_BusinessPartner
	_CAPartner	_CAPartner
	_ProviderContract	_ProviderContract

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]

@ObjectModel.modelingPattern: #TRANSACTIONAL_INTERFACE
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C

@Metadata.ignorePropagatedAnnotations: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Document Business Partner Item - TP'

define view entity I_CADocumentBPItemTP
  as projection on R_CADocumentBPItemTP

  //  association [1..1] to I_BusinessPartner          as _BusinessPartner  on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  //  association [1..1] to I_ContractAccountPartner   as _CAPartner        on  $projection.BusinessPartner = _CAPartner.BusinessPartner

  //                                                                        and $projection.ContractAccount = _CAPartner.ContractAccount

  //  association [0..1] to I_CAProviderContractHeader as _ProviderContract on  $projection.CASubApplication = 'P'

  //                                                                        and $projection.CAContract       = _ProviderContract.CAProviderContract


{
      //I_CADocumentBPItemLogical

  key CADocumentNumber,
  key CARepetitionItemNumber,
  key CABPItemNumber,
  key CASubItemNumber,
      CompanyCode,
      BusinessArea,
      BusinessPlace,
      Segment,
      ProfitCenter,
      Division,
      PersonnelNumber,
      PartnerCompany,
      BusinessPartner,
      CAContract,
      CAProviderContractItemNumber,
      CAAdditionalContract,
      ContractAccount,
      CASubApplication,
      AltvContractAcctForCollvBills,
      CAReconciliationAccount,
      CAApplicationArea,
      CAMainTransaction,
      CASubTransaction,
      CAAccountDeterminationCode,
      CADoubtfulOrValueAdjmtCode,
      CAAccountAssignmentCategory,
      CAAccountAssignment,
      CADocumentType,
      @Semantics.booleanIndicator
      CAIsDownPaymentRequest,
      @Semantics.booleanIndicator
      CAItemIsOnlyForSettlement,
      CAStatisticalItemCode,
      CABPItemText,
      CANumberOfRepetitionItems,
      CARepetitionGroup,
      CAStartDateOfBillingPeriod,
      CAEndDateOfBillingPeriod,
      CAGroupingCodeForBPItems,
      CAPeriodCode,
      @Semantics.booleanIndicator
      CAChangeIsForbidden,
      CAInterestCode,
      CARoundingItemCode,
      CAReceivingCountry,
      CAInternalPostingReasonCode,
      CAWorkflowCheckReason,
      CAWorkflowCheckProcess,
      CANegativePostingControlCode,
      CAPartnerSettlementStatus,
      @Semantics.booleanIndicator
      CAIsPartOfJointLiability,
      CADocumentOriginCode,
      CASubstituteDocumentNumber,
      CASubstituteDocumentCategory,
      CAStatisticalCodeOfOriginItem,
      CADocumentNumberOfOriginItem,
      CAReferenceDocument,
      DocumentDate,
      CAPostingDate,
      CANetDueDate,
      CADeferralDate,
      TransactionCurrency,
      CompanyCodeCurrency,
      AdditionalCurrency1,
      AdditionalCurrency2,
      CAExchangeRate,
      @Semantics.booleanIndicator
      ExchRateIsIndirectQuotation,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CAAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAAmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      CAAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      CAAmountInThirdCurrency,
      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,
      @Semantics.booleanIndicator
      CATaxIsCalculatedExternally,
      CAPaymentMethod,
      CAPaymentCompanyCode,
      CAGroupingForPayment,
      CAPaymentSpecificationCategory,
      CAClearingStatus,
      CAClearingDate,
      CAClearingDocumentNumber,
      CAPostingDateOfClearingDoc,
      CAClearingReason,
      CAClearingCurrency,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CAClearingAmountInClearingCrcy,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CATaxAmountInClearingCrcy,
      CAValueDateForClearing,
      CAClearingRestrictionCode,
      @Semantics.booleanIndicator
      CAClearingPostingIsReset,
      @Semantics.booleanIndicator
      CAItemIsWithdrawn,
      @Semantics.booleanIndicator
      CAItemIsExcludedFromDunning,
      CADunningProcedure,
      CAGrpgCodeForTransfToCollAgcy,
      @Semantics.booleanIndicator
      CAIsIncludedInCollectionCase,
      CashPlanningGroup,
      PlanningLevel,
      CAAdditionalDaysForCashMgmt,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      PlannedAmtInTransactionCrcy,
      CAAltvBPForPayment,
      CABankOfAltvBPForPayment,
      CAAddressOfAltvBPForPayment,
      CACardOfAltvBPForPayment,
      CAGLPostingCurrency,
      @Semantics.amount.currencyCode: 'CAGLPostingCurrency'
      CAGLPostingAmount,
      @Semantics.amount.currencyCode: 'CAGLPostingCurrency'
      CAGLPostingTaxAmount,
      @Semantics.booleanIndicator
      CAIsSeparateLineItemInGL,
      @Semantics.booleanIndicator
      CAIsCashFlowItem,
      CACashFlowAccount,
      CACashFlowCompanyCode,
      CAPaymentPreNotificationCode,
      CASEPAPreNotificationNumber,
      CASEPAPreNotifOriginCode,
      CASEPAPreNotifExecutionDate,
      CASEPAPreNotificationRqmtCode,
      CARevenueDistrFinalRecipient,
      CARevenueDistrCurrentStatus,
      CARevenueDistrLastStatus,
      CACurrentFactoringStatusOfRbl,
      CAFactoringCheckStsForClrgInfo,
      SEPAMandateCAInternalID,

      /* Associations */
      _DocHeader     : redirected to parent I_CADocumentTP,
      _BPItemBusLock : redirected to composition child I_CADocumentBPItemBusLockTP,
      _BusinessPartner,
      _CAPartner,
      _ProviderContract
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CADOCUMENTBPITEMTP"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CADOCUMENTBPITEMBUSLOCKTP",
"I_CADOCUMENTTP",
"I_CAPROVIDERCONTRACTHEADER",
"I_CONTRACTACCOUNTPARTNER",
"R_CADOCUMENTBPITEMBUSLOCKTP",
"R_CADOCUMENTTP"
],
"BASE":
[
"R_CADOCUMENTBPITEMTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_CADocumentBPItemTP view_entity

R_CADocumentBPItemTP view_entity