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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2SEND_REC_RELScreen Variant for Manual Actual Postings in COnvarchar50 Allow NULL? 
3VRGNGBusiness transactions for manual actual postings in COnvarchar40 Allow NULL? 
4XS_KOSTLShow cost centerchar10 Allow NULL? 
5XS_LSTARShow activity typechar10 Allow NULL? 
6XS_AUFNRShow orderchar10 Allow NULL? 
7XS_AFPOSShow order itemchar10 Allow NULL? 
8XS_VORNR_AUFShow Order Operationchar10 Allow NULL? 
9XS_PS_PSP_PNRShow work breakdown structure element (WBS element)char10 Allow NULL? 
10XS_KSTRGShow cost objectchar10 Allow NULL? 
11XS_NPLNRShow networkchar10 Allow NULL? 
12XS_VORNRShow network activitychar10 Allow NULL? 
13XS_KDAUFShow sales orderchar10 Allow NULL? 
14XS_KDPOSShow sales order itemchar10 Allow NULL? 
15XS_PAOBJNRShow profitability segmentchar10 Allow NULL? 
16XS_PRZNRShow business processchar10 Allow NULL? 
17XS_PROCNRShow production processchar10 Allow NULL? 
18XS_MATNRShow materialchar10 Allow NULL? 
19XS_WERKSShow plantchar10 Allow NULL? 
20XS_BEMOTShow accounting indicatorchar10 Allow NULL? 
21XS_RECIDShow cost typechar10 Allow NULL? 
22XS_BUKRSShow company code of the real estate objectchar10 Allow NULL? 
23XS_SWENRShow real estate asset groupchar10 Allow NULL? 
24XS_SGRNRShow property for immo business unitchar10 Allow NULL? 
25XS_SGENRShow real estate buildingschar10 Allow NULL? 
26XS_SMENRShow real estate rental unitchar10 Allow NULL? 
27XS_SMIVEShow Real Estate Lease-Outchar10 Allow NULL? 
28XS_SVWNRShow management contractchar10 Allow NULL? 
29XS_SNKSLShow real estate service charge keychar10 Allow NULL? 
30XS_SEMPSLShow real estate settlement unitchar10 Allow NULL? 
31XS_DABBZShow reference date of the real estate object settlementchar10 Allow NULL? 
32XS_RECNNRShow Contract Number of Real Estatechar10 Allow NULL? 
33XS_GEBERShow Fundchar10 Allow NULL? 
34XS_FKBERShow Functional Areachar10 Allow NULL? 
35XS_GRANT_NBRShow Grantchar10 Allow NULL? 
36XS_BUDGET_PDShow Budget Periodchar10 Allow NULL? 
37XS_CUSTOMERShow Customer Fieldschar10 Allow NULL? 
38XS_STOPStop Flag for Varying Processingchar10 Allow NULL? 
39XR_KOSTLShow cost centerchar10 Allow NULL? 
40XR_LSTARShow activity typechar10 Allow NULL? 
41XR_AUFNRShow orderchar10 Allow NULL? 
42XR_AFPOSShow order itemchar10 Allow NULL? 
43XR_VORNR_AUFShow Order Operationchar10 Allow NULL? 
44XR_PS_PSP_PNRShow work breakdown structure element (WBS element)char10 Allow NULL? 
45XR_KSTRGShow cost objectchar10 Allow NULL? 
46XR_NPLNRShow networkchar10 Allow NULL? 
47XR_VORNRShow network activitychar10 Allow NULL? 
48XR_KDAUFShow sales orderchar10 Allow NULL? 
49XR_KDPOSShow sales order itemchar10 Allow NULL? 
50XR_PAOBJNRShow profitability segmentchar10 Allow NULL? 
51XR_PRZNRShow business processchar10 Allow NULL? 
52XR_PROCNRShow production processchar10 Allow NULL? 
53XR_MATNRShow materialchar10 Allow NULL? 
54XR_WERKSShow plantchar10 Allow NULL? 
55XR_BEMOTShow accounting indicatorchar10 Allow NULL? 
56XR_RECIDShow cost typechar10 Allow NULL? 
57XR_BUKRSShow company code of the real estate objectchar10 Allow NULL? 
58XR_SWENRShow real estate asset groupchar10 Allow NULL? 
59XR_SGRNRShow property for immo business unitchar10 Allow NULL? 
60XR_SGENRShow real estate buildingschar10 Allow NULL? 
61XR_SMENRShow real estate rental unitchar10 Allow NULL? 
62XR_SMIVEShow Real Estate Lease-Outchar10 Allow NULL? 
63XR_SVWNRShow management contractchar10 Allow NULL? 
64XR_SNKSLShow real estate service charge keychar10 Allow NULL? 
65XR_SEMPSLShow real estate settlement unitchar10 Allow NULL? 
66XR_DABBZShow reference date of the real estate object settlementchar10 Allow NULL? 
67XR_RECNNRShow Contract Number of Real Estatechar10 Allow NULL? 
68XR_GEBERShow Fundchar10 Allow NULL? 
69XR_FKBERShow Functional Areachar10 Allow NULL? 
70XR_GRANT_NBRShow Grantchar10 Allow NULL? 
71XR_BUDGET_PDShow Budget Periodchar10 Allow NULL? 
72XR_CUSTOMERShow Customer Fieldschar10 Allow NULL? 
73XR_STOPStop Flag for Varying Processingchar10 Allow NULL? 
74XTARIFShow total pricechar10 Allow NULL? 
75XPERNRShow personnel numberchar10 Allow NULL? 
76XAUSBTRShow outputchar10 Allow NULL? 
77XMBGBTRShow quantitychar10 Allow NULL? 
78XSGTEXTShow item textchar10 Allow NULL? 
79START_DYNPInitial screen for manual actual postings in COchar10 Allow NULL? 
80VARI_OVIEW_LISTDisplay variant for general overview listnvarchar120 Allow NULL? 
81VARI_NAV_LISTVariant for navigation list in single entrynvarchar120 Allow NULL? 
82TCVARIANTTransaction variant for manual actual postings in COnvarchar300 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