R_CADocumentBPItemTP_2

DDL: R_CADOCUMENTBPITEMTP_2 Type: view_entity TRANSACTIONAL Package: RAP_FICA_CADOC

Document Business Partner Item - TP

R_CADocumentBPItemTP_2 is a Transactional CDS View that provides data about "Document Business Partner Item - TP" in SAP S/4HANA. It reads from 1 data source (I_CADocumentBPItemEnhanced) and exposes 229 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. It has 2 associations to related views. Part of development package RAP_FICA_CADOC.

Data Sources (1)

SourceAliasJoin Type
I_CADocumentBPItemEnhanced I_CADocumentBPItemEnhanced from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_CADocumentBPItemPhysical _Extension $projection.CADocumentNumber = _Extension.CADocumentNumber and $projection.CARepetitionItemNumber = _Extension.CARepetitionItemNumber and $projection.CABPItemNumber = _Extension.CABPItemNumber and $projection.CASubItemNumber = _Extension.CASubItemNumber
[0..*] R_CADocumentBPItemBuslockTP_2 _CADocumentBPItemBusLock

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Document Business Partner Item - TP view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name ContrAcctgDocumentBusPartItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (229)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber
KEY CARepetitionItemNumber CARepetitionItemNumber
KEY CABPItemNumber CABPItemNumber
KEY CASubItemNumber CASubItemNumber
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
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
CAGroupingKeyDocumentItems CAGroupingKeyDocumentItems
CASubstituteDocumentNumber CASubstituteDocumentNumber
CASubstituteDocumentCategory CASubstituteDocumentCategory
CADocumentNumberOfOriginItem CADocumentNumberOfOriginItem
CAReferenceDocument CAReferenceDocument
CAClassificationKey CAClassificationKey
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
CADocBPItemTotalAmountInTC CADocBPItemTotalAmountInTC
CADocBPItemOriglOpenAmountInTC CADocBPItemOriglOpenAmountInTC
CAClearingDeductionAmountInTC CAClearingDeductionAmountInTC
CACashDiscountDueDate CACashDiscountDueDate
CACashDiscountRate CACashDiscountRate
CAEligibleAmountForCshDiscount CAEligibleAmountForCshDiscount
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
CATaxAmountIsSetFromExternal CATaxAmountIsSetFromExternal
TaxCountry TaxCountry
TransToTaxCntryCrcyCnvrsnFctr TransToTaxCntryCrcyCnvrsnFctr
CAPaymentMethod CAPaymentMethod
CAPaymentCompanyCode CAPaymentCompanyCode
CAGroupingForPayment CAGroupingForPayment
CAPaymentSpecificationCategory CAPaymentSpecificationCategory
CAClearingStatus CAClearingStatus
CAClearingDate CAClearingDate
CAClearingDocumentNumber CAClearingDocumentNumber
CAPostingDateOfClearingDoc CAPostingDateOfClearingDoc
CAClearingReason CAClearingReason
CAClearingCurrency CAClearingCurrency
CAClearingAmountInClearingCrcy CAClearingAmountInClearingCrcy
CATaxAmountInClearingCrcy CATaxAmountInClearingCrcy
CACashDiscAmountInClearingCrcy CACashDiscAmountInClearingCrcy
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
SEPAMandateCAInternalID SEPAMandateCAInternalID
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
CAFactoringItem CAFactoringItem
ControllingArea ControllingArea
ChartOfAccounts ChartOfAccounts
Country Country
TaxCalculationProcedure TaxCalculationProcedure
_CADocument _CADocument
_CADocumentBPItemBusLock _CADocumentBPItemBusLock
_AdditionalCurrency1 _AdditionalCurrency1
_AdditionalCurrency2 _AdditionalCurrency2
_BusinessArea _BusinessArea
_BusinessPartner _BusinessPartner
_CAAccountAssignmentCategory _CAAccountAssignmentCategory
_CAAccountDeterminationCode _CAAccountDeterminationCode
_CAApplicationArea _CAApplicationArea
_CAClearingDocument _CAClearingDocument
_CAClearingReason _CAClearingReason
_CAClearingRestrictionCode _CAClearingRestrictionCode
_CAClearingStatus _CAClearingStatus
_CADbtflOrValueAdjmtCode _CADbtflOrValueAdjmtCode
_CADocumentType _CADocumentType
_CADunningProcedure _CADunningProcedure
_CAFactoringClrgCheckStatus _CAFactoringClrgCheckStatus
_CAFactoringReceivableStatus _CAFactoringReceivableStatus
_CAInterestCode _CAInterestCode
_CAInternalPostingReasonCode _CAInternalPostingReasonCode
_CAMainTransaction _CAMainTransaction
_CANegativePostingControlCode _CANegativePostingControlCode
_CAOriginDocument _CAOriginDocument
_CAOriglStatisticalItemCode _CAOriglStatisticalItemCode
_CAOtherTaxCode _CAOtherTaxCode
_CAPartnerSettlementStatus _CAPartnerSettlementStatus
_CAPaymentMethod _CAPaymentMethod
_CAPaytPreNotificationCode _CAPaytPreNotificationCode
_CAPaytSpecificationCategory _CAPaytSpecificationCategory
_CAPeriodCode _CAPeriodCode
_CAProviderContract _CAProviderContract
_CARevenueDistrCurrentStatus _CARevenueDistrCurrentStatus
_CARevenueDistrLastStatus _CARevenueDistrLastStatus
_CARoundingItemCode _CARoundingItemCode
_CASEPAPreNotificationRqmtCode _CASEPAPreNotificationRqmtCode
_CASEPAPreNotifOriginCode _CASEPAPreNotifOriginCode
_CashFlowAccount _CashFlowAccount
_CashFlowCompanyCode _CashFlowCompanyCode
_CashPlanningGroup _CashPlanningGroup
_CASubApplication _CASubApplication
_CASubstituteDocumentCategory _CASubstituteDocumentCategory
_CASubstituteDocument _CASubstituteDocument
_CASubTransaction _CASubTransaction
_CAWithholdingTaxCategory _CAWithholdingTaxCategory
_CAWithholdingTaxSupplement _CAWithholdingTaxSupplement
_CAWorkflowCheckProcess _CAWorkflowCheckProcess
_CAWorkflowCheckReason _CAWorkflowCheckReason
_ClearingCurrency _ClearingCurrency
_CollvBillsAltvContractAccount _CollvBillsAltvContractAccount
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_ContractAccount _ContractAccount
_ContractAccountPartner _ContractAccountPartner
_ControllingArea _ControllingArea
_ChartOfAccounts _ChartOfAccounts
_Country _Country
_Division _Division
_DownPaymentOffsetTaxAccount _DownPaymentOffsetTaxAccount
_DownPaymentTaxAccount _DownPaymentTaxAccount
_GLPostingCurrency _GLPostingCurrency
_PartnerCompany _PartnerCompany
_PaytAltvBusinessPartner _PaytAltvBusinessPartner
_PlanningLevel _PlanningLevel
_PaymentCompanyCode _PaymentCompanyCode
_ProfitCenter _ProfitCenter
_ReceivingCountry _ReceivingCountry
_ReconciliationAccount _ReconciliationAccount
_RevnDistrFnlRcpntContrAccount _RevnDistrFnlRcpntContrAccount
_Segment _Segment
_TaxCalculationProcedure _TaxCalculationProcedure
_TaxCode _TaxCode
_TaxCountry _TaxCountry
_TaxJurisdiction _TaxJurisdiction
_TransactionCurrency _TransactionCurrency
_WithholdingTaxCode _WithholdingTaxCode
@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData: { blocking: #REQUIRED,
                                  blockingIndicator: ['_BusinessPartner.IsBusinessPurposeCompleted'] } }

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

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

                sapObjectNodeType.name: 'ContrAcctgDocumentBusPartItem',
                usageType: { dataClass: #TRANSACTIONAL,
                             serviceQuality: #C,
                             sizeCategory: #XXL } }

@VDM: { lifecycle.contract.type: #SAP_INTERNAL_API,
        viewType: #TRANSACTIONAL }

define view entity R_CADocumentBPItemTP_2
  as select from I_CADocumentBPItemEnhanced

  association        to parent R_CADocumentTP_2       as _CADocument on  _CADocument.CADocumentNumber = $projection.CADocumentNumber

  composition [0..*] of R_CADocumentBPItemBuslockTP_2 as _CADocumentBPItemBusLock
                                                                  
  // Key User Extensibility. Is registered in transaction SCFD_REGISTRY. Do not change E_CADocumentBPItemPhysical or alias _Extension without adopting CFD regestry entry

  association [1..1] to E_CADocumentBPItemPhysical as _Extension on  $projection.CADocumentNumber       = _Extension.CADocumentNumber
                                                                 and $projection.CARepetitionItemNumber = _Extension.CARepetitionItemNumber
                                                                 and $projection.CABPItemNumber         = _Extension.CABPItemNumber
                                                                 and $projection.CASubItemNumber        = _Extension.CASubItemNumber
{
  key CADocumentNumber,
  key CARepetitionItemNumber,
  key CABPItemNumber,
  key CASubItemNumber,

      CreationDate,
      CreationTime,
      LastChangeDate,
      LastChangeTime,      
      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,
      CAItemIsOnlyForSettlement,
      CAStatisticalItemCode,
      CABPItemText,
      CANumberOfRepetitionItems,
      CARepetitionGroup,
      CAStartDateOfBillingPeriod,
      CAEndDateOfBillingPeriod,
      CAGroupingCodeForBPItems,
      CAPeriodCode,
      CAChangeIsForbidden,
      CAInterestCode,
      CARoundingItemCode,
      CAReceivingCountry,
      CAInternalPostingReasonCode,
      CAWorkflowCheckReason,
      CAWorkflowCheckProcess,
      CANegativePostingControlCode,
      CAPartnerSettlementStatus,
      CAIsPartOfJointLiability,
      CADocumentOriginCode,
      CAGroupingKeyDocumentItems,
      CASubstituteDocumentNumber,
      CASubstituteDocumentCategory,
      CAStatisticalCodeOfOriginItem,
      CADocumentNumberOfOriginItem,
      CAReferenceDocument,
      CAClassificationKey,
      DocumentDate,
      CAPostingDate,
      CANetDueDate,
      CADeferralDate,
      TransactionCurrency,
      CompanyCodeCurrency,
      AdditionalCurrency1,
      AdditionalCurrency2,
      CAExchangeRate,
      ExchRateIsIndirectQuotation,
      CAAmountInLocalCurrency,
      CAAmountInTransactionCurrency,
      CAAmountInSecondCurrency,
      CAAmountInThirdCurrency,
      CADocBPItemTotalAmountInTC,
      CADocBPItemOriglOpenAmountInTC,
      CAClearingDeductionAmountInTC,
      CACashDiscountDueDate,
      CACashDiscountRate,
      CAEligibleAmountForCshDiscount,
      TaxCode,
      CASupplementaryTaxCode,
      CATaxAmountInLocalCurrency,
      CATaxAmountInTransCurrency,
      CATaxAmountInSecondCurrency,
      CATaxAmountInThirdCurrency,
      CADownPaymentTaxAccount,
      CADownPaymentOffsetTaxAccount,
      TaxJurisdiction,
      CATaxDate,
      WithholdingTaxCode,
      CAWithholdingTaxSupplement,
      CAWithholdingTaxCategory,
      CABaseAmountForWithholdingTax,
      CAWithholdingTaxAmount,
      CAWithholdingTaxPercentage,
      WithholdingTaxCertificate,
      CAOtherTaxCode,
      CAGroupingCodeForTaxItems,
      CATaxPortionInLocalCurrency,
      CATaxPortionInTransCurrency,
      CATaxIsCalculatedExternally,
      CATaxAmountIsSetFromExternal,
      TaxCountry,
      TransToTaxCntryCrcyCnvrsnFctr,
      CAPaymentMethod,
      CAPaymentCompanyCode,
      CAGroupingForPayment,
      CAPaymentSpecificationCategory,
      CAClearingStatus,
      CAClearingDate,
      CAClearingDocumentNumber,
      CAPostingDateOfClearingDoc,
      CAClearingReason,
      CAClearingCurrency,
      CAClearingAmountInClearingCrcy,
      CATaxAmountInClearingCrcy,
      CACashDiscAmountInClearingCrcy,
      CAValueDateForClearing,
      CAClearingRestrictionCode,
      CAClearingPostingIsReset,
      CAItemIsWithdrawn,
      CAItemIsExcludedFromDunning,
      CADunningProcedure,
      CAGrpgCodeForTransfToCollAgcy,
      CAIsIncludedInCollectionCase,
      CashPlanningGroup,
      PlanningLevel,
      CAAdditionalDaysForCashMgmt,
      PlannedAmtInTransactionCrcy,
      CAAltvBPForPayment,
      CABankOfAltvBPForPayment,
      CAAddressOfAltvBPForPayment,
      CACardOfAltvBPForPayment,
      SEPAMandateCAInternalID,
      CAGLPostingCurrency,
      CAGLPostingAmount,
      CAGLPostingTaxAmount,
      CAIsSeparateLineItemInGL,
      CAIsCashFlowItem,
      CACashFlowAccount,
      CACashFlowCompanyCode,
      CAPaymentPreNotificationCode,
      CASEPAPreNotificationNumber,
      CASEPAPreNotifOriginCode,
      CASEPAPreNotifExecutionDate,
      CASEPAPreNotificationRqmtCode,
      CARevenueDistrFinalRecipient,
      CARevenueDistrCurrentStatus,
      CARevenueDistrLastStatus,
      CACurrentFactoringStatusOfRbl,
      CAFactoringCheckStsForClrgInfo,
      CAFactoringItem,
      ControllingArea,
      ChartOfAccounts,
      Country,
      TaxCalculationProcedure,

      /* Associations */
      //own associations

      _CADocument,
      _CADocumentBPItemBusLock,
      //associations from I_CADocumentBPItemEnhanced

      _AdditionalCurrency1,
      _AdditionalCurrency2,
      _BusinessArea,
      _BusinessPartner,
      _CAAccountAssignmentCategory,
      _CAAccountDeterminationCode,
      _CAApplicationArea,
      _CAClearingDocument,
      _CAClearingReason,
      _CAClearingRestrictionCode,
      _CAClearingStatus,
      _CADbtflOrValueAdjmtCode,
      _CADocumentType,
      _CADunningProcedure,
      _CAFactoringClrgCheckStatus,
      _CAFactoringReceivableStatus,
      _CAInterestCode,
      _CAInternalPostingReasonCode,
      _CAMainTransaction,
      _CANegativePostingControlCode,
      _CAOriginDocument,
      _CAOriglStatisticalItemCode,
      _CAOtherTaxCode,
      _CAPartnerSettlementStatus,
      _CAPaymentMethod,
      _CAPaytPreNotificationCode,
      _CAPaytSpecificationCategory,
      _CAPeriodCode,
      _CAProviderContract ,
      _CARevenueDistrCurrentStatus,
      _CARevenueDistrLastStatus,
      _CARoundingItemCode,
      _CASEPAPreNotificationRqmtCode,
      _CASEPAPreNotifOriginCode,
      _CashFlowAccount,
      _CashFlowCompanyCode,
      _CashPlanningGroup,
      _CAStatisticalItemCode,
      _CASubApplication,
      _CASubstituteDocumentCategory,
      _CASubstituteDocument,
      _CASubTransaction,
      _CAWithholdingTaxCategory,
      _CAWithholdingTaxSupplement,
      _CAWorkflowCheckProcess,
      _CAWorkflowCheckReason,
      _ClearingCurrency,
      _CollvBillsAltvContractAccount,
      _CompanyCode,
      _CompanyCodeCurrency,
      _ContractAccount,
      _ContractAccountPartner,
      _ControllingArea,
      _ChartOfAccounts,
      _Country,
      _Division,
      _DownPaymentOffsetTaxAccount,
      _DownPaymentTaxAccount,
      _GLPostingCurrency,
      _PartnerCompany,
      _PaytAltvBusinessPartner,
      _PlanningLevel,
      _PaymentCompanyCode,
      _ProfitCenter,
      _ReceivingCountry,
      _ReconciliationAccount,
      _RevnDistrFnlRcpntContrAccount,
      _Segment,
      _TaxCalculationProcedure,
      _TaxCode,
      _TaxCountry,
      _TaxJurisdiction,
      _TransactionCurrency,
      _WithholdingTaxCode
 }