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

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_PDISS1722Item Ext. 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_PDISS, PS_HL_ITEM, PS_HANDLE_ITM, PS_EXSNR, PS_CTRL_KEY, PS_IPT, PS_VALUE_RU, PS_EXLIN_IND, PS_EXT_IND_STATE, APCGK, APCGK_EXTEND, BAS_DATE, ADATTYP, START_DAT, DEV, INDANX, LIMIT_DAT, NUMERATOR, PS_FP_EXCPE, PS_TAX_CODE, PS_CNCL_BO_HDR, PS_CLOSEOUT, PS_DP_TYPE, PS_DP_AMOUNT, PS_DP_PERCENT, PS_DP_DUE_DATE, PS_GUAR_MIN_BID, PS_GUAR_MIN_QUOT, PS_GM_NO_EMF, PS_GM_CLOSED, PS_IDC_TYPE, PS_IDC_MIN_VAL, PS_IDC_MIN_QTY, PS_GUARANT_MIN, PS_IDC_VALUE, PS_INFU_IND, PS_SC_AC03, PS_SC_MK03, PS_MQP_I_DAYS, PS_MQP_I_QUAN, PS_MQP_F_DAYS, PS_MQP_F_QUAN, PS_MQP_I_DAY_BID, PS_MQP_I_QUA_BID, PS_MQP_F_DAY_BID, PS_MQP_F_QUA_BID, PS_ORIG_ACCEPT, PS_ORIG_ACC_BID, PS_POP, PS_POP_STATUS, PS_REF_GUID, PS_POP_SET, OPT_IND, OPT_STATUS, OPT_XPER_START, OPT_XPER_END, OPT_REF_GUID, PS_PO_HDR_GUID, PS_PO_HDR_NUM, PS_PO_ITM_GUID, PS_PO_ITM_NUM, PS_PO_OPEN_QUAN, PS_PA_ID, PS_PA_MIN_FEE, PS_PA_MAX_FEE, PS_PA_GS_BLW, PS_PA_GS_ABV, PS_PA_CLNG_AMT, PS_PA_TOTL_AMT, PS_PA_NTE_IND, PS_PA_NSP_IND, PS_PA_COMP_KEY, PS_PA_COMP_TYPE, PS_PA_CLOSE_CMMT, PS_DOC_ITEM, PS_IV_PLAN_NUM, PS_IP_TYPE, PS_IP_TYPE_DESC, PS_PERIO, PS_PERIO_DESC, PS_IN_ADVANCE, PS_DEV_BILL_DAT, PS_DEV_DAT_DESC, PS_START_DATE, PS_ORGN_ST_DAT, PS_ST_DAT_DES, PS_DATES_FROM, PS_ORGN_FROM_DAT, PS_FROM_DAT_DES, PS_END_DATE, PS_ORGN_END_DAT, PS_END_DAT_DES, PS_DATES_TO, PS_UNTIL_DAT, PS_UNTIL_DAT_DES, PS_HORIZON_DATE, PS_HORIZON, PS_HORIZON_DESC, PS_CALENDER_ID, PS_IS_PP, PS_PHASED_DEL, OPT_POP_START, OPT_POP_END, PS_DLV_PRIO, PS_PRIO_CODE, PS_FAST_PAY, PS_PPA_EXCL, PS_O_BO_OBJ_ID, PS_O_BO_OBJ_TY, PS_O_BO_DESC, PS_O_BO_GUID, PS_O_BO_ITM_NO, PS_O_BO_DRAFT, PS_O_BO_DOC_TY, PS_REASON_CODE, PS_EXTERNAL_ITEM, PS_MAX_QTY, PS_MAX_VALUE, PS_VENDOR_MLTPL, PS_SUBCON_ITEM, PS_TH_NOT_REL, PS_TH_TYPE, PS_TH_NUMBER, PS_TH_AVAIL_AMT, PS_TH_CURRENCY, 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_US01_TXT, PS_US02_TXT, PS_US03_TXT, PS_US04_TXT, PS_US05_TXT, PS_US06_TXT, PS_US07_TXT, PS_US08_TXT, PS_US09_TXT, PS_US10_TXT, PS_WH_PRCNT, PS_WH_IND_PA, LAM_QUO_ID, LAM_QUO_ITMNO, LAM_CTR_ID, LAM_CTR_ITMNO, LAM_GAID, LAM_ASS_PO_ID, LAM_EXT_REF1, LAM_EXT_REF2, LAM_TEXT, NO_DISCOUNT_EXI, ICC_BR_TAXCODE, ICC_BR_TAXAMT, ICC_BR_TAXDES FROM BBP_PDISS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*EC_CLIENT Allow NULL? 
2GUIDGlobally Unique identifiervarbinary160RAWNoBBP_GUID
3DUMMY_EEW_PDISSDummy function in length 1char10CHAR(N' ')YesDUMMY Allow NULL? 
4PS_HL_ITEMHigher-Level Item GUIDvarbinary160RAWYes/SAPPSSRM/_HL_ITEM
5PS_HANDLE_ITMGlobally Unique identifiervarbinary160RAWYesBBP_GUID
6PS_EXSNRExternal Sort Numbernvarchar50NUMC(N'00000')Yes/SAPPSSRM/_EXSNR Allow NULL? 
7PS_CTRL_KEYItem Process Type Control Keynvarchar40CHAR(N' ')Yes*/SAPPSSRM/_PS_CTRL_KEY Allow NULL? 
8PS_IPTPublic Sector Item Typenvarchar100CHAR(N' ')Yes*/SAPPSSRM/_IPT Allow NULL? 
9PS_VALUE_RUNet Valuedecimal152CURR((0))YesBBP_VALUE
10PS_EXLIN_INDEXLIN Indicatorchar10CHAR(N' ')Yes/SAPPSSRM/_EXLIN_IND Allow NULL? 
11PS_EXT_IND_STATECheckbox Status on the UIchar10CHAR(N' ')Yes/SAPPSSRM/_EXT_IND_UI_STATE Allow NULL? 
12APCGKAnnexing Package Keynvarchar40NUMC(N'0000')Yes/LOCSRM/TAPCGK_IL Allow NULL? 
13APCGK_EXTENDExtended key for annexing packagenvarchar100NUMC(N'0000000000')Yes/LOCSRM/TAPCGK_EXT_IL Allow NULL? 
14BAS_DATEBase Datenvarchar80DATS(N'00000000')Yes/LOCSRM/TBASDATE_IL Allow NULL? 
15ADATTYPAnnexing Date Typechar10CHAR(N' ')Yes/LOCSRM/TADATTYP_IL Allow NULL? 
16START_DATAnnexing Start Datenvarchar80DATS(N'00000000')Yes/LOCSRM/TASDAT_IL Allow NULL? 
17DEVDeviation Percentagedecimal63DEC((0))Yes/LOCSRM/TMPERC_IL
18INDANXOrder Type Annexedchar10CHAR(N' ')Yes/LOCSRM/TMANIND_IL Allow NULL? 
19LIMIT_DATAnnexing Limit Datenvarchar80DATS(N'00000000')Yes/LOCSRM/TALDAT_IL Allow NULL? 
20NUMERATORChar 20nvarchar200CHAR(N' ')YesCHAR20 Allow NULL? 
21PS_FP_EXCPEAcceptance Periodnvarchar20NUMC(N'00')Yes/SAPPSSRM/EXCPE Allow NULL? 
22PS_TAX_CODETax on Sales/Purchases Codenvarchar20CHAR(N' ')YesBBP_TAXBBP_MWSKZ Allow NULL? 
23PS_CNCL_BO_HDRGeneral Flagchar10CHAR(N' ')YesFLAG Allow NULL? 
24PS_CLOSEOUTClose-Out Statuschar10CHAR(N' ')Yes/SAPPSSRM/_US_CLOSE Allow NULL? 
25PS_DP_TYPEDown Payment Indicatornvarchar40CHAR(N' ')Yes*/SAPPSSRM/_DP_TYPE Allow NULL? 
26PS_DP_AMOUNTDown Paymentdecimal112CURR((0))Yes/SAPPSSRM/_DP_AMOUNT
27PS_DP_PERCENTDown Payment Percentagedecimal52DEC((0))Yes/SAPPSSRM/_DP_PERCENT
28PS_DP_DUE_DATEDown Payment Due Datenvarchar80DATS(N'00000000')Yes/SAPPSSRM/_DP_DUE_DATE Allow NULL? 
29PS_GUAR_MIN_BIDGuaranteed Minimum Amountdecimal152CURR((0))Yes/SAPPSSRM/_GUAR_MIN
30PS_GUAR_MIN_QUOTGuaranteed Minimum Amountdecimal152CURR((0))Yes/SAPPSSRM/_GUAR_MIN
31PS_GM_NO_EMFGuar. Min.: Suppress earmarked funds creation at savechar10CHAR(N' ')Yes/SAPPSSRM/_NO_EMF Allow NULL? 
32PS_GM_CLOSEDClose Indicator for Earmarked fundschar10CHAR(N' ')Yes/SAPPSSRM/_CLOSE_CMT Allow NULL? 
33PS_IDC_TYPEOrder Type Line Itemnvarchar100CHAR(N' ')Yes*/SAPPSSRM/IDC_TYPE Allow NULL? 
34PS_IDC_MIN_VALMinimum Value Procurement Documentsdecimal152CURR((0))Yes/SAPPSSRM/IDC_MIN_VALUE
35PS_IDC_MIN_QTYMinimum Quantity for Procurement Documentsdecimal133QUAN((0))Yes/SAPPSSRM/IDC_MIN_QTY
36PS_GUARANT_MINGuaranteed Purchase Value (Public Sector ONLY!!)decimal152CURR((0))YesBBP_GUARANTEED_MIN
37PS_IDC_VALUETarget Valuedecimal152CURR((0))YesBBP_ITEM_TARGET_VALUE
38PS_INFU_INDIncremental Funding Activechar10CHAR(N' ')Yes/SAPPSSRM/_INFU_ACTIVE Allow NULL? 
39PS_SC_AC03Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')char10CHAR(N' ')YesBOOLE_D Allow NULL? 
40PS_SC_MK03Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')char10CHAR(N' ')YesBOOLE_D Allow NULL? 
41PS_MQP_I_DAYSDuration of Initial Period in Daysnvarchar50NUMC(N'00000')Yes/SAPPSSRM/_MQP_I_DAYS Allow NULL? 
42PS_MQP_I_QUANMaximum Quantity for Initial Perioddecimal133QUAN((0))Yes/SAPPSSRM/_MQP_I_QUAN
43PS_MQP_F_DAYSDuration of Follow-On Period in Daysnvarchar50NUMC(N'00000')Yes/SAPPSSRM/_MQP_F_DAYS Allow NULL? 
44PS_MQP_F_QUANMaximum Quantity for Follow-On Periodsdecimal133QUAN((0))Yes/SAPPSSRM/_MQP_F_QUAN
45PS_MQP_I_DAY_BIDDuration of Initial Period in Daysnvarchar50NUMC(N'00000')Yes/SAPPSSRM/_MQP_I_DAYS Allow NULL? 
46PS_MQP_I_QUA_BIDMaximum Quantity for Initial Perioddecimal133QUAN((0))Yes/SAPPSSRM/_MQP_I_QUAN
47PS_MQP_F_DAY_BIDDuration of Follow-On Period in Daysnvarchar50NUMC(N'00000')Yes/SAPPSSRM/_MQP_F_DAYS Allow NULL? 
48PS_MQP_F_QUA_BIDMaximum Quantity for Follow-On Periodsdecimal133QUAN((0))Yes/SAPPSSRM/_MQP_F_QUAN
49PS_ORIG_ACCEPTIndicator: Acceptance at Originchar10CHAR(N' ')Yes/SAPPSSRM/_ORIG_ACCEPT Allow NULL? 
50PS_ORIG_ACC_BIDIndicator: Acceptance at Originchar10CHAR(N' ')Yes/SAPPSSRM/_ORIG_ACCEPT Allow NULL? 
51PS_POPPeriod of Performancenvarchar30NUMC(N'000')Yes/SAPPSSRM/_OPT_PERIOD Allow NULL? 
52PS_POP_STATUSStatus of Period of Performancechar10CHAR(N' ')Yes/SAPPSSRM/_OPT_STATUS Allow NULL? 
53PS_REF_GUIDGUID of a CRM Order Objectvarbinary160RAWYesCRMT_OBJECT_GUID
54PS_POP_SETint100((0))Yes Allow NULL? 
55OPT_INDOption Typechar10CHAR(N' ')YesBBP_OPT_IND Allow NULL? 
56OPT_STATUSOption Statuschar10CHAR(N' ')YesBBP_OPT_STATUS Allow NULL? 
57OPT_XPER_STARTExercise Period Start Datenvarchar80DATS(N'00000000')YesBBP_OPT_XPER_START Allow NULL? 
58OPT_XPER_ENDExercise Period End Datenvarchar80DATS(N'00000000')YesBBP_OPT_XPER_END Allow NULL? 
59OPT_REF_GUIDOption Reference GUIDvarbinary160RAWYesBBP_OPT_REF_GUID
60PS_PO_HDR_GUIDPurchaser Order Header GUIDvarbinary160RAWYes/SAPPSSRM/_PO_HDR_GUID
61PS_PO_HDR_NUMPurchase Order Numbernvarchar100CHAR(N' ')Yes/SAPPSSRM/_PO_HDR_NUM Allow NULL? 
62PS_PO_ITM_GUIDPurchaser Order Item GUIDvarbinary160RAWYes/SAPPSSRM/_PO_ITM_GUID
63PS_PO_ITM_NUMPurchaser Order Item Numbernvarchar100NUMC(N'0000000000')Yes/SAPPSSRM/_PO_ITM_NUM Allow NULL? 
64PS_PO_OPEN_QUANOpen Quantity of a Purchase Orderdecimal153QUAN((0))Yes/SAPPSSRM/_PO_OPEN_QUAN
65PS_PA_IDPricing Arrangement Identifiernvarchar40CHAR(N' ')Yes/SAPPSSRM/_PA_STRUC_ID Allow NULL? 
66PS_PA_MIN_FEEMinimum Feedecimal132CURR((0))Yes/SAPPSSRM/_PA_MINIMUM_FEE
67PS_PA_MAX_FEEMaximum Feedecimal132CURR((0))Yes/SAPPSSRM/_PA_MAXIMUM_FEE
68PS_PA_GS_BLWGovernment Share Belowdecimal52DEC((0))Yes/SAPPSSRM/_PA_GOV_SHARE_BELOW
69PS_PA_GS_ABVGovernment Share Abovedecimal52DEC((0))Yes/SAPPSSRM/_PA_GOV_SHARE_ABOVE
70PS_PA_CLNG_AMTCeiling Amountdecimal152CURR((0))Yes/SAPPSSRM/_PA_CEILING_AMOUNT
71PS_PA_TOTL_AMTTotal Amount of Master Itemdecimal152CURR((0))Yes/SAPPSSRM/_PA_TOTAL_AMOUNT
72PS_PA_NTE_INDNot to Exceedchar10CHAR(N' ')Yes/SAPPSSRM/_NTE_IND Allow NULL? 
73PS_PA_NSP_INDNot Separately Pricedchar10CHAR(N' ')Yes/SAPPSSRM/_NSP_IND Allow NULL? 
74PS_PA_COMP_KEYComponent Keynvarchar40CHAR(N' ')Yes/SAPPSSRM/_PA_COMP_KEY Allow NULL? 
75PS_PA_COMP_TYPEPricing Component Typechar10CHAR(N' ')Yes*/SAPPSSRM/_PA_COMP_TYPE Allow NULL? 
76PS_PA_CLOSE_CMMTClose FM Commitmentchar10CHAR(N' ')Yes/SAPPSSRM/_PA_CLOSE_COMMITMENT Allow NULL? 
77PS_DOC_ITEMItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
78PS_IV_PLAN_NUMBilling plan number / invoicing plan numbernvarchar100CHAR(N' ')Yes*FPLNR Allow NULL? 
79PS_IP_TYPEPayment Plan Typenvarchar20CHAR(N' ')Yes/SAPPSSRM/_PP_TYPE Allow NULL? 
80PS_IP_TYPE_DESCPayment Plan Date Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_PP_DESCRIPTION Allow NULL? 
81PS_PERIORule for Setting Next Datenvarchar20CHAR(N' ')Yes/SAPPSSRM/_PP_ORGN_NEXT_DATE Allow NULL? 
82PS_PERIO_DESCDescriptionnvarchar400CHAR(N' ')Yes/SAPPSSRM/_PP_DESCR Allow NULL? 
83PS_IN_ADVANCEInvoice Creation in Advancechar10CHAR(N' ')Yes/SAPPSSRM/_PP_IN_ADVANCE Allow NULL? 
84PS_DEV_BILL_DATRule for Setting Different Invoice Datenvarchar20CHAR(N' ')Yes/SAPPSSRM/_PP_DEV_BILL_DATE Allow NULL? 
85PS_DEV_DAT_DESCDescriptionnvarchar400CHAR(N' ')Yes/SAPPSSRM/_PP_DESCR Allow NULL? 
86PS_START_DATETimeframe Fromnvarchar80DATS(N'00000000')YesBBP_VPER_START Allow NULL? 
87PS_ORGN_ST_DATRule for Setting Start Datenvarchar20CHAR(N' ')Yes/SAPPSSRM/_PP_ORGN_START_DATE Allow NULL? 
88PS_ST_DAT_DESDescriptionnvarchar400CHAR(N' ')Yes/SAPPSSRM/_PP_DESCR Allow NULL? 
89PS_DATES_FROMTimeframe Fromnvarchar80DATS(N'00000000')YesBBP_VPER_START Allow NULL? 
90PS_ORGN_FROM_DATRule for Setting Start Datenvarchar20CHAR(N' ')Yes/SAPPSSRM/_PP_ORGN_START_DATE Allow NULL? 
91PS_FROM_DAT_DESDescriptionnvarchar400CHAR(N' ')Yes/SAPPSSRM/_PP_DESCR Allow NULL? 
92PS_END_DATETimeframe Tonvarchar80DATS(N'00000000')YesBBP_VPER_END Allow NULL? 
93PS_ORGN_END_DATRule for Setting End Datenvarchar20CHAR(N' ')Yes/SAPPSSRM/_PP_ORGN_END_DATE Allow NULL? 
94PS_END_DAT_DESDescriptionnvarchar400CHAR(N' ')Yes/SAPPSSRM/_PP_DESCR Allow NULL? 
95PS_DATES_TOBilling date for billing index and printoutnvarchar80DATS(N'00000000')YesFKDAT Allow NULL? 
96PS_UNTIL_DATRule for Setting End Datenvarchar20CHAR(N' ')Yes/SAPPSSRM/_PP_ORGN_END_DATE Allow NULL? 
97PS_UNTIL_DAT_DESDescriptionnvarchar400CHAR(N' ')Yes/SAPPSSRM/_PP_DESCR Allow NULL? 
98PS_HORIZON_DATEBilling date for billing index and printoutnvarchar80DATS(N'00000000')YesFKDAT Allow NULL? 
99PS_HORIZONRule for Determining Horizonnvarchar20CHAR(N' ')Yes/SAPPSSRM/_PP_HORIZON Allow NULL? 
100PS_HORIZON_DESCDescriptionnvarchar400CHAR(N' ')Yes/SAPPSSRM/_PP_DESCR Allow NULL? 
101PS_CALENDER_IDCalendar IDnvarchar20CHAR(N' ')Yes*CALID Allow NULL? 
102PS_IS_PPPayment Plan Typenvarchar20CHAR(N' ')Yes/SAPPSSRM/_PP_TYPE Allow NULL? 
103PS_PHASED_DELPhased Deliverychar10CHAR(N' ')Yes/SAPPSSRM/PHASED_DEL Allow NULL? 
104OPT_POP_STARTOption Period of Performance Start Datenvarchar80DATS(N'00000000')YesBBP_OPT_POP_START Allow NULL? 
105OPT_POP_ENDOption Period of Performance End Datenvarchar80DATS(N'00000000')YesBBP_OPT_POP_END Allow NULL? 
106PS_DLV_PRIODelivery Prioritynvarchar20NUMC(N'00')Yes*/SAPPSSRM/_DLV_PRIO Allow NULL? 
107PS_PRIO_CODEDelivery Prioritynvarchar20NUMC(N'00')Yes*/SAPPSSRM/_PRIO_CODE Allow NULL? 
108PS_FAST_PAYFast Paychar10CHAR(N' ')Yes/SAPPSSRM/_FAST_PAY Allow NULL? 
109PS_PPA_EXCLExclude from Prompt Payment Actchar10CHAR(N' ')Yes/SAPPSSRM/_PPA_EXCLUDE Allow NULL? 
110PS_O_BO_OBJ_IDTransaction Numbernvarchar100CHAR(N' ')YesCRMT_OBJECT_ID_DB Allow NULL? 
111PS_O_BO_OBJ_TYObject Typenvarchar100CHAR(N' ')Yes*SWO_OBJTYP Allow NULL? 
112PS_O_BO_DESCName of SRM Documentnvarchar400CHAR(N' ')YesBBP_DOCNAME Allow NULL? 
113PS_O_BO_GUIDGlobally Unique identifiervarbinary160RAWYesBBP_GUID
114PS_O_BO_ITM_NOItem Number in Documentnvarchar100NUMC(N'0000000000')YesCRMT_ITEM_NO Allow NULL? 
115PS_O_BO_DRAFTR/2 tablenvarchar50CHAR(N' ')YesCHAR5 Allow NULL? 
116PS_O_BO_DOC_TYCharacter field, length 32nvarchar320CHAR(N' ')YesCHAR32 Allow NULL? 
117PS_REASON_CODEReason Codenvarchar40CHAR(N' ')Yes/SAPPSSRM/_GR_REASON_CODE Allow NULL? 
118PS_EXTERNAL_ITEMExternal Origin of Smart Numberchar10CHAR(N' ')Yes/SAPPSSRM/_EXTERNAL_ITEM_FLAG Allow NULL? 
119PS_MAX_QTYMaximum Quantity in order unitdecimal133QUAN((0))Yes/SAPPSSRM/_MAX_QTY
120PS_MAX_VALUEMaximum Order Value in Item Currencydecimal152CURR((0))Yes/SAPPSSRM/_MAX_VAL
121PS_VENDOR_MLTPLSupplier Multiple in Order Unitdecimal133QUAN((0))Yes/SAPPSSRM/_VEND_MULT
122PS_SUBCON_ITEMX-field item is subcontracting itemchar10CHAR(N' ')Yes/SAPPSSRM/_SUBCON_ITEM Allow NULL? 
123PS_TH_NOT_RELThreshold not Relevantchar10CHAR(N' ')Yes/SAPPSSRM/_TH_NOT_RELEVANT Allow NULL? 
124PS_TH_TYPEThreshold Typenvarchar100CHAR(N' ')Yes*/SAPPSSRM/_TH_TYPE Allow NULL? 
125PS_TH_NUMBERThreshold Numbernvarchar100NUMC(N'0000000000')Yes/SAPPSSRM/_TH_NUM Allow NULL? 
126PS_TH_AVAIL_AMTRemaining Threshold Amountdecimal202CURR((0))Yes/SAPPSSRM/_TH_RM_AMNT
127PS_TH_CURRENCYCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
128PS_US01User-Specified Status 01nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_01 Allow NULL? 
129PS_US02User-Specified Status 02nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_02 Allow NULL? 
130PS_US03User-Specified Status 03nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_03 Allow NULL? 
131PS_US04User-Specified Status 04nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_04 Allow NULL? 
132PS_US05User-Specified Status 05nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_05 Allow NULL? 
133PS_US06User-Specified Status 06nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_06 Allow NULL? 
134PS_US07User-Specified Status 07nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_07 Allow NULL? 
135PS_US08User-Specified Status 08nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_08 Allow NULL? 
136PS_US09User-Specified Status 09nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_09 Allow NULL? 
137PS_US10User-Specified Status 10nvarchar50CHAR(N' ')Yes*/SAPPSSRM/_US_10 Allow NULL? 
138PS_US01_DATEDate of User-Specified Status 01nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US01_DATE Allow NULL? 
139PS_US02_DATEDate of User-Specified Status 02nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US02_DATE Allow NULL? 
140PS_US03_DATEDate of User-Specified Status 03nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US03_DATE Allow NULL? 
141PS_US04_DATEDate of User-Specified Status 04nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US04_DATE Allow NULL? 
142PS_US05_DATEDate of User-Specified Status 05nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US05_DATE Allow NULL? 
143PS_US06_DATEDate of User-Specified Status 06nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US06_DATE Allow NULL? 
144PS_US07_DATEDate of User-Specified Status 07nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US07_DATE Allow NULL? 
145PS_US08_DATEDate of User-Specified Status 08nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US08_DATE Allow NULL? 
146PS_US09_DATEDate of User-Specified Status 09nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US09_DATE Allow NULL? 
147PS_US10_DATEDate of User-Specified Status 10nvarchar80DATS(N'00000000')Yes/SAPPSSRM/_US10_DATE Allow NULL? 
148PS_US01_TXTUser-Specified Status 01 Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_US_TXT_01 Allow NULL? 
149PS_US02_TXTUser-Specified Status 02 Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_US_TXT_02 Allow NULL? 
150PS_US03_TXTUser-Specified Status 03 Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_US_TXT_03 Allow NULL? 
151PS_US04_TXTUser-Specified Status 04 Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_US_TXT_04 Allow NULL? 
152PS_US05_TXTUser-Specified Status 05 Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_US_TXT_05 Allow NULL? 
153PS_US06_TXTUser-Specified Status 06 Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_US_TXT_06 Allow NULL? 
154PS_US07_TXTUser-Specified Status 07 Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_US_TXT_07 Allow NULL? 
155PS_US08_TXTUser-Specified Status 08 Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_US_TXT_08 Allow NULL? 
156PS_US09_TXTUser-Specified Status 09 Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_US_TXT_09 Allow NULL? 
157PS_US10_TXTUser-Specified Status 10 Descriptionnvarchar300CHAR(N' ')Yes/SAPPSSRM/_US_TXT_10 Allow NULL? 
158PS_WH_PRCNTRetention Value as Percentagedecimal52DEC((0))Yes/SAPPSSRM/_WH_PERCENT
159PS_WH_IND_PARetention Indicator for Pricing Arrangmentschar10CHAR(N' ')Yes/SAPPSSRM/_WH_IND_PA Allow NULL? 
160LAM_QUO_IDLeasing Quotation Numbernvarchar100CHAR(N' ')YesLAM_QUO_ID Allow NULL? 
161LAM_QUO_ITMNOItem Number in Documentnvarchar100NUMC(N'0000000000')YesCRMT_ITEM_NO Allow NULL? 
162LAM_CTR_IDLeasing Contract Numbernvarchar100CHAR(N' ')YesLAM_CTR_ID Allow NULL? 
163LAM_CTR_ITMNOItem Number in Documentnvarchar100NUMC(N'0000000000')YesCRMT_ITEM_NO Allow NULL? 
164LAM_GAIDExternal Allocation Numbernvarchar160CHAR(N' ')YesLAM_ALLOCATION_ID Allow NULL? 
165LAM_ASS_PO_IDLeasing PO Assumption IDnvarchar350CHAR(N' ')YesLAM_ASS_PO_ID Allow NULL? 
166LAM_EXT_REF1Leasing External Reference 1nvarchar350CHAR(N' ')YesLAM_EXT_REF1 Allow NULL? 
167LAM_EXT_REF2Leasing External Reference 2nvarchar350CHAR(N' ')YesLAM_EXT_REF2 Allow NULL? 
168LAM_TEXTLeasing Textnvarchar350CHAR(N' ')YesLAM_TEXT Allow NULL? 
169NO_DISCOUNT_EXINot Relevant for Cash Discountchar10CHAR(N' ')YesNO_DISCOUNT_EXI Allow NULL? 
170ICC_BR_TAXCODETax Code for Brazilnvarchar20CHAR(N' ')YesITL_TCODE Allow NULL? 
171ICC_BR_TAXAMTTax Amountdecimal152CURR((0))YesBBP_TAX_AMOUNT
172ICC_BR_TAXDESEnterprise Buyer: Tax Code Descriptionnvarchar500CHAR(N' ')YesBBPTAX_DES Allow NULL? 
NamePrimaryUniqueTypeColumns
BBP_PDISS~0YesYesCLUSTEREDGUID, CLIENT
BBP_PDISS~LDHNoNoNONCLUSTEREDPS_HANDLE_ITM, CLIENT