当前位置: 首页 > 工具软件 > OPM > 使用案例 >

OPM批次成本后台表

舒斯伯
2023-12-01

 

OPM成本更新流程:
  1.跑实际成本处理  功能作用:计算成本
  2.成本更新        功能作用:更新成本
  3.OPM会计预处理程序->活动->提交流程 功能作用:是创建会计事件
  4.创建会计科目(OPM财务管理系统)    功能作用:更新成本
 
1、成本更新
2、运行请求:实际成本处理流程;--计算成本
3、运行请求:流程组织的 GMF 期间关闭流程;
4、运行“OPM会计预处理程序”;--创建会计事件
5、运行请求:创建会计科目;--创建会计科目
 
1、成本调整
2、运行请求:批次成本流程;--计算成本
3、运行请求:流程组织的 GMF 期间关闭流程;--预关闭
4、运行“OPM会计预处理程序”;--创建会计事件
5、运行请求:创建会计科目;--创建会计科目
 
物料成本CM_CMPT_DTLselect * from CM_CMPT_DTL
实际成本事物处理CM_ACST_LEDselect * from CM_ACST_LED
成本类型CM_MTHD_MSTselect * from CM_MTHD_MST
成本日历-头CM_CLDR_HDR_Bselect * from CM_CLDR_HDR_B
成本日历期间行CM_CLDR_DTLselect * from CM_CLDR_DTL
分配成本日历GMF_CALENDAR_ASSIGNMENTSselect * from GMF_CALENDAR_ASSIGNMENTS
期间状态GMF_PERIOD_STATUSESselect * from GMF_PERIOD_STATUSES
成本构成分组CM_CMPT_GRPselect * from CM_CMPT_GRP
成本构成分类CM_CMPT_MST_VLselect * from CM_CMPT_MST_VL
分析代码CM_ALYS_MSTselect * from CM_ALYS_MST
成本组织CM_WHSE_ASCselect * from CM_WHSE_ASC
调整CM_ADJS_DTLselect * from CM_ADJS_DTL
调整原因CM_REAS_CDSselect * from CM_REAS_CDS
物料成本构成CM_CMPT_MTLselect * from CM_CMPT_MTL
费用分配GL_ALOC_MSTselect * from GL_ALOC_MST
待分配费用GL_ALOC_EXPselect * from GL_ALOC_EXP
批次成本GMF_LOT_COSTS_Vselect * from GMF_LOT_COSTS_V
批次成本明细GMF_LOT_COST_DETAILSselect * from GMF_LOT_COST_DETAILS
事件实体XLA_ENTITY_TYPES_VLselect * from XLA_ENTITY_TYPES_VL
实体ID对应表XLA_ENTITY_ID_MAPPINGSselect * from XLA_ENTITY_ID_MAPPINGS
事件分类XLA_EVENT_CLASSES_VLselect * from XLA_EVENT_CLASSES_VL
事件类型XLA_EVENT_TYPES_VLselect * from XLA_EVENT_TYPES_VL
子帐头GMF_XLA_EXTRACT_HEADERSselect * from GMF_XLA_EXTRACT_HEADERS
子帐行GMF_XLA_EXTRACT_LINESselect * from GMF_XLA_EXTRACT_LINES
会计事物处理实体XLA_TRANSACTION_ENTITIESselect * from XLA_TRANSACTION_ENTITIES
会计事件XLA_EVENTSselect * from XLA_EVENTS
子帐头XLA_AE_HEADERSselect * from XLA_AE_HEADERS
子帐行XLA_AE_LINESselect * from XLA_AE_LINES
关联事物处理信息XLA_DISTRIBUTION_LINKSselect * from XLA_DISTRIBUTION_LINKS
 
SELECT xte.*
           FROM xla.xla_transaction_entities xte  
          WHERE xte.application_id = 555 
            AND xte.entity_code = 'INVENTORY'
            And xte.entity_id =23970
SELECT * 
  FROM xla_events xe 
 WHERE xe.application_id = 555 
 And xe.EVENT_ID=56052
   AND xe.entity_id IN ( 
         SELECT xte.entity_id 
           FROM xla.xla_transaction_entities xte  
          WHERE xte.application_id = 555 
            AND xte.entity_code = 'INVENTORY' ) ;
Select * From Gmf_Xla_Extract_Headers Gxeh Where Gxeh.Event_Id = 56052;
Select * From Gmf_Xla_Extract_Lines Gxel Where Gxel.Header_Id = 3124;
SELECT * 
  FROM xla_ae_headers xah 
 WHERE xah.application_id = 555    ------OPM成本 
   AND xah.entity_id IN ( 
         SELECT xte.entity_id 
           FROM xla.xla_transaction_entities xte 
          WHERE xte.application_id = 555  ------OPM成本 
            AND xte.entity_code = 'INVENTORY');
Select * From xla.xla_transaction_entities xte 
  
Select * From xla_entity_types_vl  x Where x.application_id=555;
Select * From xla_event_types_vl xet Where xet.application_id=555;
Select * From xla_entity_id_mappings xem Where xem.APPLICATION_ID=555;

转载于:https://www.cnblogs.com/lizicheng/p/8689923.html

 类似资料: