I_CADOCUMENTBPITEMLOGICAL
Document Logical Business Partner Item
I_CADOCUMENTBPITEMLOGICAL is a CDS View in S/4HANA. Document Logical Business Partner Item. It contains 38 fields. 26 CDS views read from this table.
CDS Views using this table (26)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CABusinessPartnerLineItem | view | from | CONSUMPTION | |
| C_CACreditItemAnalysis | view | from | CONSUMPTION | Analyse von Guthabenposten |
| C_CALockedOpenItem | view | from | CONSUMPTION | Gesperrte offene Posten |
| C_CANotDisputedDocumentItem | view | from | CONSUMPTION | Not Disputed Document item |
| C_CAOpenItemLockedOnBP | view | from | CONSUMPTION | Offene Posten gesperrt auf Partner |
| C_CAOpenItemLockedOnContrAcct | view | from | CONSUMPTION | Offene Posten gesperrt auf Vertragskonto |
| C_CAOpenItemLockedOnContract | view | from | CONSUMPTION | Offene Posten gesperrt auf Vertrag |
| C_CAOpenItemLockedOnContrItem | view | from | CONSUMPTION | Offene Posten gesperrt auf Vertragspos. |
| C_CAOverdueItemAnalysis | view | from | CONSUMPTION | Überfällige Posten analysieren |
| I_CAAccountBalanceItem | view | from | COMPOSITE | Kontoauszug - Position |
| I_CAAccountBalanceItem | view | union_all | COMPOSITE | Kontoauszug - Position |
| I_CABalanceNotificationItem | view | from | COMPOSITE | FI-CAC: balance notification |
| I_CABalanceNotificationItem | view | union_all | COMPOSITE | FI-CAC: balance notification |
| I_CADocSeparatedAmounts | view | from | COMPOSITE | Aufgeteilte Beträge eines Belegs |
| I_CADocumentBPItemLogicalEnhcd | view_entity | from | COMPOSITE | Enhanced Document Logical BP Item |
| I_CADocumentTotalAmountOpen | view | from | COMPOSITE | Offener Betrag eines Beleges |
| I_ContractAcctOpenAmtPerCrcy | view | from | COMPOSITE | Offener Betrag pro Vertragskonto und Währung |
| P_CAAnalyzeReceivables | view | from | CONSUMPTION | |
| P_CAClearingReasonAnalysis | view_entity | from | COMPOSITE | Prepare the data for clearing reason |
| P_CAClearingReasonAnalysis | view_entity | union_all | COMPOSITE | Prepare the data for clearing reason |
| P_CADocCreditItemBPAmount | view_entity | from | COMPOSITE | Document with business partner amounts |
| P_CADocumentBPItem | view | from | COMPOSITE | |
| P_CAInstallmentPlnBPItmLogical | view | from | CONSUMPTION | |
| P_CAInterestNoticeTotalAmount | view | from | COMPOSITE | |
| P_CANotDisputedDocBPItem | view | from | COMPOSITE | |
| P_CAOverdueItemSelection | view_entity | from | COMPOSITE |
Fields (38)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CABPItemNumber | CABPItemNumber | 13 |
| KEY | CADocumentNumber | CADocumentNumber | 12 |
| KEY | CARepetitionItemNumber | CARepetitionItemNumber | 13 |
| KEY | CASubItemNumber | CASubItemNumber | 13 |
| _BusinessPartner | _BusinessPartner | 1 | |
| _CAPartner | _CAPartner | 1 | |
| _CompCode | _CompCode | 1 | |
| _ProviderContract | _ProviderContract | 1 | |
| BusinessArea | BusinessArea | 11 | |
| BusinessPartner | BusinessPartner | 12 | |
| CAAccountDeterminationCode | CAAccountDeterminationCode | 4 | |
| CAAmountInTransactionCurrency | AmountInDisplayCurrency,CAAmountInTransactionCurrency | 5 | |
| CAApplicationArea | CAApplicationArea | 2 | |
| CAClearingCurrency | TransactionCurrency | 2 | |
| CAClearingDate | CAClearingDate | 1 | |
| CAClearingReason | CAClearingReason | 2 | |
| CAClearingStatus | CAClearingStatus | 5 | |
| CAContract | CAContract | 12 | |
| CADocumentOriginCode | CADocumentOriginCode | 1 | |
| CADocumentType | CADocumentType | 5 | |
| CADoubtfulOrValueAdjmtCode | CADoubtfulOrValueAdjmtCode | 1 | |
| CADunningProcedure | CADunningProcedure | 4 | |
| CAMainTransaction | CAMainTransaction | 12 | |
| CANetDueDate | CANetDueDate | 3 | |
| CAPaymentMethod | CAPaymentMethod | 6 | |
| CAPostingDate | CAPostingDate | 2 | |
| CAPostingDateOfClearingDoc | CAPostingDate,CAPostingDateOfClearingDoc | 4 | |
| CAProviderContractItemNumber | CAProviderContractItemNumber | 2 | |
| CAStatisticalItemCode | CAStatisticalItemCode | 5 | |
| CASubApplication | CASubApplication | 5 | |
| CASubTransaction | CASubTransaction | 12 | |
| CAValueDateForClearing | CAValueDateForClearing | 2 | |
| CompanyCode | CompanyCode | 12 | |
| ContractAccount | ContractAccount | 12 | |
| Country | Country | 1 | |
| Division | Division | 10 | |
| Segment | Segment | 11 | |
| TransactionCurrency | TransactionCurrency | 11 |
@AbapCatalog: { preserveKey: true,
sqlViewName: 'ICADOCBPITEMLOGI' }
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Document Logical Business Partner Item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: { supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
#SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE ],
usageType: { dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #XXL } }
@Search.searchable: true
@VDM.viewType: #COMPOSITE
define view I_CADocumentBPItemLogical
as select from I_CADocumentBPItemPhysical as BPItem
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
{
@Search.defaultSearchElement: true
@Search.ranking: #HIGH
key BPItem.CADocumentNumber,
key BPItem.CARepetitionItemNumber,
key BPItem.CABPItemNumber,
key BPItem.CASubItemNumber,
BPItem.CompanyCode,
BPItem.BusinessArea,
BPItem.BusinessPlace,
BPItem.Segment,
BPItem.ProfitCenter,
BPItem.Division,
BPItem.PersonnelNumber,
BPItem.PartnerCompany,
BPItem.BusinessPartner,
BPItem.CAContract,
BPItem.CAProviderContractItemNumber,
BPItem.CAAdditionalContract,
BPItem.ContractAccount,
BPItem.CASubApplication,
BPItem.AltvContractAcctForCollvBills,
BPItem.CAReconciliationAccount,
BPItem.CAApplicationArea,
BPItem.CAMainTransaction,
BPItem.CASubTransaction,
BPItem.CAAccountDeterminationCode,
BPItem.CADoubtfulOrValueAdjmtCode,
BPItem.CAAccountAssignmentCategory,
BPItem.CAAccountAssignment,
BPItem.CADocumentType,
BPItem.CAIsDownPaymentRequest,
BPItem.CAItemIsOnlyForSettlement,
BPItem.CAStatisticalItemCode,
BPItem.CABPItemText,
BPItem.CANumberOfRepetitionItems,
BPItem.CARepetitionGroup,
BPItem.CAStartDateOfBillingPeriod,
BPItem.CAEndDateOfBillingPeriod,
BPItem.CAGroupingCodeForBPItems,
BPItem.CAPeriodCode,
BPItem.CAChangeIsForbidden,
BPItem.CAInterestCode,
BPItem.CARoundingItemCode,
BPItem.CAReceivingCountry,
BPItem.CAInternalPostingReasonCode,
BPItem.CAWorkflowCheckReason,
BPItem.CAWorkflowCheckProcess,
BPItem.CANegativePostingControlCode,
BPItem.CAPartnerSettlementStatus,
BPItem.CAIsPartOfJointLiability,
BPItem.CADocumentOriginCode,
BPItem.CASubstituteDocumentNumber,
BPItem.CASubstituteDocumentCategory,
BPItem.CAStatisticalCodeOfOriginItem,
BPItem.CADocumentNumberOfOriginItem,
BPItem.CAReferenceDocument,
BPItem.DocumentDate,
BPItem.CAPostingDate,
BPItem.CANetDueDate,
BPItem.CADeferralDate,
BPItem.TransactionCurrency,
BPItem.CompanyCodeCurrency,
BPItem.CAExchangeRate,
BPItem.ExchRateIsIndirectQuotation,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CAAmountInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CAAmountInTransactionCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CAAmountInSecondCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CAAmountInThirdCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CADocBPItemTotalAmountInTC,
BPItem.CACashDiscountDueDate,
BPItem.CACashDiscountRate,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CAEligibleAmountForCshDiscount,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
BPItem.CACashDiscAmountInClearingCrcy,
BPItem.TaxCode,
BPItem.CASupplementaryTaxCode,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CATaxAmountInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CATaxAmountInTransCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CATaxAmountInSecondCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CATaxAmountInThirdCurrency,
BPItem.CADownPaymentTaxAccount,
BPItem.CADownPaymentOffsetTaxAccount,
BPItem.TaxJurisdiction,
BPItem.CATaxDate,
BPItem.WithholdingTaxCode,
BPItem.CAWithholdingTaxSupplement,
BPItem.CAWithholdingTaxCategory,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CABaseAmountForWithholdingTax,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CAWithholdingTaxAmount,
BPItem.CAWithholdingTaxPercentage,
BPItem.WithholdingTaxCertificate,
BPItem.CAOtherTaxCode,
BPItem.CAGroupingCodeForTaxItems,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CATaxPortionInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CATaxPortionInTransCurrency,
BPItem.CATaxIsCalculatedExternally,
BPItem.CAPaymentMethod,
BPItem.CAPaymentCompanyCode,
BPItem.CAGroupingForPayment,
BPItem.CAPaymentSpecificationCategory,
BPItem.CAClearingStatus,
BPItem.CAClearingDate,
BPItem.CAClearingDocumentNumber,
BPItem.CAPostingDateOfClearingDoc,
BPItem.CAClearingReason,
BPItem.CAClearingCurrency,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
BPItem.CAClearingAmountInClearingCrcy,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
BPItem.CATaxAmountInClearingCrcy,
BPItem.CAValueDateForClearing,
BPItem.CAClearingRestrictionCode,
BPItem.CAClearingPostingIsReset,
BPItem.CAItemIsWithdrawn,
BPItem.CAItemIsExcludedFromDunning,
BPItem.CADunningProcedure,
BPItem.CAGrpgCodeForTransfToCollAgcy,
BPItem.CAIsIncludedInCollectionCase,
BPItem.CashPlanningGroup,
BPItem.PlanningLevel,
BPItem.CAAdditionalDaysForCashMgmt,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.PlannedAmtInTransactionCrcy,
BPItem.CAAltvBPForPayment,
BPItem.CABankOfAltvBPForPayment,
BPItem.CAAddressOfAltvBPForPayment,
BPItem.CACardOfAltvBPForPayment,
BPItem.CAGLPostingCurrency,
@Semantics.amount.currencyCode: 'CAGLPostingCurrency'
BPItem.CAGLPostingAmount,
@Semantics.amount.currencyCode: 'CAGLPostingCurrency'
BPItem.CAGLPostingTaxAmount,
BPItem.CAIsSeparateLineItemInGL,
BPItem.CAIsCashFlowItem,
BPItem.CACashFlowAccount,
BPItem.CACashFlowCompanyCode,
BPItem.CAPaymentPreNotificationCode,
BPItem.CASEPAPreNotificationNumber,
BPItem.CASEPAPreNotifOriginCode,
BPItem.CASEPAPreNotifExecutionDate,
BPItem.CASEPAPreNotificationRqmtCode,
BPItem.CARevenueDistrFinalRecipient,
BPItem.CARevenueDistrCurrentStatus,
BPItem.CARevenueDistrLastStatus,
BPItem.CACurrentFactoringStatusOfRbl,
BPItem.CAFactoringCheckStsForClrgInfo,
BPItem.ControllingArea,
BPItem.ChartOfAccounts,
BPItem.Country,
BPItem.TaxCalculationProcedure,
BPItem.SEPAMandateCAInternalID,
/* associations from I_CADocumentBPItemPhysical */
BPItem._AcctAssgmtCat,
BPItem._AcctDetnCode,
BPItem._AltvBPForPayment,
BPItem._ApplArea,
BPItem._BusinessArea,
BPItem._BusinessPartner,
BPItem._CAHeader,
BPItem._CAHeaderCollvBills,
BPItem._CAHeaderFinalRec,
BPItem._CAPartner,
BPItem._CARevnDistrCurSts,
BPItem._CARevnDistrLastSts,
BPItem._CARoundingItemCode,
BPItem._SEPAPreNotifOrignCd,
BPItem._SEPAPreNotifRqmtCode,
BPItem._CashFlowAccount,
BPItem._CASubApplication,
BPItem._ClearingCurrency,
BPItem._ClearingDocHeader,
BPItem._ClearingReason,
BPItem._ClrgRstrcnCode,
BPItem._Currency,
BPItem._CompanyCodeCurrency,
BPItem._CompCode,
BPItem._CompCodeCashFlow,
BPItem._CompCodePayt,
BPItem._ControllingArea,
BPItem._ChartOfAccounts,
BPItem._Country,
BPItem._DbtflOrValAdjmtCode,
BPItem._Division,
BPItem._DocHeader,
BPItem._DocType,
BPItem._DunningProcedure,
BPItem._FactoringRblStatus,
BPItem._FctrngClrgChkStatus,
BPItem._GLPostingCurrency,
BPItem._InterestCode,
BPItem._IntPostingReasonCode,
BPItem._MainTransaction,
BPItem._NgtvPostingCtrlCode,
BPItem._OffsetTaxAccount,
BPItem._OriginDocHeader,
BPItem._OriglStstclItemCode,
BPItem._OtherTaxCode,
BPItem._PartnerCompany,
BPItem._PaytMethod,
BPItem._PaytPreNotifCode,
BPItem._PaytSpecCategory,
BPItem._PeriodCode,
BPItem._ProfitCenter,
BPItem._ProviderContract,
BPItem._PrtnSettlementStatus,
BPItem._ReceivingCountry,
BPItem._ReconAccount,
BPItem._Segment,
BPItem._StatisticalItemCode,
BPItem._SubstitDocCategory,
BPItem._SubstitDocHeader,
BPItem._SubTransaction,
BPItem._TaxAccount,
BPItem._WhldgTaxSuplmnt,
BPItem._CAWithholdingTaxCat,
BPItem._WithholdingTaxCode,
BPItem._WorkflowCheckProcess,
BPItem._WorkflowCheckReason
}
where
(
(
CARepetitionItemNumber = '000'
and CARepetitionGroup = '000'
)
or CARepetitionItemNumber != '000'
)
and(
BPItem.CASubstituteDocumentCategory = '' // no substitute document
or BPItem.CASubstituteDocumentCategory = 'P' // Promise to Pay
) // do not select original documents of Installment Plans and Collective Bills
union all select from I_CADocumentBPItemPhysical as BPItem
join I_CADocumentBPRepetitionItem as RepItem on BPItem.CADocumentNumber = RepItem.CADocumentNumber
and BPItem.CARepetitionGroup = RepItem.CARepetitionGroup
association [1..1] to E_CADocumentBPItemPhysical as _Extension on BPItem.CADocumentNumber = _Extension.CADocumentNumber
and RepItem.CARepetitionItemNumber = _Extension.CARepetitionItemNumber
and BPItem.CABPItemNumber = _Extension.CABPItemNumber
and BPItem.CASubItemNumber = _Extension.CASubItemNumber
{
key BPItem.CADocumentNumber,
key RepItem.CARepetitionItemNumber,
key BPItem.CABPItemNumber,
key BPItem.CASubItemNumber,
BPItem.CompanyCode,
BPItem.BusinessArea,
BPItem.BusinessPlace,
BPItem.Segment,
BPItem.ProfitCenter,
BPItem.Division,
BPItem.PersonnelNumber,
BPItem.PartnerCompany,
BPItem.BusinessPartner,
BPItem.CAContract,
BPItem.CAProviderContractItemNumber,
BPItem.CAAdditionalContract,
BPItem.ContractAccount,
BPItem.CASubApplication,
BPItem.AltvContractAcctForCollvBills,
BPItem.CAReconciliationAccount,
BPItem.CAApplicationArea,
BPItem.CAMainTransaction,
BPItem.CASubTransaction,
BPItem.CAAccountDeterminationCode,
BPItem.CADoubtfulOrValueAdjmtCode,
BPItem.CAAccountAssignmentCategory,
BPItem.CAAccountAssignment,
BPItem.CADocumentType,
BPItem.CAIsDownPaymentRequest,
BPItem.CAItemIsOnlyForSettlement,
BPItem.CAStatisticalItemCode,
BPItem.CABPItemText,
BPItem.CANumberOfRepetitionItems,
RepItem.CARepetitionGroup,
BPItem.CAStartDateOfBillingPeriod,
BPItem.CAEndDateOfBillingPeriod,
BPItem.CAGroupingCodeForBPItems,
RepItem.CAPeriodCode,
RepItem.CAChangeIsForbidden,
BPItem.CAInterestCode,
BPItem.CARoundingItemCode,
BPItem.CAReceivingCountry,
BPItem.CAInternalPostingReasonCode,
BPItem.CAWorkflowCheckReason,
BPItem.CAWorkflowCheckProcess,
BPItem.CANegativePostingControlCode,
BPItem.CAPartnerSettlementStatus,
BPItem.CAIsPartOfJointLiability,
BPItem.CADocumentOriginCode,
RepItem.CASubstituteDocumentNumber,
RepItem.CASubstituteDocumentCategory,
BPItem.CAStatisticalCodeOfOriginItem,
BPItem.CADocumentNumberOfOriginItem,
BPItem.CAReferenceDocument,
BPItem.DocumentDate,
RepItem.CAPostingDate,
RepItem.CANetDueDate,
BPItem.CADeferralDate,
BPItem.TransactionCurrency,
BPItem.CompanyCodeCurrency,
BPItem.CAExchangeRate,
BPItem.ExchRateIsIndirectQuotation,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CAAmountInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CAAmountInTransactionCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CAAmountInSecondCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CAAmountInThirdCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CADocBPItemTotalAmountInTC,
RepItem.CACashDiscountDueDate,
BPItem.CACashDiscountRate,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CAEligibleAmountForCshDiscount,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
BPItem.CACashDiscAmountInClearingCrcy,
BPItem.TaxCode,
BPItem.CASupplementaryTaxCode,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CATaxAmountInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CATaxAmountInTransCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CATaxAmountInSecondCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CATaxAmountInThirdCurrency,
BPItem.CADownPaymentTaxAccount,
BPItem.CADownPaymentOffsetTaxAccount,
BPItem.TaxJurisdiction,
BPItem.CATaxDate,
BPItem.WithholdingTaxCode,
BPItem.CAWithholdingTaxSupplement,
BPItem.CAWithholdingTaxCategory,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CABaseAmountForWithholdingTax,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CAWithholdingTaxAmount,
BPItem.CAWithholdingTaxPercentage,
BPItem.WithholdingTaxCertificate,
BPItem.CAOtherTaxCode,
BPItem.CAGroupingCodeForTaxItems,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
BPItem.CATaxPortionInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.CATaxPortionInTransCurrency,
BPItem.CATaxIsCalculatedExternally,
BPItem.CAPaymentMethod,
BPItem.CAPaymentCompanyCode,
BPItem.CAGroupingForPayment,
BPItem.CAPaymentSpecificationCategory,
case
when RepItem.CAClearingDate <> '00000000'
then '9'
else ' '
end as CAClearingStatus,
RepItem.CAClearingDate,
RepItem.CAClearingDocumentNumber,
RepItem.CAPostingDateOfClearingDoc,
RepItem.CAClearingReason,
BPItem.CAClearingCurrency,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
BPItem.CAClearingAmountInClearingCrcy,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
BPItem.CATaxAmountInClearingCrcy,
RepItem.CAValueDateForClearing,
BPItem.CAClearingRestrictionCode,
RepItem.CAClearingPostingIsReset,
RepItem.CAItemIsWithdrawn,
BPItem.CAItemIsExcludedFromDunning,
BPItem.CADunningProcedure,
BPItem.CAGrpgCodeForTransfToCollAgcy,
BPItem.CAIsIncludedInCollectionCase,
BPItem.CashPlanningGroup,
BPItem.PlanningLevel,
BPItem.CAAdditionalDaysForCashMgmt,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BPItem.PlannedAmtInTransactionCrcy,
BPItem.CAAltvBPForPayment,
BPItem.CABankOfAltvBPForPayment,
BPItem.CAAddressOfAltvBPForPayment,
BPItem.CACardOfAltvBPForPayment,
BPItem.CAGLPostingCurrency,
@Semantics.amount.currencyCode: 'CAGLPostingCurrency'
BPItem.CAGLPostingAmount,
@Semantics.amount.currencyCode: 'CAGLPostingCurrency'
BPItem.CAGLPostingTaxAmount,
BPItem.CAIsSeparateLineItemInGL,
BPItem.CAIsCashFlowItem,
BPItem.CACashFlowAccount,
BPItem.CACashFlowCompanyCode,
RepItem.CAPaymentPreNotificationCode,
RepItem.CASEPAPreNotificationNumber,
RepItem.CASEPAPreNotifOriginCode,
RepItem.CASEPAPreNotifExecutionDate,
BPItem.CASEPAPreNotificationRqmtCode,
BPItem.CARevenueDistrFinalRecipient,
BPItem.CARevenueDistrCurrentStatus,
BPItem.CARevenueDistrLastStatus,
BPItem.CACurrentFactoringStatusOfRbl,
BPItem.CAFactoringCheckStsForClrgInfo,
BPItem.ControllingArea,
BPItem.ChartOfAccounts,
BPItem.Country,
BPItem.TaxCalculationProcedure,
BPItem.SEPAMandateCAInternalID,
/* associations from I_CADocumentBPItemPhysical and I_CADocumentBPRepetitionItem */
BPItem._AcctAssgmtCat,
BPItem._AcctDetnCode,
BPItem._AltvBPForPayment,
BPItem._ApplArea,
BPItem._BusinessArea,
BPItem._BusinessPartner,
BPItem._CAHeader,
BPItem._CAHeaderCollvBills,
BPItem._CAHeaderFinalRec,
BPItem._CAPartner,
BPItem._CARevnDistrCurSts,
BPItem._CARevnDistrLastSts,
BPItem._CARoundingItemCode,
RepItem._SEPAPreNotifOrignCd,
BPItem._SEPAPreNotifRqmtCode,
BPItem._CashFlowAccount,
BPItem._CASubApplication,
BPItem._ClearingCurrency,
RepItem._ClearingDocHeader,
RepItem._ClearingReason,
BPItem._ClrgRstrcnCode,
BPItem._Currency,
BPItem._CompanyCodeCurrency,
BPItem._CompCode,
BPItem._CompCodeCashFlow,
BPItem._CompCodePayt,
BPItem._ControllingArea,
BPItem._ChartOfAccounts,
BPItem._Country,
BPItem._DbtflOrValAdjmtCode,
BPItem._Division,
BPItem._DocHeader,
BPItem._DocType,
BPItem._DunningProcedure,
BPItem._FactoringRblStatus,
BPItem._FctrngClrgChkStatus,
BPItem._GLPostingCurrency,
BPItem._InterestCode,
BPItem._IntPostingReasonCode,
BPItem._MainTransaction,
BPItem._NgtvPostingCtrlCode,
BPItem._OffsetTaxAccount,
BPItem._OriginDocHeader,
BPItem._OriglStstclItemCode,
BPItem._OtherTaxCode,
BPItem._PartnerCompany,
BPItem._PaytMethod,
RepItem._PaytPreNotifCode,
BPItem._PaytSpecCategory,
RepItem._PeriodCode,
BPItem._ProfitCenter,
BPItem._ProviderContract,
BPItem._PrtnSettlementStatus,
BPItem._ReceivingCountry,
BPItem._ReconAccount,
BPItem._Segment,
BPItem._StatisticalItemCode,
RepItem._SubstitDocCategory,
RepItem._SubstitDocHeader,
BPItem._SubTransaction,
BPItem._TaxAccount,
BPItem._WhldgTaxSuplmnt,
BPItem._CAWithholdingTaxCat,
BPItem._WithholdingTaxCode,
BPItem._WorkflowCheckProcess,
BPItem._WorkflowCheckReason
}
where
BPItem.CARepetitionItemNumber = '000'
and BPItem.CARepetitionGroup != '000'
and RepItem.CARepetitionItemIsResolved = ''