1.共用CDS
- I_CALENDARDATE 日期日历
2.MM模板标准CDS
2.1.采购订单CDS
实际 使用可参看I_PurchaseOrderTP_2
- R_PurchasingDocument 相当于EKKO数据
- R_PurchasingDocumentItem 相当于EKPO数据
- I_PurgDocScheduleLine 采购计划行，EKET
- I_Material 物料主数据
- I_PurchasingDocumentType 采购订单类型
- I_Supplier 供应商代码
- I_CompanyCode 公司代码
- I_CompanyCode 操作用户
- I_Currency 货币
- I_UnitOfMeasure 数量单位
- I_Plant 工厂
- I_StorageLocation 存储地点
- I_Language 语言
- I_TaxCalculationProcedure 税码
- I_Purchaserequisitionitem 价格条件EBAN
3.会计模板常用
标准BSEG明细可参看FIN_SUBVAL_JOURNALENTRYITEM
4.CDS常用搜索帮助
4.1.采购订单
|
1 2 3 4 5 6 7 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_PurchasingDocumentStdVH', element: 'PurchasingDocument' } }] @ObjectModel.foreignKey.association: '_PurchasingDocument' ebeln as PurchasingDocument, @Consumption.valueHelpDefinition: [ { entity: { name: 'I_PurchasingDocumentItemStdVH', element: 'PurchasingDocumentItem' } }] ebelp as PurchasingDocumentItem, // |
4.2.物料搜索帮助
|
1 2 3 4 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MaterialVH', element: 'Material' } }] |
4.3.产品（商品）搜索帮助
|
1 |
@Consumption.valueHelpDefinition: [{ entity: {name:'I_ProductStdVH' ,element: 'Product' } }] |
4.4.工厂物料搜索帮助
此例子的搜索帮助，中会把当前的工厂WERKS传入作为查询参数
|
1 2 3 4 5 6 7 |
@ObjectModel.text.association: '_MaterialText' @Consumption.valueHelpDefinition: [{ entity: {name:'I_MaterialPlant' ,element: 'Material' } , additionalBinding: [{ element: 'Plant', localElement: 'Werks' }]}] _po.matnr as Matnr, @Consumption.valueHelpDefinition: [{ entity: {name:'I_PlantStdVH' ,element: 'Plant' } }] _po.werks as Werks, |
4.5.工厂产品搜索帮助
|
1 2 3 4 5 6 |
@Consumption.valueHelpDefinition: [{ entity: {name:'I_ProductPlantStdVH' ,element: 'Product' } , additionalBinding: [{ element: 'Plant', localElement: 'Werks' }]}] _po.matnr as Matnr, @Consumption.valueHelpDefinition: [{ entity: {name:'I_PlantStdVH' ,element: 'Plant' } }] _po.werks as Werks, |
4.6.工厂搜索帮助
|
1 |
@Consumption.valueHelpDefinition: [{ entity: {name:'I_PlantStdVH' ,element: 'Plant' } }] |
4.7.货币搜索帮助
|
1 2 3 4 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_Currency', element: 'Currency' } }] |
4.8.数量单位搜索帮助
|
1 2 3 4 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_UnitOfMeasure', element: 'UnitOfMeasure,' } }] |
4.9.公司搜索帮助
|
1 2 3 4 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeVH', element: 'CompanyCode' } }] |
4.10.供应商搜索帮助
|
1 2 3 4 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_Supplier', element: 'Supplier' } }] |
4.11.利润中心
|
1 2 3 4 5 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProfitCenterStdVH', element: 'ProfitCenter' } }] prctr as ProfitCenter, // |
4.12.摊回标识
|
1 2 3 4 5 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_JointVentureRecoveryStdVH', element: 'JointVentureRecoveryCode' } }] recid as JointVentureCostRecoveryCode, // |
4.13.开票标识
|
1 2 3 4 5 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_JointVentureBillingCode', element: 'JointVentureBillingType' } }] bseg.btype as JointVentureBillingType, |
4.14.税务管辖权
|
1 2 3 4 5 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_TaxJurisdiction', element: 'TaxJurisdiction' } }] bseg.txjcd as TaxJurisdiction, // |
4.15.合作伙伴利润中心
|
1 2 3 4 5 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProfitCenterStdVH', element: 'ProfitCenter' } }] pprct as PartnerProfitCenter, // |
4.16.职能范围
|
1 2 3 4 5 6 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_FunctionalArea', element: 'FunctionalArea' } }] @ObjectModel.foreignKey.association: '_FunctionalArea' fkber_long as FunctionalArea, // |
4.17.部分报表分段，会计段
|
1 2 3 4 5 6 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_SegmentStdVH', element: 'Segment' } }] @ObjectModel.foreignKey.association: '_Segment' segment as Segment, // |
4.18.部分报表的伙伴分段
|
1 2 3 4 5 6 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_SegmentStdVH', element: 'Segment' } }] @ObjectModel.foreignKey.association: '_PartnerSegment' // psegment as PartnerSegment, |
4.19.伙伴功能范围
|
1 2 3 4 5 6 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_FunctionalArea', element: 'FunctionalArea' } }] @ObjectModel.foreignKey.association: '_PartnerFunctionalArea' pfkber as PartnerFunctionalArea, // |
4.20.科目详细信息标识
|
1 2 3 |
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_HouseBankAccountStdVH' , element: 'HouseBankAccount' } } ] @ObjectModel.foreignKey.association: '_HouseBankAccount' hktid as HouseBankAccount, // |
4.21.抵销科目编号
|
1 2 |
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_GLAccountInCompanyCodeStdVH' , element: 'GLAccount' } }] gkont as OffsettingAccount, // |
4.22.抵销科目类型
|
1 2 3 |
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_FinancialAccountType' , element: 'FinancialAccountType' } }] @ObjectModel.foreignKey.association: '_OffsettingAccountType' gkart as OffsettingAccountType, // |
4.23.付款原因
|
1 2 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_PaymentReasonVH', element: 'PaymentReason' } } ] payt_rsn as PaymentReason, |
4.24.工作分解结构元素 (WBS 元素)
|
1 2 3 4 5 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_WBSElementBasicDataStdVH', element: 'WBSElementInternalID' } }] projk as WBSElementInternalID, |
4.25.交易类型类别
|
1 2 3 4 5 |
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MovementCategory', element: 'AssetAcctTransClassfctn' } }] cast( ' ' as faa_movcat ) as AssetAcctTransClassfctn, |