SAP相关数据库表

第1章SAP相关数据库表1.1Tcode代码表Tstc1.2预算相关表BPGE总计值的总计记录成本控制对象总预算表1.3作业相关表AFKO订单表头数据PP订单AUFK订单主数据网络号AFVC工序AFVV工序时间信息TCOKT订单的科目分配类别1.4预留RESB是物料类1.5发票计划涉及到的表：FPLT，PFLA根据项目取得对应开票金额和开票计划的逻辑：2.1.根据项目编号取得WBS的出具(发票)计划编号，取数逻辑：selectprPS-FPLNRwhereprps-FAKKZ=‘X’andprps-psphi=项目定义号。2.2.根据2.1中取得发票计划编号取得合同金额：selectfpla-BASISWRTwherefpla-FPLNR=上步骤中取得的发票号2.3.根据发票计划编号取得具体的发票记录，取数逻辑：selectfplt-afdat、fplt-fakwr、fplt-TETXTfromfpltwherefplt-FPLNRIN(上步中取得的发票计划号)。根据fplt-TETXT取得对应的描述，取数逻辑：selectTVTBT-TEBEZfromTvtbtwheretvtbt-TETBE=fplt-TETXT。1.6里程碑信息在WBS上创建的里程碑，只可在WBS之间移动。在作业上创建的里程碑，只可在作业之间移动。相关表：MLST-重大事件，MLTX-重大事件描述1.7数据库列表AFKO订单表头数据PP订单AFVCP查看:作业-WBS编号AUFK订单主数据CNLDST_SHCNPB_INDX项目构造器的预览COSPCOSSDD01L义域DD02LSAP-表DD03L表字段DD04L数据元素DD08L/3DD:关系定义DD092526VDD：缓存的数据库查看的基本表格DD09LDD:表的技术设置DD12LR/3S-SECCINDEX:副的索引,标题;DD35L结构的搜索帮助分配：标题DDFTX运行时间目标带屏幕制作文本DDNTFDDNTTDDXTT延迟书写的命名表头结构JEST单独对象状态JSTO状态对象信息MLSTMLTXPRHI工作分解结构，边缘(层次指针)PROJPRPSPRTXPS文本(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登录数据（核心方使用）USRBF2快速RFC登录的用户缓冲区内容-新USREFUSUST12用户主控:授权V_21S23L读匹配码分析类型的标志V_21S2l读匹配码分析类型的标志VSPROJ_CN版本:项目定义PPAFFLWorkordersequenceAFFTOrderprocessinstructionsAFFVOrderprocessinstructionvaluesAFKOOrderheaderdataPPordersAFPOOrderitemAFRUOrdercompletionconfirmationsCKHSHeader-Unitcosting(control+totals)CKHTTextsforCKHSCKIPUnitCosting:PeriodCostsLineItemCKISUnitCosting:Items/ProductCosting:ItemizationCKITTextsforCKISCOERSalesOrderValueRevenueCRCAWorkCenterCapacityAllocationCRCOAssignmentofWorkCentertoCostCenterCRHDWorkCenterHeaderCRTXTextfortheWorkCenterorProductionResource/ToolDOSTDocumenttoBOMLinkEQSTEquipmenttoBOMLinkKAKOCapacityHeaderSegmentKAKTCapacityDescriptionKBEDCapacityrequirementsrecordsKEKOProductCosting-HeaderKEPHProductCosting:CostComponentsforCostofGoodsManuf.MASTMaterialtoBOMLinkSTASBOMs-ItemSelectionSTKOBOMHeaderSTPOBOMItemSTPUBOMSub-ItemSTZUPermanentBOMdataKDSTSalesOrdertoBOMLinkSTSTStandardBOMlinkTPSTFunctionalLocation-BOMLinkSAP数据库（数据表）相关知识(2010-11-0511:28:52)转载▼标签：杂谈分类：ABAP-BasicDeliveryclassThedeliveryclasscontrolsthetransportoftabledatawheninstallingorupgrading,inaclientcopyandwhentransportingbetweencustomersystems.Thedeliveryclassisalsousedintheextendedtablemaintenance.Therearethefollowingdeliveryclasses:A:Applicationtable(masterandtransactiondata).C:Customertable,dataismaintainedbythecustomeronly.L:Tableforstoringtemporarydata.G:Customertable,SAPmayinsertnewdatarecords,butmaynotoverwriteordeleteexistingdatarecords.E:Systemtablewithitsownnamespacesforcustomerentries.ThecustomernamespacemustbedefinedintableTRESC.S:Systemtable,datachangeshavethesamestatusasprogramchanges.W:Systemtable(e.g.tableofthedevelopmentenvironment)whosedataistransportedwithitsowntransportobjects(e.g.R3TRPROG,R3TRTABL,etc.).BehaviorduringclientcopyOnlythedataofclient-specifictablesiscopied.ClassesC,G,E,S:Thedatarecordsofthetablearecopiedtothetargetclient.ClassesW,L:Thedatarecordsofthetablearenotcopiedtothetargetclient.ClassA:Datarecordsareonlycopiedtothetargetclientifexplicitlyrequested(parameteroption).Normallyitdoesnotmakesensetotransportsuchdata,butissupportedtopermityoutocopyanentireclientenvironment.Behaviorduringinstallation,upgradeandlanguageimportThebehaviordiffershereforclient-specificandcross-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,butexistingdatarecordsarenotoverwritten.BehaviorduringtransportbetweencustomersystemsDatarecordsoftablesofdeliveryclassLarenotimportedintothetargetsystem.DatarecordsoftablesofdeliveryclassesA,C,E,G,SandWareimportedintothetargetsystem(thisisdoneforthetargetclientspecifiedinthetransportforclient-specifictables).UseofthedeliveryclassintheextendedtablemaintenanceThedeliveryclassisalsoanalyzedintheextendedtablemaintenance(SM30).Themaintenanceinterfacegeneratedforatablemakesthefollowingchecks:YoucannottransporttheentereddatawiththetransportlinkofthegeneratedmaintenanceinterfacefortablesofdeliveryclassesWandL.Whenyouenterdata,thereisacheckifthisdataviolatesthenamespacedefinedforthetableintableTRESC.Ifthedataviolatesthenamespace,theinputisrejected.部分常用的一些IMGT****tables.(SAP46C大约有23000tables,其中估计有13000以上是配置表)表名描述T000:消费者T000C:用于安装FI-SL用户化设置的表T000CM:依客户而定的FI-AR-CR设置T000F:跨集团FI设置T000G:跨客户总分类帐记帐T000GL:灵活总帐:定制检查和激活T000K:组T000MD:MRP范围级别的MRPT000_0001:屏幕字段T000维护T000_0002:屏幕字段T000维护T000_RFC:用于比较工具和远程集团复制的T000子集T001:公司代码T001A:公司代码的附加本币控制T001B:允许的记帐期T001C:公