SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | BBP_PDHSS
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1ERP EHP76.0BBP_PDHSS1531Hdr Extension for SAP Internal Enhancements (IBUs and so on)
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT CLIENT, GUID, DUMMY_EEW_PDHSS, PS_HIER_TEMPL, PS_NUMVRS, /LOCSRM/SGUID_BR, PS_COMPLEX_IND, APCGK, APCGK_EXTEND, BAS_DATE, ADATTYP, START_DAT, DEV, INDANX, LIMIT_DAT, NUMERATOR, /LOCSRM/CIG_NUM, /LOCSRM/CUP_NUM, CUP_NUM, CIG_NUM, AWARD_TYPE, CONTRACT_TYPE, PROCESS_NUM_BR, FLAG_PPS_BR, PROCESS_NUM, FLAG_BR, /LOCSRM/LAW123, /LOCSRM/RANTIME, RANTIME_CHATMSG, RANTIME_CHTMSG, PS_PGS_ID, PS_CANCEL_IND, PS_CLOSEOUT, PS_DOCB_ID, PS_IN_DOCB_PROC, PS_SEND_TO_DB, PS_DB_SXMSGUID, PS_DP_TYPE, PS_DP_AMOUNT, PS_DP_PERCENT, PS_DP_DUE_DATE, PS_COMPANY_CODE, PS_POSTING_DATE, PS_ORDER_DATE, PS_FISCAL_YEAR, PS_POST_PERIOD, PS_DOC_DATE_BL, PS_FPDS_STATUS, PS_REQUEST_DATE, PS_GUAR_MIN_QUOT, PS_GUAR_MIN_BID, PS_GM_LEVEL, PS_GM_NO_EMF, PS_GM_CLOSED, PS_IDC_DOC, PS_INFU_ACTIVE, PS_MAX_VALUE_H, PS_CORRES_NOV_PO, PS_MCNGUID, OPT_CPLX_DOC, PS_ULTIM_VALUE, PS_CURR_VALUE, PS_EST_VAL, PS_SC_ID, PS_PARK_IND, PS_PA_ID_HDR, PS_PA_CLNG_HDR, PS_PA_CLNG_IND, PS_INDICATOR, PS_REASON_CODE, PS_SELPROM_BLOCK, PS_SELPROM_REL, PS_LONGNUM, PS_NUMTYPE, PS_EXTERNAL, PS_CHANGE_SERIAL, PS_SET_LPN_FINAL, PS_CLASSCODE, PS_NAICS, PS_SYNOPSISID, PS_SETASIDE, PS_EU_DOCB_ID, PS_EU_DOCB_GUID, PS_EU_DOCB_VER, PS_TNDR_REQ, PS_TNDR_AMNT, PS_TNDR_CL_DT, PS_PQQ_REQ, PS_PQQ_CL_DT, PS_PQQ_AUTO, PS_PQQ_THRSHLD, PS_PQQ, PS_PQQ_SETGUID, PS_BDR_STS_GUID, PS_EMD_REQ, PS_EMD_AMNT, PS_EMD_CL_DT, PS_TNDR_COLB_ID, PS_TNDR_AREA_ID, PS_TECH_OPND, PS_PRICE_OPND, PS_PERM_GUID, PS_TECH_OPEN_DT, PS_TNDR_CL_TM, PS_PQQ_CL_TM, PS_EMD_CL_TM, PS_TECH_OPEN_TM, PS_TECH_QTE_STA, PS_FLDR_SET_GUID, PS_TH_EXCEEDED, PS_CHANGE_TYPE, PS_US01, PS_US02, PS_US03, PS_US04, PS_US05, PS_US06, PS_US07, PS_US08, PS_US09, PS_US10, PS_US01_DATE, PS_US02_DATE, PS_US03_DATE, PS_US04_DATE, PS_US05_DATE, PS_US06_DATE, PS_US07_DATE, PS_US08_DATE, PS_US09_DATE, PS_US10_DATE, PS_WH_PRCNT_HDR, PS_WH_IND, DOC_TYPE_EXI, PAY_METH_EXI, PAY_BLOCK_EXI, CPD_VENDOR_EXI, POBK_CURAC_EXI, BANK_ACCT_EXI, BANK_NO_EXI, BANK_CTRY_EXI, CTRL_KEY_EXI, LAM_SOL_KEY, LAM_HDR_GAID, LAM_HDR_TEXT, ICC_LZBKZ_DE, ICC_LZBKZ_NL, ICC_BR_TAXAMT, BBP_ICC_EXC_NUM, BBP_ICC_EXC_DATE, BBP_ICC_EXC_TXT, BBP_ICC_EXC_PARK, VZSKZ FROM BBP_PDHSS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*EC_CLIENT Allow NULL? 
2GUIDGlobally Unique identifiervarbinary160RAWNoBBP_GUID
3DUMMY_EEW_PDHSSDummy function in length 1char10CHAR(N' ')YesDUMMY Allow NULL? 
4PS_HIER_TEMPLHierarchy Templatenvarchar100CHAR(N' ')Yes*/SAPPSSRM/_HIERTEMPLATE Allow NULL? 
5PS_NUMVRSVersion number for item numberingnvarchar60NUMC(N'000000')Yes/SAPPSSRM/_VERSNO Allow NULL? 
6/LOCSRM/SGUID_BRGUID Object is a Copy ofvarbinary160RAWYesBBP_COPY_OF_GUID
7PS_COMPLEX_INDComplex Documents Indicatorchar10CHAR(N' ')Yes/SAPPSSRM/PS_COMPLEX_INDICATOR Allow NULL? 
8APCGKAnnexing Package Keynvarchar40NUMC(N'0000')Yes/LOCSRM/TAPCGK_IL Allow NULL? 
9APCGK_EXTENDExtended key for annexing packagenvarchar100NUMC(N'0000000000')Yes/LOCSRM/TAPCGK_EXT_IL Allow NULL? 
10BAS_DATEBase Datenvarchar80DATS(N'00000000')Yes/LOCSRM/TBASDATE_IL Allow NULL? 
11ADATTYPAnnexing Date Typechar10CHAR(N' ')Yes/LOCSRM/TADATTYP_IL Allow NULL? 
12START_DATAnnexing Start Datenvarchar80DATS(N'00000000')Yes/LOCSRM/TASDAT_IL Allow NULL? 
13DEVDeviation Percentagedecimal63DEC((0))Yes/LOCSRM/TMPERC_IL
14INDANXOrder Type Annexedchar10CHAR(N' ')Yes/LOCSRM/TMANIND_IL Allow NULL? 
15LIMIT_DATAnnexing Limit Datenvarchar80DATS(N'00000000')Yes/LOCSRM/TALDAT_IL Allow NULL? 
16NUMERATORChar 20nvarchar200CHAR(N' ')YesCHAR20 Allow NULL? 
17/LOCSRM/CIG_NUMData Element for CIG Numbernvarchar100CHAR(N' ')Yes/LOCSRM/CIGNUM_IT Allow NULL? 
18/LOCSRM/CUP_NUMData Element for CUP Numbernvarchar150CHAR(N' ')Yes/LOCSRM/CUPNUM_IT Allow NULL? 
19CUP_NUMData Element for CUP Numbernvarchar150CHAR(N' ')Yes/LOCSRM/CUPNUM_IT Allow NULL? 
20CIG_NUMData Element for CIG Numbernvarchar100CHAR(N' ')Yes/LOCSRM/CIGNUM_IT Allow NULL? 
21AWARD_TYPEAward Typenvarchar30CHAR(N' ')Yes/LOCSRM/AWARDTP_PPS_ES Allow NULL? 
22CONTRACT_TYPEContract Typenvarchar30CHAR(N' ')Yes/LOCSRM/CONTRACTTP_PPS_ES Allow NULL? 
23PROCESS_NUM_BRProcess Numbernvarchar100CHAR(N' ')Yes/LOCSRM/PROCESS_NUM Allow NULL? 
24FLAG_PPS_BRBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
25PROCESS_NUMProcess Numbernvarchar100CHAR(N' ')Yes/LOCSRM/PROCESS_NUM Allow NULL? 
26FLAG_BRBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
27/LOCSRM/LAW123Brazilian field for LAW123 active indicatorchar10CHAR(N' ')Yes/LOCSRM/LA_LAW123_AUC_BR Allow NULL? 
28/LOCSRM/RANTIMEBrazilian field for Random Time extend indicatorchar10CHAR(N' ')Yes/LOCSRM/LA_RANDOMTIME_BR Allow NULL? 
29RANTIME_CHATMSGBrazilian field for Random Time extend Chat Msg indicatorchar10CHAR(N' ')Yes/LOCSRM/LA_RAN_CHAT_BR Allow NULL? 
30RANTIME_CHTMSGBrazilian field for Random Time extend Chat Msg indicatorchar10CHAR(N' ')Yes/LOCSRM/LA_RAN_CHAT_BR Allow NULL? 
31PS_PGS_IDPartner Grouping Schema IDnvarchar160CHAR(N' ')Yes/SAPPSSRM/_BPM_PGS_ID Allow NULL? 
32PS_CANCEL_INDCancel at Header Levelchar10CHAR(N' ')Yes/SAPPSSRM/_PO_CNCL_IND Allow NULL? 
33PS_CLOSEOUTClose-Out Statuschar10CHAR(N' ')Yes/SAPPSSRM/_US_CLOSE Allow NULL? 
34PS_DOCB_IDDocument Builder IDnvarchar150CHAR(N' ')Yes/SAPPSSRM/DOCB_ID Allow NULL? 
35PS_IN_DOCB_PROCGeneral Flagchar10CHAR(N' ')YesFLAG Allow NULL? 
36PS_SEND_TO_DBUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTIMESTAMP
37PS_DB_SXMSGUIDGUID for Integration Engine Objectsvarbinary160RAWYes/SAPPSSRM/_XMSGUID
38PS_DP_TYPEDown Payment Indicatornvarchar40CHAR(N' ')Yes*/SAPPSSRM/_DP_TYPE Allow NULL? 
39PS_DP_AMOUNTDown Paymentdecimal112CURR((0))Yes/SAPPSSRM/_DP_AMOUNT
40PS_DP_PERCENTDown Payment Percentagedecimal52DEC((0))Yes/SAPPSSRM/_DP_PERCENT
41PS_DP_DUE_DATEDown Payment Due Datenvarchar80DATS(N'00000000')Yes/SAPPSSRM/_DP_DUE_DATE Allow NULL? 
42PS_COMPANY_CODECompany Codenvarchar200CHAR(N' ')YesBBP_COMPANY_CODE Allow NULL? 
43PS_POSTING_DATEPosting Date for Funds Management Docs (for Smart Numbering)nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_BOOKING_DATE_SN Allow NULL? 
44PS_ORDER_DATEOrder Date of Document (for Smart Numbering)nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_DOC_DATE_CHANGE_SN Allow NULL? 
45PS_FISCAL_YEARFiscal Yearnvarchar40NUMC(N'0000')Yes/SAPPSSRM/_YEAR Allow NULL? 
46PS_POST_PERIODPosting Date Period for Special Periodsnvarchar30NUMC(N'000')Yes/SAPPSSRM/_POST_PERIOD Allow NULL? 
47PS_DOC_DATE_BLDocument Date for Budgetary Ledgernvarchar80DATS(N'00000000')Yes/SAPPSSRM/_DOC_DATE_BL Allow NULL? 
48PS_FPDS_STATUSFPDS Reporting Statusnvarchar40CHAR(N' ')Yes/SAPPSSRM/_FPDS_STATUS Allow NULL? 
49PS_REQUEST_DATEFuture Datenvarchar80DATS(N'00000000')Yes/SAPPSSRM/_FUTURE_DATE Allow NULL? 
50PS_GUAR_MIN_QUOTGuaranteed Minimum Amountdecimal152CURR((0))Yes/SAPPSSRM/_GUAR_MIN
51PS_GUAR_MIN_BIDGuaranteed Minimum Amountdecimal152CURR((0))Yes/SAPPSSRM/_GUAR_MIN
52PS_GM_LEVELGuaranteed Minimum Levelnvarchar30CHAR(N' ')Yes/SAPPSSRM/_GUAR_MIN_LEVEL Allow NULL? 
53PS_GM_NO_EMFGuar. Min.: Suppress earmarked funds creation at savechar10CHAR(N' ')Yes/SAPPSSRM/_NO_EMF Allow NULL? 
54PS_GM_CLOSEDClose Indicator for Earmarked fundschar10CHAR(N' ')Yes/SAPPSSRM/_CLOSE_CMT Allow NULL? 
55PS_IDC_DOCOrder Typechar10CHAR(N' ')Yes/SAPPSSRM/IDC_INDICATOR Allow NULL? 
56PS_INFU_ACTIVEIncremental Funding Activechar10CHAR(N' ')Yes/SAPPSSRM/_INFU_ACTIVE Allow NULL? 
57PS_MAX_VALUE_HMaximum Order Value in Item Currencydecimal152CURR((0))Yes/SAPPSSRM/_MAX_VAL
58PS_CORRES_NOV_POCorresponding Novation Purchase Ordernvarchar100CHAR(N' ')Yes/SAPPSSRM/_CORRES_NOV_PO Allow NULL? 
59PS_MCNGUIDMass Change/Novation GUID in Object (Internal ID)varbinary160RAWYes/SAPPSSRM/_MCNGUID
60OPT_CPLX_DOCDocuments Containing Optionschar10CHAR(N' ')YesBBP_OPT_CPLX_DOC Allow NULL? 
61PS_ULTIM_VALUEUltimate Option Document Valuedecimal152CURR((0))Yes/SAPPSSRM/_OPT_ULTIMATE_VALUE
62PS_CURR_VALUECurrent Value of Option Contractdecimal152CURR((0))Yes/SAPPSSRM/_OPT_CURR_VAL
63PS_EST_VALEstimated Value of Option Contractdecimal152CURR((0))Yes/SAPPSSRM/_OPT_EST_VAL
64PS_SC_IDShopping Cart Numbernvarchar100CHAR(N' ')YesBBP_SC_NUMBER Allow NULL? 
65PS_PARK_INDPark Indicatorchar10CHAR(N' ')Yes/SAPPSSRM/_PARK_IND Allow NULL? 
66PS_PA_ID_HDRPricing Arrangement Identifiernvarchar40CHAR(N' ')Yes/SAPPSSRM/_PA_STRUC_ID Allow NULL? 
67PS_PA_CLNG_HDRCeiling Amountdecimal152CURR((0))Yes/SAPPSSRM/_PA_CEILING_AMOUNT
68PS_PA_CLNG_INDHeader Ceiling Amount Indicatorchar10CHAR(N' ')Yes/SAPPSSRM/_PA_CEILING_IND Allow NULL? 
69PS_INDICATORIndicatorchar10CHAR(N' ')Yes/SAPPSSRM/_INDICATOR Allow NULL? 
70PS_REASON_CODEReason Codenvarchar40CHAR(N' ')Yes/SAPPSSRM/_GR_REASON_CODE Allow NULL? 
71PS_SELPROM_BLOCKSelective Release Statuschar10CHAR(N' ')Yes/SAPPSSRM/_SP_BLOCK_FLAG Allow NULL? 
72PS_SELPROM_RELIndicator: Releasechar10CHAR(N' ')Yes/SAPPSSRM/_SP_RELEASE_FLAG Allow NULL? 
73PS_LONGNUMSmart Numbernvarchar400CHAR(N' ')Yes/SAPPSSRM/_LONGNUM Allow NULL? 
74PS_NUMTYPEType of Numbering Schemenvarchar100CHAR(N' ')Yes/SAPPSSRM/_NUMTYPE Allow NULL? 
75PS_EXTERNALExternal Smart Numberchar10CHAR(N' ')Yes/SAPPSSRM/_EXTERNAL_FLAG Allow NULL? 
76PS_CHANGE_SERIALGenerate New Serial Numberchar10CHAR(N' ')Yes/SAPPSSRM/_CHANGE_FLAG Allow NULL? 
77PS_SET_LPN_FINALSet as Final Smart Numberchar10CHAR(N' ')Yes/SAPPSSRM/_SET_LPN_FINAL Allow NULL? 
78PS_CLASSCODEClassification Codenvarchar500CHAR(N' ')Yes/SAPPSSRM/_CLASSCODE Allow NULL? 
79PS_NAICSNAICS Codenvarchar60CHAR(N' ')Yes/SAPPSSRM/_NAICS Allow NULL? 
80PS_SYNOPSISIDSynopsis IDnvarchar250CHAR(N' ')Yes/SAPPSSRM/_SYNOPSISID Allow NULL? 
81PS_SETASIDESet Asidenvarchar40CHAR(N' ')Yes/SAPPSSRM/_SETASIDE Allow NULL? 
82PS_EU_DOCB_IDDocument Builder IDnvarchar150CHAR(N' ')Yes/SAPPSSRM/_DOCB_ID Allow NULL? 
83PS_EU_DOCB_GUIDDocument Builder GUIDvarbinary160RAWYes/SAPPSSRM/_DOCB_GUID
84PS_EU_DOCB_VERDocument Builder Versionnvarchar100CHAR(N' ')Yes/SAPPSSRM/_DOCB_VERSION Allow NULL? 
85PS_TNDR_REQTender Fee Requiredchar10CHAR(N' ')Yes/SAPPSSRM/_TND_PMNT_REQ Allow NULL? 
86PS_TNDR_AMNTTender Fee Amountdecimal152CURR((0))Yes/SAPPSSRM/_TENDAMNT
87PS_TNDR_CL_DTTender Fee Closing Datenvarchar80DATS(N'00000000')Yes/SAPPSSRM/_TNDR_FEE_CLOSE_DATE Allow NULL? 
88PS_PQQ_REQPQQ Requiredchar10CHAR(N' ')Yes/SAPPSSRM/_PQQ_REQ_CHECK Allow NULL? 
89PS_PQQ_CL_DTPQQ Closing Datenvarchar80DATS(N'00000000')Yes/SAPPSSRM/_PQQ_CLOSE_DATE Allow NULL? 
90PS_PQQ_AUTOProcess PQQ Automaticallychar10CHAR(N' ')Yes/SAPPSSRM/_PQQ_AUTOMATIC Allow NULL? 
91PS_PQQ_THRSHLDPQQ Threshold Valuesmallint50INT2((0))Yes/SAPPSSRM/_THRSH_HOLD_VAL
92PS_PQQPrequalification Questionnairenvarchar50CHAR(N' ')Yes/SAPPSSRM/_PQQ_GROUP Allow NULL? 
93PS_PQQ_SETGUIDSet GUIDvarbinary160RAWYesBBP_SETGUID
94PS_BDR_STS_GUIDGlobally Unique identifiervarbinary160RAWYesBBP_GUID
95PS_EMD_REQEarnest Money Deposit Requiredchar10CHAR(N' ')Yes/SAPPSSRM/_EMD_PMNT_REQ Allow NULL? 
96PS_EMD_AMNTEarnest Money Deposit Amountdecimal152CURR((0))Yes/SAPPSSRM/_EMDAMNT
97PS_EMD_CL_DTEMD Closing Datenvarchar80DATS(N'00000000')Yes/SAPPSSRM/_EMD_CLOSE_DATE Allow NULL? 
98PS_TNDR_COLB_IDcFolder Collaboration IDnvarchar320CHAR(N' ')Yes/SAPPSSRM/_CFOLD_COLLAB Allow NULL? 
99PS_TNDR_AREA_IDcFolder Collaboration Area IDnvarchar320CHAR(N' ')Yes/SAPPSSRM/_CFOLD_AREA Allow NULL? 
100PS_TECH_OPNDRFx Response Open Statuschar10CHAR(N' ')Yes/SAPPSSRM/_TNDROPN Allow NULL? 
101PS_PRICE_OPNDRFx Response Open Statuschar10CHAR(N' ')Yes/SAPPSSRM/_TNDROPN Allow NULL? 
102PS_PERM_GUIDGUID Key for Permissionsvarbinary160RAWYes/SAPPSSRM/_PERMGUID
103PS_TECH_OPEN_DTTechnical RFx Response Opening Datenvarchar80DATS(N'00000000')Yes/SAPPSSRM/_TECH_OPEN_DATE Allow NULL? 
104PS_TNDR_CL_TMTender Closing Timenvarchar60TIMS(N'000000')Yes/SAPPSSRM/_TNDR_CL_TIME Allow NULL? 
105PS_PQQ_CL_TMPQQ Closing Timenvarchar60TIMS(N'000000')Yes/SAPPSSRM/_PQQ_CL_TIME Allow NULL? 
106PS_EMD_CL_TMEMD Closing Timenvarchar60TIMS(N'000000')Yes/SAPPSSRM/_EMD_CL_TIME Allow NULL? 
107PS_TECH_OPEN_TMTechnical RFx Response Opening Timenvarchar60TIMS(N'000000')Yes/SAPPSSRM/_TECH_OPEN_TIME Allow NULL? 
108PS_TECH_QTE_STATechnical RFx Response Statuschar10CHAR(N' ')Yes/SAPPSSRM/_TECH_BID_STATUS Allow NULL? 
109PS_FLDR_SET_GUIDGlobally Unique identifiervarbinary160RAWYesBBP_GUID
110PS_TH_EXCEEDEDThreshold Exceededchar10CHAR(N' ')Yes/SAPPSSRM/_TH_EXCEEDED Allow NULL? 
111PS_CHANGE_TYPEChanges Require Supplier Approvalchar10CHAR(N' ')Yes/SAPPSSRM/_UNI_BILITERAL_CHANG Allow NULL? 
112PS_US01User-Specified Status 01nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_01 Allow NULL? 
113PS_US02User-Specified Status 02nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_02 Allow NULL? 
114PS_US03User-Specified Status 03nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_03 Allow NULL? 
115PS_US04User-Specified Status 04nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_04 Allow NULL? 
116PS_US05User-Specified Status 05nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_05 Allow NULL? 
117PS_US06User-Specified Status 06nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_06 Allow NULL? 
118PS_US07User-Specified Status 07nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_07 Allow NULL? 
119PS_US08User-Specified Status 08nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_08 Allow NULL? 
120PS_US09User-Specified Status 09nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_09 Allow NULL? 
121PS_US10User-Specified Status 10nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_10 Allow NULL? 
122PS_US01_DATEDate of User-Specified Status 01nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US01_DATE Allow NULL? 
123PS_US02_DATEDate of User-Specified Status 02nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US02_DATE Allow NULL? 
124PS_US03_DATEDate of User-Specified Status 03nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US03_DATE Allow NULL? 
125PS_US04_DATEDate of User-Specified Status 04nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US04_DATE Allow NULL? 
126PS_US05_DATEDate of User-Specified Status 05nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US05_DATE Allow NULL? 
127PS_US06_DATEDate of User-Specified Status 06nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US06_DATE Allow NULL? 
128PS_US07_DATEDate of User-Specified Status 07nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US07_DATE Allow NULL? 
129PS_US08_DATEDate of User-Specified Status 08nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US08_DATE Allow NULL? 
130PS_US09_DATEDate of User-Specified Status 09nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US09_DATE Allow NULL? 
131PS_US10_DATEDate of User-Specified Status 10nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US10_DATE Allow NULL? 
132PS_WH_PRCNT_HDRRetention Value as Percentagedecimal52DEC((0))Yes/SAPPSSRM/_WH_PERCENT
133PS_WH_INDRetention Indicatorchar10CHAR(N' ')Yes/SAPPSSRM/_WH_IND Allow NULL? 
134DOC_TYPE_EXIDocument Typenvarchar20CHAR(N' ')YesDOC_TYPE_EXI Allow NULL? 
135PAY_METH_EXIPayment Methodchar10CHAR(N' ')YesPAY_METH_EXI Allow NULL? 
136PAY_BLOCK_EXICheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
137CPD_VENDOR_EXINew Input Valueschar10CHAR(N' ')YesXFLAG Allow NULL? 
138POBK_CURAC_EXIAccount Number of Bank Account At Post Officenvarchar160CHAR(N' ')YesPSKTO Allow NULL? 
139BANK_ACCT_EXIBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
140BANK_NO_EXIBank numbernvarchar150CHAR(N' ')YesBANKL Allow NULL? 
141BANK_CTRY_EXIBank country keynvarchar30CHAR(N' ')Yes*BANKS Allow NULL? 
142CTRL_KEY_EXIBank Control Keynvarchar20CHAR(N' ')YesBKONT Allow NULL? 
143LAM_SOL_KEYSolution Keynvarchar100CHAR(N' ')Yes*CUF_SOL_KEY Allow NULL? 
144LAM_HDR_GAIDExternal Allocation Numbernvarchar160CHAR(N' ')YesLAM_ALLOCATION_ID Allow NULL? 
145LAM_HDR_TEXTText (length 35)nvarchar350CHAR(N' ')YesTEXT35 Allow NULL? 
146ICC_LZBKZ_DEState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
147ICC_LZBKZ_NLState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
148ICC_BR_TAXAMTTax Amountdecimal152CURR((0))YesBBP_TAX_AMOUNT
149BBP_ICC_EXC_NUMExcise Document Numbernvarchar100CHAR(N' ')YesBBP_ICC_EXNUM_IN Allow NULL? 
150BBP_ICC_EXC_DATEExcise Document Datenvarchar80DATS(N'00000000')YesBBP_ICC_EXDATE_IN Allow NULL? 
151BBP_ICC_EXC_TXTText Information for Country Versionsnvarchar600CHAR(N' ')YesBBP_ICC_TEXT Allow NULL? 
152BBP_ICC_EXC_PARKGeneral Flagchar10CHAR(N' ')YesFLAG Allow NULL? 
153VZSKZInterest Calculation Indicatornvarchar20CHAR(N' ')Yes*FPIA_INTEREST_INDICATOR Allow NULL? 
NamePrimaryUniqueTypeColumns
BBP_PDHSS~0YesYesCLUSTEREDGUID, CLIENT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy