R_CADOCUMENTBPITEMTP

CDS View

Document Business Partner Item - TP

R_CADOCUMENTBPITEMTP is a CDS View in S/4HANA. Document Business Partner Item - TP. 5 CDS views read from this table.

Used by 5 CDS view(s)

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_CADocumentBPItem view_entity projection CONSUMPTION Document Business Partner Item
C_CADocumentBPItemTP view_entity projection CONSUMPTION Contr Acct Business Partner Item
C_CADocumentClearedItem view_entity from CONSUMPTION Cleared Item of a CA Document
I_CADocumentBPItemTP view_entity projection TRANSACTIONAL Document Business Partner Item - TP
I_CADocumentBPItemUI view_entity from COMPOSITE Business Partner Item 
@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
  as select from I_CADocumentBPItemEnhanced

  association        to parent R_CADocumentTP       as _DocHeader on  _DocHeader.CADocumentNumber = $projection.CADocumentNumber

  composition [0..*] of R_CADocumentBPItemBusLockTP as _BPItemBusLock

  association [1..1] to I_CADocumentBPItemUI        as _BPItemUI  on  $projection.CADocumentNumber       = _BPItemUI.CADocumentNumber
                                                                  and $projection.CABPItemNumber         = _BPItemUI.CABPItemNumber
                                                                  and $projection.CARepetitionItemNumber = _BPItemUI.CARepetitionItemNumber
                                                                  and $projection.CASubItemNumber        = _BPItemUI.CASubItemNumber
                                                                  
  // 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

      _DocHeader,
      _BPItemBusLock,
      _BPItemUI,
      //associations from I_CADocumentBPItemEnhanced

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

Learn More