SAP SNC - List of useful tables

[shekhar_gupta3]

List of Tables in SAP SNC

Master Data                                     

/SAPAPO/MATLOCPR	Partner-Dependent Location Product Attributes . Location Prdouct Settings
/SAPAPO/SCNCTRL	Customer Scenario Control Values
/SAPAPO/SCNCTRLT	Customer Scenario Control Values Text
/SAPAPO/CATPRT	Partner Product Category
/SAPAPO/CATPRTXT	Partner Product Category Description
/SAPAPO/CDS_PCAT	Customizing:Partner Category Change Do
/SAPAPO/CDS_PPRD	Customizing: Partner Product Change Doc
/SAPAPO/MATPRMRM	Alternative units of measure for partner
/SAPAPO/MATPRT	Partner Product Master Data
/SAPAPO/MATPRTXT	Partner product description

Purchase Order                          

/SCA/APPRPRF	Assignment of Approval Profiles
/SCA/APPRRULE	Approval Profiles
/SCA/ORST	Change Profiles for Purchase Order Items
/SCA/ORSTPRF	Assignment of Change Profiles for Purchase Items

Advanced Shipping Notification                                                                                                

/SCA/DLVDOCCAT	ICH ASN: Document Categories
/SCA/DLVDOCCATT	ICH ASN: Document Categories
/SCA/DLVDOCMAP	Mapping table for Document Category

ASN Packing

/SCA/LABELASSN	Label-Partner Assignment
/SCA/PACKASSN	Pack Specification assignment table

Kanban

/SCA/DM_CCIDT	Text table for Contro Cycle ID
/SCA/DM_KANBAN	ICH Kanban Master Data
/SCA/DM_SUPAREAT	Text Table for Supply Area Description

Supplier Confirmations

/SCA/DM_SACSEND	Supplier Confirmations: Consecutive Number for CMDS Int
/SCA/DM_SCONREQU	Settings for Request Generation

Alert Monitor

/SCA/ALACTSCERN	Alert Actions That Cause a SCERN to Be Sent
/SCA/ALBPTYPSET	Alert Type Settings Dependent on Business Partner
/SCA/ALINFCNTXT	Alert Information Context
/SCA/ALINFCNTXTT	Alert Information Context Text Table
/SCA/ALNAVCLASS	Navigation Classes
/SCA/ALRTSTATUS	Alert Status
/SCA/ALRTSTATUST	Alert Status Texxt Table
/SCA/ALSTATSTEPS	Status Change Options
/SCA/SPPALCONST	SPP Alert Monitor Constants
/SCA/SPPALTYPES	Alert Types Metadata of SPP Alert Monitor

SMI Algorithm               

/SCA/DUELISTA	Assignment for Due List Strategy
/SCA/PRJSTKPRFL	Projected stock profile definition
/SCA/PRJSTKPRFLA	Projected Stock Profile Assignment
/SCA/TLDEFPRFL	Time line definition profile
/SCA/TLDEFPRFLA	Time line definition assignment
/SCA/TOLASSIGN	Tolerance Profile Assignment
/SCA/TOLPROFILE	Release Tolerance Profile
/SCA/TOLPROFILET	Release Tolerance Profile Description

Collaboration Book

/SCA/CBELEMENT	Collaboration Book elements
/SCA/CBFUNCTIONS	functions of collaboration books
/SCA/CBGRDIM	Collaboration Book dimensions
/SCA/CBGRDIMVAL	Collaboration Book dimensions content
/SCA/CBGRTYPES	Collaboration Book grid types
/SCA/CBVIEW	Collaboration Book Views
/SCA/CBVIEWT	Collaboration Book views texts
/SCA/CBVWELEMREF	Collaboration Book elements references
/SCA/CBVWELUSOBJ	Collaboration Book view element user objects
/SCA/CBVWELUSOBV	Collaboration Book view element user object val
/SCA/CBVWELUSSEL	Collaboration Book view  element user selection
/SCA/CBVWLAYOUT	Collaboration Book view layout
/SCA/COLLBOOK	Collaboration Book
/SCA/COLLBOOKT	Collaboration Books Texts

