SAP ABAP Table SBPBWRET (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
Basic Data
Table Category INTTAB    Structure 
Structure SBPBWRET   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 OVERALL BP_WGES X CHAR 1   0   Overall values too  
62 AUTORELEASE FM_BK_AUTORELEASE X CHAR 1   0   Automatic Release  
63 RESPONSIBLE BP_VERANT VERAB CHAR 20   0   Person Responsible for Planning/Budgeting  
64 RPUBLAW FM_PUBLAW FM_PUBLAW CHAR 20   0   Public Law Cited  
65 RLEGIS FM_LEGIS FM_LEGIS CHAR 1   0   Type of Legislation  
66 RCOHORT FM_COHORT FM_COHORT CHAR 4   0   Reporting Year for Cohort  
67 AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure *
68 AWREF AWREF AWREF CHAR 10   0   Reference document number  
69 AWORG AWORG AWORG CHAR 10   0   Reference organisational units  
70 AWSYS AWSYS LOGSYS CHAR 10   0   Logical system of source document *
71 VALUE_DATE BD_VADAT DATUM DATS 8   0   Planning/budgeting value date  
72 DOC_DATE BP_BLDAT DATUM DATS 8   0   Document Date  
73 POSTING_DATE BUDAT DATUM DATS 8   0   Posting Date in the Document  
74 POSTING_PERIOD POPER POPER NUMC 3   0   Posting period  
75 DOC_TEXT SGTXT TEXT50 CHAR 50   0   Item Text  
76 VALKEY BP_VALKEY BP_VALKEY CHAR 10   0   Validation Key Budget/Planning  
77 VALUE_TYPE CO_WRTTP CO_WRTTP CHAR 2   0   Value Type  
78 BDGT_TYPE BP_VORGANG ACTIVITY CHAR 4   0   Budget Type Budgeting/Planning *
79 BDGT_SUBTYPE BP_SUBVO BP_SUBVO CHAR 4   0   Budget Subtype *
80 COMMT_YEAR GNJHR GJAHR NUMC 4   0   Year of Cash Effectivity  
81 PERIOD POPER POPER NUMC 3   0   Posting period  
82 DISTR_KEY SPRED SPRED CHAR 4   0   Distribution Key *
83 FAREA FM_FAREA FKBER CHAR 16   0   Functional Area *
84 LNITEM_GROUP FM_LNITEM_GROUP FM_LNITEM_GROUP NUMC 3   0   Doc. Line Items Grp  
85 VALUE BP_WERT3 WERTV8 CURR 15   2   Amount  
86 COMPANY_CODE BUKRS BUKRS CHAR 4   0   Company Code *
87 CO_AREA KOKRS CACCD CHAR 4   0   Controlling Area *
88 ACCOUNT_NUMBER SAKNR SAKNR CHAR 10   0   G/L Account Number *
89 ASSET ANLN1 ANLN1 CHAR 12   0   Main Asset Number *
90 SUB_ASSET ANLN2 ANLN2 CHAR 4   0   Asset Subnumber *
91 COST_ELEMENT KSTAR KSTAR CHAR 10   0   Cost Element *
92 COST_CENTER KOSTL KOSTL CHAR 10   0   Cost Center *
93 ORDER_NUMBER AUFNR AUFNR CHAR 12   0   Order Number *
94 WBS_ELEMENT PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
95 PROFIT_CENTER PRCTR PRCTR CHAR 10   0   Profit Center *
96 BUSINESS_ENTITY SWENR SWENR CHAR 8   0   Business Entity Number *
97 PROPERTY_NUMBER SGRNR SGRNR CHAR 8   0   Land Number for BE *
98 BUILDING_NUMBER SGENR SGENR CHAR 8   0   Building Number *
99 RENTAL_UNIT SMENR SMENR CHAR 8   0   Number of Rental Unit *
100 LEASE_NUMBER SMIVE VVSMIVE CHAR 13   0   Lease-Out Number  
101 SETTLEMENT_UNIT SEMPSL SEMPSL CHAR 5   0   Settlement Unit *
102 FUND_TYP FM_FUNDTYPE FM_FUNDTYPE CHAR 6   0   FM Fund Type *
103 ORDER_NUMBER_NP NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment *
104 ORDER_NUMBER_NV CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
105 ORDER_POSNR_NV CO_APLZL CO_APLZL NUMC 8   0   General counter for order *
106 ORDER_NUMBER_SD VBELN VBELN CHAR 10   0   Sales and Distribution Document Number *
107 ORDER_POSNR_SD POSNR_VA POSNR NUMC 6   0   Sales Document Item *
108 DR_CR_IND SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
109 TRANSAC J_VORGANG J_VORGANG CHAR 4   0   Business Transaction *
110 PARTNER_FUND FM_PFUND BP_GEBER CHAR 10   0   Partner Fund *
111 PARTNER_FUND_TYP FM_FUNDTYPE FM_FUNDTYPE CHAR 6   0   FM Fund Type *
112 FLG_CO_RECON FM_FLG_AO XFELD CHAR 1   0   CO reconciliation object  
113 DISTR_CHAN VTWEG VTWEG CHAR 2   0   Distribution Channel *
114 SALESORG VKORG VKORG CHAR 4   0   Sales Organization *
115 DIVISION SPART SPART CHAR 2   0   Division *
116 PLANT WERKS_D WERKS CHAR 4   0   Plant *
117 BUS_AREA GSBER GSBER CHAR 4   0   Business Area *
118 ABSCHN FM_ABSCHN FM_ABSCHN CHAR 12   0   Number of section *
119 BW_BUDCAT FMBP_BW_BUDCAT NUMC1 NUMC 1   0   Budget Category from BW  
120 BW_VALTYPE FMBP_BW_VALTYPE NUMC2 NUMC 2   0   Value Type from BW  
121 BW_BUDDETAIL FMBP_BW_BUDDETAIL NUMC3 NUMC 3   0   Budget Detail  
122 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SBPBWRET CMMT_ITEM FMCI GJAHR    
2 SBPBWRET DISTKEY T821S SPRED    
3 SBPBWRET DOCTYPE FMEDDOCTYPE DOCTYPE    
4 SBPBWRET FM_AREA FM01 FIKRS    
5 SBPBWRET FUNC_AREA TFKB FKBER    
6 SBPBWRET FUND FMFINCODE FINCODE    
7 SBPBWRET FUNDS_CTR FMFCTR FICTR    
8 SBPBWRET PROCESS BUPROCESS_UI PROCESS_UI    
9 SBPBWRET TEXT_ID TTXID TDID    
10 SBPBWRET TRANS_CURR TCURC WAERS    
History
Last changed by/on SAP  20130529 
SAP Release Created in 462