I_CADOCUMENTBPITEM
Document Business Partner Item
I_CADOCUMENTBPITEM is a CDS View in S/4HANA. Document Business Partner Item. It contains 211 fields. 20 CDS views read from this table.
CDS Views using this table (20)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_PL_CAExcessDelRepLogItm | view_entity | from | CONSUMPTION | |
| I_CADocumentBPItemCube | view_entity | from | COMPOSITE | Document Business Partner Item - Cube |
| I_CADocumentBPItemPhysical | view | from | COMPOSITE | Document Physical Business Partner Item |
| I_CAOverdueItemsAtDate | view_entity | from | COMPOSITE | FICA Overdue items at given date |
| I_NL_SAFTBusinessPartner | view | inner | COMPOSITE | SAF-T NL Business Partner |
| P_BOPFICA_BP_ITEM_1 | view_entity | from | COMPOSITE | FICA BP Item 1 |
| P_CABusLockForBusinessPartner | view_entity | from | COMPOSITE | Business Lock for a Business Partner |
| P_CABusLockForContrAcct | view_entity | from | COMPOSITE | Business Lock for a Contract Account |
| P_CADocCtnDocBPItem | view_entity | from | COMPOSITE | |
| P_CADoctBPItemAmountInTC | view_entity | from | COMPOSITE | Amount for a BP Item |
| P_CADocumentBPItemCount | view_entity | from | COMPOSITE | Count of Document BP Items |
| P_CADocumentBusinessPartner | view_entity | from | COMPOSITE | Document with Business Partner |
| P_CADocumentClearedAmountInTC | view_entity | from | COMPOSITE | Cleared Amount in Transaction Currency |
| P_CADocumentDueAmountInTC | view_entity | from | COMPOSITE | Due Amount of a Ca Document in TC |
| P_CADocumentOpenAmountInTC | view_entity | from | COMPOSITE | Open Amount of a Contr Acctg Document |
| P_CADocumentSumBPItem | view_entity | from | COMPOSITE | Summarized Business Partner Items |
| P_CADocumentSumClearedItem | view_entity | from | COMPOSITE | Summarized Cleared Items |
| P_GrantorCADocBPItem | view_entity | from | COMPOSITE | |
| P_JP_ForeignBPClearedItem | view_entity | from | CONSUMPTION | |
| P_PT_CADocItmAnnex | view_entity | inner | CONSUMPTION | Contract Accounting Document Item for Portugal Annex O |
Fields (211)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BusinessPartner | BusinessPartner | 5 |
| KEY | CABPItemNumber | CABPItemNumber | 6 |
| KEY | CAContract | CAContract | 3 |
| KEY | CADocumentNumber | CADocumentNumber | 6 |
| KEY | CARepetitionItemNumber | CARepetitionItemNumber | 6 |
| KEY | CASubItemNumber | CASubItemNumber | 6 |
| KEY | CompanyCode | CompanyCode | 6 |
| KEY | ContractAccount | ContractAccount | 3 |
| _AcctAssgmtCat | _AcctAssgmtCat | 1 | |
| _AcctDetnCode | _AcctDetnCode | 1 | |
| _AltvBPForPayment | _AltvBPForPayment | 1 | |
| _ApplArea | _ApplArea | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _BusinessPartner | _BusinessPartner | 3 | |
| _CAHeader | _CAHeader | 1 | |
| _CAHeaderCollvBills | _CAHeaderCollvBills | 1 | |
| _CAHeaderFinalRec | _CAHeaderFinalRec | 1 | |
| _CAPartner | _CAPartner | 3 | |
| _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 | |
| _ClearingStatus | _ClearingStatus | 1 | |
| _ClrgRstrcnCode | _ClrgRstrcnCode | 1 | |
| _CompanyCodeCurrency | _CompanyCodeCurrency | 1 | |
| _CompCode | _CompCode | 1 | |
| _CompCodeCashFlow | _CompCodeCashFlow | 1 | |
| _CompCodePayt | _CompCodePayt | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _Country | _Country | 1 | |
| _Currency | _Currency | 1 | |
| _DbtflOrValAdjmtCode | _DbtflOrValAdjmtCode | 1 | |
| _Division | _Division | 1 | |
| _DocHeader | _DocHeader | 1 | |
| _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 | 3 | |
| _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 | 3 | |
| BusinessPlace | BusinessPlace | 1 | |
| CAAccountAssignment | CAAccountAssignment | 1 | |
| CAAccountAssignmentCategory | CAAccountAssignmentCategory | 1 | |
| CAAccountDeterminationCode | CAAccountDeterminationCode | 2 | |
| CAAdditionalContract | CAAdditionalContract | 1 | |
| CAAdditionalDaysForCashMgmt | CAAdditionalDaysForCashMgmt | 1 | |
| CAAddressOfAltvBPForPayment | CAAddressOfAltvBPForPayment | 1 | |
| CAAltvBPForPayment | CAAltvBPForPayment | 1 | |
| CAAmountInLocalCurrency | CAAmountInLocalCurrency,TransactionAmountInLocalCrcy | 4 | |
| CAAmountInSecondCurrency | CAAmountInSecondCurrency | 1 | |
| CAAmountInThirdCurrency | CAAmountInThirdCurrency | 1 | |
| CAAmountInTransactionCurrency | AmountInTransactionCurrency,CAAmountInTransactionCurrency | 3 | |
| CAApplicationArea | CAApplicationArea | 1 | |
| CABankOfAltvBPForPayment | CABankOfAltvBPForPayment | 1 | |
| CABaseAmountForWithholdingTax | CABaseAmountForWithholdingTax | 1 | |
| CABPItemText | CABPItemText | 1 | |
| CACardOfAltvBPForPayment | CACardOfAltvBPForPayment | 1 | |
| CACashDiscAmountInClearingCrcy | CACashDiscAmountInClearingCrcy | 2 | |
| CACashDiscountDueDate | CACashDiscountDueDate | 1 | |
| CACashDiscountRate | CACashDiscountRate | 1 | |
| CACashFlowAccount | CACashFlowAccount | 1 | |
| CACashFlowCompanyCode | CACashFlowCompanyCode | 1 | |
| CAChangeIsForbidden | CAChangeIsForbidden | 1 | |
| CAClearingAmountInClearingCrcy | CAClearingAmountInClearingCrcy | 1 | |
| CAClearingCurrency | CAClearingCurrency | 2 | |
| CAClearingDate | CAClearingDate | 2 | |
| CAClearingDocumentNumber | CAClearingDocumentNumber | 2 | |
| CAClearingPostingIsReset | CAClearingPostingIsReset | 1 | |
| CAClearingReason | CAClearingReason | 1 | |
| CAClearingRestrictionCode | CAClearingRestrictionCode | 1 | |
| CAClearingStatus | CAClearingStatus | 1 | |
| CACurrentFactoringStatusOfRbl | CACurrentFactoringStatusOfRbl | 1 | |
| CADeferralDate | CADeferralDate | 1 | |
| CADocBPItemTotalAmountInTC | CADocBPItemTotalAmountInTC | 1 | |
| CADocumentNumberOfOriginItem | CADocumentNumberOfOriginItem | 1 | |
| CADocumentOriginCode | CADocumentOriginCode | 3 | |
| CADocumentType | CADocumentType | 2 | |
| CADoubtfulOrValueAdjmtCode | CADoubtfulOrValueAdjmtCode | 1 | |
| CADownPaymentOffsetTaxAccount | CADownPaymentOffsetTaxAccount | 1 | |
| CADownPaymentTaxAccount | CADownPaymentTaxAccount | 1 | |
| CADunningProcedure | CADunningProcedure | 1 | |
| CAEligibleAmountForCshDiscount | CAEligibleAmountForCshDiscount | 1 | |
| CAEndDateOfBillingPeriod | CAEndDateOfBillingPeriod | 1 | |
| CAExchangeRate | CAExchangeRate | 2 | |
| CAFactoringCheckStsForClrgInfo | CAFactoringCheckStsForClrgInfo | 1 | |
| CAFactoringItem | CAFactoringItem | 1 | |
| CAGLPostingAmount | CAGLPostingAmount | 1 | |
| CAGLPostingCurrency | CAGLPostingCurrency | 1 | |
| CAGLPostingTaxAmount | CAGLPostingTaxAmount | 1 | |
| CAGroupingCodeForBPItems | CAGroupingCodeForBPItems | 1 | |
| CAGroupingCodeForTaxItems | CAGroupingCodeForTaxItems | 1 | |
| 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 | 2 | |
| 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,GLAccount | 2 | |
| 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 | 3 | |
| CASubstituteDocumentCategory | CASubstituteDocumentCategory | 1 | |
| CASubstituteDocumentNumber | CASubstituteDocumentNumber | 1 | |
| CASubTransaction | CASubTransaction | 2 | |
| CASupplementaryTaxCode | CASupplementaryTaxCode | 1 | |
| CATaxAmountInClearingCrcy | CATaxAmountInClearingCrcy | 1 | |
| CATaxAmountInLocalCurrency | CATaxAmountInLocalCurrency | 1 | |
| CATaxAmountInSecondCurrency | CATaxAmountInSecondCurrency | 1 | |
| CATaxAmountInThirdCurrency | CATaxAmountInThirdCurrency | 1 | |
| CATaxAmountInTransCurrency | CATaxAmountInTransCurrency | 1 | |
| CATaxAmountIsSetFromExternal | CATaxAmountIsSetFromExternal | 1 | |
| 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 | 2 | |
| CompanyCodeCurrency | CompanyCodeCurrency,LocalCurrency | 4 | |
| ControllingArea | ControllingArea | 1 | |
| Country | CompanyCodeCountry,Country | 2 | |
| Division | Division | 1 | |
| DocumentDate | DocumentDate | 1 | |
| ExchRateIsIndirectQuotation | ExchRateIsIndirectQuotation | 2 | |
| PartnerCompany | PartnerCompany | 2 | |
| PersonnelNumber | PersonnelNumber | 1 | |
| PlannedAmtInTransactionCrcy | PlannedAmtInTransactionCrcy | 1 | |
| PlanningLevel | PlanningLevel | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| Segment | Segment | 3 | |
| SEPAMandateCAInternalID | SEPAMandateCAInternalID | 1 | |
| TaxCode | TaxCode | 2 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TransactionCurrency | TransactionCurrency | 4 | |
| WithholdingTaxCertificate | WithholdingTaxCertificate | 1 | |
| WithholdingTaxCode | WithholdingTaxCode | 1 |
@AccessControl: { authorizationCheck: #MANDATORY,
personalData: { blocking: #REQUIRED,
blockingIndicator: ['_BusinessPartner.IsBusinessPurposeCompleted'] } }
@EndUserText.label: 'Document Business Partner Item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: { modelingPattern: #NONE,
//representativeKey: 'CABPItemNumber',
supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
#SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE ],
usageType: { dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #XXL } }
@VDM.viewType: #BASIC
define view entity I_CADocumentBPItem
as select from dfkkop
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [1..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [0..1] to I_BusinessPartner as _AltvBPForPayment on $projection.CAAltvBPForPayment = _AltvBPForPayment.BusinessPartner
association [0..1] to I_CAAccountAssignmentCategory as _AcctAssgmtCat on $projection.CAAccountAssignmentCategory = _AcctAssgmtCat.CAAccountAssignmentCategory
association [0..1] to I_CAAccountDetnCode as _AcctDetnCode on $projection.CAAccountDeterminationCode = _AcctDetnCode.CAAccountDeterminationCode
association [1..1] to I_CAApplicationArea as _ApplArea on $projection.CAApplicationArea = _ApplArea.CAApplicationArea
association [0..1] to I_CAClearingReason as _ClearingReason on $projection.CAClearingReason = _ClearingReason.CAClearingReason
association [0..1] to I_CAClearingRestrictionCode as _ClrgRstrcnCode on $projection.CAClearingRestrictionCode = _ClrgRstrcnCode.CAClearingRestrictionCode
association [0..1] to I_CAClearingStatus as _ClearingStatus on $projection.CAClearingStatus = _ClearingStatus.CAClearingStatus
association [0..1] to I_CADbtflOrValueAdjmtCode as _DbtflOrValAdjmtCode on $projection.CADoubtfulOrValueAdjmtCode = _DbtflOrValAdjmtCode.CADoubtfulOrValueAdjmtCode
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 [0..1] to I_CADocumentType as _DocType on $projection.CADocumentType = _DocType.CADocumentType
and $projection.CAApplicationArea = _DocType.CAApplicationArea
association [0..1] to I_CADunningProcedure as _DunningProcedure on $projection.CADunningProcedure = _DunningProcedure.CADunningProcedure
association [0..1] to I_CAFactoringClrgCheckStatus as _FctrngClrgChkStatus on $projection.CAFactoringCheckStsForClrgInfo = _FctrngClrgChkStatus.CAFactoringCheckStsForClrgInfo
association [0..1] to I_CAFactoringReceivableStatus as _FactoringRblStatus on $projection.CACurrentFactoringStatusOfRbl = _FactoringRblStatus.CACurrentFactoringStatusOfRbl
association [0..1] to I_CAInterestCode as _InterestCode on $projection.CAInterestCode = _InterestCode.CAInterestCode
association [0..1] to I_CAIntPostingReasonCode as _IntPostingReasonCode on $projection.CAInternalPostingReasonCode = _IntPostingReasonCode.CAInternalPostingReasonCode
association [1..1] to I_CAMainTransaction as _MainTransaction on $projection.CAApplicationArea = _MainTransaction.CAApplicationArea
and $projection.CAMainTransaction = _MainTransaction.CAMainTransaction
association [0..1] to I_CANegativePostingCtrlCode as _NgtvPostingCtrlCode on $projection.CANegativePostingControlCode = _NgtvPostingCtrlCode.CANegativePostingControlCode
association [1..1] to I_CAOriglStstclItemCode as _OriglStstclItemCode on $projection.CAStatisticalCodeOfOriginItem = _OriglStstclItemCode.CAStatisticalCodeOfOriginItem
association [0..1] to I_CAOtherTaxCode as _OtherTaxCode on $projection.CAOtherTaxCode = _OtherTaxCode.CAOtherTaxCode
and $projection.Country = _OtherTaxCode.Country
association [0..1] to I_CAPartnerSettlementStatus as _PrtnSettlementStatus on $projection.CAPartnerSettlementStatus = _PrtnSettlementStatus.CAPartnerSettlementStatus
association [0..1] to I_CAPaymentMethod as _PaytMethod on $projection.Country = _PaytMethod.Country
and $projection.CAPaymentMethod = _PaytMethod.CAPaymentMethod
association [0..1] to I_CAPaytPreNotificationCode as _PaytPreNotifCode on $projection.CAPaymentPreNotificationCode = _PaytPreNotifCode.CAPaymentPreNotificationCode
association [0..1] to I_CAPaytSpecificationCat as _PaytSpecCategory on $projection.CAPaymentSpecificationCategory = _PaytSpecCategory.CAPaymentSpecificationCategory
association [0..1] to I_CAPeriodCode as _PeriodCode on $projection.CAPeriodCode = _PeriodCode.CAPeriodCode
association [0..1] to I_CAProviderContractHeader as _ProviderContract on $projection.CASubApplication = 'P'
and $projection.CAContract = _ProviderContract.CAProviderContract
association [0..1] to I_CARevenueDistrStatus as _CARevnDistrCurSts on $projection.CARevenueDistrCurrentStatus = _CARevnDistrCurSts.CARevenueDistributionStatus
association [0..1] to I_CARevenueDistrStatus as _CARevnDistrLastSts on $projection.CARevenueDistrLastStatus = _CARevnDistrLastSts.CARevenueDistributionStatus
association [0..1] to I_CARoundingItemCode as _CARoundingItemCode on $projection.CARoundingItemCode = _CARoundingItemCode.CARoundingItemCode
association [0..1] to I_CASEPAPreNotifOriginCode as _SEPAPreNotifOrignCd on $projection.CASEPAPreNotifOriginCode = _SEPAPreNotifOrignCd.CASEPAPreNotifOriginCode
association [0..1] to I_CASEPAPreNotifRqmtCode as _SEPAPreNotifRqmtCode on $projection.CASEPAPreNotificationRqmtCode = _SEPAPreNotifRqmtCode.CASEPAPreNotificationRqmtCode
association [0..1] to I_CASubApplication as _CASubApplication on $projection.CASubApplication = _CASubApplication.CASubApplication
association [1..1] to I_CASubTransaction as _SubTransaction on $projection.CAApplicationArea = _SubTransaction.CAApplicationArea
and $projection.CAMainTransaction = _SubTransaction.CAMainTransaction
and $projection.CASubTransaction = _SubTransaction.CASubTransaction
association [0..1] to I_CAWithholdingTaxSupplement as _WhldgTaxSuplmnt on $projection.CAWithholdingTaxSupplement = _WhldgTaxSuplmnt.CAWithholdingTaxSupplement
and $projection.Country = _WhldgTaxSuplmnt.Country
association [0..1] to I_CAWorkflowCheckProcess as _WorkflowCheckProcess on $projection.CAWorkflowCheckProcess = _WorkflowCheckProcess.CAWorkflowCheckProcess
association [0..1] to I_CAWorkflowCheckReason as _WorkflowCheckReason on $projection.CAWorkflowCheckReason = _WorkflowCheckReason.CAWorkflowCheckReason
association [0..1] to I_ChartOfAccounts as _ChartOfAccounts on $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
association [1..1] to I_CompanyCode as _CompCode on $projection.CompanyCode = _CompCode.CompanyCode
association [0..1] to I_CompanyCode as _CompCodePayt on $projection.CAPaymentCompanyCode = _CompCodePayt.CompanyCode
association [0..1] to I_CompanyCode as _CompCodeCashFlow on $projection.CACashFlowCompanyCode = _CompCodeCashFlow.CompanyCode
association [1..1] to I_ContractAccountHeader as _CAHeader on $projection.ContractAccount = _CAHeader.ContractAccount
association [0..1] to I_ContractAccountHeader as _CAHeaderCollvBills on $projection.AltvContractAcctForCollvBills = _CAHeaderCollvBills.ContractAccount
association [0..1] to I_ContractAccountHeader as _CAHeaderFinalRec on $projection.CARevenueDistrFinalRecipient = _CAHeaderFinalRec.ContractAccount
association [1..1] to I_ContractAccountPartner as _CAPartner on $projection.BusinessPartner = _CAPartner.BusinessPartner
and $projection.ContractAccount = _CAPartner.ContractAccount
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..1] to I_Country as _Country on $projection.Country = _Country.Country
association [0..1] to I_Country as _ReceivingCountry on $projection.CAReceivingCountry = _ReceivingCountry.Country
association [0..1] to I_Country as _TaxCountry on $projection.TaxCountry = _TaxCountry.Country
association [1..1] to I_Currency as _Currency on $projection.TransactionCurrency = _Currency.Currency
association [0..1] to I_Currency as _ClearingCurrency on $projection.CAClearingCurrency = _ClearingCurrency.Currency
association [0..1] to I_Currency as _GLPostingCurrency on $projection.CAGLPostingCurrency = _GLPostingCurrency.Currency
association [0..1] to I_Currency as _CompanyCodeCurrency on $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
association [0..1] to I_Division as _Division on $projection.Division = _Division.Division
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 [0..1] to I_Partnercompany as _PartnerCompany on $projection.PartnerCompany = _PartnerCompany.PartnerCompany
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ProfitCenter = _ProfitCenter.ProfitCenter
and $projection.ControllingArea = _ProfitCenter.ControllingArea
association [0..1] to I_Segment as _Segment on $projection.Segment = _Segment.Segment
association [0..1] to I_CAStatisticalItemCode as _StatisticalItemCode on $projection.CAStatisticalItemCode = _StatisticalItemCode.CAStatisticalItemCode
association [0..1] to I_CASubstituteDocCategory as _SubstitDocCategory on $projection.CASubstituteDocumentCategory = _SubstitDocCategory.CASubstituteDocumentCategory
association [0..1] to I_CAWithholdingTaxCat as _CAWithholdingTaxCat on $projection.CAWithholdingTaxCategory = _CAWithholdingTaxCat.CAWithholdingTaxCategory
association [0..1] to I_WithholdingTaxCode as _WithholdingTaxCode on $projection.Country = _WithholdingTaxCode.Country
and $projection.WithholdingTaxCode = _WithholdingTaxCode.WithholdingTaxCode
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 */
@ObjectModel.foreignKey.association: '_DocHeader'
key opbel as CADocumentNumber,
key opupw as CARepetitionItemNumber,
key opupk as CABPItemNumber,
key opupz as CASubItemNumber,
@ObjectModel.foreignKey.association: '_CompCode'
bukrs as CompanyCode,
@ObjectModel.foreignKey.association: '_BusinessArea'
cast(gsber as fis_rbusa preserving type) as BusinessArea,
cast(bupla as farp_bupla preserving type) as BusinessPlace,
@ObjectModel.foreignKey.association: '_Segment'
cast(segment as fb_segment preserving type) as Segment,
@ObjectModel.foreignKey.association: '_ProfitCenter'
cast(prctr as fis_prctr preserving type) as ProfitCenter,
@ObjectModel.foreignKey.association: '_Division'
cast(spart as spart preserving type) as Division,
pernr as PersonnelNumber,
@ObjectModel.foreignKey.association: '_PartnerCompany'
cast(vbund as fis_rassc preserving type) as PartnerCompany,
@ObjectModel.foreignKey.association: '_BusinessPartner'
gpart as BusinessPartner,
vtref as CAContract,
vtpos as CAProviderContractItemNumber,
vtre2 as CAAdditionalContract,
@ObjectModel.foreignKey.association: '_CAHeader'
vkont as ContractAccount,
@ObjectModel.foreignKey.association: '_CASubApplication'
subap as CASubApplication,
@ObjectModel.foreignKey.association: '_CAHeaderCollvBills'
abwkt as AltvContractAcctForCollvBills,
@ObjectModel.foreignKey.association: '_ReconAccount'
hkont as CAReconciliationAccount,
/* posting attributes */
@ObjectModel.foreignKey.association: '_ApplArea'
applk as CAApplicationArea,
@ObjectModel.foreignKey.association: '_MainTransaction'
hvorg as CAMainTransaction,
@ObjectModel.foreignKey.association: '_SubTransaction'
tvorg as CASubTransaction,
@ObjectModel.foreignKey.association: '_AcctDetnCode'
kofiz as CAAccountDeterminationCode,
@ObjectModel.foreignKey.association: '_DbtflOrValAdjmtCode'
infoz as CADoubtfulOrValueAdjmtCode,
@ObjectModel.foreignKey.association: '_AcctAssgmtCat'
kontt as CAAccountAssignmentCategory,
kontl as CAAccountAssignment,
@ObjectModel.foreignKey.association: '_DocType'
blart as CADocumentType,
xanza as CAIsDownPaymentRequest,
@Semantics.booleanIndicator: true
verkz as CAItemIsOnlyForSettlement,
@ObjectModel.foreignKey.association: '_StatisticalItemCode'
stakz as CAStatisticalItemCode,
optxt as CABPItemText,
whang as CANumberOfRepetitionItems,
whgrp as CARepetitionGroup,
abrzu as CAStartDateOfBillingPeriod,
abrzo as CAEndDateOfBillingPeriod,
grkey as CAGroupingCodeForBPItems,
@ObjectModel.foreignKey.association: '_PeriodCode'
persl as CAPeriodCode,
xaesp as CAChangeIsForbidden,
@ObjectModel.foreignKey.association: '_InterestCode'
ikey as CAInterestCode,
@ObjectModel.foreignKey.association: '_CARoundingItemCode'
rndps as CARoundingItemCode,
@ObjectModel.foreignKey.association: '_ReceivingCountry'
landl as CAReceivingCountry,
@ObjectModel.foreignKey.association: '_IntPostingReasonCode'
intbu as CAInternalPostingReasonCode,
@ObjectModel.foreignKey.association: '_WorkflowCheckReason'
c4eye as CAWorkflowCheckReason,
@ObjectModel.foreignKey.association: '_WorkflowCheckProcess'
c4eyp as CAWorkflowCheckProcess,
@ObjectModel.foreignKey.association: '_NgtvPostingCtrlCode'
negbu as CANegativePostingControlCode,
@ObjectModel.foreignKey.association: '_PrtnSettlementStatus'
ptitm as CAPartnerSettlementStatus,
@Semantics.booleanIndicator: true
palix as CAIsPartOfJointLiability,
herkf_kk as CADocumentOriginCode,
/* document references */
@ObjectModel.foreignKey.association: '_SubstitDocHeader'
cast(abwbl as abwbl_gfn_kk preserving type) as CASubstituteDocumentNumber,
@ObjectModel.foreignKey.association: '_SubstitDocCategory'
abwtp as CASubstituteDocumentCategory,
@ObjectModel.foreignKey.association: '_OriglStstclItemCode'
astkz as CAStatisticalCodeOfOriginItem,
@ObjectModel.foreignKey.association: '_OriginDocHeader'
asblg as CADocumentNumberOfOriginItem,
xblnr as CAReferenceDocument,
/* dates and amounts */
bldat as DocumentDate,
budat as CAPostingDate,
faedn as CANetDueDate,
studt as CADeferralDate,
@ObjectModel.foreignKey.association: '_Currency'
waers as TransactionCurrency,
@ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
_CompCode.Currency as CompanyCodeCurrency,
//kursf as CAExchangeRate, ////replace due to conversion exit EXCRT
cast( abs( kursf ) as fis_absolute_exchangerate preserving type ) as CAExchangeRate,
cast( case when kursf < 0
then 'X'
else ' '
end as fis_indirect_quotation preserving type ) as ExchRateIsIndirectQuotation,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
betrh as CAAmountInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
betrw as CAAmountInTransactionCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency' // AdditionaCurrency1 would be right, but too many dependant tables
betr2 as CAAmountInSecondCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency' // AdditionaCurrency2 would be right, but too many dependant tables
betr3 as CAAmountInThirdCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
oriop as CADocBPItemTotalAmountInTC,
/* cash discount */
faeds as CACashDiscountDueDate,
sktpz as CACashDiscountRate,
@Semantics.amount.currencyCode: 'TransactionCurrency'
cast(skfbt as skfbt_gfn_kk preserving type) as CAEligibleAmountForCshDiscount,
/* tax data */
cast(mwskz as fis_mwskz preserving type) as TaxCode,
mwszkz as CASupplementaryTaxCode,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
sbeth as CATaxAmountInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
sbetw as CATaxAmountInTransCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency' // AdditionaCurrency1 would be right, but too many dependant tables
sbet2 as CATaxAmountInSecondCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency' // AdditionaCurrency2 would be right, but too many dependant tables
sbet3 as CATaxAmountInThirdCurrency,
@ObjectModel.foreignKey.association: '_TaxAccount'
mwsko as CADownPaymentTaxAccount,
@ObjectModel.foreignKey.association: '_OffsetTaxAccount'
mwvko as CADownPaymentOffsetTaxAccount,
cast(txjcd as fis_txjcd preserving type) as TaxJurisdiction,
txdat as CATaxDate,
@ObjectModel.foreignKey.association: '_WithholdingTaxCode'
cast(qsskz as fac_qsskz preserving type) as WithholdingTaxCode,
@ObjectModel.foreignKey.association: '_WhldgTaxSuplmnt'
cast(qssew as qssew_gfn_kk preserving type) as CAWithholdingTaxSupplement,
@ObjectModel.foreignKey.association: '_CAWithholdingTaxCat'
cast(qsptp as qsptp_gfn_kk preserving type) as CAWithholdingTaxCategory,
@Semantics.amount.currencyCode: 'TransactionCurrency'
qsshb as CABaseAmountForWithholdingTax,
@Semantics.amount.currencyCode: 'TransactionCurrency'
cast(qbshb as qbshb_gfn_kk preserving type) as CAWithholdingTaxAmount,
qsprz as CAWithholdingTaxPercentage,
cast(qsznr as fis_wtcert preserving type) as WithholdingTaxCertificate,
@ObjectModel.foreignKey.association: '_OtherTaxCode'
cast(strkz as strkz_gfn_kk preserving type) as CAOtherTaxCode,
txgrp as CAGroupingCodeForTaxItems,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
cast(sctax as sctax_gfn_kk preserving type) as CATaxPortionInLocalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
sttax as CATaxPortionInTransCurrency,
xustpd as CATaxIsCalculatedExternally,
inttx as CATaxAmountIsSetFromExternal,
@ObjectModel.foreignKey.association: '_TaxCountry'
tax_country as TaxCountry,
taxc_factor as TransToTaxCntryCrcyCnvrsnFctr,
/* payment data */
@ObjectModel.foreignKey.association: '_PaytMethod'
pymet as CAPaymentMethod,
@ObjectModel.foreignKey.association: '_CompCodePayt'
pybuk as CAPaymentCompanyCode,
pygrp as CAGroupingForPayment,
@ObjectModel.foreignKey.association: '_PaytSpecCategory'
pdtyp as CAPaymentSpecificationCategory,
/* clearing data */
@ObjectModel.foreignKey.association: '_ClearingStatus'
augst as CAClearingStatus,
augdt as CAClearingDate,
@ObjectModel.foreignKey.association: '_ClearingDocHeader'
augbl as CAClearingDocumentNumber,
augbd as CAPostingDateOfClearingDoc,
@ObjectModel.foreignKey.association: '_ClearingReason'
augrd as CAClearingReason,
@ObjectModel.foreignKey.association: '_ClearingCurrency'
augwa as CAClearingCurrency,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
augbt as CAClearingAmountInClearingCrcy,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
augbs as CATaxAmountInClearingCrcy,
@Semantics.amount.currencyCode: 'CAClearingCurrency'
augsk as CACashDiscAmountInClearingCrcy,
augvd as CAValueDateForClearing,
@ObjectModel.foreignKey.association: '_ClrgRstrcnCode'
augrs as CAClearingRestrictionCode,
xragl as CAClearingPostingIsReset,
augob as CAItemIsWithdrawn,
/* dunning and collections */
xmanl as CAItemIsExcludedFromDunning,
@ObjectModel.foreignKey.association: '_DunningProcedure'
mahnv as CADunningProcedure,
inkps as CAGrpgCodeForTransfToCollAgcy,
xcolc as CAIsIncludedInCollectionCase,
/* cash management data */
fdgrp as CashPlanningGroup,
cast(fdlev as fdlev preserving type) as PlanningLevel,
fdztg as CAAdditionalDaysForCashMgmt,
@Semantics.amount.currencyCode: 'TransactionCurrency'
cast(fdwbt as fis_fdwbt) as PlannedAmtInTransactionCrcy,
/* alternative business partner for payment */
@ObjectModel.foreignKey.association: '_AltvBPForPayment'
emgpa as CAAltvBPForPayment,
embvt as CABankOfAltvBPForPayment,
emadr as CAAddressOfAltvBPForPayment,
emcrd as CACardOfAltvBPForPayment,
emmnd as SEPAMandateCAInternalID,
/* GL data */
@ObjectModel.foreignKey.association: '_GLPostingCurrency'
pswsl as CAGLPostingCurrency,
@Semantics.amount.currencyCode: 'CAGLPostingCurrency'
pswbt as CAGLPostingAmount,
@Semantics.amount.currencyCode: 'CAGLPostingCurrency'
pswtx as CAGLPostingTaxAmount,
xeiph as CAIsSeparateLineItemInGL,
/* cash flow data */
xcsha as CAIsCashFlowItem,
@ObjectModel.foreignKey.association: '_CashFlowAccount'
reacc as CACashFlowAccount,
@ObjectModel.foreignKey.association: '_CompCodeCashFlow'
rebuk as CACashFlowCompanyCode,
/* pre notification data */
@ObjectModel.foreignKey.association: '_PaytPreNotifCode'
xpyor as CAPaymentPreNotificationCode,
pnnum as CASEPAPreNotificationNumber,
@ObjectModel.foreignKey.association: '_SEPAPreNotifOrignCd'
pnhkf as CASEPAPreNotifOriginCode,
pnexd as CASEPAPreNotifExecutionDate,
@ObjectModel.foreignKey.association: '_SEPAPreNotifRqmtCode'
pnctr as CASEPAPreNotificationRqmtCode,
/* revenue distribution data */
@ObjectModel.foreignKey.association: '_CAHeaderFinalRec'
finre as CARevenueDistrFinalRecipient,
@ObjectModel.foreignKey.association: '_CARevnDistrCurSts'
rdsta as CARevenueDistrCurrentStatus,
@ObjectModel.foreignKey.association: '_CARevnDistrLastSts'
rdstb as CARevenueDistrLastStatus,
/* Factoring */
@ObjectModel.foreignKey.association: '_FactoringRblStatus'
fasta as CACurrentFactoringStatusOfRbl,
@ObjectModel.foreignKey.association: '_FctrngClrgChkStatus'
pasta as CAFactoringCheckStsForClrgInfo,
opupf as CAFactoringItem,
/* Additional data */
@ObjectModel.foreignKey.association: '_ControllingArea'
_CompCode.ControllingArea as ControllingArea,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
_CompCode.ChartOfAccounts as ChartOfAccounts,
@ObjectModel.foreignKey.association: '_Country'
_CompCode.Country as Country,
/* Associations */
_AcctAssgmtCat,
_AcctDetnCode,
_AltvBPForPayment,
_ApplArea,
_BusinessArea,
_BusinessPartner,
_CAHeader,
_CAHeaderCollvBills,
_CAHeaderFinalRec,
_CAPartner,
_CARevnDistrCurSts,
_CARevnDistrLastSts,
_CARoundingItemCode,
_SEPAPreNotifOrignCd,
_SEPAPreNotifRqmtCode,
_CashFlowAccount,
_CASubApplication,
_ClearingCurrency,
_ClearingDocHeader,
_ClearingReason,
_ClearingStatus,
_ClrgRstrcnCode,
_Currency,
_CompanyCodeCurrency,
_CompCode,
_CompCodeCashFlow,
_CompCodePayt,
_ControllingArea,
_ChartOfAccounts,
_Country,
_DbtflOrValAdjmtCode,
_Division,
_DocHeader,
_DocType,
_DunningProcedure,
_FactoringRblStatus,
_FctrngClrgChkStatus,
_GLPostingCurrency,
_InterestCode,
_IntPostingReasonCode,
_MainTransaction,
_NgtvPostingCtrlCode,
_OffsetTaxAccount,
_OriginDocHeader,
_OriglStstclItemCode,
_OtherTaxCode,
_PartnerCompany,
_PaytMethod,
_PaytPreNotifCode,
_PaytSpecCategory,
_PeriodCode,
_ProfitCenter,
_ProviderContract,
_PrtnSettlementStatus,
_ReceivingCountry,
_ReconAccount,
_Segment,
_StatisticalItemCode,
_SubstitDocCategory,
_SubstitDocHeader,
_SubTransaction,
_TaxAccount,
_TaxCountry,
_WhldgTaxSuplmnt,
_CAWithholdingTaxCat,
_WithholdingTaxCode,
_WorkflowCheckProcess,
_WorkflowCheckReason
}