Collaboration Engine          

/SCA/CLB	Collaboration processes
/SCA/CLBCONDT	Collaboration state condition
/SCA/CLBDAREA	Collaboration data area
/SCA/CLBDATPBOOK	Collaboration data type - Collaboration b
/SCA/CLBDATPDEF	Collaboration data type definition
/SCA/CLBDATPPRF	Collaboration data type profile
/SCA/CLBFUNC	Collaboration function
/SCA/CLBFUNCDEF	Collaboration function definition
/SCA/CLBFUNCOBJ	Collaboration function objects
/SCA/CLBFUNCPDEF	Collaboration function profile definition
/SCA/CLBFUNCPRF	Collaboration function profile
/SCA/CLBFUNCSTAT	Collaboration function status change
/SCA/CLBFUNCT	Collaboration function text
/SCA/CLBNOTE	Collaboration notes
/SCA/CLBNOTEPRF	Collaboration note type profile
/SCA/CLBNOTEPRFT	Collaboration note type profile text
/SCA/CLBPARTACC	Collaboration partner access
/SCA/CLBPARTPRF	Collaboration partner profile
/SCA/CLBPARTROLE	Collaboration partner role
/SCA/CLBPARTROLT	Collaboration partner role text
/SCA/CLBPRF	Collaboration profile
/SCA/CLBREF	Collaboration references
/SCA/CLBROLEPRF	Collaboration role profile
/SCA/CLBSTATE	Collaboration states

SMI data management                            

/SCA/AMACTION	Alert Type and Alert Action leads to sending a Message?
/SCA/AMAPPL	Map Application  to XML Process Code (Outbound)
/SCA/BIFALP_DEF	BIF Valuation Property to Alert Parameter Mapping
/SCA/BIFALP_MAP	BIF Valuation Property to Alert Parameter Mapping
/SCA/CONFCONTROL	Confirmation Control
/SCA/DLVASSDP	Assign Display Profile for ASNs
/SCA/DLVDISPRF	Diplay Profile for ASNs
/SCA/DLVHD_EXT	Delivery header data (extension)
/SCA/DLVVAL	Validation Scenario for ASNs
/SCA/RELCRQ_CU	Settings for Release Processing
/SCA/SCERN	Send SCERN Message
/SCA/SCERNALAPID	Determine Alert Engine Application ID for Inbound SCERN
/SCA/STOCK_II06	LIME - Stock Key Product GUID, Version (ICH)
/SCA/STOCK_SI06	LIME - Stock Key Product GUID, Version (ICH)
/SCA/USRSEL	User Assignment

SCC Macro Engine

/SCA/MCCOB	Collaboration planning objects in macros
/SCA/MCHEADER	Header table of macros
/SCA/MCKEYFS	Key figures of node in macro steps
/SCA/MCNODE	Macro nodes
/SCA/MCPROGRAM	Generated program of macro
/SCA/MCSELECTION	Selection for macro steps
/SCA/MCSTEP	Steps of macro
/SCA/MCTEXT	Language dependent description of macros

Order data management

/SCA/FREITMEXT	F&R Engine Order Item Extensional Data
/SCA/ORDAREA	Order data area
/SCA/ORDAREASC	Order data area source
/SCA/ORDAREATABS	Order data area tables
/SCA/ORDER	Order
/SCA/ORITEM	Order item
/SCA/ORMAP	Order mapping
/SCA/ORNOTE	Order note
/SCA/ORREF	Order reference
/SCA/ORSTRDEF	Order data structure definition
/SCA/ORSTRUCTURE	Order data structure
/SCA/ORTYPE	Order type structures
/SCA/ORTYPESTR	Order type - Order structure

Order Data Management

