SAP相关数据库表

第1章 SAP相关数据库表

1.1 Tcode代码表

Tstc

1.2 预算相关表

1.3 作业相关表

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 数据库列表

PP

(2010-11-0511:28:52)

分类：

标

签：

Delivery?class

The?delivery?class?controls?the?transport?of?table?data?when?installing?or?upgrading,?in?a?cli ent?copy?and?when?transporting?between?customer?systems.?The?delivery?class?is?also?used?in?th e?extended?table?maintenance.

There?are?the?following?delivery?classes:

A:?Application?table?(master?and?transaction?data).

C:?Customer?table,?data?is?maintained?by?the?customer?only.

L:?Table?for?storing?temporary?data.

G:?Customer?table,?SAP?may?insert?new?data?records,?but?may?not?overwrite?or?delete?exist ing?data?records.

E:?System?table?with?its?own?namespaces?for?customer?entries.?The?customer?namespace?m ust?be?defined?in?table?TRESC.

S:?System?table,?data?changes?have?the?same?status?as?program?changes.

W:?System?table?(e.g.?table?of?the?development?environment)?whose?data?is?transported?wit h?its?own?transport?objects?(e.g.?R3TR?PROG,?R3TR?TABL,?etc.).

Behavior?during?client?copy

Only?the?data?of?client-specific?tables?is?copied.

Classes?C,?G,?E,?S:?The?data?records?of?the?table?are?copied?to?the?target?client.

Classes?W,?L:?The?data?records?of?the?table?are?not?copied?to?the?target?client.

Class?A:?Data?records?are?only?copied?to?the?target?client?if?explicitly?requested?(parameter? option).?Normally?it?does?not?make?sense?to?transport?such?data,?but?is?supported?to?permit?yo u?to?copy?an?entire?client?environment.

Behavior?during?installation,?upgrade?and?language?import

The?behavior?differs?here?for?client-specific?and?cross-client?tables.

Client-specific?tables

Classes?A?and?C:?Data?is?only?imported?into?client?000.?Existing?data?records?are?overwritte n.

Classes?E,?S?and?W:?Data?is?imported?into?all?clients.?Existing?data?records?are?overwritten.

Class?G:?Existing?data?records?are?overwritten?in?client?000.?In?all?other?clients,?new?data?re cords?are?inserted,?but?existing?data?records?are?not?overwritten.

Class?L:?No?data?is?imported.

Cross-client?tables