SAP各模组常用TABLE
合集下载
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
Table BKPF BNKA BSAD BSAK BSAS BSEC
Table Type TRANSP TRANSP TRANSP TRANSP TRANSP CLUSTER
Application Class FB FB FB FB FB FB
Data Class Transaction Master Transaction Transaction Transaction Transaction
FB FB FB FB FB FB FB FB FB FB FB
Organizational Organizational Organizational Organizational Organizational Organizational Organizational Organizational Organizational Organizational Organizational Master Transaction Transaction
GLFUNCT 汇总 GL 类似GLTO,比GLTO字段多，灵活 GLFUNCA line item, 比BSEG好 G/L account master data fs00 第一屏的 type/description存在SKA1中，其他和company code有关的放在skb1 TFKB functional area descriptn
Description Accounting document header Bank master record Accounting: Secondary index for customers (cleared items) Accounting: Secondary index for vendors (cleared items) Accounting: Secondary index for G/L accounts (cleared items) One-time account data document segment
PYF PYF
FI Tables, Page 1
T012T TBSL TBSLT TCURC TCURF TCURR TCURT TCURV TCURW TGSB TGSBT ANLA MHND MHNK
POOL POOL POOL TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP
Logical Database/s
Notes
BSEG BSET BSID BSIK BSIS GLT0 KNA1 KNAS KNB1 KNB4 KNB5 KNBK KNC1 KNC3 KNKA KNKK LFA1 LFAS LFB1 LFB5 LFBK LFC1 LFC3 NBNK NKUK PAYR PCEC REGUA REGUH REGUP REGUS REGUV SKA1 SKAT SKB1 T001 T001B T005 T005T T012 1160402.xls
1160402.xls
FI Tables, Page 2
House bank account names Posting keys Posting key names Currency codes Conversion Factors Currency exchange rates Currency code names Exchange rate types for currency translation Exchange rate type usage Business Areas Business area names Asset Master Record Segment Dunning data Dunning data (account entries)
FB FB FB FB FB FG FB FB FB FB FB FB FB FB FB FB FB FB FB FB FB FB FB FB FB FBZ FBZ FBZ FBZ FBZ FBZ FBZ FB FB FB FB FB FB FB FB
Transaction Transaction Transaction Transaction Transaction Transaction Master Master Master Master Master Master Master Master Master Master Master Master Master Master Master Master Master Organizational Organizational Transaction Organizational Transaction Transaction Transaction Transaction Transaction Master Master Master Organizational Organizational Organizational Organizational Organizational
wenku.baidu.com
AVOID USING!!! Use BSID, BSIK, and/or BSIS for open items and BSAD, BSAK, and/or BSAS for cleared items
DDF DDF DDF DDF DDF DDF DDF DDF DDF DDF KOF KOF KOF KOF KOF KOF KOF
Accounting document segment Tax data document segment Accounting: Secondary index for customers Accounting: Secondary index for vendors Accounting: Secondary index for G/L accounts G/L Account Master Record Monthly Debits and Credits General Data in Customer Master Customer master (VAT registration numbers general section) Customer master (company code) Customer payment history Customer master (dunning data) Customer master (bank details) Customer master (transaction figures) Customer master (special G/L transaction figures) Customer master credit management: Central data Customer master credit management: Control area data Vendor master (general section) Vendor master (VAT registration numbers general section) Vendor master (company code) Vendor master (dunning data) Vendor master (bank details) Vendor master (transaction figures) Vendor master (special G/L transaction figures) Number range for banks Number range for change documents Payment transfer medium file Prenumbered Checks Change of payment proposals: user and time Settlement data from payment program Processed items from payment program Acounts blocked by payment proposal Control records for the payment program G/L accounts master (chart of accounts) G/L account master record (chart of accounts: description) G/L account master (company code) Company Codes Posting periods allowed Countries Country names House banks
CLUSTER CLUSTER TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP CLUSTER TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP POOL
Table Type TRANSP TRANSP TRANSP TRANSP TRANSP CLUSTER
Application Class FB FB FB FB FB FB
Data Class Transaction Master Transaction Transaction Transaction Transaction
FB FB FB FB FB FB FB FB FB FB FB
Organizational Organizational Organizational Organizational Organizational Organizational Organizational Organizational Organizational Organizational Organizational Master Transaction Transaction
GLFUNCT 汇总 GL 类似GLTO,比GLTO字段多，灵活 GLFUNCA line item, 比BSEG好 G/L account master data fs00 第一屏的 type/description存在SKA1中，其他和company code有关的放在skb1 TFKB functional area descriptn
Description Accounting document header Bank master record Accounting: Secondary index for customers (cleared items) Accounting: Secondary index for vendors (cleared items) Accounting: Secondary index for G/L accounts (cleared items) One-time account data document segment
PYF PYF
FI Tables, Page 1
T012T TBSL TBSLT TCURC TCURF TCURR TCURT TCURV TCURW TGSB TGSBT ANLA MHND MHNK
POOL POOL POOL TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP
Logical Database/s
Notes
BSEG BSET BSID BSIK BSIS GLT0 KNA1 KNAS KNB1 KNB4 KNB5 KNBK KNC1 KNC3 KNKA KNKK LFA1 LFAS LFB1 LFB5 LFBK LFC1 LFC3 NBNK NKUK PAYR PCEC REGUA REGUH REGUP REGUS REGUV SKA1 SKAT SKB1 T001 T001B T005 T005T T012 1160402.xls
1160402.xls
FI Tables, Page 2
House bank account names Posting keys Posting key names Currency codes Conversion Factors Currency exchange rates Currency code names Exchange rate types for currency translation Exchange rate type usage Business Areas Business area names Asset Master Record Segment Dunning data Dunning data (account entries)
FB FB FB FB FB FG FB FB FB FB FB FB FB FB FB FB FB FB FB FB FB FB FB FB FB FBZ FBZ FBZ FBZ FBZ FBZ FBZ FB FB FB FB FB FB FB FB
Transaction Transaction Transaction Transaction Transaction Transaction Master Master Master Master Master Master Master Master Master Master Master Master Master Master Master Master Master Organizational Organizational Transaction Organizational Transaction Transaction Transaction Transaction Transaction Master Master Master Organizational Organizational Organizational Organizational Organizational
wenku.baidu.com
AVOID USING!!! Use BSID, BSIK, and/or BSIS for open items and BSAD, BSAK, and/or BSAS for cleared items
DDF DDF DDF DDF DDF DDF DDF DDF DDF DDF KOF KOF KOF KOF KOF KOF KOF
Accounting document segment Tax data document segment Accounting: Secondary index for customers Accounting: Secondary index for vendors Accounting: Secondary index for G/L accounts G/L Account Master Record Monthly Debits and Credits General Data in Customer Master Customer master (VAT registration numbers general section) Customer master (company code) Customer payment history Customer master (dunning data) Customer master (bank details) Customer master (transaction figures) Customer master (special G/L transaction figures) Customer master credit management: Central data Customer master credit management: Control area data Vendor master (general section) Vendor master (VAT registration numbers general section) Vendor master (company code) Vendor master (dunning data) Vendor master (bank details) Vendor master (transaction figures) Vendor master (special G/L transaction figures) Number range for banks Number range for change documents Payment transfer medium file Prenumbered Checks Change of payment proposals: user and time Settlement data from payment program Processed items from payment program Acounts blocked by payment proposal Control records for the payment program G/L accounts master (chart of accounts) G/L account master record (chart of accounts: description) G/L account master (company code) Company Codes Posting periods allowed Countries Country names House banks
CLUSTER CLUSTER TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP CLUSTER TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP POOL