SAP相关数据库表资料Word文件下载.docx

1、1.7 数据库列表AFVCP查看: 作业 - WBS 编号订单主数据CNLDST_SHCNPB_INDX项目构造器的预览COSPCOSSDD01L义域DD02LSAP - 表DD03L表字段DD04L数据元素DD08L/3 DD: 关系定义DD092526VDD：缓存的数据库查看的基本表格DD09LDD: 表的技术设置DD12LR/3 S-SECCINDEX: 副的索引,标题;DD35L结构的搜索帮助分配：标题DDFTX运行时间目标带屏幕制作文本DDNTFDDNTTDDXTT延迟书写的命名表头结构JEST单独对象状态JSTO状态对象信息MLSTMLTXPRHI工作分解结构，边缘（层次指针）PR

2、OJPRPSPRTXPS 文本 （WBS）RPSCO项目信息数据库: 成本, 销售收入,财务TC10CIM 屏幕顺序的初始值TCJ41工作分解结构的默认值TCMF5错误管理的对象标识（SAP）TCMF7断点TCMF9最小信息类型（SAP）TCN00关键词 ID 用于PS 用户字段TFAW字段选择: 可变动字段TFAWC字段选择：字段属性更改（用户定义）TFAWF 可修改的字段TFAWY组合干预/更改的字段（最终用户）TFDIR功能模块TJ02T系统状态文本TJ04状态控制为对象类型TJ30T用户状态文本TKA01成本控制范围USOBX_C为表 USOBT_C 检查表格USR02登录数据（核心方

3、使用）USRBF2快速 RFC 登录的用户缓冲区内容 - 新USREFUSUST12用户主控: 授权V_21S23L读匹配码分析类型的标志V_21S2lVSPROJ_CN版本: 项目定义PPAFFLWork order sequenceAFFTOrder process instructionsAFFVOrder process instruction valuesOrder header data PP ordersAFPOOrder itemAFRUOrder completion confirmationsCKHSHeader - Unit costing （control + tota

4、ls）CKHTTexts for CKHSCKIPUnit Costing: Period Costs Line ItemCKIS Items / Product Costing: ItemizationCKITTexts for CKISCOERSales Order Value RevenueCRCAWork Center Capacity AllocationCRCOAssignment of Work Center to Cost CenterCRHDWork Center HeaderCRTXText for the Work Center or Production Resourc

5、e/ToolDOSTDocument to BOM LinkEQSTEquipment to BOM LinkKAKOCapacity Header SegmentKAKTCapacity DescriptionKBEDCapacity requirements recordsKEKOProduct Costing - HeaderKEPHProduct Costing: Cost Components for Cost of Goods Manuf.MASTMaterial to BOM LinkSTASBOMs - Item SelectionSTKOBOM HeaderSTPOBOM I

6、temSTPUBOM Sub-ItemSTZUPermanent BOM dataKDSTSales Order to BOM LinkSTSTStandard BOM linkTPSTFunctional Location - BOM LinkSAP数据库（数据表）相关知识（2010-11-05 11:28:52） 转载标签： 杂谈分类： ABAP-Basic DeliveryclassThedeliveryclasscontrolsthetransportoftabledatawheninstallingorupgrading,inaclientcopyandtransportingbet

7、weencustomersystems.isalsousedextendedmaintenance.Therearefollowingclasses:A:Application（mastertransactiondata）.C:Customertable,maintainedbyonly.L:Tableforstoringtemporarydata.G:SAPmayinsertnewrecords,butnotoverwritedeleteexistingrecords.E:Systemwithitsownnamespacesentries.namespacemustbedefinedTRES

8、C.S:changeshavesamestatusasprogramchanges.W:（e.g.developmentenvironment）whosetransportedobjectsR3TRPROG,TABL,etc.）.BehaviorduringcopyOnlyclient-specifictablescopied.ClassesC,G,E,recordscopiedtotargetclient.W,ClassDataonlyifexplicitlyrequested（parameteroption）.Normallyitdoesmakesensesuchdata,supportedpermityouanentireenvironment.installation,upgradelanguageimportbehaviordiffersherecross-clienttables.Client-specifictablesAimportedinto000.Existingoverwritten.Sallclients.overwrittenInotherclients,inserted,Noimported.Cross-clientA,LS,imported.ExisitngkeyClassethatdoexistove