/SCA/ORADM	Order administration
/SCA/ORDARDEF	Order data area
/SCA/ORDERDAR	Order data area
/SCA/ORDERDSTR	Order data structure
/SCA/ORDERDSTRT	Order data structure text table
/SCA/ORDERDTP	Order data type
/SCA/ORDERDTPT	Order type text table
/SCA/ORDERTP	Order type
/SCA/ORDERTPT	Order type text table
/SCA/ORDSDEF	Order data structure definition
/SCA/ORSALL	Order value selections
/SCA/ORTPVER	Order data area validity
/SCA/ORVALL	Order all values (test only)

Supplier Delivery Performance Evaluation

/SCA/SDPROBJECTS	Mapping of SDPR relevant source documents to SDPR classes
/SCA/SDPROBJECTT	Mapping of SDPR relevant source documents to SDPR classes

Selection management model                       

/SCF/SELMODE	Assignment of Selection Mode to Application Data ID
/SCF/SELMODE_DEF	Assignment of Default Selection Mode to Application Data ID
/SCF/SELOBJ	Selection Mode
/SCF/SELOBJ_TXT	Selection Mode Description

UI Application

/SCF/CBAGGCPRM	ICH data matrix aggregate level description
/SCF/CBAGGKPRM	ICH data matrix aggregate level description
/SCF/CBAGGLEV	ICH data matrix aggregate levels definition
/SCF/CBAGGLEVDEF	ICH data matrix aggregate levels definition
/SCF/CBBASSERV	ICHDM basic services
/SCF/CBKPRMSERV	ICH data matrix key figures services
/SCF/CBSELSTATUS	ICHDM selector
/SCF/CBSERVICES	ICH data matrix services
/SCF/CBVCMPLX	ICHDM complex view definition
/SCF/CBVCPROP	ICH data matrix view cell properties
/SCF/CBVH	ICH data matrix view column definition
/SCF/CBVHT	ICH data matrix view column definition
/SCF/CBVLYT	ICH dta matrix view layout
/SCF/CBVRPROP	ICH data matrix view row properties
/SCF/CBVSTATES	ICH data matrix view status key figures
/SCF/CBVV	ICH data matrix view row definition
/SCF/CBVVT	ICH data matrix view row definition
/SCF/CBV_COMP	ICH data matrix view compatibility (assignment)
/SCF/CBV_DEF	ICH data matrix view definition
/SCF/CBV_DEFT	ICH data matrix view definition
/SCF/CB_ACTINPT	ICH data matrix input for actions
/SCF/CB_ACTIONS	ICH data matrix action definition
/SCF/CB_DEF	ICH data matrix definition
/SCF/CB_DEFT	ICH data matrix definition language dependent description
/SCF/CB_DEP	ICH data matrix dependencies
/SCF/CB_SELECTOR	ICHDM selector
/SCF/CB_TSDMTP	ICH data matrix time series type config for data access
/SCF/CCBAGGKPRM	ICH data matrix key figure definition
/SCF/CCBAGGLEV	ICH data matrix aggregate levels definition
/SCF/CCBBASSERV	ICHDM basic services - customer extension
/SCF/CCBKPRMSERV	ICH data matrix key figures services
/SCF/CCBVH	ICH data matrix view column definition
/SCF/CCBVHT	ICH data matrix view column definition
/SCF/CCBVSTATES	ICH data matrix view status key figures
/SCF/CCBVV	ICH data matrix view row definition
/SCF/CCBVVT	ICH data matrix view row definition
/SCF/CCBV_COMP	ICH data matrix view compatibility (assignment)
/SCF/CCB_ACTINPT	ICH data matrix input for actions
/SCF/CCB_ACTIONS	ICH data matrix action definition - Customer extension
/SCF/CCB_DEP	ICH data matrix dependencies
/SCF/CHARTPROP	SMI chart propertires
/SCF/COLORS	Colors definition
/SCF/QPEXAMPLE	QP example
/SCF/SMIMON_RFC	RFC destinations for SMIMON application class
/SCF/STATES_DEF	States definition
/SCF/STATES_DEFT	States definition translation
/SCF/STATES_PERS	States values - personal settings