SAP ABAP Table SBPBWRET_BCS (Structure for Plan Data Transfer)
Hierarchy
☛
EA-PS (Software Component) SAP Enterprise Extension Public Services
⤷ PSM-FM (Application Component) Funds Management
⤷ BPREP_BWRET (Package) Retraction: BW -> R/3
⤷ PSM-FM (Application Component) Funds Management
⤷ BPREP_BWRET (Package) Retraction: BW -> R/3
Basic Data
Table Category | INTTAB | Structure |
Structure | SBPBWRET_BCS | Table Relationship Diagram |
Short Description | Structure for Plan Data Transfer |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Header data for Entry document - Method Create | |||||
2 | FM_AREA | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | FM01 | |
3 | VERSION | BUKU_VERSION | COVERSI | CHAR | 3 | 0 | Budget version | * | |
4 | DOCDATE | BP_BLDAT | DATUM | DATS | 8 | 0 | Document Date | ||
5 | PSTNG_DATE | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
6 | DOCTYPE | BUED_DOCTYPE | BUED_DOCTYPE | CHAR | 4 | 0 | Budget entry document type | FMEDDOCTYPE | |
7 | DOCSTATE | BUED_DOCSTATE | BUED_DOCSTATE | CHAR | 1 | 0 | Status of a budget entry document | ||
8 | PROCESS | BUKU_PROCESS_UI | BUKU_PROCESS_UI | CHAR | 4 | 0 | Budgeting Process | BUPROCESS_UI | |
9 | EXTERNAL_NUMBER | BUED_EXT_DOCNR | BELNR | CHAR | 10 | 0 | External Number for Budget Entry Document | ||
10 | .INCLUDE | 0 | 0 | Header additionnal data | |||||
11 | PERS_RESP | BP_VERANT | VERAB | CHAR | 20 | 0 | Person Responsible for Planning/Budgeting | ||
12 | HEADER_TEXT | BUED_HDTEXT | TEXT50 | CHAR | 50 | 0 | Header Text for Budget Entry Document | ||
13 | PUBLAW | FM_PUBLAW | FM_PUBLAW | CHAR | 20 | 0 | Public Law Cited | ||
14 | LEGIS | FM_LEGIS | FM_LEGIS | CHAR | 1 | 0 | Type of Legislation | ||
15 | COHORT | FM_COHORT | FM_COHORT | CHAR | 4 | 0 | Reporting Year for Cohort | ||
16 | TEXT_NAME | BP_TDNAM | CHAR32 | CHAR | 32 | 0 | Text Name | ||
17 | REF_ORG_UN | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
18 | REF_DOC | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
19 | OBJ_SYS | AWSYS | LOGSYS | CHAR | 10 | 0 | Logical system of source document | * | |
20 | OBJ_TYPE | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
21 | DOCFAM | BUED_DOCFAM | BELNR | CHAR | 10 | 0 | Document Family Number | ||
22 | DOC_YEAR | BUKU_DOCYEAR | GJAHR | NUMC | 4 | 0 | Document Year | ||
23 | DOCUMENT | BUED_DOCNR | BELNR | CHAR | 10 | 0 | Budget entry document number | ||
24 | GET_ITEM | BAPI_GET_ITEM | XFELD | CHAR | 1 | 0 | Item data required | ||
25 | GET_PERIOD | BAPI_GET_PERIOD | XFELD | CHAR | 1 | 0 | Period data required | ||
26 | GET_LONGTEXT | BAPI_GET_LONGTEXT | XFELD | CHAR | 1 | 0 | Long text required | ||
27 | GET_STDTEXT | BAPI_GET_STDTEXT | XFELD | CHAR | 1 | 0 | Standard text required | ||
28 | LANGUAGE | SYLANGU | SYLANGU | LANG | 1 | 0 | Language Key | ||
29 | BAPIMAXROW | BAPIMAXROW | SYST_LONG | INT4 | 10 | 0 | Maximum number of lines of hits | ||
30 | TESTRUN | TESTRUN | BAPIFLAG | CHAR | 1 | 0 | Switch to Simulation Session for Write BAPIs | ||
31 | .INCLUDE | 0 | 0 | Entry Document - Line item | |||||
32 | ITEM_NUM | BUED_DOCLN | DOCLN6 | CHAR | 6 | 0 | Budget entry document line | ||
33 | FISC_YEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
34 | BUDCAT | BUKU_BUDCAT | RLDNR | CHAR | 2 | 0 | Budget Category | * | |
35 | BUDTYPE | BUKU_BUDTYPE | CHAR4 | CHAR | 4 | 0 | Budget Type | ||
36 | FUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | FMFINCODE | |
37 | FUNDS_CTR | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | FMFCTR | |
38 | CMMT_ITEM | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | FMCI | |
39 | FUNC_AREA | FM_FAREA | FKBER | CHAR | 16 | 0 | Functional Area | TFKB | |
40 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
41 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
42 | TRANS_CURR | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | TCURC | |
43 | TRANS_CURR_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
44 | TOTAL_AMOUNT | BAPICURR_D | BAPICURR | DEC | 23 | 4 | Currency amount in BAPI interfaces | ||
45 | DISTKEY | BUKU_SPRED | SPRED | CHAR | 4 | 0 | Distribution Key | T821S | |
46 | ITEM_TEXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
47 | VALTYPE | BUKU_VALTYPE | BUKU_VALTYPE | CHAR | 2 | 0 | BCS Value Type | * | |
48 | CASH_YEAR | GNJHR | GJAHR | NUMC | 4 | 0 | Year of Cash Effectivity | ||
49 | BUDGETING_PERIOD | BUKU_PERIOD | BUKU_PERIOD | NUMC | 3 | 0 | Budgeting period | ||
50 | PERIOD_AMOUNT | BAPICURR_D | BAPICURR | DEC | 23 | 4 | Currency amount in BAPI interfaces | ||
51 | .INCLUDE | 0 | 0 | Long text | |||||
52 | TEXT_ID | TDID | TDID | CHAR | 4 | 0 | Text ID | TTXID | |
53 | FORMAT_COL | TDFORMAT | TDELEMSTYL | CHAR | 2 | 0 | Tag column | ||
54 | TEXT_LINE | TDLINE | TDSTXLLINE | CHAR | 132 | 0 | Text Line | ||
55 | .INCLUDE | 0 | 0 | Ref. structure for BAPI parameter ExtensionIn/ExtensionOut | |||||
56 | STRUCTURE | TE_STRUC | AS4TAB | CHAR | 30 | 0 | Structure name of BAPI table extension | * | |
57 | VALUEPART1 | VALUEPART | CHAR240 | CHAR | 240 | 0 | Data part of BAPI extension parameter | ||
58 | VALUEPART2 | VALUEPART | CHAR240 | CHAR | 240 | 0 | Data part of BAPI extension parameter | ||
59 | VALUEPART3 | VALUEPART | CHAR240 | CHAR | 240 | 0 | Data part of BAPI extension parameter | ||
60 | VALUEPART4 | VALUEPART | CHAR240 | CHAR | 240 | 0 | Data part of BAPI extension parameter | ||
61 | COMPANY_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
62 | CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
63 | ACCOUNT_NUMBER | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
64 | ASSET | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
65 | SUB_ASSET | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
66 | COST_ELEMENT | KSTAR | KSTAR | CHAR | 10 | 0 | Cost Element | * | |
67 | COST_CENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
68 | ORDER_NUMBER | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
69 | WBS_ELEMENT | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
70 | PROFIT_CENTER | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
71 | BUSINESS_ENTITY | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | * | |
72 | PROPERTY_NUMBER | SGRNR | SGRNR | CHAR | 8 | 0 | Land Number for BE | * | |
73 | BUILDING_NUMBER | SGENR | SGENR | CHAR | 8 | 0 | Building Number | * | |
74 | RENTAL_UNIT | SMENR | SMENR | CHAR | 8 | 0 | Number of Rental Unit | * | |
75 | LEASE_NUMBER | SMIVE | VVSMIVE | CHAR | 13 | 0 | Lease-Out Number | ||
76 | SETTLEMENT_UNIT | SEMPSL | SEMPSL | CHAR | 5 | 0 | Settlement Unit | * | |
77 | FUND_TYP | FM_FUNDTYPE | FM_FUNDTYPE | CHAR | 6 | 0 | FM Fund Type | * | |
78 | ORDER_NUMBER_NP | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
79 | ORDER_NUMBER_NV | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
80 | ORDER_POSNR_NV | CO_APLZL | CO_APLZL | NUMC | 8 | 0 | General counter for order | * | |
81 | ORDER_NUMBER_SD | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | * | |
82 | ORDER_POSNR_SD | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
83 | DR_CR_IND | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
84 | TRANSAC | J_VORGANG | J_VORGANG | CHAR | 4 | 0 | Business Transaction | * | |
85 | PARTNER_FUND | FM_PFUND | BP_GEBER | CHAR | 10 | 0 | Partner Fund | * | |
86 | PARTNER_FUND_TYP | FM_FUNDTYPE | FM_FUNDTYPE | CHAR | 6 | 0 | FM Fund Type | * | |
87 | FLG_CO_RECON | FM_FLG_AO | XFELD | CHAR | 1 | 0 | CO reconciliation object | ||
88 | DISTR_CHAN | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
89 | SALESORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
90 | DIVISION | SPART | SPART | CHAR | 2 | 0 | Division | * | |
91 | PLANT | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
92 | BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
93 | ABSCHN | FM_ABSCHN | FM_ABSCHN | CHAR | 12 | 0 | Number of section | * | |
94 | BW_BUDCAT | FMBP_BW_BUDCAT | NUMC1 | NUMC | 1 | 0 | Budget Category from BW | ||
95 | BW_VALTYPE | FMBP_BW_VALTYPE | NUMC2 | NUMC | 2 | 0 | Value Type from BW | ||
96 | BW_BUDDETAIL | FMBP_BW_BUDDETAIL | NUMC3 | NUMC | 3 | 0 | Budget Detail | ||
97 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SBPBWRET_BCS | CMMT_ITEM | FMCI | GJAHR | |||
2 | SBPBWRET_BCS | DISTKEY | T821S | SPRED | |||
3 | SBPBWRET_BCS | DOCTYPE | FMEDDOCTYPE | DOCTYPE | |||
4 | SBPBWRET_BCS | FM_AREA | FM01 | FIKRS | |||
5 | SBPBWRET_BCS | FUNC_AREA | TFKB | FKBER | |||
6 | SBPBWRET_BCS | FUND | FMFINCODE | FINCODE | |||
7 | SBPBWRET_BCS | FUNDS_CTR | FMFCTR | FICTR | |||
8 | SBPBWRET_BCS | PROCESS | BUPROCESS_UI | PROCESS_UI | |||
9 | SBPBWRET_BCS | TEXT_ID | TTXID | TDID | |||
10 | SBPBWRET_BCS | TRANS_CURR | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 110 |