I_CADOCUMENTBPITEMPHYSICAL
Document Physical Business Partner Item
I_CADOCUMENTBPITEMPHYSICAL is a CDS View in S/4HANA. Document Physical Business Partner Item. It contains 209 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CADocumentBPItemTransfer | view_entity | from | CONSUMPTION | Business Partner Items Transfer |
| I_CADocumentBPItemLogical | view | from | COMPOSITE | Document Logical Business Partner Item |
| I_CADocumentBPItemLogical | view | union_all | COMPOSITE | Document Logical Business Partner Item |
| P_BE_AnnSlsListCA | view_entity | from | CONSUMPTION | Domestic Sales List FI-CA Helper View |
| P_BE_DomesticSalesListFica | view | from | CONSUMPTION | Domestic Sales List FICA view for BE |
| P_BE_DomesticSalesListFica | view | inner | CONSUMPTION | Domestic Sales List FICA view for BE |
Fields (209)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CABPItemNumber | CABPItemNumber | 2 |
| KEY | CADocumentNumber | CADocumentNumber | 3 |
| KEY | CARepetitionItemNumber | CARepetitionItemNumber | 2 |
| KEY | CASubItemNumber | CASubItemNumber | 2 |
| KEY | CompanyCode | CompanyCode | 3 |
| _AcctAssgmtCat | _AcctAssgmtCat | 1 | |
| _AcctDetnCode | _AcctDetnCode | 1 | |
| _AltvBPForPayment | _AltvBPForPayment | 1 | |
| _ApplArea | _ApplArea | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _BusinessPartner | _BusinessPartner | 1 | |
| _CAHeader | _CAHeader | 1 | |
| _CAHeaderCollvBills | _CAHeaderCollvBills | 1 | |
| _CAHeaderFinalRec | _CAHeaderFinalRec | 1 | |
| _CAPartner | _CAPartner | 1 | |
| _CARevnDistrCurSts | _CARevnDistrCurSts | 1 | |
| _CARevnDistrLastSts | _CARevnDistrLastSts | 1 | |
| _CARoundingItemCode | _CARoundingItemCode | 1 | |
| _CashFlowAccount | _CashFlowAccount | 1 | |
| _CASubApplication | _CASubApplication | 1 | |
| _CAWithholdingTaxCat | _CAWithholdingTaxCat | 1 | |
| _ChartOfAccounts | _ChartOfAccounts | 1 | |
| _ClearingCurrency | _ClearingCurrency | 1 | |
| _ClearingDocHeader | _ClearingDocHeader | 1 | |
| _ClearingReason | _ClearingReason | 1 | |
| _ClrgRstrcnCode | _ClrgRstrcnCode | 1 | |
| _CompanyCodeCurrency | _CompanyCodeCurrency | 1 | |
| _CompCode | _CompCode | 2 | |
| _CompCodeCashFlow | _CompCodeCashFlow | 1 | |
| _CompCodePayt | _CompCodePayt | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _Country | _Country | 2 | |
| _Currency | _Currency | 1 | |
| _DbtflOrValAdjmtCode | _DbtflOrValAdjmtCode | 1 | |
| _Division | _Division | 1 | |
| _DocHeader | _DocHeader | 2 | |
| _DocType | _DocType | 1 | |
| _DunningProcedure | _DunningProcedure | 1 | |
| _FactoringRblStatus | _FactoringRblStatus | 1 | |
| _FctrngClrgChkStatus | _FctrngClrgChkStatus | 1 | |
| _GLPostingCurrency | _GLPostingCurrency | 1 | |
| _InterestCode | _InterestCode | 1 | |
| _IntPostingReasonCode | _IntPostingReasonCode | 1 | |
| _MainTransaction | _MainTransaction | 1 | |
| _NgtvPostingCtrlCode | _NgtvPostingCtrlCode | 1 | |
| _OffsetTaxAccount | _OffsetTaxAccount | 1 | |
| _OriginDocHeader | _OriginDocHeader | 1 | |
| _OriglStstclItemCode | _OriglStstclItemCode | 1 | |
| _OtherTaxCode | _OtherTaxCode | 1 | |
| _PartnerCompany | _PartnerCompany | 1 | |
| _PaytMethod | _PaytMethod | 1 | |
| _PaytPreNotifCode | _PaytPreNotifCode | 1 | |
| _PaytSpecCategory | _PaytSpecCategory | 1 | |
| _PeriodCode | _PeriodCode | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ProviderContract | _ProviderContract | 1 | |
| _PrtnSettlementStatus | _PrtnSettlementStatus | 1 | |
| _ReceivingCountry | _ReceivingCountry | 1 | |
| _ReconAccount | _ReconAccount | 1 | |
| _Segment | _Segment | 1 | |
| _SEPAPreNotifOrignCd | _SEPAPreNotifOrignCd | 1 | |
| _SEPAPreNotifRqmtCode | _SEPAPreNotifRqmtCode | 1 | |
| _StatisticalItemCode | _StatisticalItemCode | 1 | |
| _SubstitDocCategory | _SubstitDocCategory | 1 | |
| _SubstitDocHeader | _SubstitDocHeader | 1 | |
| _SubTransaction | _SubTransaction | 1 | |
| _TaxAccount | _TaxAccount | 1 | |
| _WhldgTaxSuplmnt | _WhldgTaxSuplmnt | 1 | |
| _WithholdingTaxCode | _WithholdingTaxCode | 1 | |
| _WorkflowCheckProcess | _WorkflowCheckProcess | 1 | |
| _WorkflowCheckReason | _WorkflowCheckReason | 1 | |
| AltvContractAcctForCollvBills | AltvContractAcctForCollvBills | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessPartner | BusinessPartner | 3 | |
| BusinessPlace | BusinessPlace | 1 | |
| CAAccountAssignment | CAAccountAssignment | 1 | |
| CAAccountAssignmentCategory | CAAccountAssignmentCategory | 1 | |
| CAAccountDeterminationCode | CAAccountDeterminationCode | 1 | |
| CAAdditionalContract | CAAdditionalContract | 1 | |
| CAAdditionalDaysForCashMgmt | CAAdditionalDaysForCashMgmt | 1 | |
| CAAddressOfAltvBPForPayment | CAAddressOfAltvBPForPayment | 1 | |
| CAAltvBPForPayment | CAAltvBPForPayment | 1 | |
| CAAmountInLocalCurrency | CAAmountInLocalCurrency | 1 | |
| CAAmountInSecondCurrency | CAAmountInSecondCurrency | 1 | |
| CAAmountInThirdCurrency | CAAmountInThirdCurrency | 1 | |
| CAAmountInTransactionCurrency | CAAmountInTransactionCurrency | 1 | |
| CAApplicationArea | CAApplicationArea | 1 | |
| CABankOfAltvBPForPayment | CABankOfAltvBPForPayment | 1 | |
| CABaseAmountForWithholdingTax | CABaseAmountForWithholdingTax | 1 | |
| CABPItemText | CABPItemText | 1 | |
| CACardOfAltvBPForPayment | CACardOfAltvBPForPayment | 1 | |
| CACashDiscAmountInClearingCrcy | CACashDiscAmountInClearingCrcy | 1 | |
| CACashDiscountDueDate | CACashDiscountDueDate | 1 | |
| CACashDiscountRate | CACashDiscountRate | 1 | |
| CACashFlowAccount | CACashFlowAccount | 1 | |
| CACashFlowCompanyCode | CACashFlowCompanyCode | 1 | |
| CAChangeIsForbidden | CAChangeIsForbidden | 1 | |
| CAClearingAmountInClearingCrcy | CAClearingAmountInClearingCrcy | 1 | |
| CAClearingCurrency | CAClearingCurrency | 1 | |
| CAClearingDate | CAClearingDate | 1 | |
| CAClearingDocumentNumber | CAClearingDocumentNumber | 1 | |
| CAClearingPostingIsReset | CAClearingPostingIsReset | 1 | |
| CAClearingReason | CAClearingReason | 1 | |
| CAClearingRestrictionCode | CAClearingRestrictionCode | 1 | |
| CAClearingStatus | CAClearingStatus | 1 | |
| CAContract | CAContract | 1 | |
| CACurrentFactoringStatusOfRbl | CACurrentFactoringStatusOfRbl | 1 | |
| CADeferralDate | CADeferralDate | 1 | |
| CADocBPItemTotalAmountInTC | CADocBPItemTotalAmountInTC | 1 | |
| CADocumentNumberOfOriginItem | CADocumentNumberOfOriginItem | 1 | |
| CADocumentOriginCode | CADocumentOriginCode | 1 | |
| CADocumentType | AccountingDocumentType,CADocumentType | 3 | |
| CADoubtfulOrValueAdjmtCode | CADoubtfulOrValueAdjmtCode | 1 | |
| CADownPaymentOffsetTaxAccount | CADownPaymentOffsetTaxAccount | 1 | |
| CADownPaymentTaxAccount | CADownPaymentTaxAccount | 1 | |
| CADunningProcedure | CADunningProcedure | 1 | |
| CAEligibleAmountForCshDiscount | CAEligibleAmountForCshDiscount | 1 | |
| CAEndDateOfBillingPeriod | CAEndDateOfBillingPeriod | 1 | |
| CAExchangeRate | CAExchangeRate | 1 | |
| CAFactoringCheckStsForClrgInfo | CAFactoringCheckStsForClrgInfo | 1 | |
| CAGLPostingAmount | CAGLPostingAmount | 1 | |
| CAGLPostingCurrency | CAGLPostingCurrency | 1 | |
| CAGLPostingTaxAmount | CAGLPostingTaxAmount | 1 | |
| CAGroupingCodeForBPItems | CAGroupingCodeForBPItems | 1 | |
| CAGroupingCodeForTaxItems | CAGroupingCodeForTaxItems | 2 | |
| CAGroupingForPayment | CAGroupingForPayment | 1 | |
| CAGrpgCodeForTransfToCollAgcy | CAGrpgCodeForTransfToCollAgcy | 1 | |
| CAInterestCode | CAInterestCode | 1 | |
| CAInternalPostingReasonCode | CAInternalPostingReasonCode | 1 | |
| CAIsCashFlowItem | CAIsCashFlowItem | 1 | |
| CAIsDownPaymentRequest | CAIsDownPaymentRequest | 1 | |
| CAIsIncludedInCollectionCase | CAIsIncludedInCollectionCase | 1 | |
| CAIsPartOfJointLiability | CAIsPartOfJointLiability | 1 | |
| CAIsSeparateLineItemInGL | CAIsSeparateLineItemInGL | 1 | |
| CAItemIsExcludedFromDunning | CAItemIsExcludedFromDunning | 1 | |
| CAItemIsOnlyForSettlement | CAItemIsOnlyForSettlement | 1 | |
| CAItemIsWithdrawn | CAItemIsWithdrawn | 1 | |
| CAMainTransaction | CAMainTransaction | 1 | |
| CANegativePostingControlCode | CANegativePostingControlCode | 1 | |
| CANetDueDate | CANetDueDate | 1 | |
| CANumberOfRepetitionItems | CANumberOfRepetitionItems | 1 | |
| CAOtherTaxCode | CAOtherTaxCode | 1 | |
| CAPartnerSettlementStatus | CAPartnerSettlementStatus | 1 | |
| CAPaymentCompanyCode | CAPaymentCompanyCode | 1 | |
| CAPaymentMethod | CAPaymentMethod | 1 | |
| CAPaymentPreNotificationCode | CAPaymentPreNotificationCode | 1 | |
| CAPaymentSpecificationCategory | CAPaymentSpecificationCategory | 1 | |
| CAPeriodCode | CAPeriodCode | 1 | |
| CAPostingDate | CAPostingDate,PostingDate | 3 | |
| CAPostingDateOfClearingDoc | CAPostingDateOfClearingDoc | 1 | |
| CAProviderContractItemNumber | CAProviderContractItemNumber | 1 | |
| CAReceivingCountry | CAReceivingCountry | 1 | |
| CAReconciliationAccount | CAReconciliationAccount | 1 | |
| CAReferenceDocument | CAReferenceDocument | 1 | |
| CARepetitionGroup | CARepetitionGroup | 1 | |
| CARevenueDistrCurrentStatus | CARevenueDistrCurrentStatus | 1 | |
| CARevenueDistrFinalRecipient | CARevenueDistrFinalRecipient | 1 | |
| CARevenueDistrLastStatus | CARevenueDistrLastStatus | 1 | |
| CARoundingItemCode | CARoundingItemCode | 1 | |
| CASEPAPreNotifExecutionDate | CASEPAPreNotifExecutionDate | 1 | |
| CASEPAPreNotificationNumber | CASEPAPreNotificationNumber | 1 | |
| CASEPAPreNotificationRqmtCode | CASEPAPreNotificationRqmtCode | 1 | |
| CASEPAPreNotifOriginCode | CASEPAPreNotifOriginCode | 1 | |
| CashPlanningGroup | CashPlanningGroup | 1 | |
| CAStartDateOfBillingPeriod | CAStartDateOfBillingPeriod | 1 | |
| CAStatisticalCodeOfOriginItem | CAStatisticalCodeOfOriginItem | 1 | |
| CAStatisticalItemCode | CAStatisticalItemCode | 1 | |
| CASubApplication | CASubApplication | 1 | |
| CASubstituteDocumentCategory | CASubstituteDocumentCategory | 1 | |
| CASubstituteDocumentNumber | CASubstituteDocumentNumber | 1 | |
| CASubTransaction | CASubTransaction | 1 | |
| CASupplementaryTaxCode | CASupplementaryTaxCode | 1 | |
| CATaxAmountInClearingCrcy | CATaxAmountInClearingCrcy | 1 | |
| CATaxAmountInLocalCurrency | CATaxAmountInLocalCurrency | 2 | |
| CATaxAmountInSecondCurrency | CATaxAmountInSecondCurrency | 1 | |
| CATaxAmountInThirdCurrency | CATaxAmountInThirdCurrency | 1 | |
| CATaxAmountInTransCurrency | CATaxAmountInTransCurrency,TaxAmount | 3 | |
| CATaxDate | CATaxDate | 1 | |
| CATaxIsCalculatedExternally | CATaxIsCalculatedExternally | 1 | |
| CATaxPortionInLocalCurrency | CATaxPortionInLocalCurrency | 1 | |
| CATaxPortionInTransCurrency | CATaxPortionInTransCurrency | 1 | |
| CAValueDateForClearing | CAValueDateForClearing | 1 | |
| CAWithholdingTaxAmount | CAWithholdingTaxAmount | 1 | |
| CAWithholdingTaxCategory | CAWithholdingTaxCategory | 1 | |
| CAWithholdingTaxPercentage | CAWithholdingTaxPercentage | 1 | |
| CAWithholdingTaxSupplement | CAWithholdingTaxSupplement | 1 | |
| CAWorkflowCheckProcess | CAWorkflowCheckProcess | 1 | |
| CAWorkflowCheckReason | CAWorkflowCheckReason | 1 | |
| ChartOfAccounts | ChartOfAccounts | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 2 | |
| ContractAccount | ContractAccount | 1 | |
| ControllingArea | ControllingArea | 1 | |
| Country | Country,TaxCountry,TaxReturnCountry | 3 | |
| Division | Division | 1 | |
| DocumentDate | DocumentDate | 3 | |
| ExchRateIsIndirectQuotation | ExchRateIsIndirectQuotation | 1 | |
| PartnerCompany | PartnerCompany | 1 | |
| PersonnelNumber | PersonnelNumber | 1 | |
| PlannedAmtInTransactionCrcy | PlannedAmtInTransactionCrcy | 1 | |
| PlanningLevel | PlanningLevel | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| Segment | Segment | 1 | |
| SEPAMandateCAInternalID | SEPAMandateCAInternalID | 1 | |
| TaxCalculationProcedure | TaxCalculationProcedure | 3 | |
| TaxCode | TaxCode | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TransactionCurrency | TransactionCurrency | 2 | |
| WithholdingTaxCertificate | WithholdingTaxCertificate | 1 | |
| WithholdingTaxCode | WithholdingTaxCode | 1 |
// !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
// DEPRECATED - DON'T USE ANYMORE
// use I_CADocumentBPItem instead
// !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@AbapCatalog: { preserveKey: true,
sqlViewName: 'ICADOCBPITEMPHYS' }
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Document Physical Business Partner Item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: { supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
#SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE ],
usageType: { serviceQuality: #C,
sizeCategory: #XXL,
dataClass: #TRANSACTIONAL } }
@Search.searchable: true
@VDM.viewType: #COMPOSITE
define view I_CADocumentBPItemPhysical
as select from I_CADocumentBPItem as CADocBPItem
association [1..1] to I_CADocumentHeader as _DocHeader on $projection.CADocumentNumber = _DocHeader.CADocumentNumber
association [0..1] to I_CADocumentHeader as _SubstitDocHeader on $projection.CASubstituteDocumentNumber = _SubstitDocHeader.CADocumentNumber
association [0..1] to I_CADocumentHeader as _ClearingDocHeader on $projection.CAClearingDocumentNumber = _ClearingDocHeader.CADocumentNumber
association [0..1] to I_CADocumentHeader as _OriginDocHeader on $projection.CADocumentNumberOfOriginItem = _OriginDocHeader.CADocumentNumber
association [1..1] to I_GLAccountInChartOfAccounts as _ReconAccount on $projection.ChartOfAccounts = _ReconAccount.ChartOfAccounts
and $projection.CAReconciliationAccount = _ReconAccount.GLAccount
association [0..1] to I_GLAccountInChartOfAccounts as _TaxAccount on $projection.ChartOfAccounts = _TaxAccount.ChartOfAccounts
and $projection.CADownPaymentTaxAccount = _TaxAccount.GLAccount
association [0..1] to I_GLAccountInChartOfAccounts as _OffsetTaxAccount on $projection.ChartOfAccounts = _OffsetTaxAccount.ChartOfAccounts
and $projection.CADownPaymentOffsetTaxAccount = _OffsetTaxAccount.GLAccount
association [0..1] to I_GLAccountInChartOfAccounts as _CashFlowAccount on $projection.ChartOfAccounts = _CashFlowAccount.ChartOfAccounts
and $projection.CACashFlowAccount = _CashFlowAccount.GLAccount
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
{
/* business partner item identification */
@Search.defaultSearchElement: true
@Search.ranking: #HIGH
key CADocBPItem.CADocumentNumber,
key CADocBPItem.CARepetitionItemNumber,
key CADocBPItem.CABPItemNumber,
key CADocBPItem.CASubItemNumber,
CADocBPItem.CompanyCode,
CADocBPItem.BusinessArea,
CADocBPItem.BusinessPlace,
CADocBPItem.Segment,
CADocBPItem.ProfitCenter,
CADocBPItem.Division,
CADocBPItem.PersonnelNumber,
CADocBPItem.PartnerCompany,
CADocBPItem.BusinessPartner,
CADocBPItem.CAContract,
CADocBPItem.CAProviderContractItemNumber,
CADocBPItem.CAAdditionalContract,
CADocBPItem.ContractAccount,
CADocBPItem.CASubApplication,
CADocBPItem.AltvContractAcctForCollvBills,
CADocBPItem.CAReconciliationAccount,
/* posting attributes */
CADocBPItem.CAApplicationArea,
CADocBPItem.CAMainTransaction,
CADocBPItem.CASubTransaction,
CADocBPItem.CAAccountDeterminationCode,
CADocBPItem.CADoubtfulOrValueAdjmtCode,
CADocBPItem.CAAccountAssignmentCategory,
CADocBPItem.CAAccountAssignment,
CADocBPItem.CADocumentType,
CADocBPItem.CAIsDownPaymentRequest,
CADocBPItem.CAItemIsOnlyForSettlement,
CADocBPItem.CAStatisticalItemCode,
CADocBPItem.CABPItemText,
CADocBPItem.CANumberOfRepetitionItems,
CADocBPItem.CARepetitionGroup,
CADocBPItem.CAStartDateOfBillingPeriod,
CADocBPItem.CAEndDateOfBillingPeriod,
CADocBPItem.CAGroupingCodeForBPItems,
CADocBPItem.CAPeriodCode,
CADocBPItem.CAChangeIsForbidden,
CADocBPItem.CAInterestCode,
CADocBPItem.CARoundingItemCode,
CADocBPItem.CAReceivingCountry,
CADocBPItem.CAInternalPostingReasonCode,
CADocBPItem.CAWorkflowCheckReason,
CADocBPItem.CAWorkflowCheckProcess,
CADocBPItem.CANegativePostingControlCode,
CADocBPItem.CAPartnerSettlementStatus,
CADocBPItem.CAIsPartOfJointLiability,
CADocBPItem.CADocumentOriginCode,
/* document references */
CADocBPItem.CASubstituteDocumentNumber,
CADocBPItem.CASubstituteDocumentCategory,
CADocBPItem.CAStatisticalCodeOfOriginItem,
CADocBPItem.CADocumentNumberOfOriginItem,
CADocBPItem.CAReferenceDocument,
/* dates and amounts */
CADocBPItem.DocumentDate,
CADocBPItem.CAPostingDate,
CADocBPItem.CANetDueDate,
CADocBPItem.CADeferralDate,
CADocBPItem.TransactionCurrency,
CADocBPItem.CompanyCodeCurrency,
//kursf as CAExchangeRate, ////replace due to conversion exit EXCRT
CADocBPItem.CAExchangeRate,
CADocBPItem.ExchRateIsIndirectQuotation,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
CADocBPItem.CAAmountInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
CADocBPItem.CAAmountInTransactionCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
CADocBPItem.CAAmountInSecondCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
CADocBPItem.CAAmountInThirdCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
CADocBPItem.CADocBPItemTotalAmountInTC,
/* cash discount */
CADocBPItem.CACashDiscountDueDate,
CADocBPItem.CACashDiscountRate,
@Semantics.amount.currencyCode: 'TransactionCurrency'
CADocBPItem.CAEligibleAmountForCshDiscount,
/* tax data */
CADocBPItem.TaxCode,
CADocBPItem.CASupplementaryTaxCode,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
CADocBPItem.CATaxAmountInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
CADocBPItem.CATaxAmountInTransCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
CADocBPItem.CATaxAmountInSecondCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
CADocBPItem.CATaxAmountInThirdCurrency,
CADocBPItem.CADownPaymentTaxAccount,
CADocBPItem.CADownPaymentOffsetTaxAccount,
CADocBPItem.TaxJurisdiction,
CADocBPItem.CATaxDate,
CADocBPItem.WithholdingTaxCode,
CADocBPItem.CAWithholdingTaxSupplement,
CADocBPItem.CAWithholdingTaxCategory,
@Semantics.amount.currencyCode: 'TransactionCurrency'
CADocBPItem.CABaseAmountForWithholdingTax,
@Semantics.amount.currencyCode: 'TransactionCurrency'
CADocBPItem.CAWithholdingTaxAmount,
CADocBPItem.CAWithholdingTaxPercentage,
CADocBPItem.WithholdingTaxCertificate,
CADocBPItem.CAOtherTaxCode,
CADocBPItem.CAGroupingCodeForTaxItems,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
CADocBPItem.CATaxPortionInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
CADocBPItem.CATaxPortionInTransCurrency,
CADocBPItem.CATaxIsCalculatedExternally,
CADocBPItem.CATaxAmountIsSetFromExternal,
/* payment data */
CADocBPItem.CAPaymentMethod,
CADocBPItem.CAPaymentCompanyCode,
CADocBPItem.CAGroupingForPayment,
CADocBPItem.CAPaymentSpecificationCategory,
/* clearing data */
CADocBPItem.CAClearingStatus,
CADocBPItem.CAClearingDate,
CADocBPItem.CAClearingDocumentNumber,
CADocBPItem.CAPostingDateOfClearingDoc,
CADocBPItem.CAClearingReason,
CADocBPItem.CAClearingCurrency,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
CADocBPItem.CAClearingAmountInClearingCrcy,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
CADocBPItem.CATaxAmountInClearingCrcy,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
CADocBPItem.CACashDiscAmountInClearingCrcy,
CADocBPItem.CAValueDateForClearing,
CADocBPItem.CAClearingRestrictionCode,
CADocBPItem.CAClearingPostingIsReset,
CADocBPItem.CAItemIsWithdrawn,
/* dunning and collections */
CADocBPItem.CAItemIsExcludedFromDunning,
CADocBPItem.CADunningProcedure,
CADocBPItem.CAGrpgCodeForTransfToCollAgcy,
CADocBPItem.CAIsIncludedInCollectionCase,
/* cash management data */
CADocBPItem.CashPlanningGroup,
CADocBPItem.PlanningLevel,
CADocBPItem.CAAdditionalDaysForCashMgmt,
@Semantics.amount.currencyCode: 'TransactionCurrency'
CADocBPItem.PlannedAmtInTransactionCrcy,
/* alternative business partner for payment */
CADocBPItem.CAAltvBPForPayment,
CADocBPItem.CABankOfAltvBPForPayment,
CADocBPItem.CAAddressOfAltvBPForPayment,
CADocBPItem.CACardOfAltvBPForPayment,
CADocBPItem.SEPAMandateCAInternalID,
/* GL data */
CADocBPItem.CAGLPostingCurrency,
@Semantics.amount.currencyCode: 'CAGLPostingCurrency'
CADocBPItem.CAGLPostingAmount,
@Semantics.amount.currencyCode: 'CAGLPostingCurrency'
CADocBPItem.CAGLPostingTaxAmount,
CADocBPItem.CAIsSeparateLineItemInGL,
/* cash flow data */
CADocBPItem.CAIsCashFlowItem,
CADocBPItem.CACashFlowAccount,
CADocBPItem.CACashFlowCompanyCode,
/* pre notification data */
CADocBPItem.CAPaymentPreNotificationCode,
CADocBPItem.CASEPAPreNotificationNumber,
CADocBPItem.CASEPAPreNotifOriginCode,
CADocBPItem.CASEPAPreNotifExecutionDate,
CADocBPItem.CASEPAPreNotificationRqmtCode,
/* revenue distribution data */
CADocBPItem.CARevenueDistrFinalRecipient,
CADocBPItem.CARevenueDistrCurrentStatus,
CADocBPItem.CARevenueDistrLastStatus,
/* Factoring */
CADocBPItem.CACurrentFactoringStatusOfRbl,
CADocBPItem.CAFactoringCheckStsForClrgInfo,
CADocBPItem.CAFactoringItem,
/* additional data */
CADocBPItem.ControllingArea,
CADocBPItem.ChartOfAccounts,
CADocBPItem.Country,
CADocBPItem._Country.TaxCalculationProcedure as TaxCalculationProcedure,
/* associations from I_CADocumentBPItem */
CADocBPItem._CAAccountAssignmentCategory as _AcctAssgmtCat,
CADocBPItem._CAAccountDeterminationCode as _AcctDetnCode,
CADocBPItem._PaytAltvBusinessPartner as _AltvBPForPayment,
CADocBPItem._CAApplicationArea as _ApplArea,
CADocBPItem._BusinessArea,
CADocBPItem._BusinessPartner,
CADocBPItem._ContractAccount as _CAHeader,
CADocBPItem._CollvBillsAltvContractAccount as _CAHeaderCollvBills,
CADocBPItem._RevnDistrFnlRcpntContrAccount as _CAHeaderFinalRec,
CADocBPItem._ContractAccountPartner as _CAPartner,
CADocBPItem._CARevenueDistrCurrentStatus as _CARevnDistrCurSts,
CADocBPItem._CARevenueDistrLastStatus as _CARevnDistrLastSts,
CADocBPItem._CARoundingItemCode,
CADocBPItem._CASEPAPreNotifOriginCode as _SEPAPreNotifOrignCd,
CADocBPItem._CASEPAPreNotificationRqmtCode as _SEPAPreNotifRqmtCode,
_CashFlowAccount,
CADocBPItem._CASubApplication,
CADocBPItem._ClearingCurrency,
_ClearingDocHeader,
CADocBPItem._CAClearingReason as _ClearingReason,
CADocBPItem._CAClearingStatus as _ClearingStatus,
CADocBPItem._CAClearingRestrictionCode as _ClrgRstrcnCode,
CADocBPItem._TransactionCurrency as _Currency,
CADocBPItem._CompanyCodeCurrency,
CADocBPItem._CompanyCode as _CompCode,
CADocBPItem._CashFlowCompanyCode as _CompCodeCashFlow,
CADocBPItem._PaymentCompanyCode as _CompCodePayt,
CADocBPItem._ControllingArea,
CADocBPItem._ChartOfAccounts,
CADocBPItem._Country,
CADocBPItem._CADbtflOrValueAdjmtCode as _DbtflOrValAdjmtCode,
CADocBPItem._Division,
_DocHeader,
CADocBPItem._CADocumentType as _DocType,
CADocBPItem._CADunningProcedure as _DunningProcedure,
CADocBPItem._CAFactoringReceivableStatus as _FactoringRblStatus,
CADocBPItem._CAFactoringClrgCheckStatus as _FctrngClrgChkStatus,
CADocBPItem._GLPostingCurrency,
CADocBPItem._CAInterestCode as _InterestCode,
CADocBPItem._CAInternalPostingReasonCode as _IntPostingReasonCode,
CADocBPItem._CAMainTransaction as _MainTransaction,
CADocBPItem._CANegativePostingControlCode as _NgtvPostingCtrlCode,
_OffsetTaxAccount,
_OriginDocHeader,
CADocBPItem._CAOriglStatisticalItemCode as _OriglStstclItemCode,
CADocBPItem._CAOtherTaxCode as _OtherTaxCode,
CADocBPItem._PartnerCompany,
CADocBPItem._CAPaymentMethod as _PaytMethod,
CADocBPItem._CAPaytPreNotificationCode as _PaytPreNotifCode,
CADocBPItem._CAPaytSpecificationCategory as _PaytSpecCategory,
CADocBPItem._CAPeriodCode as _PeriodCode,
CADocBPItem._ProfitCenter,
CADocBPItem._CAProviderContract as _ProviderContract,
CADocBPItem._CAPartnerSettlementStatus as _PrtnSettlementStatus,
CADocBPItem._ReceivingCountry,
CADocBPItem._Segment,
CADocBPItem._CAStatisticalItemCode as _StatisticalItemCode,
CADocBPItem._CASubstituteDocumentCategory as _SubstitDocCategory,
_ReconAccount,
_SubstitDocHeader,
CADocBPItem._CASubTransaction as _SubTransaction,
_TaxAccount,
CADocBPItem._CAWithholdingTaxSupplement as _WhldgTaxSuplmnt,
CADocBPItem._CAWithholdingTaxCategory as _CAWithholdingTaxCat,
CADocBPItem._WithholdingTaxCode,
CADocBPItem._CAWorkflowCheckProcess as _WorkflowCheckProcess,
CADocBPItem._CAWorkflowCheckReason as _WorkflowCheckReason
}
// don't append/show budget billing requests with clearing restrictions 1 and 6
where
not(
CAApplicationArea = 'R'
and(
CAStatisticalItemCode = 'P'
or CAStatisticalItemCode = 'Z'
)
and(
CAClearingRestrictionCode = '1'
or CAClearingRestrictionCode = '6'
)
)