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  | PRCC_COND_CT
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
Application Platform :: Pricing Condition Technique :: Pricing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PRCC_COND_CT481Condition Types (T685A)Pricing
SQL:  selectupdate insert create

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

SELECT MANDT, KAPPL, KSCHL, KRECH, KZBZG, STFKZ, KNTYP, KGRPE, KDUPL, KRUEK, KOAID, KFKIV, KVARC, KTREL, KBFLAG, DTASRC, KRELI, KOUPD, KMANU, GANZZ, KOFRS, KOFRS_NUM, KNEGA, TXPRF, KAEND_BTR, KAEND_WRT, KAEND_UFK, KAEND_RCH, KAEND_LOE, KAEND_MEH, BERGL, RDIFA, KMENG, KKOPF, KPOSI, PURP, USE_HOLIDAYS, GRLNR, GRLNR_NUM, GRMEN, KSTPR, IDXUP, KPRDT, PRECH, KFRST, KDELE, RKSCHL, DATA_ORIGIN FROM PRCC_COND_CT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2KAPPLApplicationnvarchar30CHAR(N' ')No/SAPCND/T681APRCT_APPLICATION Allow NULL? 
3KSCHLPricing - Condition Typenvarchar40CHAR(N' ')No/SAPCND/T685PRCT_COND_TYPE Allow NULL? 
4KRECHCalculation Type for Conditionnvarchar30CHAR(N' ')YesPRCC_CTYPE_DEFPRCT_CALCULATION_TYPE Allow NULL? 
5KZBZGIndicator: Scale Base Typenvarchar30CHAR(N' ')Yes*PRCT_SCALE_BASE_TYPE Allow NULL? 
6STFKZScale Type of a Conditionchar10CHAR(N' ')YesPRCT_COND_SCALE_TYPE Allow NULL? 
7KNTYPCondition Cat.: Frt, Tax, Basic Price=Revenue, Price, Costchar10CHAR(N' ')YesPRCT_COND_CATEGORY Allow NULL? 
8KGRPECondition is Group Conditionchar10CHAR(N' ')YesPRCT_FLAG_GROUP_COND Allow NULL? 
9KDUPLStructure Conditionchar10CHAR(N' ')YesPRCT_COND_STRUCT Allow NULL? 
10KRUEKAccruals are Set up for the Condition (e.g. Freight)char10CHAR(N' ')YesPRCT_FLAG_ACCRUAL Allow NULL? 
11KOAIDCondition Classchar10CHAR(N' ')YesPRCT_COND_CLASS Allow NULL? 
12KFKIVCondition for Inter-Company Billingchar10CHAR(N' ')YesPRCT_COND_INTER_COMPANY Allow NULL? 
13KVARCCondition for Configurationchar10CHAR(N' ')YesPRCT_COND_VARIANTS Allow NULL? 
14KTRELRelevance for Account Assignmentchar10CHAR(N' ')YesPRCT_FLAG_ACCOUNT_RELEVANT Allow NULL? 
15KBFLAGBit Encrypted Flags in Pricingvarbinary20RAWYesPRCT_GENERAL_FLAGS
16DTASRCPrimary Data Record Source for a Condition Recordnvarchar20CHAR(N' ')YesPRCT_DATA_SOURCE1 Allow NULL? 
17KRELIInvoice List Condition Flagchar10CHAR(N' ')YesPRCT_FLAG_INVOICE_LIST Allow NULL? 
18KOUPDCondition Update Flagchar10CHAR(N' ')YesPRCT_FLAG_COND_UPDATE Allow NULL? 
19KMANUGive Way Rule for Manual Entries (KMANU)char10CHAR(N' ')YesPRCT_COND_MAN_PRIORITY Allow NULL? 
20GANZZIndicator: Currency Conversion after Multiplicationchar10CHAR(N' ')YesPRCT_FLAG_CURR_CONV_LAST Allow NULL? 
21KOFRSScale Basis Formulanvarchar200CHAR(N' ')YesPRCT_FRM_SCALE_BASIS Allow NULL? 
22KOFRS_NUMScale Basis Formula IPCnvarchar70NUMC(N'0000000')YesPRCT_FRM_SCALE_BASIS_NUM Allow NULL? 
23KNEGAPlus/Minus Sign of the Condition Amountchar10CHAR(N' ')YesPRCT_COND_SIGN Allow NULL? 
24TXPRFRounding Rulechar10CHAR(N' ')YesPRCT_ROUNDING_RULE Allow NULL? 
25KAEND_BTRCondition Rate of Change for Amount/Percentagechar10CHAR(N' ')YesPRCT_FLAG_EDIT_RATE Allow NULL? 
26KAEND_WRTScope for Changing the Valuechar10CHAR(N' ')YesPRCT_FLAG_EDIT_VALUE Allow NULL? 
27KAEND_UFKScope for Changing Conversion Factorschar10CHAR(N' ')YesPRCT_FLAG_EDIT_CONV Allow NULL? 
28KAEND_RCHCondition Rate of Change for Calculation Typechar10CHAR(N' ')YesPRCT_FLAG_EDIT_RULE Allow NULL? 
29KAEND_LOEDelete the Scope for Changing Ratechar10CHAR(N' ')YesPRCT_FLAG_EDIT_DELE Allow NULL? 
30KAEND_MEHCondition Scope of Change for Unit of Measurechar10CHAR(N' ')YesPRCT_FLAG_EDIT_UNIT Allow NULL? 
31BERGLCalculation Basechar10CHAR(N' ')YesPRCT_CALCULATION_BASE Allow NULL? 
32RDIFARounding Difference Clearingchar10CHAR(N' ')YesPRCT_ROUNDING_COMPARISON Allow NULL? 
33KMENGQuantity Conversionchar10CHAR(N' ')YesPRCT_FLAG_UNIT_CONVERSION Allow NULL? 
34KKOPFFlag 'Condition is Condition'char10CHAR(N' ')YesPRCT_FLAG_HEAD_COND Allow NULL? 
35KPOSICondition is Item Conditionchar10CHAR(N' ')YesPRCT_FLAG_ITEM_COND Allow NULL? 
36PURPCondition Functionnvarchar40CHAR(N' ')YesPRCC_COND_DESTPRCT_COND_PURPOSE Allow NULL? 
37USE_HOLIDAYSexclude holidays for time-dependent conditionschar10CHAR(N' ')YesPRCT_USE_HOLIDAYS Allow NULL? 
38GRLNRGroup Key Routinenvarchar200CHAR(N' ')YesPRCT_FRM_GROUP_KEY Allow NULL? 
39GRLNR_NUMGroup Key Routine IPCnvarchar70NUMC(N'0000000')YesPRCT_FRM_GROUP_KEY_NUM Allow NULL? 
40GRMENCondition Scale Unit of Measurenvarchar30UNIT(N' ')YesT006PRCT_COND_SCALE_UOM Allow NULL? 
41KSTPRChecking Rule for Scale Rateschar10CHAR(N' ')YesPRCT_RATE_CHECK_RULE Allow NULL? 
42IDXUPUpdate Condition Indexchar10CHAR(N' ')YesPRCT_FLAG_INDEX_UPDATE Allow NULL? 
43KPRDTPricing Date (KPRDT)char10CHAR(N' ')YesPRCT_FLAG_PRICING_DATE Allow NULL? 
44PRECHPeriod Condition Calculation Typenvarchar30CHAR(N' ')Yes*PRCT_CALCULATION_TYPE_PERIODS Allow NULL? 
45KFRSTRelease Statuschar10CHAR(N' ')YesPRCT_RELEASE_STATUS Allow NULL? 
46KDELECondition Records Should be Deleted from the Databasechar10CHAR(N' ')YesPRCT_FLAG_DELETION Allow NULL? 
47RKSCHLPricing - Condition Typenvarchar40CHAR(N' ')Yes/SAPCND/T685PRCT_COND_TYPE Allow NULL? 
48DATA_ORIGINData source systemnvarchar100CHAR(N' ')YesPRC_DATA_ORIGIN Allow NULL? 
NamePrimaryUniqueTypeColumns
PRCC_COND_CT~0YesYesCLUSTEREDKSCHL, KAPPL, 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