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  | KAKO
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
Production Planning and Control :: Basic Data :: Work Center
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0KAKO765Capacity Header SegmentWork Center
SQL:  selectupdate insert create

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

SELECT MANDT, KAPID, AZMAX, AZNOR, BASNE, BASZL, BEGZT, BRGRU, ENDZT, KALID, KAPAR, MEINS, MOSID, NAME, NGRAD, PAUSE, PLANR, POOLK, REFAN, REFAZ, REFID, SUPPK, VERSA, WERKS, KAPIE, KAPTER, KAPAVO, UEBERLAST, KAPLPL, KAPEH, MEHR, ANG_UNIT, ANG_MIN, ANG_MAX, TYPE, RESTYPE, CAPACITY_A, CAPACITY_A_UNIT, NUM_OF_PERIODS, PERIOD, BUFFERTIME, BUFFERTIME_UNIT, IS_BOTTLENECK, UNDERLOAD, OVERLAP_BUCKETS, START_ON_GRID, MIN_OVERLAP, MIN_OVERLAP_UNIT, LOSS_FACTOR, SORT, SYNC_START, DEFINE_BUCKETS, LC_DAYS_MINUS, LC_DAYS_PLUS, STORAGE_CAPABLE, MIN_STORAGE, MAX_STORAGE, STORAGE_UNIT, DIM_STORAGE, STORAGE_TO_ZERO, SNPLC, UTIL_BUCKET, CAMPAIGN_PPDS, CAMPAIGN_SNP, TSTREAM_EXTERNAL, FINITY_LEVEL, BR_QUANT, BR_QUNIT, BR_TIME, BR_TUNIT, RITT_FLG, MDRMODEL, PP_DEF_BUCKETS, PP_BUCKET_SCHEMA, PP_BUCKET_FACT, MIX_PLAN_TYPE FROM KAKO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2KAPIDCapacity IDnvarchar80NUMC(N'00000000')NoKAPID Allow NULL? 
3AZMAXNumber of individual capacitiessmallint50INT2((0))YesKAPANZAHL
4AZNORNumber of individual capacitiessmallint50INT2((0))YesKAPANZAHL
5BASNEDenominator of the base capacitydecimal50DEC((0))YesKAPBASNEN
6BASZLNumerator for base capacitydecimal50DEC((0))YesKAPBASZHL
7BEGZTStart time in seconds (internal)int100INT4((0))YesKAPBEGZT Allow NULL? 
8BRGRUAuthorization Groupnvarchar40CHAR(N' ')Yes*BRGRU Allow NULL? 
9ENDZTFinish time in seconds (internal)int100INT4((0))YesKAPENDZT Allow NULL? 
10KALIDFactory calendar IDnvarchar20CHAR(N' ')YesTFACDCR_WFCID Allow NULL? 
11KAPARCapacity categorynvarchar30CHAR(N' ')YesTC26KAPART Allow NULL? 
12MEINSBase Unit of Measurement for Capacitynvarchar30UNIT(N' ')YesT006KAPBASIS Allow NULL? 
13MOSIDGrouping for Shift Definitions and Shift Sequencesnvarchar20CHAR(N' ')YesTC39ASCHGRUP Allow NULL? 
14NAMECapacity namenvarchar80CHAR(N' ')YesKAPNAME Allow NULL? 
15NGRADCapacity utilization rate (percent)nvarchar30NUMC(N'000')YesNUTZGRAD Allow NULL? 
16PAUSECumulative break time in seconds (internal)int100INT4((0))YesKAPPAUSE Allow NULL? 
17PLANRCapacity planner groupnvarchar30CHAR(N' ')YesTC27KAPPLANER Allow NULL? 
18POOLKIndicator for pooled capacitychar10CHAR(N' ')YesKAP_KZPOOL Allow NULL? 
19REFANDenominator relationship: No. of indiv. capacities referencetinyint30INT1((0))YesKAPREFANZN
20REFAZNumerator relationships: No. of indiv. capacities referencetinyint30INT1((0))YesKAPREFANZZ
21REFIDCapacity IDnvarchar80NUMC(N'00000000')YesKAKOKAPID Allow NULL? 
22SUPPKAvailable capacity limitschar10CHAR(N' ')YesKAP_SUPPLY Allow NULL? 
23VERSAActive version of available capacitynvarchar20NUMC(N'00')YesTC36KAPVERSAKT Allow NULL? 
24WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
25KAPIECapacity IDnvarchar80NUMC(N'00000000')NoKAKOKAPID Allow NULL? 
26KAPTERIndicator: Capacity relevant to finite schedulingchar10CHAR(N' ')YesKAP_KZTER Allow NULL? 
27KAPAVOIndicator: Several operations can use capacitychar10CHAR(N' ')YesKAP_KZAVO Allow NULL? 
28UEBERLASTOverloadnvarchar30NUMC(N'000')YesUEBERLAST Allow NULL? 
29KAPLPLIndicator: Capacity excluded from long-term planningchar10CHAR(N' ')YesKAP_KZLPL Allow NULL? 
30KAPEHUnit of measure of capacitynvarchar30UNIT(N' ')YesT006CR_KAPEH Allow NULL? 
31MEHRHas individual capacitieschar10CHAR(N' ')YesKAP_MEHR Allow NULL? 
32ANG_UNITUnit for available capacitynvarchar30UNIT(N' ')Yes*KAPAZIT_VM_UNIT Allow NULL? 
33ANG_MINMinimum capacity in volume unit or unit of measuredecimal133QUAN((0))YesKAPAZIT_VM_MIN
34ANG_MAXMaximum capacity in volume unit or unit of measuredecimal133QUAN((0))YesKAPAZIT_VM_MAX
35TYPEResource Typenvarchar20NUMC(N'00')YesCRES_RESOURCETYPE Allow NULL? 
36RESTYPEResource Categorychar10CHAR(N' ')YesCRES_RESOURCE_CATEGORY Allow NULL? 
37CAPACITY_ACapacity of Bucket Resourcedecimal133QUAN((0))YesCRES_CAPACITYV1_DISP
38CAPACITY_A_UNITUnit of Measurement for the Capacity of a Bucket Resourcenvarchar30UNIT(N' ')Yes*CRES_CAPACITYV_UNIT Allow NULL? 
39NUM_OF_PERIODSNumber of Periods to Which the Capacity Refersnvarchar30NUMC(N'000')YesCRES_NUM_OF_PERIODS Allow NULL? 
40PERIODPeriod Typenvarchar20NUMC(N'00')YesCRES_PERIOD Allow NULL? 
41BUFFERTIMEResource-Dependent Time Bufferint100INT4((0))YesCRES_BUFFERTIME Allow NULL? 
42BUFFERTIME_UNITUnit of Measurement for Time Buffernvarchar30UNIT(N' ')Yes*CRES_BUFFERTIME_UNIT Allow NULL? 
43IS_BOTTLENECKThis Resource is a Bottleneck Resourcechar10CHAR(N' ')YesCRES_BOTTLENECK Allow NULL? 
44UNDERLOADMinimum Capacity Load for the Resourcenvarchar30NUMC(N'000')YesCRES_UNDERLOAD Allow NULL? 
45OVERLAP_BUCKETSActivities can Overlap into Another Periodchar10CHAR(N' ')YesCRES_OVERLAP_BUCKETS Allow NULL? 
46START_ON_GRIDActivities can Only Begin at the Start of the Bucketchar10CHAR(N' ')YesCRES_START_ON_GRID Allow NULL? 
47MIN_OVERLAPMaximum Overlap of Activitiesint100INT4((0))YesCRES_MIN_OVERLAP Allow NULL? 
48MIN_OVERLAP_UNITUnit of Measurement for Maximum Overlap of Two Activitiesnvarchar30UNIT(N' ')Yes*CRES_MIN_OVERLAP_UNIT Allow NULL? 
49LOSS_FACTORLoss Factor in Percent when Deriving Bucket Capacitynvarchar30NUMC(N'000')YesCRES_LOSS_FACTOR Allow NULL? 
50SORTFreely Selectable Character Sequence for Sorting Resourcesnvarchar300CHAR(N' ')YesCRES_SORT Allow NULL? 
51SYNC_STARTSynchronization of Activities when Overlapping Occurschar10NUMC(N'0')YesCRES_SYNC_START Allow NULL? 
52DEFINE_BUCKETSDefinition of the Bucket Capacity of a Mixed Resourcechar10CHAR(N' ')YesCRES_DEFINE_BUCKETS Allow NULL? 
53LC_DAYS_MINUSValidity of Available Capacity (In Past)nvarchar40NUMC(N'0000')YesCRES_GEN_LC_BACKWARDS Allow NULL? 
54LC_DAYS_PLUSValidity of Available Resource Capacity (In the Future)nvarchar40NUMC(N'0000')YesCRES_GEN_LC_FORWARD Allow NULL? 
55STORAGE_CAPABLEResource has Storage Characteristicschar10CHAR(N' ')YesCRES_STORAGE_CAPABLE Allow NULL? 
56MIN_STORAGEMinimum Production Quantitydecimal153QUAN((0))YesCRES_MIN_STORAGE
57MAX_STORAGEMaximum Stock Leveldecimal153QUAN((0))YesCRES_MAX_STORAGE
58STORAGE_UNITStock Unitnvarchar30UNIT(N' ')Yes*CRES_STORAGE_UNIT Allow NULL? 
59DIM_STORAGEDimension of Storage Characteristic of a Resourcenvarchar60CHAR(N' ')YesT006DCRES_DIMENSION_STORAGE Allow NULL? 
60STORAGE_TO_ZEROHandling of Remaining Fill Levelchar10CHAR(N' ')YesCRES_STORAGE_TO_ZERO Allow NULL? 
61SNPLCResource is not Relevant to SNPchar10CHAR(N' ')YesCRES_SNPLC Allow NULL? 
62UTIL_BUCKETUtilization Rate for Bucket-Oriented Capacity [%]decimal63DEC((0))YesCRES_UTIL_BUCKET
63CAMPAIGN_PPDSResource is Campaign-Relevantchar10CHAR(N' ')YesCRES_CAMPAIGN_PPDS Allow NULL? 
64CAMPAIGN_SNPCross-Period Lot Sizeschar10CHAR(N' ')YesCRES_CAMPAIGN_SNP Allow NULL? 
65TSTREAM_EXTERNALCapacity Data for Time Stream Originates in External Systemchar10CHAR(N' ')YesCRES_TSTREAM_EXTERNAL Allow NULL? 
66FINITY_LEVELFiniteness Level of Resourcenvarchar40NUMC(N'0000')YesCRES_FINITY_LEVEL Allow NULL? 
67BR_QUANTNumber of Units of Measure for Base Ratedecimal133QUAN((0))YesCRES_BASE_RATE
68BR_QUNITUnit of Measure for Production Ratenvarchar30UNIT(N' ')Yes*CRES_RATE_QUNIT Allow NULL? 
69BR_TIMENumber of Time Units for Production Ratedecimal52QUAN((0))YesCRES_RATE_TIME
70BR_TUNITTime Unit of Production Ratenvarchar30UNIT(N' ')Yes*CRES_RATE_TUNIT Allow NULL? 
71RITT_FLG/SAPAPO/RITT_FLGchar10CHAR(N' ')YesCRES_RITT_FLG Allow NULL? 
72MDRMODELDefintion Name for the Product-Dependent Ratenvarchar400CHAR(N' ')YesCRES_MDR_NAME Allow NULL? 
73PP_DEF_BUCKETSDefinition of PP/DS Bucket Capacitychar10CHAR(N' ')YesCRES_PP_DEFINE_BUCKETS Allow NULL? 
74PP_BUCKET_SCHEMAPP/DS Bucket Schemanvarchar20NUMC(N'00')YesCRES_PP_BUCKET_SCHEMA Allow NULL? 
75PP_BUCKET_FACTFactor: Relation. of Avl. Bucket Cap. to Avl. Time-Cont Cap.nvarchar30NUMC(N'000')YesCRES_PP_BUCKET_FACTOR Allow NULL? 
76MIX_PLAN_TYPEFinite Capacity of a Mixed Resourcechar10NUMC(N'0')YesCRES_MIX_PLAN_TYPE Allow NULL? 
NamePrimaryUniqueTypeColumns
KAKO~0YesYesCLUSTEREDKAPID, MANDT
KAKO~ANoNoNONCLUSTEREDKAPAR, NAME, WERKS, MANDT
KAKO~BNoNoNONCLUSTEREDKAPAR, MANDT
KAKO~CNoNoNONCLUSTEREDKAPIE, MANDT
KAKO~PNoNoNONCLUSTEREDPLANR, 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