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_PDIGP
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1ERP EHP76.0BBP_PDIGP1625Business Transaction Item-Purchasing Information
SQL:  selectupdate insert create

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

SELECT CLIENT, GUID, CATEGORY, CATEGORY_ID, SCHEMA_TYPE, CT_CATEGORY_ID, ITM_EX_CT_UN_ID, MANU_PROD, MFR_NO_EXT, CATALOGID, CATALOGITEM, EXT_QUOTE_ID, EXT_QUOTE_ITEM, PRODUCT_TYPE, DEL_DATCAT, DELIV_DATE, DELIV_TIME, LEADTIME, VPER_START, VPER_END, QUANTITY, UNIT, GROSS_PRICE, PRICE, PRICE_UNIT, PRICE_ORIGIN, VALUE, CURRENCY, TAX_CODE, BBP_MOVE_TYPE, UNASSIGNED, SRC_OBJECT_TYPE, SRC_OBJECT_ID, SRC_ITM_ID, SRC_LOG_SYS, SRC_GUID, CTR_LOG_SYS, CTR_GUID, CTR_ITEM_NUMBER, CTR_HDR_NUMBER, CTR_HDR_GUID, COMM_ID, DEL_IND, FINAL_INV, FINAL_ENTRY, DEDUCT_IND, REJECT_WI, VAL_ASN_E, VAL_ASN, VAL_CF_E, VAL_CF, VAL_IV_E, VAL_IV, VAL_PO_E, VAL_PO_E_AGG, QUAN_ASN_E, QUAN_ASN, QUAN_CF_E, QUAN_CF, QUAN_IV_E, QUAN_IV, QUAN_PO_E, NUM_ASN, NUM_CONF, NUM_INV, DCIND, SUBDCIND, SUBTYPE, SOURCE_REL_IND, EXT_DEMID, EXT_DEM_POSID, EXT_DEM_LOGSYS, PCINS, PCNUM, PCNAME, PCDAT_TO, LOGSYS_FI, ITM_RELEASED, ACTIVE_ITEM, TIME_FROM, TIME_TO, ORIGIN_ORDER_ID, ORIGIN_ITEM_ID, NUM_SOS, GROUPING_LEVEL, ICC_BR_NETPRI, ICC_BR_GROPRI, ICC_BR_NETVAL, ICC_BR_GROVAL, ICC_BR_NETDIS, ICC_BR_GRODIS, ICC_BR_NETFRE, ICC_BR_GROFRE, ICC_BR_NETINS, ICC_BR_GROINS, ICC_BR_NETOTH, ICC_BR_GROOTH, ICC_BR_NETTOT, ICC_BR_GROTOT, ICC_BR_ICMSLAW, ICC_BR_IPILAW, ICC_BR_CFOP, ICC_BR_STEUC, ICC_BR_MATUSE, ICC_BR_MATORG, ICC_BR_OWNPRO, ICC_BR_INDUST, ICC_BR_MANCHG, ESRPZ, ESRNR, ESRRE, ICC_IN_TXJCD, DELIV_DAYS, INCOTERM_KEY, INCOTERM_LOC, GTIN, TAX_CODE_ORIGIN, MIN_ORDER_VALUE, MIN_ORDER_QUAN, GUARANTEED_MIN, EXT_DEM_SUBPOSID, ACCEPT_STAT_CODE, GROSS_WEIGHT, GROSSWEIGHT_UNIT, NET_WEIGHT, NETWEIGHT_UNIT, VOLUME_VAL, VOLUME_UNIT, SHIPPING_TS, DEL_NOTE_NUMBER, DEL_NOTE_ITEM_NO, FIX_LINE_IND, CHECK_IND, HIER_CHECK_IND, UOM_DENOMINATOR, UOM_NUMERATOR, DOC_PRIORITY, LUMP_SUM_IND, CO_CODE, PROJECT_ID, PROJECT_TASK_ID, PROJECT_ROLE_ID, EXT_DEM_KEY, EXT_DEM_POSKEY, QUOTA_RELEVANT, DOC_FLOW_CTRL, EXPSV_ITEM_TYPE, ORIG_GUID, PR_UNIT, TAR_IVAL, TAR_QTY, PMNTTRMS, ITEM_PROCESS_TYP, EXLIN, REV_LEV, BLK_LOCAL_SRC, EXT_DEM_CH_AT, EXT_DEM_EXLIN, CTR_SRV_NUM, PRC_CHG_IND, ACC_STAT_SUS, HIDE_DATE FROM BBP_PDIGP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*EC_CLIENT Allow NULL? 
2GUIDGlobally Unique identifiervarbinary160RAWNoBBP_GUID
3CATEGORYProduct Category GUIDvarbinary160RAWYesBBP_CATEGORY_GUID_RAW
4CATEGORY_IDProduct Category IDnvarchar200CHAR(N' ')YesBBP_CATEGORY_ID Allow NULL? 
5SCHEMA_TYPEStandard Schema Typenvarchar100CHAR(N' ')Yes*SCHEMA_TYPE Allow NULL? 
6CT_CATEGORY_IDCategory Namenvarchar600CHAR(N' ')YesBBP_CT_CATEGORY_ID Allow NULL? 
7ITM_EX_CT_UN_IDUnique Key in External Categorynvarchar400CHAR(N' ')YesBBP_ITM_EX_CT_UN_ID Allow NULL? 
8MANU_PRODManufacturer Part Numbernvarchar400CHAR(N' ')YesBBP_MFRPN Allow NULL? 
9MFR_NO_EXTExternal manufacturer code name or numbernvarchar100CHAR(N' ')YesEMNFR Allow NULL? 
10CATALOGIDTechnical Key of a Web Service (for Example - a Catalog)nvarchar200CHAR(N' ')YesBBP_CAT_ENTITYBBP_WS_SERVICE_ID Allow NULL? 
11CATALOGITEMCatalog Item (Unique Key)nvarchar400CHAR(N' ')YesBBP_CATALOGITEM Allow NULL? 
12EXT_QUOTE_IDNumber of an External RFx Responsenvarchar350CHAR(N' ')YesBBP_EXT_QUOTE_ID Allow NULL? 
13EXT_QUOTE_ITEMItem of an External RFx Responsenvarchar100NUMC(N'0000000000')YesBBP_EXT_QUOTE_ITEM Allow NULL? 
14PRODUCT_TYPEProduct Typenvarchar20CHAR(N' ')Yes*BBP_PRODUCT_TYPE Allow NULL? 
15DEL_DATCATDate type (day, week, month, interval)char10CHAR(N' ')YesLPEIN_INT Allow NULL? 
16DELIV_DATEItem Delivery Datenvarchar80DATS(N'00000000')YesEINDT Allow NULL? 
17DELIV_TIMEDelivery Time of the Itemnvarchar60TIMS(N'000000')YesBBP_DELIV_TIME Allow NULL? 
18LEADTIMEDelivery Time in Daysnvarchar50CHAR(N' ')YesBBP_LEADTIME Allow NULL? 
19VPER_STARTTimeframe Fromnvarchar80DATS(N'00000000')YesBBP_VPER_START Allow NULL? 
20VPER_ENDTimeframe Tonvarchar80DATS(N'00000000')YesBBP_VPER_END Allow NULL? 
21QUANTITYQuantity in Order Unitdecimal133QUAN((0))YesBBP_MNG
22UNITUnit of Measurementnvarchar30UNIT(N' ')Yes*BBP_UNIT Allow NULL? 
23GROSS_PRICEGross Pricedecimal132CURR((0))YesBBP_GROSS_PRICE
24PRICENet Pricedecimal132CURR((0))YesBBP_PRICE
25PRICE_UNITPrice Unitdecimal50DEC((0))YesEPEIN
26PRICE_ORIGINOriginal Price (Determination/Manual Input)char10CHAR(N' ')YesBBP_PRICE_ORIGIN Allow NULL? 
27VALUENet Valuedecimal152CURR((0))YesBBP_VALUE
28CURRENCYCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
29TAX_CODETax on Sales/Purchases Codenvarchar20CHAR(N' ')YesBBP_MWSKZ Allow NULL? 
30BBP_MOVE_TYPEMovement Code for Enterprise Buyer Professional Editionnvarchar40CHAR(N' ')YesBBP_MOVE_TYPE Allow NULL? 
31UNASSIGNEDSpecifies If the Template Item Is Availablechar10CHAR(N' ')YesBBP_UNASSIGNED Allow NULL? 
32SRC_OBJECT_TYPEObject Type of Reference Itemnvarchar100CHAR(N' ')Yes*BBP_SRC_I_OBJ_TYP Allow NULL? 
33SRC_OBJECT_IDBusiness Transaction Document IDnvarchar350CHAR(N' ')YesBBP_BTD_ID Allow NULL? 
34SRC_ITM_IDUnique ID of a Template Itemnvarchar200CHAR(N' ')YesBBP_SRC_ITM_ID Allow NULL? 
35SRC_LOG_SYSLogical System of Template Document (Vacant if in Loc. Sys.)nvarchar100CHAR(N' ')Yes*BBP_SRC_LOG_SYS Allow NULL? 
36SRC_GUIDReference Item GUIDvarbinary160RAWYesBBP_SRC_I_GUID
37CTR_LOG_SYSLogical System from Which the Contract Originatesnvarchar100CHAR(N' ')Yes*BBP_CTR_LOG_SYSTEM Allow NULL? 
38CTR_GUIDContract Template Item GUIDvarbinary160RAWYesBBP_CTR_I_GUID
39CTR_ITEM_NUMBERNumber of Contract Itemnvarchar100NUMC(N'0000000000')YesBBP_CTR_ITEM Allow NULL? 
40CTR_HDR_NUMBERContract Numbernvarchar100CHAR(N' ')YesBBP_CTR_ID Allow NULL? 
41CTR_HDR_GUIDGUID Contractvarbinary160RAWYesBBP_CTR_H_GUID
42COMM_IDClear Item ID for Commitments Interfacenvarchar50NUMC(N'00000')Yes*BBP_COMM_ID Allow NULL? 
43DEL_INDDeletion Indicator SRM Purchasing Documentchar10CHAR(N' ')YesBBP_DEL_IND Allow NULL? 
44FINAL_INVFinal invoice indicatorchar10CHAR(N' ')YesBBP_EREKZ Allow NULL? 
45FINAL_ENTRYFinal Entry Indicator (Goods/Services)char10CHAR(N' ')YesBBP_FINAL_ENTRY Allow NULL? 
46DEDUCT_INDDiscount/Rejection Indicator at Item Levelchar10CHAR(N' ')YesBBP_DEDUCT_IND Allow NULL? 
47REJECT_WIWork item IDnvarchar120NUMC(N'000000000000')Yes*SWW_WIID Allow NULL? 
48VAL_ASN_EShipping Notification Value Entereddecimal152CURR((0))YesBBP_ASN_VALUE_E
49VAL_ASNShip Note Value Releaseddecimal152CURR((0))YesBBP_ASN_VALUE
50VAL_CF_EValue of Entered Confirmationsdecimal152CURR((0))YesBBP_CF_VALUE_E
51VAL_CFValue of Confirmations Releaseddecimal152CURR((0))YesBBP_CF_VALUE
52VAL_IV_EEntered Invoice Valuedecimal152CURR((0))YesBBP_IV_VALUE_E
53VAL_IVReleased Invoice Valuedecimal152CURR((0))YesBBP_IV_VALUE
54VAL_PO_EValue of POs/Confirmations/Invoices Created for Contractdecimal152CURR((0))YesBBP_PO_VALUE_E
55VAL_PO_E_AGGValue PO / Confirm. / Inv. for Contract Hierarchydecimal152CURR((0))YesBBP_AGG_VALUE_E
56QUAN_ASN_EShipping Notification Quantity Entereddecimal153QUAN((0))YesBBP_ASN_QUANT_E
57QUAN_ASNShip Note Quantity Releas'ddecimal153QUAN((0))YesBBP_ASN_QUANT
58QUAN_CF_EQuantity of Entered Confirmationdecimal153QUAN((0))YesBBP_CF_QUANT_E
59QUAN_CFQuantity of Released Confirmationsdecimal153QUAN((0))YesBBP_CF_QUANT
60QUAN_IV_EEntered Invoiced Quantitydecimal153QUAN((0))YesBBP_IV_QUANT_E
61QUAN_IVReleased Invoiced Quantitydecimal153QUAN((0))YesBBP_IV_QUANT
62QUAN_PO_EQuantity of POs/Confirmations/Invoices Created for Contractdecimal153QUAN((0))YesBBP_PO_QUANT_E
63NUM_ASNNo. of Shipping Notifications Entered for a POint100INT4((0))YesBBP_NUM_ASN Allow NULL? 
64NUM_CONFNumber of Entered Confirmations for a Purchase Orderint100INT4((0))YesBBP_NUM_CONF Allow NULL? 
65NUM_INVNumber of Entered Invoices for Purchase Order or Confirmat.int100INT4((0))YesBBP_NUM_INV Allow NULL? 
66DCINDDebit/Credit Indicatorchar10CHAR(N' ')YesBBP_DCIND Allow NULL? 
67SUBDCINDSubsequent Debit/Credit Indicatorchar10CHAR(N' ')YesBBP_SUBDCIND Allow NULL? 
68SUBTYPESpecification Purchase Item (e.g. Direct Material/Hierarch.)nvarchar20CHAR(N' ')YesBBP_I_SUBTYPE Allow NULL? 
69SOURCE_REL_INDIndicator - If the Document is Sourcing-Relevantchar10CHAR(N' ')YesBBP_SOURCE_REL_IND Allow NULL? 
70EXT_DEMIDExternal Requirement Numbernvarchar320CHAR(N' ')YesBBP_EXT_DEMID Allow NULL? 
71EXT_DEM_POSIDExternal Requirement Tracking Numbernvarchar320CHAR(N' ')YesBBP_EXT_DEM_POSID Allow NULL? 
72EXT_DEM_LOGSYSLogical System from where an External Requirement Comesnvarchar100CHAR(N' ')Yes*BBP_EXT_DEM_LOGSYS Allow NULL? 
73PCINSProcurement card companynvarchar40CHAR(N' ')Yes*BBPPCINS Allow NULL? 
74PCNUMProcurement card numbernvarchar250CHAR(N' ')Yes*BBPPCNUM Allow NULL? 
75PCNAMEName of procurement cardholdernvarchar400CHAR(N' ')YesBBPPCNAME Allow NULL? 
76PCDAT_TOProcurement Card Validity Datenvarchar80DATS(N'00000000')YesBBPPCDAT_TO Allow NULL? 
77LOGSYS_FILogical System of FI Systemnvarchar100CHAR(N' ')Yes*BBP_LOGSYS_FI Allow NULL? 
78ITM_RELEASEDStatus of Itemchar10CHAR(N' ')YesBBP_ITM_RELEASED Allow NULL? 
79ACTIVE_ITEMGlobally Unique identifiervarbinary160RAWYesBBP_GUID
80TIME_FROMStart Timenvarchar60TIMS(N'000000')YesBBP_TIME_FROM Allow NULL? 
81TIME_TOEnd Timenvarchar60TIMS(N'000000')YesBBP_TIME_TO Allow NULL? 
82ORIGIN_ORDER_IDOrigninal Customer's PO No. for Third Party Transactionnvarchar350CHAR(N' ')YesBBP_ORIGIN_ORDER_ID Allow NULL? 
83ORIGIN_ITEM_IDOrignl Customer Purchase Order Item No. - Third Party Trans.nvarchar100NUMC(N'0000000000')YesBBP_ORIGIN_ORDER_ITEM_ID Allow NULL? 
84NUM_SOSNumber of Sources of Supply Found (for Performance)char10CHAR(N' ')YesBBP_NUM_SOS Allow NULL? 
85GROUPING_LEVELSpecifies How Hierarchy Positions are to be Managedchar10CHAR(N' ')YesBBP_GROUPING_LEVEL Allow NULL? 
86ICC_BR_NETPRINota Fiscal: Net Price Without Taxesdecimal166DEC((0))YesBBP_ICC_NETPRI
87ICC_BR_GROPRINota Fiscal: Net Price including Taxesdecimal166DEC((0))YesBBP_ICC_NFPRI
88ICC_BR_NETVALNota Fiscal: Net Value Without Taxesdecimal152CURR((0))YesBBP_ICC_NETVAL
89ICC_BR_GROVALNota Fiscal: Net Value including Taxesdecimal152CURR((0))YesBBP_ICC_NFNET
90ICC_BR_NETDISNota Fiscal: Net Discount Valuedecimal152CURR((0))YesBBP_ICC_NETDIS
91ICC_BR_GRODISNota Fiscal: Discount Value including Taxesdecimal152CURR((0))YesBBP_ICC_NFDIS
92ICC_BR_NETFRENota Fiscal: Net Freight Valuedecimal152CURR((0))YesBBP_ICC_NETFRE
93ICC_BR_GROFRENota Fiscal: Freight Value including Taxesdecimal152CURR((0))YesBBP_ICC_NFFRE
94ICC_BR_NETINSNota Fiscal: Net Insurance Valuedecimal152CURR((0))YesBBP_ICC_NETINS
95ICC_BR_GROINSNota Fiscal: Insurance Value including Taxesdecimal152CURR((0))YesBBP_ICC_NFINS
96ICC_BR_NETOTHNota Fiscal: Net Expensesdecimal152CURR((0))YesBBP_ICC_NETOTH
97ICC_BR_GROOTHNota Fiscal: Expenses including Taxesdecimal152CURR((0))YesBBP_ICC_NFOTH
98ICC_BR_NETTOTNota Fiscal: Net Value/Freight/Insurance/Expenses/Discountdecimal152CURR((0))YesBBP_ICC_NETWRT
99ICC_BR_GROTOTNota Fiscal: Value/Freight/Insurance/Exp./disc. with Taxesdecimal152CURR((0))YesBBP_ICC_NFNETT
100ICC_BR_ICMSLAWICMS Tax Law IDnvarchar30CHAR(N' ')YesCOMC_TAX_LAW_1ITL_TAXLAW1 Allow NULL? 
101ICC_BR_IPILAWIPI Tax Law IDnvarchar30CHAR(N' ')YesCOMC_TAX_LAW_2ITL_TAXLAW2 Allow NULL? 
102ICC_BR_CFOPCFOP Code and Extensionnvarchar100CHAR(N' ')YesCOMC_CFOP_CODEITL_CFOP Allow NULL? 
103ICC_BR_STEUCBrazilian NCM Codenvarchar160CHAR(N' ')YesCRMC_TAX_TCODEITL_NCM Allow NULL? 
104ICC_BR_MATUSEMaterial Usagechar10CHAR(N' ')YesITL_MAT_USAGE Allow NULL? 
105ICC_BR_MATORGOrigin of the materialchar10CHAR(N' ')YesITL_NF_MATORG Allow NULL? 
106ICC_BR_OWNPROProduced in-housechar10CHAR(N' ')YesITL_OWNPRO Allow NULL? 
107ICC_BR_INDUSTMaterial CFOP categorynvarchar20CHAR(N' ')YesITL_NF_INDUS3 Allow NULL? 
108ICC_BR_MANCHGCheckbox for Manual Changes in Nota Fiscal Item Fieldsvarbinary40RAWYesBBP_ICC_NF_ITEM_CHANGE
109ESRPZISR Check Digitnvarchar20CHAR(N' ')YesESRPZ Allow NULL? 
110ESRNRISR Subscriber Numbernvarchar110CHAR(N' ')YesESRNR Allow NULL? 
111ESRREISR Reference Numbernvarchar270CHAR(N' ')YesESRRE Allow NULL? 
112ICC_IN_TXJCDTax Tariff Codenvarchar160CHAR(N' ')YesCRMT_TAX_TARIFF_CODE Allow NULL? 
113DELIV_DAYSDelivery Time in Daysnvarchar30NUMC(N'000')YesBBP_DELIV_DAYS Allow NULL? 
114INCOTERM_KEYIncoterm Keynvarchar30CHAR(N' ')Yes*BBP_INCOTERM_KEY Allow NULL? 
115INCOTERM_LOCIncoterm Locationnvarchar280CHAR(N' ')YesBBP_INCOTERM_LOCATION Allow NULL? 
116GTINProduct ID GTINnvarchar400CHAR(N' ')YesBBPT_CT_PRODUCT_ID_GTIN Allow NULL? 
117TAX_CODE_ORIGINOrigin Tax Code Indicator (Determination/Manual Entry)char10CHAR(N' ')YesBBP_TAX_CODE_ORIGIN Allow NULL? 
118MIN_ORDER_VALUEMinimum Order Valuedecimal152CURR((0))YesBBP_MIN_ORDER_VALUE
119MIN_ORDER_QUANMinimum Order Quantitydecimal133QUAN((0))YesBBP_MIN_ORDER_QUANTITY
120GUARANTEED_MINGuaranteed Purchase Value (Public Sector ONLY!!)decimal152CURR((0))YesBBP_GUARANTEED_MIN
121EXT_DEM_SUBPOSIDExternal Requirement Subitem Numbernvarchar320CHAR(N' ')YesBBP_EXT_DEM_SUBPOSID Allow NULL? 
122ACCEPT_STAT_CODEAcceptance Statuschar10CHAR(N' ')YesBBP_ACCEPT_STAT_CODE Allow NULL? 
123GROSS_WEIGHTGross Weightdecimal150QUAN((0))YesBBP_GROSS_WEIGHT
124GROSSWEIGHT_UNITUnit of Weightnvarchar30UNIT(N' ')YesBBP_WEIGHT_UNIT Allow NULL? 
125NET_WEIGHTNet Weightdecimal150QUAN((0))YesBBP_NET_WEIGHT
126NETWEIGHT_UNITUnit of Weightnvarchar30UNIT(N' ')YesBBP_WEIGHT_UNIT Allow NULL? 
127VOLUME_VALVolumes, Pack Sizedecimal150QUAN((0))YesBBP_VOLUME
128VOLUME_UNITVolume Unitnvarchar30UNIT(N' ')YesBBP_VOLUME_UNIT Allow NULL? 
129SHIPPING_TSShipping Date and Time (Time Stamp)nvarchar140CHAR(N' ')YesBBP_SHIPPING_TS Allow NULL? 
130DEL_NOTE_NUMBERDelivery Note Numbernvarchar160CHAR(N' ')YesBBP_DEL_NOTE_NUMBER Allow NULL? 
131DEL_NOTE_ITEM_NODelivery Note Itemnvarchar100NUMC(N'0000000000')YesBBP_DEL_NOTE_ITEM_NO Allow NULL? 
132FIX_LINE_INDFixing Indicator for Schedule Line Itemschar10CHAR(N' ')YesBBP_FIX_LINE_IND Allow NULL? 
133CHECK_INDCheck Indicator at Item Level (Error in Item + Sets)char10CHAR(N' ')YesBBP_CHECK_IND Allow NULL? 
134HIER_CHECK_INDCheck Indicator at Hierarchy Level (error in subitem)char10CHAR(N' ')YesBBP_HIER_CHECK_IND Allow NULL? 
135UOM_DENOMINATORDenominator for Conversion to Base Unit of Measureint100INT4((0))YesBBP_UOM_DENOMINATOR Allow NULL? 
136UOM_NUMERATORCounter for Conversion to Base Unit of Measureint100INT4((0))YesBBP_UOM_NUMERATOR Allow NULL? 
137DOC_PRIORITYDocument Prioritynvarchar40CHAR(N' ')YesBBP_DOC_PRIORITY Allow NULL? 
138LUMP_SUM_INDIndicator for a Blanket Linechar10CHAR(N' ')YesBBP_LUMP_SUM_IND Allow NULL? 
139CO_CODECompany Code in FI Systemnvarchar40CHAR(N' ')Yes*BBP_CO_CODE Allow NULL? 
140PROJECT_IDProject Keynvarchar320CHAR(N' ')YesBBP_PROJECT_ID Allow NULL? 
141PROJECT_TASK_IDKey of Project Tasknvarchar320CHAR(N' ')YesBBP_PROJECT_TASK_ID Allow NULL? 
142PROJECT_ROLE_IDKey of Project Rolenvarchar320CHAR(N' ')YesBBP_PROJECT_ROLE_ID Allow NULL? 
143EXT_DEM_KEYTechnical Key of External Requirementvarbinary160RAWYesBBP_EXT_DEMKEY
144EXT_DEM_POSKEYTechnical Key of External Purchase Requisitionvarbinary160RAWYesBBP_EXT_DEM_POSKEY
145QUOTA_RELEVANTIndicator That Quota Arrangement is Relevantchar10CHAR(N' ')YesBBP_QUOTA_RELEVANT Allow NULL? 
146DOC_FLOW_CTRLIndicator of Possible Subsequent Processeschar10CHAR(N' ')YesBBP_DOC_FLOW_CTRL Allow NULL? 
147EXPSV_ITEM_TYPEItem Variantnvarchar50CHAR(N' ')YesBBP_EXPRESSIVE_ITEM_TYPE Allow NULL? 
148ORIG_GUIDOriginal Item GUIDvarbinary160RAWYesBBP_ORIG_GUID
149PR_UNITUnit of Measurementnvarchar30UNIT(N' ')Yes*BBP_UNIT Allow NULL? 
150TAR_IVALRelationship of Release Value to Target Value (in Percent)decimal30DEC((0))YesBBP_PER_IVAL
151TAR_QTYRelationship of Release Quantity to Target Quantity (in Per)decimal30DEC((0))YesBBP_PER_QTY
152PMNTTRMSTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
153ITEM_PROCESS_TYPItem Process Typenvarchar100CHAR(N' ')Yes*/SAPSRM/PDO_ITEM_PROCESS_TYPE Allow NULL? 
154EXLINConfigurable Line Item Numbernvarchar400CHAR(N' ')Yes/SAPSRM/EXLIN Allow NULL? 
155REV_LEVRevision Levelnvarchar20CHAR(N' ')YesCC_REVLV Allow NULL? 
156BLK_LOCAL_SRCBlock Local Sourcing Indicatorchar10CHAR(N' ')YesBBP_LOCAL_SOURCE_IND Allow NULL? 
157EXT_DEM_CH_ATTimestamp When an External Requirement was Recently Changeddecimal150DEC((0))YesBBP_EXT_DEM_CHANGED_AT
158EXT_DEM_EXLINConfigurable Line Item Numbernvarchar400CHAR(N' ')Yes/SAPSRM/EXLIN Allow NULL? 
159CTR_SRV_NUMContract Service Numbernvarchar200CHAR(N' ')YesBBP_CTR_SERVICE_NUMBER Allow NULL? 
160PRC_CHG_INDPrice Change Indicatorchar10CHAR(N' ')YesBBP_PRICE_CHG_IND Allow NULL? 
161ACC_STAT_SUSAcceptance Status for SUSchar10CHAR(N' ')YesBBP_SUS_ACCEPT_STAT_CODE Allow NULL? 
162HIDE_DATEDeferred until date for SoConvarchar80DATS(N'00000000')Yes/SAPSRM/HIDE_DATE Allow NULL? 
NamePrimaryUniqueTypeColumns
BBP_PDIGP~0YesYesCLUSTEREDGUID, CLIENT
BBP_PDIGP~CTRNoNoNONCLUSTEREDCTR_GUID
BBP_PDIGP~EXTNoNoNONCLUSTEREDEXT_DEM_KEY, EXT_DEMID
BBP_PDIGP~SOCNoNoNONCLUSTEREDSOURCE_REL_IND, DEL_IND
BBP_PDIGP~SRCNoNoNONCLUSTEREDSRC_GUID

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