SAP FICO 常用table

Table    描        述    "Table
Type"    "Application
Class"    "Data
Class"    Description    "Logical 
Database/s"    Notes    表格大概内容
                                
BKPF    会计核算凭证标题    TRANSP    FB    Transaction    Accounting document header            公司代码;会计凭证编号;会计年度;凭证类型等
BNKA    银行主记录    TRANSP    FB    Master    Bank master record            
BSAD    会计核算:客户的第二个索引(已结算项目)    TRANSP    FB    Transaction    Accounting: Secondary index for customers (cleared items)            
BSAK    会计核算:供应商的第二个索引(已结算项目)    TRANSP    FB    Transaction    Accounting: Secondary index for vendors (cleared items)            
BSAS    会计核算:总帐科目的第二个索引(已结算项目)    TRANSP    FB    Transaction    Accounting: Secondary index for G/L accounts (cleared items)            
BSEC    一次性帐户数据凭证段    CLUSTER    FB    Transaction    One-time account data document segment            
BSEG    会计核算凭证段    CLUSTER    FB    Transaction    Accounting document segment        "AVOID USING!!!
Use BSID, BSIK, and/or BSIS for open items
and BSAD, BSAK, and/or BSAS for cleared items"    
BSET    税收数据凭证段    CLUSTER    FB    Transaction    Tax data document segment            
BSID    会计核算:客户的第二次索引    TRANSP    FB    Transaction    Accounting: Secondary index for customers            
BSIK    会计核算:供应商的第二次索引    TRANSP    FB    Transaction    Accounting: Secondary index for vendors            
BSIS    会计核算: 总帐科目的次级索引    TRANSP    FB    Transaction    Accounting: Secondary index for G/L accounts            
GLT0    总帐科目主记录业务额    TRANSP    FG    Transaction    G/L Account Master Record  Monthly Debits and Credits            
KNA1    客户主文件的一般数据    TRANSP    FB    Master    General Data in Customer Master    DDF        
KNAS    客户主数据(一般地区的增值税登记号)    TRANSP    FB    Master    Customer master (VAT registration numbers general section)    DDF        
KNB1    客户主数据 (公司代码)    TRANSP    FB    Master    Customer master (company code)    DDF        
KNB4    客户收付历史    TRANSP    FB    Master    Customer payment history    DDF        
KNB5    客户主记录 (催款数据)    TRANSP    FB    Master    Customer master (dunning data)    DDF        
KNBK    客户主数据 (银行细目)    TRANSP    FB    Master    Customer master (bank details)    DDF        
KNC1    客户主记录 (交易额)    TRANSP    FB    Master    Customer master (transaction figures)    DDF        
KNC3    客户主数据 (特殊总帐业务额)    TRANSP    FB    Master    Customer master (special G/L transaction figures)    DDF        
KNKA    客户主数据信贷管理: 中心数据    TRANSP    FB    Master    Customer master credit management: Central data    DDF        
KNKK    客户主数据信贷管理: 控制范围数据    TRANSP    FB    Master    Customer master credit management: Control area data    DDF        
KNVV    客户主记录销售数据                            
KNVP    客户主记录合作伙伴功能                            
ADDR1_DATA    地址传输结构                            员工供应商名称 1;名称 1;检索项1;检索项2
LFA1    供应商主数据 (一般地区)    TRANSP    FB    Master    Vendor master (general section)    KOF        供应商代码;名称1;
LFAS    供应商主数据 (增值税登记号的一般部分)    TRANSP    FB    Master    Vendor master (VAT registration numbers general section)    KOF        
LFB1    供应商主数据 (公司代码)    TRANSP    FB    Master    Vendor master (company code)    KOF        
LFB5    供应商主数据 (催款数据)    TRANSP    FB    Master    Vendor master (dunning data)    KOF        
LFBK    供应商主数据 (银行细目)    TRANSP    FB    Master    Vendor master (bank details)    KOF        
LFC1    供应商主数据 (业务额)    TRANSP    FB    Master    Vendor master (transaction figures)    KOF        供应商代码;公司代码;应付账款未清项;
LFC3    主供应商 (特殊总分类帐交易图表)    TRANSP    FB    Master    Vendor master (special G/L transaction figures)    KOF        
NBNK    银行的号码范围    TRANSP    FB    Organizational    Number range for banks            
NKUK    改变凭证编号范围    TRANSP    FB    Organizational    Number range for change documents            
PAYR    支付媒体文件    TRANSP    FBZ    Transaction    Payment transfer medium file            
PCEC    预先计数检查    TRANSP    FBZ    Organizational    Prenumbered Checks            
REGUA    收付建议的更改: 用户和时间    TRANSP    FBZ    Transaction    Change of payment proposals: user and time            
REGUH    来自支付程序的结算数据    TRANSP    FBZ    Transaction    Settlement data from payment program    PYF        
REGUP    来自收付程序的处理项目    CLUSTER    FBZ    Transaction    Processed items from payment program    PYF        
REGUS    科目被收付建议冻结    TRANSP    FBZ    Transaction    Acounts blocked by payment proposal            
REGUV    对于收付程序的控制记录    TRANSP    FBZ    Transaction    Control records for the payment program            
PF02K    维护供应商主记录屏幕和工作区                            供应商帐号;公司代码;供应商或债权人的帐号
SKA1    总帐科目主记录 (科目表)    TRANSP    FB    Master    G/L accounts master (chart of accounts)            
SKAT    总帐科目主记录(科目表:说明)    TRANSP    FB    Master    G/L account master record (chart of accounts: description)            
SKB1    总帐科目主记录 (公司代码)    TRANSP    FB    Master    G/L account master (company code)            
T001    公司代码    TRANSP    FB    Organizational    Company Codes            公司中文名字;公司代码,
T001B    允许的记帐期    TRANSP    FB    Organizational    Posting periods allowed            
T005    国家    TRANSP    FB    Organizational    Countries            
T005T    国家名    TRANSP    FB    Organizational    Country names            
T012    开户行    POOL    FB    Organizational    House banks            
T012T    开户行帐户名    POOL    FB    Organizational    House bank account names            
TBSL    过帐码    POOL    FB    Organizational    Posting keys            
TBSLT    过帐代码名称    POOL    FB    Organizational    Posting key names            
TCURC    货币代码    TRANSP    FB    Organizational    Currency codes            
TCURF    转换因子    TRANSP    FB    Organizational    Conversion Factors            
TCURR    汇率    TRANSP    FB    Organizational    Currency exchange rates            
TCURT    货币代码名    TRANSP    FB    Organizational    Currency code names            
TCURV    货币换算的兑换率类型    TRANSP    FB    Organizational    Exchange rate types for currency translation            
TCURW    汇率类型的使用    TRANSP    FB    Organizational    Exchange rate type usage            
TGSB    业务范围    TRANSP    FB    Organizational    Business Areas            
TGSBT    业务部门名称    TRANSP    FB    Organizational    Business area names            
ANLA    资产主记录段            asset master                
ANLB     折旧期限            Asset Depreciation                
ANKT    资产类别描述            Asset class                
ANEP    资产行项目                            
ANLZ    时间相关资产分配                            
ANLP    资产期间价值                            
ANEK    凭证抬头资产过帐                            
ANEPV                          (asset line items)    资产行项目(ANEP + ANEA + ANEK)                            
ANLQ    来自每一记帐等级折旧记帐运行的期间值                            
Table        Table Type    "Application
Class"    "Data 
Class"    Description    "Logical
Database/s"    Notes
                            
