CDS标准视图:一次性账户的客户行项目 I_ONETIMEACCOUNTCUSTOMER
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_BankStatement44.CDS标准视图:银行对账单行项目 I_BankStatementItem45.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_ARJrnlEntrItmAgingGrid
55.CDS标准视图:一次性账户的客户行项目 I_ONETIMEACCOUNTCUSTOMER
视图名称:一次性账户的客户行项目
视图类型:基础#
视图代码:#
点击查看代码
@EndUserText.label: 'One-Time Account Data for Customer Items'
@Analytics: { dataCategory:#DIMENSION}
@Analytics.internalName:#LOCAL
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IONETIMECUSTOMER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.buffering.type: #NONE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:#MIXED
@ObjectModel.representativeKey: 'AccountingDocumentItem'
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE , #CDS_MODELING_ASSOCIATION_TARGET ]
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AccessControl.privilegedAssociations: ['_Address']
define view I_OneTimeAccountCustomer
as select from bsec
association [1..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [1..1] to I_JournalEntry as _JournalEntry on $projection.CompanyCode = _JournalEntry.CompanyCode
and $projection.AccountingDocument = _JournalEntry.AccountingDocument
and $projection.FiscalYear = _JournalEntry.FiscalYear
association [0..1] to I_FiscalYearForCompanyCode as _FiscalYear on $projection.FiscalYear = _FiscalYear.FiscalYear
and $projection.CompanyCode = _FiscalYear.CompanyCode
association [0..1] to I_Address as _Address on $projection.AddressID = _Address.AddressID
association [1..1] to I_OperationalAcctgDocItem as _OperationalAcctgDocItem on _OperationalAcctgDocItem.CompanyCode = $projection.CompanyCode
and _OperationalAcctgDocItem.AccountingDocument = $projection.AccountingDocument
and _OperationalAcctgDocItem.FiscalYear = $projection.FiscalYear
and _OperationalAcctgDocItem.AccountingDocumentItem = $projection.AccountingDocumentItem
association [1..1] to I_CustomerCompany as _CustomerCompany on _CustomerCompany.CompanyCode = $projection.CompanyCode
and _CustomerCompany.Customer = $projection.Customer
{
@ObjectModel.foreignKey.association: '_CompanyCode'
key bsec.bukrs as CompanyCode,
@ObjectModel.foreignKey.association: '_JournalEntry'
key bsec.belnr as AccountingDocument,
@ObjectModel.foreignKey.association: '_FiscalYear'
key bsec.gjahr as FiscalYear,
key bsec.buzei as AccountingDocumentItem,
cast(bsec.name1 as ad_name1) as BusinessPartnerName1,
cast(bsec.name2 as ad_name2) as BusinessPartnerName2,
cast(bsec.name3 as ad_name3) as BusinessPartnerName3,
cast(bsec.name4 as ad_name4) as BusinessPartnerName4,
bsec.land1 as Country,
cast(bsec.ort01 as ad_city1) as CityName,
bsec.pfach as POBox,
bsec.pstl2 as POBoxPostalCode,
bsec.pstlz as PostalCode,
bsec.regio as Region,
bsec.stcd1 as TaxID1,
bsec.stcd2 as TaxID2,
bsec.stcd3 as TaxID3,
bsec.stcd4 as TaxID4,
bsec.stcd5 as TaxID5,
bsec.stras as StreetAddressName,
bsec.stcdt as TaxNumberType,
bsec.adrnr as AddressID,
bsec.intad as AccountingClerkInternetAddress,
cast(bsec.stkzn as bu_natural_person) as IsNaturalPerson,
bsec.begru as AuthorizationGroup,
case bsec.xcpdk when 'X' then cast('' as farp_isalternativepayer) else cast ('X' as farp_isalternativepayer)
end as PayerIsAlternativePayer,
_OperationalAcctgDocItem.Customer as Customer,
_CompanyCode,
_JournalEntry,
_FiscalYear,
_Address,
_OperationalAcctgDocItem,
_CustomerCompany
}
where
_OperationalAcctgDocItem.FinancialAccountType = 'D'
事务代码:一次性客户的行项目#
视图结构:#
字段名称 | 技术名称 |
---|---|
公司代码 | COMPANYCODE |
凭证编号 | ACCOUNTINGDOCUMENT |
会计年度 | FISCALYEAR |
项目 | ACCOUNTINGDOCUMENTITEM |
名称 | BUSINESSPARTNERNAME1 |
名称 2 | BUSINESSPARTNERNAME2 |
名称 3 | BUSINESSPARTNERNAME3 |
名称 4 | BUSINESSPARTNERNAME4 |
国家/地区 | COUNTRY |
城市 | CITYNAME |
邮政信箱 | POBOX |
邮箱邮政编码 | POBOXPOSTALCODE |
邮政编码 | POSTALCODE |
地区 | REGION |
税号 1 | TAXID1 |
税号 2 | TAXID2 |
税号3 | TAXID3 |
税号4 | TAXID4 |
税号 5 | TAXID5 |
街道 | STREETADDRESSNAME |
税号类型 | TAXNUMBERTYPE |
地址 | ADDRESSID |
员工的互联网 | ACCOUNTINGCLERKINTERNETADDRESS |
自然人 | ISNATURALPERSON |
权限组 | AUTHORIZATIONGROUP |
是备选付款方 | PAYERISALTERNATIVEPAYER |
客户 | CUSTOMER |
作者:观兴
出处:https://www.cnblogs.com/guanxing/p/18663680
版权:本作品采用「署名-非商业性使用-相同方式共享 4.0 国际」许可协议进行许可。
转载需本人同意,未经同意转载视同接受稿费2元/字
本文来自博客园,作者:观兴,转载请注明原文链接:https://www.cnblogs.com/guanxing/p/18663680
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 推荐几款开源且免费的 .NET MAUI 组件库
· 实操Deepseek接入个人知识库
· 易语言 —— 开山篇
· 一个费力不讨好的项目,让我损失了近一半的绩效!