CDS标准视图:银行对账单行项目 I_BankStatementItem
1.CDS标准视图:日期迁移视图 I_ShiftedCalendarDate2.CDS标准视图:设备 I_Equipment3.CDS标准视图:功能位置 I_FunctionalLocation4.CDS标准视图:设备功能位置变更历史 I_EQUIPINSTALLATIONHISTORYC5.CDS标准视图:设备描述 I_EquipmentText6.CDS标准视图:设备信息 I_EquipmentData7.CDS标准视图:维护活动类型 I_MaintenanceActivityType8.CDS标准视图:PM通知单 I_LocationAnalysisCube9.CDS标准视图:ABC标识文本 I_ABCIndicatorText10.CDS标准视图:技术对象类别文本 I_TechnicalObjectTypeText11.CDS标准视图:功能位置可用标签 I_FUNCNLLOCALTERNATIVELABEL12.CDS标准视图:功能位置种类描述 I_FlocCategoryText13.CDS标准视图:功能位置描述 I_FunctionalLocationText14.CDS标准视图:功能位置信息 I_FunctionalLocationData15.CDS标准视图:维修工单工艺数据 I_MAINTORDEROPERATIONDATA16.CDS标准视图:有技术对象的维修工单 I_MAINTORDERTECHOBJCUBE17.CDS标准视图:维护通知任务数据 I_MaintNotificationTaskData18.CDS标准视图:维护通知原因数据 I_MaintNotificationCauseData19.CDS标准视图:维护通知活动信息 I_MaintNotificationActyData20.CDS标准视图:维护计划数据 C_MaintenancePlanDEX21.CDS标准视图:维护计划 I_MaintenancePlanBasic22.CDS标准视图:维护项目数据 C_MaintenanceItemDEX23.CDS标准视图:维护活动类型描述 I_MaintenanceActivityTypeText24.CDS标准视图:技术对象检验级别 I_TechObjInspectionLevelCode25.CDS标准视图:技术对象检验级别描述 I_TechObjInspectionLevelText26.CDS标准视图:维护通知数据 I_PMNotifMaintenanceData27.CDS标准视图:维修工单实际成本数据 I_MaintOrderActualCostDataCube28.CDS标准视图:维护任务清单数据 I_MaintenanceTaskListData29.CDS标准视图:维护计划员组 I_MAINTENANCEPLANNERGROUP30.CDS标准视图:分配到任务清单的维护包数据 I_PckgTaskListOpalLocData31.CDS标准视图:维护包描述 I_MaintPackageTextData32.CDS标准视图:维护包数据 I_MaintenancePackageData33.CDS标准视图:优先级描述数据 I_GenericPriorityTextData34.CDS标准视图:优先级数据 I_GenericPriorityData35.CDS标准视图:测量文档数据 I_MeasurementDocumentData36.CDS标准视图:测量点数据 I_MeasuringPointData37.CDS标准视图:维护策略描述 I_MaintStrategyTextData38.CDS标准视图:维护策略数据 I_MaintenanceStrategyData39.CDS标准视图:安排维护计划的调用 I_MAINTENANCEPLANSCHEDULE40.CDS标准视图:付款锁定原因 I_PaymentBlockingReason41.CDS标准视图:付款锁定原因描述 I_PaymentBlockingReasonText42.CDS标准视图:会计员 I_AccountingClerk43.CDS标准视图:银行对账单抬头 I_BankStatement
44.CDS标准视图:银行对账单行项目 I_BankStatementItem
45.CDS标准视图:催款范围 I_DunningArea46.CDS标准视图:催款范围描述 I_DunningAreaText47.CDS标准视图:催款冻结 I_DunningBlockingReasonCode48.CDS标准视图:催款冻结描述 I_DunningBlockingReasonText49.CDS标准视图:催款代码 I_DunningKey50.CDS标准视图:催款级别分配 I_DunningLevelDistribution51.CDS标准视图:预期应收 I_FutureAccountsReceivables52.CDS标准视图:总计应收款 I_TotalAccountsReceivables53.CDS标准视图:销售变现天数 I_DaysSalesOutstanding54.CDS标准视图:应收账龄表 I_ARJrnlEntrItmAgingGrid55.CDS标准视图:一次性账户的客户行项目 I_ONETIMEACCOUNTCUSTOMER视图名称:银行对账单行项目 I_BankStatementItem
视图类型:基础视图#
视图代码:#
点击查看代码
@AbapCatalog.sqlViewName: 'IBANKSTATMENTITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Items of a bank statement'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities:[ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
define view I_BankStatementItem
as select from P_Arbanktransactiondocitem_06 as BankStmtItem
// get company code from febko
inner join P_Arbanktransactiondoc_02 as BankStmtHeader on BankStmtItem.StatementShortID = BankStmtHeader.StatementShortID
association [0..1] to I_Arbsitmemolinewithorig as _MemoLine on $projection.BankStatementShortID = _MemoLine.BankStatementShortID
and $projection.BankStatementItem = _MemoLine.BankStatementItem
association [0..1] to I_Currency as _Currency on _Currency.Currency = $projection.TransactionCurrency
association [0..1] to I_Currency as _OriginalCurrency on _OriginalCurrency.Currency = $projection.OriginalCurrency
{
key BankStmtItem.StatementShortID as BankStatementShortID,
key BankStmtItem.StatementItem as BankStatementItem,
BankStmtHeader.CompanyCode as CompanyCode,
cast ( BankStmtItem.PostingRule as farp_vgint ) as BankStatementPostingRule,
cast ( BankStmtItem.PaymentTransaction as farp_vorgc ) as PaymentTransaction,
BankStmtItem.InterpretationAlgorithm,
cast (_MemoLine.MemoLine as far_memo_line ) as MemoLine,
cast ( BankStmtItem.ValueDate as farp_valut ) as ValueDate,
cast ( BankStmtItem.BankPostingDate as farp_bvdat) as BankPostingDate,
BankStmtItem.PostingDate,
BankStmtItem.ValueDateTime,
BankStmtItem.TransactionCurrency,
BankStmtItem.OriginalCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
case BankStmtItem.DebitCreditCode
when 'D' then - abs(BankStmtItem.AmountInAccountCurrency)
when 'S' then - abs(BankStmtItem.AmountInAccountCurrency)
else BankStmtItem.AmountInAccountCurrency
end as AmountInTransactionCurrency,
@Semantics.amount.currencyCode: 'OriginalCurrency'
cast ( case BankStmtItem.DebitCreditCode
when 'D' then - abs(BankStmtItem.ForeignCurrencyAmount)
when 'S' then - abs(BankStmtItem.ForeignCurrencyAmount)
else BankStmtItem.ForeignCurrencyAmount
end as farp_fwbtr ) as AmountInOriginalCurrency,
cast ( BankStmtItem.ExchangeRate as far_curr_rate ) as ExchangeRate,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BankStmtItem.FeeAmountInTransactionCrcy,
@Semantics.amount.currencyCode: 'OriginalCurrency'
cast ( BankStmtItem.FeeAmountInOriginalCrcy as farp_spesf ) as FeeAmountInOriginalCrcy,
cast ( case when BankStmtItem.PaymentAdviceAccountType = 'K'
then BankStmtItem.PaymentAdviceAccount
else '' end as lifnr ) as Supplier,
cast ( case when BankStmtItem.PaymentAdviceAccountType = 'D'
then BankStmtItem.PaymentAdviceAccount
else '' end as kunnr ) as Customer,
cast ( case when BankStmtItem.PaymentAdviceAccountType = 'S'
then BankStmtItem.PaymentAdviceAccount
else '' end as farp_hkont ) as GLAccount,
cast ( BankStmtItem.BusinessPartnerName as farp_partn ) as BusinessPartnerName,
cast ( BankStmtItem.PaymentManualTransacType as far_vgman ) as PaymentManualTransacType,
cast ( BankStmtItem.PaymentExternalTransacType as farp_vgext ) as PaymentExternalTransacType,
BankStmtItem.PaymentAdvice,
case when BankStmtItem.CheckType = 'C' and BankStmtItem.CheckNumber is not initial then BankStmtItem.CheckNumber
when BankStmtItem.CheckType = 'C' and BankStmtItem.CheckNumber is initial then BankStmtItem.Cheque
else ''
end as Cheque,
cast ( case when BankStmtItem.CheckType = 'D' and BankStmtItem.CheckNumber is not initial then BankStmtItem.CheckNumber
when BankStmtItem.CheckType = 'D' and BankStmtItem.CheckNumber is initial then BankStmtItem.Cheque
else ''
end as far_chect ) as PaymentMediumReference,
cast ( case when BankStmtItem.CheckType = '' and BankStmtItem.CheckNumber is not initial then BankStmtItem.CheckNumber
when BankStmtItem.CheckType = '' and BankStmtItem.CheckNumber is initial then BankStmtItem.Cheque
else ''
end as far_chect_orig ) as CustomerReferenceNumber,
cast ( BankStmtItem.BankLedgerDocument as farp_belnr_bank_ledger ) as BankLedgerDocument,
cast ( BankStmtItem.SubledgerDocument as farp_nbbln ) as SubledgerDocument,
cast ( BankStmtItem.BankLedgerOnAccountDocument as farp_ak1bl ) as BankLedgerOnAccountDocument,
cast ( BankStmtItem.SubledgerOnAccountDocument as farp_akbln ) as SubledgerOnAccountDocument,
BankStmtItem.FiscalYear,
cast ( BankStmtItem.PartnerBankCountry as farp_pabks ) as PartnerBankCountry,
cast ( BankStmtItem.PartnerBank as farp_pablz ) as PartnerBank,
cast ( BankStmtItem.PartnerBankSWIFTCode as paswi_eb) as PartnerBankSWIFTCode,
cast ( BankStmtItem.PartnerBankAccount as farp_pakto ) as PartnerBankAccount,
BankStmtItem.PartnerBankIBAN,
BankStmtItem.DocumentItemText,
cast ( BankStmtItem.BankReference as farp_vgref ) as BankReference,
BankStmtItem.IsCompleted,
_Currency,
_OriginalCurrency
}
事务代码:#
视图结构:#
字段名称 | 技术名称 |
---|---|
短代码 | BANKSTATEMENTSHORTID |
备忘记录号码 | BANKSTATEMENTITEM |
公司代码 | COMPANYCODE |
过账规则 | BANKSTATEMENTPOSTINGRULE |
外部付款交易 | PAYMENTTRANSACTION |
解释算法 | INTERPRETATIONALGORITHM |
备注行 | MEMOLINE |
起息日 | VALUEDATE |
对账单过账日期 | BANKPOSTINGDATE |
过帐日期 | POSTINGDATE |
计值日期时间 | VALUEDATETIME |
帐户货币 | TRANSACTIONCURRENCY |
外币 | ORIGINALCURRENCY |
金额 | AMOUNTINTRANSACTIONCURRENCY |
付款金额 | AMOUNTINORIGINALCURRENCY |
汇率 | EXCHANGERATE |
科目费用 | FEEAMOUNTINTRANSACTIONCRCY |
付款货币费用 | FEEAMOUNTINORIGINALCRCY |
供应商编号 | SUPPLIER |
客户 | CUSTOMER |
总账科目 | GLACCOUNT |
合作伙伴名称 | BUSINESSPARTNERNAME |
手动交易 | PAYMENTMANUALTRANSACTYPE |
外部业务 | PAYMENTEXTERNALTRANSACTYPE |
付款通知编号 | PAYMENTADVICE |
支票号 | CHEQUE |
付款媒介参考 | PAYMENTMEDIUMREFERENCE |
客户参考编号 | CUSTOMERREFERENCENUMBER |
银行分类账凭证编号 | BANKLEDGERDOCUMENT |
明细分类账凭证编号 | SUBLEDGERDOCUMENT |
科目凭证的银行分类账 | BANKLEDGERONACCOUNTDOCUMENT |
科目凭证的明细分类账 | SUBLEDGERONACCOUNTDOCUMENT |
会计年度 | FISCALYEAR |
合作伙伴银行 C/R | PARTNERBANKCOUNTRY |
合作伙伴银行代码 | PARTNERBANK |
合作伙伴 SWIFT | PARTNERBANKSWIFTCODE |
合作伙伴银行账户 | PARTNERBANKACCOUNT |
合作伙伴IBAN | PARTNERBANKIBAN |
文本 | DOCUMENTITEMTEXT |
项目参考 | BANKREFERENCE |
行项目完成 | ISCOMPLETED |
作者:观兴
出处:https://www.cnblogs.com/guanxing/p/18662165
版权:本作品采用「署名-非商业性使用-相同方式共享 4.0 国际」许可协议进行许可。
转载需本人同意,未经同意转载视同接受稿费2元/字
本文来自博客园,作者:观兴,转载请注明原文链接:https://www.cnblogs.com/guanxing/p/18662165
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
· 上周热点回顾(2.17-2.23)