SAP相关数据库表资料.docx

1、SAP相关数据库表资料第1章 SAP相关数据库表1.1 Tcode代码表Tstc1.2 预算相关表BPGE总计值的总计记录 成本控制对象总预算表1.3 作业相关表AFKO订单表头数据 PP 订单AUFK订单主数据 网络号AFVC工序AFVV工序时间信息TCOKT订单的科目分配类别1.4 预留RESB是物料类1.5 发票计划涉及到的表：FPLT，PFLA根据项目取得对应开票金额和开票计划的逻辑：2.1.根据项目编号取得WBS的出具(发票)计划编号，取数逻辑：select prPS-FPLNR where prps- FAKKZ = X and prps-psphi = 项目定义号。2.2.根据2

2、.1中取得发票计划编号取得合同金额：select fpla-BASISWRT where fpla-FPLNR = 上步骤中取得的发票号2.3.根据发票计划编号取得具体的发票记录，取数逻辑：select fplt-afdat、fplt-fakwr、fplt- TETXT from fplt where fplt-FPLNR IN (上步中取得的发票计划号)。根据fplt- TETXT取得对应的描述，取数逻辑：select TVTBT- TEBEZ from Tvtbt where tvtbt- TETBE = fplt- TETXT。1.6 里程碑信息在WBS上创建的里程碑，只可在WBS之间移

3、动。在作业上创建的里程碑，只可在作业之间移动。相关表：MLST-重大事件，MLTX-重大事件描述1.7 数据库列表AFKO订单表头数据 PP 订单AFVCP查看: 作业 - WBS 编号AUFK订单主数据CNLDST_SHCNPB_INDX项目构造器的预览COSPCOSSDD01L义域DD02LSAP - 表DD03L表字段DD04L数据元素DD08L/3 DD: 关系定义DD092526VDD：缓存的数据库查看的基本表格DD09LDD: 表的技术设置DD12LR/3 S-SECCINDEX: 副的索引,标题;DD35L结构的搜索帮助分配：标题DDFTX运行时间目标带屏幕制作文本DDNTFDD

4、NTTDDXTT延迟书写的命名表头结构JEST单独对象状态JSTO状态对象信息MLSTMLTXPRHI工作分解结构，边缘(层次指针)PROJPRPSPRTXPS 文本 (WBS)RPSCO项目信息数据库: 成本, 销售收入,财务TC10CIM 屏幕顺序的初始值TCJ41工作分解结构的默认值TCMF5错误管理的对象标识(SAP)TCMF7断点TCMF9最小信息类型(SAP)TCN00关键词 ID 用于PS 用户字段TFAW字段选择: 可变动字段TFAWC字段选择：字段属性更改（用户定义）TFAWF字段选择: 可修改的字段TFAWY字段选择：组合干预/更改的字段（最终用户）TFDIR功能模块TJ0

5、2T系统状态文本TJ04状态控制为对象类型TJ30T用户状态文本TKA01成本控制范围USOBX_C为表 USOBT_C 检查表格USR02登录数据（核心方使用）USRBF2快速 RFC 登录的用户缓冲区内容 - 新USREFUSUST12用户主控: 授权V_21S23L读匹配码分析类型的标志V_21S2l读匹配码分析类型的标志VSPROJ_CN版本: 项目定义PPAFFLWork order sequenceAFFTOrder process instructionsAFFVOrder process instruction valuesAFKOOrder header data PP or

6、dersAFPOOrder itemAFRUOrder completion confirmationsCKHSHeader - Unit costing (control + totals)CKHTTexts for CKHSCKIPUnit Costing: Period Costs Line ItemCKISUnit Costing: Items / Product Costing: ItemizationCKITTexts for CKISCOERSales Order Value RevenueCRCAWork Center Capacity AllocationCRCOAssign

7、ment of Work Center to Cost CenterCRHDWork Center HeaderCRTXText for the Work Center or Production Resource/ToolDOSTDocument to BOM LinkEQSTEquipment to BOM LinkKAKOCapacity Header SegmentKAKTCapacity DescriptionKBEDCapacity requirements recordsKEKOProduct Costing - HeaderKEPHProduct Costing: Cost C

8、omponents for Cost of Goods Manuf.MASTMaterial to BOM LinkSTASBOMs - Item SelectionSTKOBOM HeaderSTPOBOM ItemSTPUBOM Sub-ItemSTZUPermanent BOM dataKDSTSales Order to BOM LinkSTSTStandard BOM linkTPSTFunctional Location - BOM LinkSAP数据库（数据表）相关知识(2010-11-05 11:28:52) 转载标签： 杂谈分类： ABAP-Basic Deliverycla

9、ssThedeliveryclasscontrolsthetransportoftabledatawheninstallingorupgrading,inaclientcopyandwhentransportingbetweencustomersystems.Thedeliveryclassisalsousedintheextendedtablemaintenance.Therearethefollowingdeliveryclasses:A:Applicationtable(masterandtransactiondata).C:Customertable,dataismaintainedb

10、ythecustomeronly.L:Tableforstoringtemporarydata.G:Customertable,SAPmayinsertnewdatarecords,butmaynotoverwriteordeleteexistingdatarecords.E:Systemtablewithitsownnamespacesforcustomerentries.ThecustomernamespacemustbedefinedintableTRESC.S:Systemtable,datachangeshavethesamestatusasprogramchanges.W:Syst

11、emtable(e.g.tableofthedevelopmentenvironment)whosedataistransportedwithitsowntransportobjects(e.g.R3TRPROG,R3TRTABL,etc.).BehaviorduringclientcopyOnlythedataofclient-specifictablesiscopied.ClassesC,G,E,S:Thedatarecordsofthetablearecopiedtothetargetclient.ClassesW,L:Thedatarecordsofthetablearenotcopi

12、edtothetargetclient.ClassA:Datarecordsareonlycopiedtothetargetclientifexplicitlyrequested(parameteroption).Normallyitdoesnotmakesensetotransportsuchdata,butissupportedtopermityoutocopyanentireclientenvironment.Behaviorduringinstallation,upgradeandlanguageimportThebehaviordiffershereforclient-specifi

13、candcross-clienttables.Client-specifictablesClassesAandC:Dataisonlyimportedintoclient000.Existingdatarecordsareoverwritten.ClassesE,SandW:Dataisimportedintoallclients.Existingdatarecordsareoverwritten.ClassG:Existingdatarecordsareoverwritteninclient000.Inallotherclients,newdatarecordsareinserted,butexistingdatarecordsarenotoverwritten.ClassL:Nodataisimported.Cross-clienttablesClassesA,LandC:Nodataisimported.ClassesE,S,andW:Dataisimported.Exisitngdatarecordswiththesamekeyareoverwritten.ClasseG:Datarecordsthatdonotexistareinserted,butexistingdatarecordsarenotove