CEPC    利润中心主数据表(利润中心代码)    TRANSP    KE    Master    Profit center master data table        
COBK    成本控制对象:凭证标题    TRANSP    KA    Transaction    CO Object: Document header        
COEJ    成本控制对象:与财政年度相关的各行项目    TRANSP    KA    Transaction    CO object:  year-related line items        
COEJL    成本控制对象:业务类型行项目(按财政年)    TRANSP    KA    Transaction    CO Object: Line Items for Activity Types (by Year)        
COEJR    成本控制对象:统计关键数行项目(按财政年)    TRANSP    KA    Transaction    CO Object: Statistical Key Figure Line Items (by Year)        
COEJT    成本控制对象:业务价格行项目(按财政年)    TRANSP    KA    Transaction    CO Object: Activity Price Line Items (by Year)        
COEP    成本控制对象:与期间相关的各行项目    TRANSP    KA    Transaction    CO object:  period-related line items        
COEPB    成本控制对象:行项目差异/基于期间的结果分析    TRANSP    KA    Transaction    CO Object: Line Items Variance/Period-based Results Analysis        
COEPL    成本控制对象:业务类型行项目(按期间)    TRANSP    KA    Transaction    CO Object: Line Items for Activity Types (by Period)        
COEPR    成本控制对象:统计关键数行项目(按期间)    TRANSP    KA    Transaction    CO Object: Statistical Key Figure Line Items (by Period)        
COEPT    成本控制对象:业务价格行项目(按期间)    TRANSP    KA    Transaction    CO Object: Activity Price Line Items (by Period)        
COKA    成本控制对象:成本要素控制数据    TRANSP    KA    Transaction    CO Object: Cost Element Control Data        
COKL    成本控制对象:作业类型的控制数据    TRANSP    KA    Transaction    CO Object: Activity type control data        
COKP    成本控制对象:主要计划控制数据    TRANSP    KA    Transaction    CO Object: Primary Planning Control Data        
COKR    成本控制对象:统计关键数控制数据    TRANSP    KA    Transaction    CO Object: Statistical Key Figure Control Data        
COKS    成本控制对象:次级计划编制的控制数据    TRANSP    KA    Transaction    CO Object: Control Data for Secondary Planning        
COSB    成本控制对象:差异总计/结果分析    TRANSP    KA    Transaction    CO Object: Total Variances/Results Analyses        
COSBD    CO 对象: 差异/待摊, 已结算的    TRANSP    KA    Transaction    CO Object: Total of variances/accruals, of which settled        
COSL    成本控制对象:作业类型总计    TRANSP    KA    Transaction    CO Object: Activity Type Totals        
COSP    CO 对象:外部记帐的成本总计    TRANSP    KA    Transaction    CO Object:  Cost Totals - External Postings        
COSPD    CO 对象: 已结算初级成本总计    TRANSP    KA    Transaction    CO Object: Settled Primary Cost Totals        
COSR    CO 对象:统计关键指数总计    TRANSP    KA    Transaction    CO Object:  Statistical Ratio Totals        
COSS    CO 对象:内部过帐成本总计    TRANSP    KA    Transaction    CO Object:  Cost Totals - Internal Postings        
COSSD    CO 对象: 已结算次级成本总计    TRANSP    KA    Transaction    CO Object: Settled Secondary Cost Totals        
COST    成本控制对象:价格总计    TRANSP    KA    Transaction    CO object:  standard rate totals        
CSKA    成本要素 (数据与科目表相关kbg)    TRANSP    KS    Master    Cost elements (data dependent on chart of accounts)        
CSKB    成本要素 (数据与成本控制范围kbg相关)    TRANSP    KS    Master    Cost elements (data dependent on controlling area)        
CSKS    成本中心主数据(对应利润中心)    TRANSP    KSS    Master    Cost center master        
CSKT    成本中心说明文本(成本中心名称)    TRANSP    KSS    Master    Cost center texts        
CSKU    成本要素文本(基础资料)    TRANSP    KS    Master    Cost element texts        
CSLA    作业主档(作业类型代号基础资料)    TRANSP    KSS    Master    Activity master        
CSLT    作业类型文本(作业类型名称基础资料)    TRANSP    KSS    Master    Activity type texts        
CSSK    成本中心/成本要素    TRANSP    KSS    Master    Cost center  /cost element        
CSSL    成本中心/作业类型(关系表)    TRANSP    KSS    Master    Cost center / activity        
原文地址:https://www.cnblogs.com/JackeyLove/p/13299249.html