版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
ABAP实现本地化的资产负债表和损益表
1.设计思路:
SAP没有提供标准的符合中国标准的资产负债表和损益表,需要我们在系统中自
定义开发,我们在配置报表版本时都指定了
一个项目的编号,一个版本下面都有期其统驭的科目范围,我们可以根据这个项
目编号找到相应的科目范围,然后根据科目范围
获取科目借贷汇总的值。
SAP中资产负债表的配置图示:
L曰1资产Assets
一电io流动资产
一国1301子页付费用-待摊费J
i资金
一日1000货市资金一—
SKGCQ00020L201-0000203101xlxStartofGroup
SKGC000025L101-0000251101X|X银行存款-定期
—由1101交易性金融姿『
—由1121
——国1122
加账准备-应收账2
—由1122A
—由1123
—国
1132EndofGroup
1131竟鸭应收款
—□□1221
—由1400
一笨内到期的非清动资j
—031507
—由1499其他流动资F
一国1488A待处理财产损1
我们传统的资产负债表如下格式:
奥产行次期末余酸年初余额负焦和所有者权益(或股东权益)行次
流动生产:1”顶日洞号深动负债;1
货币资金21000/23,226,46452短期借款2
交易性金融资产31101-交易性金融负俵3
应收票据41121-应付票据4
应收咪款5112212,043,41357应付账款5
预付款项61123一预收款项6
应收利息71132―应付职工薪酬7
应收股利81131-应交税费8
其他应收款912215,559,091.62应付利息9
存货10140015,5€4,52846应付股利10
一年内到期的季淙动费产111507其他应付款11
其他流动费产121499一年内到期的非流动负债12
流动资产合计13C8+C1856,史3,498.17其他流动负债13
手美动资产:14―潦动负得合计14
可供出售金融资产151503李流动负俵:15
持有至到期投费161501长期借款16
我们可以在程序中用项目编号找到其下面的科目范围,然后取科目汇总值,因为
资产负债表是固定的,所以我们要
建立一个CBO表来存放各个具体的项目和在SAP中对应的项目编号。
最后要强调的是在资产负债表中未分配利润的计算:
未分配利润的期末余额二年初结转额(留存收益的上年余额)+今年截至到本月的
盈利额(利润表中有体现)
利润表的思路和资产负债表是一样的。
项目行次本期金籁累计金额
一、营业收入
114,625,999.39124,617,624.78
减:营业成本2
2,991,357.5428,620,869.50
营业税金及附加3
T
销售费用H
44,781,374.6551,372,031.90
管理费用
51,123,316.6110,288,635.08
财务费用
611,790.78-656,625.03
资产减值损失7
1,535,433.04
力口:公允价值变动收益(损失以号埴列)8-一
具体的代码实现:
*&*
*&CompanyCode:N207
*&module:FI
*&createby:rrzhang
*&createdate:2011.12.28
*&*
*&title:资产负债表,利润表
*&Description:资产负债表,利润表报表呈现
*&*
*&ChangeHistory
**
*C.RNo|Date|Developer|Description
**
*2012.01.lllccyu
**
REPORTzfir00026.
INCLUDEzfir00026_top.
INCLUDEzfir00026_cls.
INCLUDEzfir00026_f01.
INCLUDEzfir00026_o01.
INCLUDEzfir00026_i01.
INCLUDE<icon>.
INITIALIZATION.
py=sy-datum+0(4).
p_m=sy-datum+4(2).
ATSELECTTON-SCREENOUTPUT.
PERFORMsetclisUSINGp_rpv.
IFcISINITIAL.
PERFORMsetlist.
gv_name='爱思开实业(上海)商贸有限公司合并财务报表版本'.
c='X'.
gv_rp='资产负债表'.
ELSE.
PERFORMsetpegUSINGp_rpv.
CASEprpv.
WHEN'2070'.
gv-name='爱思开实业(上海)商贸有限公司合并财务报表版本'.
WHEN'2071'.
gv_name=’爱思开实业(上海)商贸有限公总部财务报表版本’.
WHEN'2072'.
gv_name='爱思开实业(上海)商贸有限公司直营店财务报表版本'.
WHEN'2073'.
gv_name=".
ENDCASE.
IFp_rp='BS'.
gv_rp='资产负债表'.
ELSE.
gv_rp='利润表’.
ENDTF.
END1I-.
START-OF-SELECTTON.
PERFORMsynchrodata.
PERFORMgct_datal.
*&*
*&IncludeZFIR00026_T0P
*&*
*Datadefinition
TYPE-POOLSvrm.
TABLES:fag!flexa.
“同步数据用的凭证抬头表
DATA:BEGINOFgt_bkpfsynOCCURS0,
gjahrLIKEbkpf-gjahr,
bukrsLIKEbkpf-bukrs,
belnrLIKEbkpf-belnr,
ENDOFgtbkpfsyn.
DATAly(4)TYPEn.
“同步数据用的凭证行项目表(bseg)
DATA:BEGINOFgt_bsegsynOCCURS0,
gjahrLIKEbseg-gjahr,
bukrsLIKEbseg-bukrs,
belnrLIKEbseg-belnr,
prctrLIKEbseg-prctr,
pprctLIKEbseg-pprct,
buzeiLIKEbseg-buzei,
ENDOFgt_bsegsyn.
DATA:BEGINOFgt_fagasynOCCURS0.
INCLUDESTRUCTUREfaglflexa.
DATA:ENDOFgt_fagasyn.
TYPES:ch(3)TYPEc,
cf(4)TYPEc,
cgcp(12)TYPEc,
ok_codeLIKEsy-uconm.
DATA:c,d,
gvbsTYPEukurs_currVALUE1,“倍数
gv_iden(2).
“要显示的资产负债表
DATA:BEGINOFgt_alv_bsOOCCURS0,
IctlTYPEinti,
itemlTYPEzitem,
yamtlTYPEhslvtl2,
ysamtlTYPEhslvt12,
lct2TYPEinti,
item2TYPEzitem,
yamt2TYPEhslvtl2,
ysamt2TYPEhslvtl2,
waersLIKEtOOl-waers,
ENDOFgt_alvbsO.
DATA:BEGINOFgt_bsOCCURS0,
ukursTYPEukurscurr,
gdatuTYPEgdatu_inv,
ENDOFgtbs.
DATA:gv_mf(5).Themonthfield
*Thereportversionaccountinformation.
“要显示的利润表
DATA:BEGINOFgt_alv_is0OCCURS0,
letTYPEinti,
itemTYPEzitem,
yamtLIKEfaglflext-hslvt,本年累计数
mamtLIKEfaglflext-hslvt,ff本月累计数
waersLIKE1001-waers,
ENDOFgt_alv_is0.
“下载数据的内表
DATA:BEGINOFgt_alv_is01OCCURS0,
letTYPEinti,
itemTYPEzitem,
yamtLIKEfaglflext-hslvt,w本年累计数
mamtLIKEfaglflext-hslvt,本月累计数
ENDOFgt_alv_is01.
*利润表下钻数据内表
*->2012.01.16CCYUSTART
DATA:BEGINOFgt_skatOCCURS0,
saknrLIKEskat-saknr,
txt50LIKEskat-txt50,
ENDOFgt_skat.
*<-2012.01.16CCYUEND.
DATA:BEGINOFgOlvis_dplOCCURS0,
racctLIKEfaglflexa-racct,
*->2012.01.16CCYUSTART
txt50LIKEskat-txt50,
*<-2012.01.16CCYUEND.
hslLIKEfaglflexa-hsl,
ENDOFgt_alv_is_dpl.
*利润表下钻数据内表
DATA:BEGINOFgt_alv_bs_dplOCCURS0,
racctLIKEfaglflexa-racct,
*->2012.01.16CCYUSTART
txt50LIKEskat-txt50,
*<-2012.01.16CCYUEND.
hslLIKEfaglflexa-hsl,
ENDOFgtalvbsdpi.
DATA:BEGINOFgt_alv_bs_dp2OCCURS0,
racctLIKEfaglflexa-racct,
*->2012.01.16CCYUSTART
txt50LIKEskat-txt50,
*<-2012.01.16CCYUEND.
hslLIKEfaglflexa-hsl,
ENDOFgt_alv_bs_dp2.
TYPES:BEGINOFgs_alv_bs_dp_obj,
racctLIKEfaglflexa-racct,
*->2012.01.16CCYUSTART
txt50LIKEskat-txt50,
*<-2012.01.16CCYUEND.
hslLIKEfaglflexa-hsl,
ENDOFgs_alv_bs_dp_obj.
DATA:gs_alv_bs_dp_obj1TYPEgs_a1v_bs_dp_obj.
TYPES:gt_alv_bs_dpTYPESTANDARDTABLEOFgs_alv_bs_dp_obj.
*利润表下钻临时数据内表
DATA:BEGINOFgt_alv_is_dp2OCCURS0,
racctLIKEfaglflexa-racct,
*->2012.01.16CCYUSTART
txt50LIKEskat-txt50,
*<-2012.01.16CCYUEND.
hslLIKEfaglflexa-hsl,
ENDOFgt_alv_is_dp2.
DATA:BEGINOFgtfaglOllzcOCCURS0,
versnLIKEfagl_01Izc-versn,
ergslLIKEfagl_01Izc-ergsl,
txt45LIKEfagl_011qt-txt45,
vonktLIKEfagl_011zc-vonkt,
bisktLIKEfagl_Ollzc-biskt,
ENDOFgt_fagl_011zc.
DATA:BEGINOFgt_fagl,OllqtOCCURS0,
ergslLIKEfagl_011qt-ergsl,
txt45LIKEfagl011qt-txt45,
ENDOFgt_fagl_011qt.
DATA:BEGINOFgtrnant_isOCCURS0,
amtLIKEfaglflext-hslvt,
ENDOFgt_mamt_is.
RANGESgr_actFORfaglflext-racct.
DATA:BEGINOFgt_monvOCCURS0,
month(2)TYPEn,
valueLIKEfaglflext-hslvt,
ENDOFgt_monv.
DATA:BEGINOFgs_hsl,
hslOlLIKEfaglflext-hslvt,
hs102LIKEfaglflext-hslvt,
hs103LIKEfaglflext-hslvt,
hsl04LIKEfaglflext-hslvt,
hsl05LIKEfaglflext-hslvt,
hsl06LIKEfaglflext-hslvt,
hs107LIKEfaglflext-hslvt,
hsl08LIKEfaglflext-hslvt,
hs109LIKEfaglflext-hslvt,
hsllOLIKEfaglflext-hslvt,
hslllLIKEfaglflext-hslvt,
hsll2LIKEfaglflext-hslvt,
ENDOFgs_hsl.
DATA:BEGINOFgs_hsll,
hslOlLIKEfaglflext-hslvt,
hslO2LIKEfaglflext-hslvt,
hsl03LIKEfaglflext-hslvt,
hs104LIKEfaglflext-hslvt,
hsl05LIKEfaglflext-hslvt,
hsl06LIKEfaglflext-hslvt,
hsl07LIKEfaglflext-hslvt,
hs108LIKEfaglflext-hslvt,
hsl09LIKEfaglflext-hslvt,
hsllOLIKEfaglflext-hslvt,
hslllLIKEfaglflext-hslvt,
hsll2LIKEfaglflext-hslvt,
hslvtLIKEfaglflext-hslvt,
END01'gs_hsll.
DATA:gs_alvisTYPEREFTOcl_gui_alvgrid,nthealvobjectforisreport
gs_alv_bsTYPEREFT'Ocl_gui_alv_grid,“thealvobjectforbsreport
gsalvisdpiTYPEREFTOclguialvgrid,"thealvobjectforbsreport
gs_alv_bs_dplTYPEREFTOcl_gui_alv_grid,“thealvobjectforbsreport
gs_conTYPEREFTOcl_gui_customcontainer,wthecontianerobject
gs_conlTYPEREFTOcl_gui_custom_container,wthecontianerobject
gs_layoutTYPElvc_s_layo,wsetthelayoutofthealv
gt_fieldcatTYPElvc_t_fcat,wthefieldcatelogtable
gs_fieldcatTYPElvc_s_fcat,thefieldcatelogworkarea
gtoolbarTYPEui_functions,“thetoolbarofthealv
g_toolbarlTYPEui_functions,“thetoolbarofthealv
gt_sortTYPElvc_t_sort,ncontrolthesortofthealv
gs_sortTYPElvc_s_sort.theworkareaofthegt_sort
DATA:gsdyndoc_idTYPEREFTOcldddocument,
gs_dyndoc_idlTYPEREFTOcl_dd_document,
gs_splitterTYPEREFTOcl_gui_splitter_container,
gs_parent_htmlTYPEREFTOcl_gui_container,
gs_parcnt_gridTYPEREFTOcl_gui_containcr,
gs_splitterlTYPEREFTOcl_gui_splitter_container,
gs_parent_htmllTYPEREFTOcl_gui_container,
gs_parent_gridlTYPEREFTOcl_gui_container,
gs_html_cntrlTYPEREFTOcl_gui_html_viewer.
"SCREENDEFINE
DATAokcode.
*->2012.01.17CCYUSTART
DATA:BEGINOFgtheadlOCCURS0,
tl(6),
t2(20),
t3(20),
t4(20),
t5(6),
t6(20),
t7(20),
t8(20),
ENDOFgt_headl.
DATA:BEGINOFgt_head2OCCURS0,
tl(6),
t2(20),
t3(20),
t4(20),
ENDOFgt_head2.
DATA:BEGINOFgt_alv_bs01OCCURS0,
IctlTYPEinti,
itemlTYPEzitem,
yamtlTYPEhslvtl2,
ysamtlTYPEhslvtl2,
lct2TYPEinti,
item2TYPEzitem,
yamt2TYPEhslvt12,
ysamt2TYPEhslvt12,
ENDOFgt_alvbsOl.
*<-2012.01.17CCYUEND.
SELECTTON-SCREENBEGINOFBLOCKblkWITHFRAMETITLEtext-001.
“公司代码
SELECTION-SCREENBEGINOFLINE.
SELECTION-SCREENPOSITION1.
SELECTION-SCREENCOMMENT(79)text-002.
SELECTION-SCREENENDOFLINE.
“Currency
SELECTTON-SCREENBEGINOFLINE.
SELECTION-SCREENPOSITION
1.“从位置1开始输出
SELECTION-SCREENCOMMENT(7)text-003FORFIELDp_curr.
SELECTION-SCREENPOSITION15.
PARAMETERSp_currTVPEchASLISTBOXVISIBLELENGTH12OBLIGATORY
DEFAULT'CNY'.
SELECTION-SCREENENDOFLINE.
reportversion
SELECTION-SCREENBEGINOFLINE.
SELECTION-SCREENPOSITION1.
SELECTION-SCREENCOMMENT(9)text-004FORFIELDp_rpv.
SELECTTON-SCREENPOSITION15.
PARAMETERSp_rpvTYPEcfASLISTBOXVISIBLELENGTH12USER-COMMANDdp
OBLIGATORYDEFAULT'2070'.
SELECTION-SCREENPOSITION28.
SELECTION-SCREENCOMMENT(60)gv_name.
SELECTTON-SCREENENDOFLINE.
uprofitcentergroup
SELECTTON-SCREENBEGINOFLINE.
SELECTION-SCREENPOSITION1.
SELECTION-SCREENCOMMENT(12)text-005FORFIELDppeg.
SELECTION-SCREENPOSITION15.
PARAMETERSp_pcgTYPEegepASLISTBOXVISIBLELENGTH12USER-COMMANDdpi
OBLIGATORY.
SELECTTON-SCREENENDOFLINE.
“profitcenter
SELECTION-SCREENBEGINOFLINE.
SELECTION-SCREENPOSITION1.
SELECTION-SCREENCOMMENT(12)text-006FORFIELDp_pc.
SELECTION-SCREENPOSITION15.
PARAMETERSp_pcTYPEegepASLISTBOXVISIBLELENGTH12MODIFIDpc.
SELECTTON-SCREENENDOFLINE.
“REPROT
SELECTTON-SCREENBEGINOFLINE.
SELECTION-SCREENPOSITION1.
SELECTION-SCREENCOMMENT(12)text-007FORFIELDp_rp.
SELECTION-SCREENPOSITION15.
PARAMETERSp_rpTYPEegepASLISTBOXVISIBLELENGTH12USER-COMMANDrp
OBLIGATORYDEFAULT'BS'.
SELECTTON-SCREENCOMMENT(12)gvrp.
SELECTIONSCREENENDOFLINE.
“YEAR
SELECTTON-SCREENBEGINOFLINE.
SELECTION-SCREENPOSITION1.
SELECTTON-SCREENCOMMENT(12)text-008FORFIELDpy.
SELECTION-SCREENPOSITION15.
PARAMETERSp_y(4)TYPEnOBLIGATORY.
SELECTION-SCREENENDOFLINE.
“MONTH
SELECTION-SCREENBEGINOFLINE.
SELECTION-SCREENPOSITION1.
SELECTTON-SCREENCOMMENT(12)text-009FORFIELDpm.
SELECTION-SCREENPOSITION15.
*PARAMETERSPM(2)TYPENOBLIGATORY.
*->2012.01.11ccyuSTART
PARAMETERSpin(3)TYPEnASLISTBOXVISIBLELENGTH4OBLIGATORY.
*<-2012.01.11ccyuEND.
SELECTION-SCREENENDOFLINE.
SELECTION-SCREENENDOFBLOCKblk.
极*
*&*
*&ClassLCL_APP_COMPT
*&*
*theeventhandlerclassforalv
**
CLASSLCLAPPCOMPTDEFINITION.
PUBLICSECTION.
*thefunctionhandletoolbarwhichhandlethetoolbareventofthealv
METHODS:HANDLE_TOOLBARFOREVENTTOOLBAR
OFCL_GUIALVGRID
IMPORTINGE_OB.JECT
E_INTERACTIVE.
*thefunctionhand1e_user_commandwhichhandletheuser_command
*eventofthealv
METHODS:HANDLE_USER_COMMANDFOREVENTUSER_COMMAND
OFCL_GUI_ALV_GRID
IMPORTINGE_UCOMM.
*thefunctionhand1e_topofpagewhichhandlethetopofpage
METHODS:HANDLETOPOFPAGEFOREVENTTOPOFPAGE
OFCL_GUI_ALV_GRID
IMPORTINGEDYNDOC.ID.
"handlethehotspot_click事件
METHODS:HANDLE_HOTSPOT_CLICKFOREVENTHOTSPOT^CLICK
OFCL_GUI_ALV_GRID
IMPORTINGE_ROW_IDE_COLUMN_IDES_ROW_NO.
ENDCLASS.“LCL_APP_COMPT
*&IncludeZOOALV_CLS
*
*&*
*&*
*&Class(Implementation)lcl_app_compt
*&*
*implementation:foralv
**
CLASSLCLAPPCOMPTIMPLEMENTATION.
METHOD:HANDLE_TOOLBAR.
PERFORMMODIFY_TOOLBARUSINGEOBJECT”.
ENDMETHOD.”:
METHOD:HANDLE_USER_COMMAND.
PERFORMFM_USER_COMMANDUSINGE_UCOMM.
ENDMETHOD.nhandle_user_command
*TOPOFPAGE
METHOD:HANDLE_TOPOFPAGE.
PERFORMFMADDTOPOFPAGEUSINGEDYNDOCID.
ENDMETIIOD.”handle_topofpage
METHOD:HANDLEHOTSPOTCLICK.
PERFORMDR1LLDOWN1S1USINGE_ROW_IDE_COLUMN_IDES_ROW_NO.
ENDMETHOD.nHANDLE_HOTSPOT_CLICK
ENDCLASS.lcl_app_compt
*&*
*&IncludeZFIR00026_F01
*&*
*&*
*&FormSETLIST
*&*
*text
*•_*
*->pltext
*<-p2text
**
FORMsetlist.
DATA:itabTYPESTANDARDTABLEOFvrm_value,
lineTYPEvrm_value.
CLEARitab[].
line-key='CNY'.
line-text='CNY'.
APPENDlineTOitab.
line-key=<KRW,.
line-text='KRW'.
APPENDlineTOitab.
CALLFUNCTION'VRMSETVALUESJ
EXPORTING
id='P_CURR'
values=itab[],
CLEARitab[].
CLEARline.
line-key='2070'.
line-text='2070'.
APPENDlineTOitab.
line-key='2071'.
line-text='2071’.
APPENDlineTOitab.
line-key=‘2072’.
line-text='2072’.
APPENDlineTOitab.
line-key='2073’.
line-text='2073'.
APPENDlineTOitab.
CALLFUNCTION'VRM_SET_VALUES'
EXPORTING
id=<P_RPV,
values=itab[].
IFp_pcgISINITIAL.
CLEARitab[].
CLEARline.
line-key='N207'.
line-text='N207'.
APPENDlineTOitab.
CALLFUNCTION<VRM_SET_VALUES,
EXPORTING
id='P_PCG'
values=itab[].
ENDTF.
CLEARitab[].
CLEARline.
line-key='BS
line-text='BS'.
APPENDlineTOitab.
line-key='IS'.
line-text='TS'.
APPENDlineTOitab.
CALLFUNCTION4VRMSETVALUES'
EXPORTING
id='P_RP'
values=itab[].
*->2012.01.11CCYUSRART
CLEARitab[].
CLEARline.
line-key='01'.
line-text='01'.
APPENDlineTOitab.
line-key='02'.
line-text='02'.
APPENDlineTOitab.
line-key='03'.
line-text='03'.
APPENDlineTOitab.
line-key='04'.
line-text='04'.
APPENDlineTOitab.
line-key='05'.
line-text='05'.
APPENDlineTOitab.
line-key='06'.
line-text='06'.
APPENDlineTOitab.
line-key='07'.
line-text='07'.
APPENDlineTOitab.
line-key='08'.
line-text='08'.
APPENDlineTOitab.
line-key='09'.
line-text='09'.
APPENDlineTOitab.
line-key='10’.
line-text='10'.
APPENDlineTOitab.
line-key='ll',
line-text='ll'.
APPENDlineTOitab.
line-key='12'.
line-text='12'.
APPENDlineTOitab.
CALLFUNCTION'VRMSETVALUES'
EXPORTING
id='P_M'
values=itab[].
”IFP_PCGISINITIAL.
”CLEARTTAB[].
”CALLFUNCT1ON'VRM_SET_VALUES'
"EXPORTING
"ID<P_PC,
"VALUES=ITAB[].
”ELSE.
PERFORMsetpegUSINGp_rpv.
"ENDIF.
*<-2012.01.11CCYUEND.
ENDFORM.”SETLIST
*&*
*&FormSETPCG
*&*
*text
**
*SETTHEPROFITCENTERGROUP
**
FORMsetpegUSINGp.
DATA:itabTYPESTANDARDTABLEOFvrm_value,
lineTYPEvrm_value.
CLEAR:itab[],line.
“CLEARp_pcg.
IFp='2070'.
line-key='N207'.
line-text='N207'.
APPENDlineTOitab.
CALLFUNCTION'VRM_SET_VALUES'
EXPORTING
id='P_PCG'
values=itab[].
p_pcg='N207'.
CLEARitab[].
”APPENDLINETOITAB.
CALLFUNCTION'VRM_SET_VALUES'
EXPORTING
id='P_PC'
values=itab[].
CLEARd.
ELSE.
CLEARitab[].
CLEARp_pc.
CALLFUNCTION'VRM_SET_VALUES'
EXPORTING
id='PPC'
values=itab[].
IFdISINITIAL.
SELECTDISTINCTsetnameASkeysetnameAStextFROMsetleaf
INTOCORRESPONDINGFIELDSOFTABLEitab
WHEREsubclass='N207'ANDsetclass='0106'.
IFitab[]ISNOTINITIAL.
CALLFUNCTION'VRMSETVALUES'
EXPORTING
id=<P_PCG,
values=itab[].
READTABLEitabINTOlineINDEX1.
p_pcg=line-key.
CLEARitab[].
SELECTDISTINCTvalfromASkeyvalfromAStextFROMsetleaf
INTOCORRESPONDINGFIELDSOFTABLEitab
WHEREsubclass='N207'ANDsetname=ppegANDsetclass='0106'.
IFitab[]ISNOTINITIAL.
CALLFUNCTION'VRMSETVALUESJ
EXPORTING
id='P_PC'
values=itab[],
ENDIF.
d='X'.
ENDIF.
ELSE.
SELECTDISTINCTvalfromASkeyvalfromAStextFROMsetleaf
INTOCORRESPONDINGFIELDSOFTABLEitab
WHEREsubclass'N207'ANDsetname=p_pcgANDsetclass='0106’.
IFitab[]ISNOTINITIAL.
CALLFUNCTION'VRMSETVALUES'
EXPORTING
(
id二PPC'
values=itab[].
ENDIF.
CLEARitab[].
ENDIF.
ENDIF.
ENDFORM.”SETPCG
*&*
*&FormSETDIS
*&*
*setthedisableoftheprofitcenter
**
*->PPRPVtext
*一*
FORMsetdisUSINGp.
LOOPATSCREEN.
IFp='2070'.
IFscreen-groupl='PC'.
screen-input='O'.
ENDIF.
ENDTF.
MODIFYSCREEN.
ENDLOOP.
ENDFORM."SETDIS
*&*
*&FormGETDATA
*&*
*text
**
*->pltext
*<-p2text
**
FORMget_datal.
PERFORMgetrv."获取报表项目对应的科目范围
ENDFORM.”GETDATA
*&*
*&FormGETRV
*&*
*getthereportitemandtheaccountrange
**
*->pltext
*<-p2text
**
FORMgetrv.
CLEARgt_fagl_011zc[].
SELECTversn
ergsl
vonkt
biskt
FROMfagl_011zcINTOCORRESPONDINGFIELDSOFTABLEgt_fagl_01Izc
WHEREversn=prpv.
IFgt_fagl_011zc[]ISNOTINITIAL.
SELECTDISTINCTergsl
txt45
INTOCORRESPONDINGFIELDSOFTABLEgt_fagl_011qt
FROMfagl_011qtFORALLENTRIESINgt_fagl_01Izc
WHEREversn=p_rpvANDergsl=gt_fagl_011zc-ergs1.
IFgt_fagl_011qt[]ISNOTINITIAL.
SORTgt_fagl_01IqtBYergsl.
LOOPATgt_fagl_011zc.
READTABLEgt_fagl_01IqtWITHKEYergsl=gt_fagl_01Izc-ergslBINARY
SEARCH.
IFsy-subrc=0.
gt_fagl_01lzc-txt45=gt_fagl_01lqt-txt45.
ENDIF.
MODIFYgt_fagl_011zc.
ENDLOOP.
ENDIF.
IFp_curr='KRW'.
PERFORMgetbs.
ENDIF.
ly=p_y-1.”取去年
CALLFUNCT1ON'CONVERSION_EX1T_ALPHA_INPUT'
EXPORTING
input=p_m
IMPORTING
output=p_m.
IFp_rp='BS'.
CLEARgt_alv_bsO[].
PERFORMsctbsitcm.
SORTgt_alv_bsOBYIctlASCENDING.
DATA:lv_pro(10)TYPEpDECIMALS2VALUE'3’,
lv_i(10)TYPEpDECZMALS2VALUE’3’.
“为核算固定资产等项目设置的临时变量
DATA:al601_1TYPEhslvtl2,
a!601_2TYPEhslvt12,
al602_lTYPEhslvtl2,
al602_2TYPEhslvt12,
al603_lTYPEhslvtl2,
al603_2TYPEhslvtl2,
a4001_lTYPEhslvtl2,
a4001_2TYPEhslvtl2,
a3103_lTYPEhslvtl2,
a3103_2TYPEhslvtl2,
a4104_lTYPEhslvt12,
a41042TYPEhslvtl2,
a4102_lTYPEhslvt12,
a4102_2TYPEhslvt12,
al3yamtlTYPEhslvt12,
al3ysamtlTYPEhslvtl2,
al4yamt2TYPEhslvt12,
al4ysamt2TYPEhslvtl2,
a23yamt2TYPEhslvt12,
a23ysamt2TYPEhslvtl2,
a24yamt2TYPEhslvt12,
a24ysamt2TYPEhslvtl2,
a31yamt2TYPEhslvt12,
a31ysamt2TYPEhslvtl2,
a32yamtlTYPEhslvt12,
a32ysamtlTYPEhslvtl2,
a33yamtlTYPEhslvt!2,
a33ysamtlTYPEhslvll2,
a33yamt2TYPEhslvt!2,
a33ysamt2TYPEhslvtl2,
a30yamt2TYPEhslvt12,
a30ysamt2TYPEhslvtl2,
a26yamt2TYPEhslvt12,
a26ysamt2TYPEhslvtl2,
a27yamt2TYPEhslvt12,
a27ysamt2TYPEhslvtl2,
a29yamt2TYPEhslvt12,
a29ysamt2TYPEhslvtl2.
“构造科目查询范围的查询条件
LOOPATgt_alvbsO.
IFgt_alv_bsO-iteml='货币资金,.
PERFORMgetbsamtUSING:gtalvbsO-yamtlgtalvbsO-ysamtl'1000'ly,
gt_alv_bs0-yamt2gt_alv_bs0-ysamt2"2001'ly.
ELSEIFgt_alv_bsO-iteml='交易性金融资产'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alv_bsO-ysamt1'1101'ly,
gt_alv_bs0-yamt2gt_alv_bs0-ysamt2'2010'ly.
ELSEIFgt_alv_bsO-iteml=,应收票据,.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alvbsO-ysamt1'1121'ly,
gt_alvbs0-yamt2gt_alvbs0-ysamt2'2201'ly.
ELSEIFgt_alv_bsO-iteml='应收账款'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alv_bsO-ysamt1'1122'ly,
gt_alv_bs0-yamt2gt_alv_bs0-ysamt2'2202'ly.
ELSEIFgt_alv_bsO-iteml='预付款项,.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alv_bsO-ysamt1'1123'ly,
gt_alv_bs0-yamt2gt_alv_bs0-ysamt2'2203'ly.
ELSEIFgt_alv_bsO-iteml='应收利息,.
PERFORMgetbsamtUSING:gt_a1vbsO-yamt1gt_alvbsO-ysamt1'1132'ly,
gt_alv_bs0-yamt2gt_alv_bs0-ysamt2'2211'ly.
ELSEIFgt_alv_bsO-iteml='应收股利'.
PERFORMgetbsamtUSING:gt_alvbsO-yamtlgt_alvbsO-ysamt1'1131'ly,
gt_alv_bs0-yamt2gt_alv_bs0-ysamt2'2221'ly.
ELSEIFgt_alvbsO-iteml=,其他应收款'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alv_bsO-ysamt1'1221'ly,
gt_alv_bsO-yamt2gt_alv_bs0-ysamt2'2231'ly.
ELSEIFgt_alv_bsO-iteml=,存货'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamt1gt_alvbsO-ysamt1'1400'ly,
gtalvbs0-yamt2gtalvbs0-ysamt2'2232'ly.
ELSEIFgt_alv_bsO-iteml=,一年内到期的非流动资产,.
PERFORMgetbsamtUSING:gt_alvbsO-yamt1gt_alvbsO-ysamtl'1507'ly,
gt_alv_bsO-yamt2gt_alv_bs0-ysamt2'2241'ly.
ELSEIFgt_alv_bsO-iteml=,其他流动资产'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alv_bsO-ysamt1'1499'ly,
gt_alv_bs0-yamt2gt_alv_bsQ-ysamt2'2240'ly.
ELSEIFgt_alvbsO-iteml='流动资产合计,.
PERFORMgetbsamtUSINGgt_alv_bs0-yamt2gt_alv_bs0-ysamt2'2222'ly.
ELSEIFgt_alv_bsO-iteml='可供出售金融资产'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alvbsO-ysamt1'1503'ly.
ELSEIFgt_alvbsO-iteml='持有至到期投资'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alv_bsO-ysamt1'1501'ly,
gt_alv_bs0-yamt2gt_alv_bs0-ysamt2'2501'ly.
ELSEIFgt_alv_bsO-iteml=,长期应收款'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamt1gt_alvbsO-ysamt1'1504'ly,
gt_alv_bs0-yamt2gt_alv_bs0-ysamt2'2502'ly.
ELSEIFgt_alv_bsO-iteml=,长期股权投资'.
PERFORMgetbsamtUSING:gt_alvbsO-yamtlgt_alvbsO-ysamt1'1511'ly,
gt_alv_bs0-yamt2gt_alv_bs0-ysamt2'2701'ly.
ELSEIFgt_alvbsO-iteml='投资性房地产'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alv_bsO-ysamt1'1521'ly,
gt_alv_bsO-yamt2gt_alv_bs0-ysamt2'2711'ly.
ELSEIFgt_alv_bsO-iteml='固定资产,.
CLEAR:al601_l,al601_2,a1602_i,al602_2,al603_l,al603_2.
PERFORMgetbsamtUS:NG:al6011al6012'1601'ly,
al602_lal602_2'1602'ly,
al603_lal603„2‘1603'ly,
gt_alv_bsO-yamt2gt_alv_bs0-ysamt2'2801'ly.
gt_alvbsO-yamt1=al601_l+al602_l+al603_l.
gt_alv_bsO-ysamt1=al601_2+al602_2+al603_2.
ELSEIFgt_alv_bsO-iteml='在建工程’.
PERFORMgetbsamtUSING:gt_alvbsO-yamtlgt_alvbsO-ysamt1'1604'ly,
gt_alv_bs0-yamt2gt_alv_bs0-ysamt2'2901'ly.
ELSEIFgt_alv_bsO-iteml='工程物资'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alvbsO-ysamt1'1605'ly,
gtalvbs0-yamt2gtalvbs0-ysamt2'2000'ly.
ELSEIFgt_alv_bsO-iteml='固定资产清理,.
PERFORMgetbsamtUSING:gt_a1vbsO-yamt1gt_alv_bsO-ysamtl'1606'ly.
ELSEIFgt_alv_bsO-iteml='无形资产'.
PERFORMgetbsamtUSING:gt_alv_bsO-yamt1gt_alvbsO-ysamt1'1701'ly,
a4001_la4001_2'4001'ly,
a3103_la3103_243103/ly.
gt_alv_bs0-yamt2=a4001_1+a3103_l.
gt_alv_bs0-ysamt2=a4001_2+a3103_2.
ELSEIFgt_alvbsO-iteml='开发支出,.
PERFORMgetbsamtUSING:gt_alv_bsO-yamtlgt_alv_bsO-ysamt1'1710'ly,
gt_alv_bsO-yamt2gt_alv_bs0-ysamt2'4002'ly.
ELSEIFgt_alv_bsO-iteml='商誉,.
PERFORMgetbsamtUS
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 贷款基础知识试题及答案
- 2026年服装推广能源托管协议
- 安徽省安庆一中、山西省太原五中等五省六校2026届全国新高三下学期开学大联考试题化学试题含解析
- 浙江省高中联盟2026届高考三轮模拟试卷化学试题卷含解析
- 《屋市政工程有限空间识别及施工安全作业指南(试行)》
- 2025年湖南省娄底市初二学业水平地生会考真题试卷+解析及答案
- 2026届广东省深圳市宝安区高三最后一卷高三化学试题练习卷含解析
- 贵州省从江县民族中学2026届高三下学期第一次教学质量诊断性考试化学试题试卷含解析
- 住院医师规范化培训《内科》练习题库含答案(附解析)
- 邹平市普通话模拟考试试题及答案
- 摩根士丹利-中国消费:当前消费趋势走向何方?-China Consumer:Where is consumption trending now-20260601
- GB 26396-2026洗涤用品安全技术规范
- 2026年北京市石景山区初三二模英语试卷(含答案及解析)
- 广告牌安装外包合同
- GB/T 47328.3-2026乳及乳制品感官分析第3部分:产品感官特性符合性评价评分法
- 2026汽车后市场行业格局与消费趋势研究报告
- 2026年山东省济南市历下区中考化学二模试卷(含答案)
- 有梦想就去追平凡人也能造不凡-张雪机车世界夺冠的追梦启示+课件-2025-2026学年高一下学期励志教育主题班会
- GB/T 4937.28-2026半导体器件机械和气候试验方法第28部分:静电放电(ESD)敏感度测试带电器件模型(CDM)器件级
- QBQB3112023冷成形用高屈服强度热连轧钢板及钢带
- 2026年监理工程师继续教育试卷附答案
评论
0/150
提交评论