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  | SEND_REC_REL_DEF
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
Controlling
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SEND_REC_REL_DEF821Definition of Screen Variants for Manual Actual PostingsControlling
SQL:  selectupdate insert create

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

SELECT MANDT, SEND_REC_REL, VRGNG, XS_KOSTL, XS_LSTAR, XS_AUFNR, XS_AFPOS, XS_VORNR_AUF, XS_PS_PSP_PNR, XS_KSTRG, XS_NPLNR, XS_VORNR, XS_KDAUF, XS_KDPOS, XS_PAOBJNR, XS_PRZNR, XS_PROCNR, XS_MATNR, XS_WERKS, XS_BEMOT, XS_RECID, XS_BUKRS, XS_SWENR, XS_SGRNR, XS_SGENR, XS_SMENR, XS_SMIVE, XS_SVWNR, XS_SNKSL, XS_SEMPSL, XS_DABBZ, XS_RECNNR, XS_GEBER, XS_FKBER, XS_GRANT_NBR, XS_BUDGET_PD, XS_CUSTOMER, XS_STOP, XR_KOSTL, XR_LSTAR, XR_AUFNR, XR_AFPOS, XR_VORNR_AUF, XR_PS_PSP_PNR, XR_KSTRG, XR_NPLNR, XR_VORNR, XR_KDAUF, XR_KDPOS, XR_PAOBJNR, XR_PRZNR, XR_PROCNR, XR_MATNR, XR_WERKS, XR_BEMOT, XR_RECID, XR_BUKRS, XR_SWENR, XR_SGRNR, XR_SGENR, XR_SMENR, XR_SMIVE, XR_SVWNR, XR_SNKSL, XR_SEMPSL, XR_DABBZ, XR_RECNNR, XR_GEBER, XR_FKBER, XR_GRANT_NBR, XR_BUDGET_PD, XR_CUSTOMER, XR_STOP, XTARIF, XPERNR, XAUSBTR, XMBGBTR, XSGTEXT, START_DYNP, VARI_OVIEW_LIST, VARI_NAV_LIST, TCVARIANT FROM SEND_REC_REL_DEF
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SEND_REC_RELScreen Variant for Manual Actual Postings in COnvarchar50CHAR(N' ')NoSEND_REC_RELDE_SEND_REC_REL Allow NULL? 
3VRGNGBusiness transactions for manual actual postings in COnvarchar40CHAR(N' ')NoTJ01DE_VRGNG_KBXX Allow NULL? 
4XS_KOSTLShow cost centerchar10CHAR(N' ')YesX_KOSTL_FADE_IN Allow NULL? 
5XS_LSTARShow activity typechar10CHAR(N' ')YesX_LSTAR_FADE_IN Allow NULL? 
6XS_AUFNRShow orderchar10CHAR(N' ')YesX_AUFNR_FADE_IN Allow NULL? 
7XS_AFPOSShow order itemchar10CHAR(N' ')YesX_AFPOS_FADE_IN Allow NULL? 
8XS_VORNR_AUFShow Order Operationchar10CHAR(N' ')YesX_VORNR_AUF_FADE_IN Allow NULL? 
9XS_PS_PSP_PNRShow work breakdown structure element (WBS element)char10CHAR(N' ')YesX_PS_PSP_PNR_FADE_IN Allow NULL? 
10XS_KSTRGShow cost objectchar10CHAR(N' ')YesX_KSTRG_FADE_IN Allow NULL? 
11XS_NPLNRShow networkchar10CHAR(N' ')YesX_NPLNR_FADE_IN Allow NULL? 
12XS_VORNRShow network activitychar10CHAR(N' ')YesX_VORNR_FADE_IN Allow NULL? 
13XS_KDAUFShow sales orderchar10CHAR(N' ')YesX_KDAUF_FADE_IN Allow NULL? 
14XS_KDPOSShow sales order itemchar10CHAR(N' ')YesX_KDPOS_FADE_IN Allow NULL? 
15XS_PAOBJNRShow profitability segmentchar10CHAR(N' ')YesX_PAOBJNR_FADE_IN Allow NULL? 
16XS_PRZNRShow business processchar10CHAR(N' ')YesX_PRZNR_FADE_IN Allow NULL? 
17XS_PROCNRShow production processchar10CHAR(N' ')YesX_PROCNR_FADE_IN Allow NULL? 
18XS_MATNRShow materialchar10CHAR(N' ')YesX_MATNR_FADE_IN Allow NULL? 
19XS_WERKSShow plantchar10CHAR(N' ')YesX_WERKS_FADE_IN Allow NULL? 
20XS_BEMOTShow accounting indicatorchar10CHAR(N' ')YesX_BEMOT_FADE_IN Allow NULL? 
21XS_RECIDShow cost typechar10CHAR(N' ')YesX_RECID_FADE_IN Allow NULL? 
22XS_BUKRSShow company code of the real estate objectchar10CHAR(N' ')YesX_BUKRS_FADE_IN Allow NULL? 
23XS_SWENRShow real estate asset groupchar10CHAR(N' ')YesX_SWENR_FADE_IN Allow NULL? 
24XS_SGRNRShow property for immo business unitchar10CHAR(N' ')YesX_SGRNR_FADE_IN Allow NULL? 
25XS_SGENRShow real estate buildingschar10CHAR(N' ')YesX_SGENR_FADE_IN Allow NULL? 
26XS_SMENRShow real estate rental unitchar10CHAR(N' ')YesX_SMENR_FADE_IN Allow NULL? 
27XS_SMIVEShow Real Estate Lease-Outchar10CHAR(N' ')YesX_SMIVE_FADE_IN Allow NULL? 
28XS_SVWNRShow management contractchar10CHAR(N' ')YesX_VVSSVWNR_FADE_IN Allow NULL? 
29XS_SNKSLShow real estate service charge keychar10CHAR(N' ')YesX_SNKSL_FADE_IN Allow NULL? 
30XS_SEMPSLShow real estate settlement unitchar10CHAR(N' ')YesX_SEMPSL_FADE_IN Allow NULL? 
31XS_DABBZShow reference date of the real estate object settlementchar10CHAR(N' ')YesX_DABBZ_FADE_IN Allow NULL? 
32XS_RECNNRShow Contract Number of Real Estatechar10CHAR(N' ')YesX_RECNNR_FADE_IN Allow NULL? 
33XS_GEBERShow Fundchar10CHAR(N' ')YesX_GEBER_FADE_IN Allow NULL? 
34XS_FKBERShow Functional Areachar10CHAR(N' ')YesX_FKBER_FADE_IN Allow NULL? 
35XS_GRANT_NBRShow Grantchar10CHAR(N' ')YesX_GRANT_FADE_IN Allow NULL? 
36XS_BUDGET_PDShow Budget Periodchar10CHAR(N' ')YesX_BUDGET_PERIOD_FADE_IN Allow NULL? 
37XS_CUSTOMERShow Customer Fieldschar10CHAR(N' ')YesX_CUSTOMER_FADE_IN Allow NULL? 
38XS_STOPStop Flag for Varying Processingchar10CHAR(N' ')YesX_STOP_FLAG Allow NULL? 
39XR_KOSTLShow cost centerchar10CHAR(N' ')YesX_KOSTL_FADE_IN Allow NULL? 
40XR_LSTARShow activity typechar10CHAR(N' ')YesX_LSTAR_FADE_IN Allow NULL? 
41XR_AUFNRShow orderchar10CHAR(N' ')YesX_AUFNR_FADE_IN Allow NULL? 
42XR_AFPOSShow order itemchar10CHAR(N' ')YesX_AFPOS_FADE_IN Allow NULL? 
43XR_VORNR_AUFShow Order Operationchar10CHAR(N' ')YesX_VORNR_AUF_FADE_IN Allow NULL? 
44XR_PS_PSP_PNRShow work breakdown structure element (WBS element)char10CHAR(N' ')YesX_PS_PSP_PNR_FADE_IN Allow NULL? 
45XR_KSTRGShow cost objectchar10CHAR(N' ')YesX_KSTRG_FADE_IN Allow NULL? 
46XR_NPLNRShow networkchar10CHAR(N' ')YesX_NPLNR_FADE_IN Allow NULL? 
47XR_VORNRShow network activitychar10CHAR(N' ')YesX_VORNR_FADE_IN Allow NULL? 
48XR_KDAUFShow sales orderchar10CHAR(N' ')YesX_KDAUF_FADE_IN Allow NULL? 
49XR_KDPOSShow sales order itemchar10CHAR(N' ')YesX_KDPOS_FADE_IN Allow NULL? 
50XR_PAOBJNRShow profitability segmentchar10CHAR(N' ')YesX_PAOBJNR_FADE_IN Allow NULL? 
51XR_PRZNRShow business processchar10CHAR(N' ')YesX_PRZNR_FADE_IN Allow NULL? 
52XR_PROCNRShow production processchar10CHAR(N' ')YesX_PROCNR_FADE_IN Allow NULL? 
53XR_MATNRShow materialchar10CHAR(N' ')YesX_MATNR_FADE_IN Allow NULL? 
54XR_WERKSShow plantchar10CHAR(N' ')YesX_WERKS_FADE_IN Allow NULL? 
55XR_BEMOTShow accounting indicatorchar10CHAR(N' ')YesX_BEMOT_FADE_IN Allow NULL? 
56XR_RECIDShow cost typechar10CHAR(N' ')YesX_RECID_FADE_IN Allow NULL? 
57XR_BUKRSShow company code of the real estate objectchar10CHAR(N' ')YesX_BUKRS_FADE_IN Allow NULL? 
58XR_SWENRShow real estate asset groupchar10CHAR(N' ')YesX_SWENR_FADE_IN Allow NULL? 
59XR_SGRNRShow property for immo business unitchar10CHAR(N' ')YesX_SGRNR_FADE_IN Allow NULL? 
60XR_SGENRShow real estate buildingschar10CHAR(N' ')YesX_SGENR_FADE_IN Allow NULL? 
61XR_SMENRShow real estate rental unitchar10CHAR(N' ')YesX_SMENR_FADE_IN Allow NULL? 
62XR_SMIVEShow Real Estate Lease-Outchar10CHAR(N' ')YesX_SMIVE_FADE_IN Allow NULL? 
63XR_SVWNRShow management contractchar10CHAR(N' ')YesX_VVSSVWNR_FADE_IN Allow NULL? 
64XR_SNKSLShow real estate service charge keychar10CHAR(N' ')YesX_SNKSL_FADE_IN Allow NULL? 
65XR_SEMPSLShow real estate settlement unitchar10CHAR(N' ')YesX_SEMPSL_FADE_IN Allow NULL? 
66XR_DABBZShow reference date of the real estate object settlementchar10CHAR(N' ')YesX_DABBZ_FADE_IN Allow NULL? 
67XR_RECNNRShow Contract Number of Real Estatechar10CHAR(N' ')YesX_RECNNR_FADE_IN Allow NULL? 
68XR_GEBERShow Fundchar10CHAR(N' ')YesX_GEBER_FADE_IN Allow NULL? 
69XR_FKBERShow Functional Areachar10CHAR(N' ')YesX_FKBER_FADE_IN Allow NULL? 
70XR_GRANT_NBRShow Grantchar10CHAR(N' ')YesX_GRANT_FADE_IN Allow NULL? 
71XR_BUDGET_PDShow Budget Periodchar10CHAR(N' ')YesX_BUDGET_PERIOD_FADE_IN Allow NULL? 
72XR_CUSTOMERShow Customer Fieldschar10CHAR(N' ')YesX_CUSTOMER_FADE_IN Allow NULL? 
73XR_STOPStop Flag for Varying Processingchar10CHAR(N' ')YesX_STOP_FLAG Allow NULL? 
74XTARIFShow total pricechar10CHAR(N' ')YesX_TARIF_FADE_IN Allow NULL? 
75XPERNRShow personnel numberchar10CHAR(N' ')YesX_PERNR_FADE_IN Allow NULL? 
76XAUSBTRShow outputchar10CHAR(N' ')YesX_AUSBTR_FADE_IN Allow NULL? 
77XMBGBTRShow quantitychar10CHAR(N' ')YesX_MBGBTR_FADE_IN Allow NULL? 
78XSGTEXTShow item textchar10CHAR(N' ')YesX_SGTXT_FADE_IN Allow NULL? 
79START_DYNPInitial screen for manual actual postings in COchar10CHAR(N' ')NoDE_START_DYNP Allow NULL? 
80VARI_OVIEW_LISTDisplay variant for general overview listnvarchar120CHAR(N' ')NoLTDXVARI_OVIEW_LIST Allow NULL? 
81VARI_NAV_LISTVariant for navigation list in single entrynvarchar120CHAR(N' ')NoLTDXVARI_NAV_LIST Allow NULL? 
82TCVARIANTTransaction variant for manual actual postings in COnvarchar300CHAR(N' ')NoTC_VARIANT_KBXXN Allow NULL? 
NamePrimaryUniqueTypeColumns
SEND_REC_REL_DEF~0YesYesCLUSTEREDVRGNG, SEND_REC_REL, MANDT

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