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_PDHGP
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_PDHGP1016Business Transaction Purchasing Information
SQL:  selectupdate insert create

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

SELECT CLIENT, GUID, REF_DOC_NO, POSTING_DATE_FI, GR_GI_SLIP_NO, BILL_OF_LADING, CO_CODE, LOGSYS_FI, CURRENCY, GROSS_AMOUNT, TOTAL_VALUE, TOTAL_TAX, TOTAL_VALUE_APPR, USR_BUDGET_VALUE, PMNTTRMS, DSCNT1_TO, DSCNT2_TO, DSCNT3_TO, CASH_DISC1, CASH_DISC2, VPER_START, VPER_END, PCINS, PCNUM, PCNAME, PCDAT_TO, DOC_CLOSED, DOC_INCOMPLETE, DOC_FLOW_CTRL, INP_TYPE, WFL_CREATOR_TYPE, SRC_OBJECT_TYPE, SRC_GUID, SRC_OBJECT_ID, SRC_LOGSYS, REASON_CODE, TZONE, NF_TYPE, DOC_LANGU, SUBTYPE, REF_OBJECT_ID, EXT_DEM_LOGSYS, TOL_GROUP, PAYMENT_REF_NO, APPROVAL_IND, ICC_BUPLA_AR, ICC_BR_NF_FRE, ICC_BR_NF_INS, ICC_BR_NF_OTH, ICC_BR_NF_DIS, ICC_BR_NF_NET, ICC_BR_NF_TOT, ICC_BUPLA_BR, ICC_KIDNO_DK, ICC_KIDNO_FI, ICC_BUPLA_KR, ICC_KIDNO_NO, ICC_KIDNO_SE, ICC_BUPLA_TH, ICC_BUPLA_TW, VERSION_TYPE, ACTIVE_HEADER, CHANGE_LOCK, VERSION_NO, EXT_VERSION_NO, STOCH_CHECK, DELIV_DAYS, INCOTERM_KEY, INCOTERM_LOC, SK_COUNTRY, SK_SCENARIO1, SK_SCENARIO2, SK_SCENARIO3, SK_SCENARIO4, SK_SCENARIO5, VAL_PO_E, VAL_PO_E_AGG, ACCEPT_STAT_CODE, CONF_MODE_CODE, EXT_CREATE_DATE, SUSASN_TRANSTYPE, SUSASN_TRANSID, SUSASN_BILL_LAD, GUARANTEED_MIN, TRANSACTION_DATE, NO_ITEMS_ALLOWED, ROOT_IND, SENSITIVE, PMNT_BASIS_DATE, PURCHTEAM, GRP_IND, TAR_HVAL, EXPIRY_DAYS, SIG_IND, DIST_IND, PRESPEXT, SRV_LOC, BIDDING_SYSTEM, BBP_REVAL, NO_SRVBUNDLING, BBP_WF_COUNT FROM BBP_PDHGP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*EC_CLIENT Allow NULL? 
2GUIDGlobally Unique identifiervarbinary160RAWNoBBP_GUID
3REF_DOC_NOReference Document Numbernvarchar160CHAR(N' ')YesBBP_XBLNR Allow NULL? 
4POSTING_DATE_FITransaction Posting Date in Accountingnvarchar80DATS(N'00000000')YesPOSTING_DATE_FI Allow NULL? 
5GR_GI_SLIP_NOGoods receipt/issue slip numbernvarchar100CHAR(N' ')YesBBP_GRGI_SLIP_NO Allow NULL? 
6BILL_OF_LADINGBill of Lading Numbernvarchar160CHAR(N' ')YesBBP_BILL_OF_LADING Allow NULL? 
7CO_CODECompany Code in FI Systemnvarchar40CHAR(N' ')Yes*BBP_CO_CODE Allow NULL? 
8LOGSYS_FILogical System of FI Systemnvarchar100CHAR(N' ')Yes*BBP_LOGSYS_FI Allow NULL? 
9CURRENCYCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
10GROSS_AMOUNTGross invoice amount in document currencydecimal152CURR((0))YesBBP_IV_AMOUNT
11TOTAL_VALUETotal Value of Shopping Cart / Target Value of Contractdecimal152CURR((0))YesBBP_TOTAL_VALUE
12TOTAL_TAXTax Amountdecimal152CURR((0))YesBBP_TAX_AMOUNT
13TOTAL_VALUE_APPRTotal Value of Shopping Cart at Time of Approval (BI)decimal152CURR((0))YesBBP_TOTAL_VALUE_APPR
14USR_BUDGET_VALUETotal Value of Shopping Cart Relevant to User Budgetdecimal152CURR((0))YesBBP_USER_BUDGET_VALUE
15PMNTTRMSTerms of Payment Keynvarchar40CHAR(N' ')YesBBP_DZTERM Allow NULL? 
16DSCNT1_TOCash discount days 1decimal30DEC((0))YesBBP_BDET1BAPI
17DSCNT2_TOCash discount days 2decimal30DEC((0))YesBBP_BDET2BAPI
18DSCNT3_TOCash discount days 3decimal30DEC((0))YesBBP_BDET3BAPI
19CASH_DISC1Cash Discount Percentage 1decimal53DEC((0))YesDZBD1P
20CASH_DISC2Cash Discount Percentage 2decimal53DEC((0))YesDZBD2P
21VPER_STARTTimeframe Fromnvarchar80DATS(N'00000000')YesBBP_VPER_START Allow NULL? 
22VPER_ENDTimeframe Tonvarchar80DATS(N'00000000')YesBBP_VPER_END Allow NULL? 
23PCINSProcurement card companynvarchar40CHAR(N' ')Yes*BBPPCINS Allow NULL? 
24PCNUMProcurement card numbernvarchar250CHAR(N' ')Yes*BBPPCNUM Allow NULL? 
25PCNAMEName of procurement cardholdernvarchar400CHAR(N' ')YesBBPPCNAME Allow NULL? 
26PCDAT_TOProcurement Card Validity Datenvarchar80DATS(N'00000000')YesBBPPCDAT_TO Allow NULL? 
27DOC_CLOSEDIndicator Document Closedchar10CHAR(N' ')YesBBP_DOC_CLOSED Allow NULL? 
28DOC_INCOMPLETEIndicator Document Incompletechar10CHAR(N' ')YesBBP_DOC_INCOMPLETE Allow NULL? 
29DOC_FLOW_CTRLIndicator of Possible Subsequent Processeschar10CHAR(N' ')YesBBP_DOC_FLOW_CTRL Allow NULL? 
30INP_TYPECreation Indictaor (Dialog, XML and so on)char10CHAR(N' ')YesBBP_INP_TYPE Allow NULL? 
31WFL_CREATOR_TYPEType/Role of the Person who Starts the Approval Workflowchar10CHAR(N' ')YesBBP_WFL_CREATOR_TYPE Allow NULL? 
32SRC_OBJECT_TYPEObject Type of Reference Documentnvarchar100CHAR(N' ')Yes*BBP_SRC_H_OBJ_TYP Allow NULL? 
33SRC_GUIDReference Document GUIDvarbinary160RAWYesBBP_SRC_H_GUID
34SRC_OBJECT_IDBusiness Transaction Document IDnvarchar350CHAR(N' ')YesBBP_BTD_ID Allow NULL? 
35SRC_LOGSYSLogical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
36REASON_CODEReason for Rejectionnvarchar40CHAR(N' ')YesBBP_IVREABBP_PD_REASON Allow NULL? 
37TZONETime Zone for Date and Time Fields of Procurement Documentnvarchar60CHAR(N' ')YesBBP_TZONE Allow NULL? 
38NF_TYPENota Fiscal Typenvarchar20CHAR(N' ')Yes*BBP_NFTYPE Allow NULL? 
39DOC_LANGULanguage Key for Document / Vendorchar10LANG(N' ')YesBBP_DOCUMENT_LANGU Allow NULL? 
40SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20CHAR(N' ')YesBBP_H_SUBTYPE Allow NULL? 
41REF_OBJECT_IDReference Transaction Numbernvarchar100CHAR(N' ')YesBBP_REF_OBJECT_ID Allow NULL? 
42EXT_DEM_LOGSYSLogical System from where an External Requirement Comesnvarchar100CHAR(N' ')Yes*BBP_EXT_DEM_LOGSYS Allow NULL? 
43TOL_GROUPTolerance Groupnvarchar40CHAR(N' ')YesBBP_TOL_GROUP Allow NULL? 
44PAYMENT_REF_NOCountry Specific Payment Referencenvarchar300CHAR(N' ')YesBBP_PAYMENT_REF_NO Allow NULL? 
45APPROVAL_INDApproval Indicatorchar10CHAR(N' ')YesBBP_APPROVAL_IND Allow NULL? 
46ICC_BUPLA_ARBusiness Placenvarchar40CHAR(N' ')YesICC_BUPLA Allow NULL? 
47ICC_BR_NF_FRENota Fiscal: Freight Value including Taxesdecimal152CURR((0))YesBBP_ICC_NFFRE
48ICC_BR_NF_INSNota Fiscal: Insurance Value including Taxesdecimal152CURR((0))YesBBP_ICC_NFINS
49ICC_BR_NF_OTHNota Fiscal: Expenses including Taxesdecimal152CURR((0))YesBBP_ICC_NFOTH
50ICC_BR_NF_DISNota Fiscal: Discount Value including Taxesdecimal152CURR((0))YesBBP_ICC_NFDIS
51ICC_BR_NF_NETNota Fiscal: Net Value including Taxesdecimal152CURR((0))YesBBP_ICC_NFNET
52ICC_BR_NF_TOTNota Fiscal: Total Value including All Taxesdecimal152CURR((0))YesBBP_ICC_NFTOT
53ICC_BUPLA_BRBusiness Placenvarchar40CHAR(N' ')YesICC_BUPLA Allow NULL? 
54ICC_KIDNO_DKPayment Reference Numbernvarchar300CHAR(N' ')YesID_KIDNO Allow NULL? 
55ICC_KIDNO_FIPayment Reference Numbernvarchar300CHAR(N' ')YesID_KIDNO Allow NULL? 
56ICC_BUPLA_KRBusiness Placenvarchar40CHAR(N' ')YesICC_BUPLA Allow NULL? 
57ICC_KIDNO_NOPayment Reference Numbernvarchar300CHAR(N' ')YesID_KIDNO Allow NULL? 
58ICC_KIDNO_SEPayment Reference Numbernvarchar300CHAR(N' ')YesID_KIDNO Allow NULL? 
59ICC_BUPLA_THBusiness Placenvarchar40CHAR(N' ')YesICC_BUPLA Allow NULL? 
60ICC_BUPLA_TWBusiness Placenvarchar40CHAR(N' ')YesICC_BUPLA Allow NULL? 
61VERSION_TYPEVersion Type (Active Document, 'Normal', Work Version)char10CHAR(N' ')NoBBP_VERSION_TYPE Allow NULL? 
62ACTIVE_HEADERGlobally Unique identifiervarbinary160RAWNoBBP_GUID
63CHANGE_LOCKChange Lock ('X': changes not allowed)char10CHAR(N' ')NoBBP_CHANGE_LOCK Allow NULL? 
64VERSION_NOVersion Numbernvarchar80CHAR(N' ')NoBBP_VERSION_NO Allow NULL? 
65EXT_VERSION_NOVersion Numbernvarchar80CHAR(N' ')YesBBP_VERSION_NO Allow NULL? 
66STOCH_CHECKDocument was Flagged by Stochastic Checkchar10CHAR(N' ')NoBBP_STOCH_CHECK Allow NULL? 
67DELIV_DAYSDelivery Time in Daysnvarchar30NUMC(N'000')NoBBP_DELIV_DAYS Allow NULL? 
68INCOTERM_KEYIncoterm Keynvarchar30CHAR(N' ')No*BBP_INCOTERM_KEY Allow NULL? 
69INCOTERM_LOCIncoterm Locationnvarchar280CHAR(N' ')NoBBP_INCOTERM_LOCATION Allow NULL? 
70SK_COUNTRYCountry ISO codenvarchar20CHAR(N' ')YesINTCA Allow NULL? 
71SK_SCENARIO1Key of a Scenario for Field Extensionnvarchar30CHAR(N' ')YesBBP_CUF_SCENARIO_KEY Allow NULL? 
72SK_SCENARIO2Key of a Scenario for Field Extensionnvarchar30CHAR(N' ')YesBBP_CUF_SCENARIO_KEY Allow NULL? 
73SK_SCENARIO3Key of a Scenario for Field Extensionnvarchar30CHAR(N' ')YesBBP_CUF_SCENARIO_KEY Allow NULL? 
74SK_SCENARIO4Key of a Scenario for Field Extensionnvarchar30CHAR(N' ')YesBBP_CUF_SCENARIO_KEY Allow NULL? 
75SK_SCENARIO5Key of a Scenario for Field Extensionnvarchar30CHAR(N' ')YesBBP_CUF_SCENARIO_KEY Allow NULL? 
76VAL_PO_EValue of POs/Confirmations/Invoices Created for Contractdecimal152CURR((0))YesBBP_PO_VALUE_E
77VAL_PO_E_AGGValue PO / Confirm. / Inv. for Contract Hierarchydecimal152CURR((0))YesBBP_AGG_VALUE_E
78ACCEPT_STAT_CODEAcceptance Statuschar10CHAR(N' ')YesBBP_ACCEPT_STAT_CODE Allow NULL? 
79CONF_MODE_CODEType of Confirmationchar10CHAR(N' ')YesBBP_CONF_MODE_CODE Allow NULL? 
80EXT_CREATE_DATECreation Date of PO in External System (SRM/MM)nvarchar80DATS(N'00000000')YesBBP_EXT_CREATE_DATE Allow NULL? 
81SUSASN_TRANSTYPESUS ASN Transportation Typenvarchar40CHAR(N' ')YesBBP_SUSASN_TRANS_TYPE Allow NULL? 
82SUSASN_TRANSIDSUS ASN Transportation IDnvarchar200CHAR(N' ')YesBBP_SUSASN_TRANS_ID Allow NULL? 
83SUSASN_BILL_LADSUS Bill of Ladingnvarchar350CHAR(N' ')YesBBP_SUSASN_BILL_OF_LADING Allow NULL? 
84GUARANTEED_MINGuaranteed Purchase Value (Public Sector ONLY!!)decimal152CURR((0))YesBBP_GUARANTEED_MIN
85TRANSACTION_DATEService Provision Datenvarchar80DATS(N'00000000')YesBBP_TRANSACTION_DATE Allow NULL? 
86NO_ITEMS_ALLOWEDFlag for Document Without Items (for example, HDR CTR)char10CHAR(N' ')YesBBP_NO_ITEMS_ALLOWED Allow NULL? 
87ROOT_INDis Root of a Hierarchychar10CHAR(N' ')YesBBP_ROOT_IND Allow NULL? 
88SENSITIVEConfidential Level of the SRM Documentchar10CHAR(N' ')YesBBP_SENSITIVE Allow NULL? 
89PMNT_BASIS_DATEReference Date From Which Payment Terms Applynvarchar150NUMC(N'000000000000000')YesBBP_PMNT_BASIS_DATE Allow NULL? 
90PURCHTEAMTeam Purchasing: Purchasing Teamnvarchar80CHAR(N' ')Yes*BBP_PURCHTEAM Allow NULL? 
91GRP_INDGrouping logic for locations activation flagchar10CHAR(N' ')YesBBP_GOA_DIST_F Allow NULL? 
92TAR_HVALContract header:Relationship of release value to total valuedecimal30DEC((0))YesBBP_PER_HVAL
93EXPIRY_DAYSTime Frame Before Contract Validity End (in Days)nvarchar30NUMC(N'000')YesBBP_EXPIRY_DAYS Allow NULL? 
94SIG_INDSignaturechar10CHAR(N' ')YesBBP_SIG_IND Allow NULL? 
95DIST_INDDistribution Flagchar10CHAR(N' ')YesBBP_DIST_FLAG Allow NULL? 
96PRESPEXTPerson Responsible Externalnvarchar120CHAR(N' ')YesBBP_PERSON_RESPONSIBLE_EXT Allow NULL? 
97SRV_LOCService Locationnvarchar250CHAR(N' ')YesBBP_SERVICE_LOCATION Allow NULL? 
98BIDDING_SYSTEMSystem in Which Bidding Takes Placechar10CHAR(N' ')YesBBP_BIDDING_SYSTEM Allow NULL? 
99BBP_REVALPrice Revaluation Statuschar10CHAR(N' ')YesBBP_PRC_REVAL Allow NULL? 
100NO_SRVBUNDLINGService Bundling Indicatorchar10CHAR(N' ')YesBBP_NO_SERVICE_BUNDLING Allow NULL? 
101BBP_WF_COUNTWorkflow trigger counterchar10NUMC(N'0')YesBBP_WF_COUNT Allow NULL? 
NamePrimaryUniqueTypeColumns
BBP_PDHGP~0YesYesCLUSTEREDGUID, CLIENT
BBP_PDHGP~INCNoNoNONCLUSTEREDDOC_INCOMPLETE
BBP_PDHGP~REFNoNoNONCLUSTEREDREF_DOC_NO
BBP_PDHGP~ROINoNoNONCLUSTEREDREF_OBJECT_ID
BBP_PDHGP~SRCNoNoNONCLUSTEREDSRC_GUID, CLIENT
BBP_PDHGP~VERNoNoNONCLUSTEREDACTIVE_HEADER, 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