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

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

548 columns | Print definition?ERP 6.0  | VALID_TO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_INFDET_VLValues for Interface Determination19VALID_TODate Tonvarchar80
2/AIF/T_MVMAPVALValue mapping for master data (no transport)12VALID_TODate Tonvarchar80
3/AIF/T_MVMAPVAL5Value mapping for master data (no transport)15VALID_TODate Tonvarchar80
4/AIF/T_VMAPVALValue mapping for master data (customizing)12VALID_TODate Tonvarchar80
5/AIF/T_VMAPVAL5Value mapping for master data (customizing)15VALID_TODate Tonvarchar80
6/AIF/VALID_PERIOAIF Validity Period4VALID_TODate Tonvarchar80
7/CFMFND/TDAOFZeitabhängige AO-Funktionen5VALID_TOZeitabh. AO-Funktion: Gültig bisnvarchar80
8/CIDEON/DMS_VALIValidity of document's version7VALID_TOValid to datenvarchar80
9/GRCPI/GRIAFFUSRMaintain SPM Firefighter Assignment to FF ID/Roles10VALID_TOValidity End Datenvarchar80
10/GSINS/NLG_CTR_CGBA Interface: Countries codes4VALID_TOValid To Datenvarchar80
11/GSINS/NLG_NAT_CGBA Interface: Nationalities Codes4VALID_TOValid To Datenvarchar80
12/MRSS/D_TIMERULEMRS Time Rules5VALID_TOTime Stamp (Date and Time)decimal150
13/MRSS/D_WRK_RSVDemand Reserve Details5VALID_TOEnd Date of Calendar Week for Demand Reservenvarchar80
14/OEE/MMC_AEQUIMachine Equipment Assignment6VALID_TOValid Tonvarchar80
15/OEE/MMC_AFLOCMachine Function Location Assignment6VALID_TOValid Tonvarchar80
16/OEE/MPH_KPITARGPlant Hierarchy KPI Target Details7VALID_TOValid Tonvarchar80
17/OEE/MPH_MRKDWNPlant Hierarchy Node Mark Parent Down6VALID_TOValid Tonvarchar80
18/OEE/MPH_NODEPlant Hierarchy Nodes8VALID_TOValid Tonvarchar80
19/OEE/MPH_NODEATOPlant Hierarchy Node Assigned Technical Objects6VALID_TOValid Tonvarchar80
20/OEE/MPH_NODESTRPlant Hierarchy Node Standard Rate6VALID_TOValid Tonvarchar80
21/SAPPSSRM/C_PGSBasis Table of the Partner Grouping Schema4VALID_TOUTC timestamp in short form (YYYYMMDDhhmmss)decimal150
22/SLOAP/PRICING_1Conditions (1-Dimensional Quantity Scale)9VALID_TOValidity end date of the condition recordnvarchar80
23/XFT/CAC_TB01Header data for CAC organizer7VALID_TOValid tonvarchar80
24/XLSO/ACCESS_CODAccess Code Details Assigned to a Bulk Sales Order9VALID_TOValid Tonvarchar80
25/XLSO/CODE_USRAccess Code User Info with Sub Access Code7VALID_TOValid Tonvarchar80
26/XLSO/EVOUCHERE-Voucher Details9VALID_TOValid Tonvarchar80
27BBPM_BUT_FRG0011Business Partner: General BBP Data5VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
28BBPM_BUT_FRG0021Business Partner: Bidder Characterisitc6VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
29BBPM_BUT_FRG0031Business Partner: Quality Standards6VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
30BBPM_BUT_FRG0041Business Partner: Accepted Payment Card Types6VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
31BBPM_BUT_FRG0061Business Partner: Purchasing Data6VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
32BBPM_PRGENERALProduct - Purchasing Set8VALID_TOValid To (Time Stamp)decimal150
33BBPM_PRGENERALHGeneral Purchasing Data on Product (History)3VALID_TOValid To (Time Stamp)decimal150
34BBP_PDBGPPartner Extension Gen. Purchasing Data5VALID_TOTime Dependency: Validity End Datedecimal150
35BBP_STD_ACCLocal Accounting Data6VALID_TODate To Which The Generic Account Is Validnvarchar80
36BBP_SUS_NEWSSRM-SUS: News Management by Purchaser8VALID_TODate for Newsnvarchar80
37BBP_SUS_STG_FAXStaging address table18VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
38BBP_SUS_STG_MAILstaging mail table15VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
39BBP_SUS_STG_TELStaging table for telephone17VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
40BPTAXCBusiness Partner Tax Compliance10VALID_TOTax Compliance: End Datenvarchar80
41CLB2D_SESSIONPlatform Session Mapping8VALID_TOCollaboration: Valid Todecimal150
42CLB2D_TOKENOAuth Access Data for User8VALID_TOCollaboration: Valid Todecimal150
43CLB2D_USER_TOKENOAuth Access Data for User5VALID_TOCollaboration: Valid Todecimal150
44CLBD_USER_TOKENOAuth Access Data for User5VALID_TOCollaboration: Valid Todecimal150
45CNVMBTKEYSPartner keys6VALID_TOValid-to date in current Release only 99991231 possiblenvarchar80
46COMM_PR_TTCODESet type for tax details in service4VALID_TOValid To (Time Stamp)decimal150
47COMM_PR_TTCODEHSet type for tax details in service3VALID_TOValid To (Time Stamp)decimal150
48DECREE_NUM_IDIndonesia Minister's decree number4VALID_TOValidity end date of the condition recordnvarchar80
49DFKKPTSAFTBPEXTDPortugal: SAF-T BP Requesting Receipts Extension5VALID_TODatenvarchar80
50DFKKPTSAFTBPRCTPortugal: SAF-T Business Partners Requesting Receipts5VALID_TODate validity endsnvarchar80
51DOTM_SYSDBOSC-TM: System2VALID_TODBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
52DOTM_SYS_ASSOCDBOSC-TM: System Associations2VALID_TODBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
53ECOMP_REL_BRBrazil: Define Energy Compensation Relationships6VALID_TODate at Which a Time Slice Expiresnvarchar80
54EHFNDD_REGL_EXEMExemption List10VALID_TOValid-To Date for Exemptionnvarchar80
55EHFNDD_RL_C_EXResult of compared exemptions11VALID_TOValid-To Date for Exemptionnvarchar80
56EINV_BSIC_COM_TRTurkey e-Invoice- Customers data Basic/Commercial Scenario5VALID_TOTurkey e-Invoice Valid-To Datenvarchar80
57EINV_BS_CM_MM_TRTurkey e-Invoice- Vendor data Basic/Commercial Scenario5VALID_TOTurkey e-Invoice Valid-To Datenvarchar80
58FDT_BRS_CC_0000BRS Managed System: Meta data of generate code4VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
59FIAPXXD_LFA1Tax Details4VALID_TOValid To Datenvarchar80
60FIA_VOC_IDFIdentifying VAT on Cash information for Business Partner6VALID_TODate validity endsnvarchar80
61FIEUA_VOC_IDFIdentifying VAT on Cash Information for Business Partner6VALID_TODate validity endsnvarchar80
62FIWTQAD_TAXQatar Tax Details6VALID_TOValid To Datenvarchar80
63GHO_ALC_SRC_FORMFormula Source data for Allocation results invalidation9VALID_TOValid From Timestampdecimal150
64GHO_FORM_MEAS_HAllocation Formula Measurements Header10VALID_TOValid To Timestampdecimal150
65GHO_MEAS_PRIO_HAllocation Rules Measurement Priority Header9VALID_TOValid To Timestampdecimal150
66GHO_OBJ_FACTOR_HNetwork Object Factors Header6VALID_TOValid To Timestampdecimal150
67GHO_RULE_DATESValidity Dates for Rule7VALID_TODatenvarchar80
68GHO_RULE_DETAILGeneric Rule13VALID_TODatenvarchar80
69GRACBUSROLEUSERSBusiness Role User Reassignment8VALID_TOValidity End Datenvarchar80
70GRACFFUSERMaintain SPM Firefighter Assignment to FF ID/Roles10VALID_TOValidity End Datenvarchar80
71GRACHRSYSCUP HR System5VALID_TOValidity End Datenvarchar80
72GRACREQOMOBJITEMHR OM Object assigned to request12VALID_TOValidity End Datenvarchar80
73GRACREQPROVITEMLine Items Associated with Request12VALID_TOValidity End Datenvarchar80
74GRACROLEAPPRVRRole Approver9VALID_TOValidity End Datenvarchar80
75GRACUSERASSIGNMEObselete - User Assignment Table -( To be deleted )8VALID_TOTime Stampdecimal150
76GRACUSERCONNTable to store connector specific user9VALID_TOValidity End Datenvarchar80
77GRACUSERROLEUser Role Assignment Table8VALID_TOTime Stampdecimal150
78GRFNAE_BKAudit Entity History5VALID_TOEnd Datenvarchar80
79GRFNBRABusiness Rule Assignment - Data common7VALID_TOEnd Datenvarchar80
80GRFNLOCKOBJECTLocks for API objects3VALID_TOEnd Datenvarchar80
81GRFNPOLICYGRPDB table for Policy group in policy management4VALID_TOEnd Datenvarchar80
82GRFNPOLICYLOCALDB table for localized information in policy management6VALID_TOEnd Datenvarchar80
83GRFNPOLICYSCOPEDB table for policy scope information in policy management5VALID_TOEnd Datenvarchar80
84GRFNPOLICYVERDB table for policy version information in policy management5VALID_TOEnd Datenvarchar80
85GRRMOBLEASGNVALLoss Event Assignment to HR Objects - Validity6VALID_TOValid Tonvarchar80
86GRRMOBSDMStatic Data Mgt. - Mapping5VALID_TOTime Stamp (Date and Time)nvarchar140
87IDSAU_CR_DATAVendor Certificates7VALID_TOCertification Valid to Datenvarchar80
88ISPS_MARAProduct Master MARA4VALID_TOValid To (Time Stamp)decimal150
89ISPS_MARAHProduct Master MARA3VALID_TOValid To (Time Stamp)decimal150
90J_1BTFISC_IDTax Incentive ID (Incentive ID) table8VALID_TOEnd Datenvarchar80
91J_1BTFISC_ID_SDTax Incentive ID (Incentive ID) for SD table8VALID_TOEnd Datenvarchar80
92J_1I_SCHM_CNTRYEXIM : Scheme Market Focusing6VALID_TOValid Tonvarchar80
93J_1I_SCHM_MASTEREXIM : Scheme Master5VALID_TOScheme Valid Tonvarchar80
94J_1I_SCHM_PRDCTEXIM : Product based Scheme11VALID_TOValid Tonvarchar80
95MENA_CR_DATAMENA Certificates6VALID_TOCertificate Valid to Datenvarchar80
96MENA_CR_DATA_TText table for MENA Certificates6VALID_TOCertificate Valid to Datenvarchar80
97NWS_EXT_ADFA2Transfer structure for fax numbers (central address admin.)16VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
98NWS_EXT_ADFAXTransfer structure for fax numbers (central address admin.)16VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
99NWS_EXT_ADPA2Transfer Structure for Page Numbers (Centr. Addr. Mgmnt)15VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
100NWS_EXT_ADPAGTransfer Structure for Page Numbers (Centr. Addr. Mgmnt)15VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
101NWS_EXT_ADPR2Transfer Structure for PRT Addresses (Centr. Address Mgmnt)10VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
102NWS_EXT_ADPRTTransfer Structure for PRT Addresses (Centr. Address Mgmnt)10VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
103NWS_EXT_ADRF2Transfer Structure for RFC Addresses (Centr. Addr. Mgmnt)11VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
104NWS_EXT_ADRFCTransfer Structure for RFC Addresses (Centr. Addr. Mgmnt)11VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
105NWS_EXT_ADRM2Transfer Structure for RML Addresses (Centr. Addr. Mgmnt)14VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
106NWS_EXT_ADRMLTransfer Structure for RML Addresses (Centr. Addr. Mgmnt)14VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
107NWS_EXT_ADSM2Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)14VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
108NWS_EXT_ADSMTTransfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)14VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
109NWS_EXT_ADTE2Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt)15VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
110NWS_EXT_ADTELTransfer Structure for Telephone Nos (Centr. Addr. Mgmnt)15VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
111NWS_EXT_ADTL2Transfer Structure for Telex Nos (Centr. Addr. Mgmnt)12VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
112NWS_EXT_ADTLXTransfer Structure for Telex Nos (Centr. Addr. Mgmnt)12VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
113NWS_EXT_ADTT2Transfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)12VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
114NWS_EXT_ADTTXTransfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)12VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
115NWS_EXT_ADX40Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)36VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
116NWS_EXT_ADX42Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)36VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
117REFXCN_DIVIDERule of Sharing Expenses6VALID_TOVaild Tonvarchar80
118SAML2_USED_ASSRTStorage Table for SAML2 Assertions5VALID_TOValidity of an SAML2 Assertiondecimal150
119SRAL_TRACE_CFGSRAL Trace Configuration5VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
120SRT_IBCSRT: Identifiable Business Context6VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
121SRT_IBCRSRT: Identifiable Business Context Reference8VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
122SRT_SR_NTF_HServices Registry: Notification header10VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
123SRT_SR_PUB_HServices Registry: Publication header13VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
124SRT_SR_SUB_HServices Registry: Subscription header13VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
125T5UEFFR_BUND_RECTemporary storage of Bundled records in Effort Certification9VALID_TOEnd Datenvarchar80
126TFK8117BASEDiscounts/Charges on Billed Items: Basis Determination3VALID_TOEnd of Validity of a Discount/Charge Versionnvarchar80
127TFK8117BASETDiscounts/Charges on Billed Items: Basis Determin. (Texts)4VALID_TOEnd of Validity of a Discount/Charge Versionnvarchar80
128TFK8117CARDiscounts/Charges on Billed Items: Calculation Rule3VALID_TOEnd of Validity of a Discount/Charge Versionnvarchar80
129TFK8117CARADiscounts/Charges on Billed Items: Calculation Rule Attrib.3VALID_TOEnd of Validity of a Discount/Charge Versionnvarchar80
130TFK8117CARTDiscounts/Charges on Billed Items: Calculation Rule (Texts)4VALID_TOEnd of Validity of a Discount/Charge Versionnvarchar80
131TFK8117CORDiscounts/Charges on Billed Items: Condition Rule3VALID_TOEnd of Validity of a Discount/Charge Versionnvarchar80
132TFK8117CORADiscounts/Charges on Billed Items: Condition Rule Attributes3VALID_TOEnd of Validity of a Discount/Charge Versionnvarchar80
133TFK8117CORTDiscounts/Charges on Billed Items: Condition Rules (Texts)4VALID_TOEnd of Validity of a Discount/Charge Versionnvarchar80
134TFK_ODN_CONFEXTODN: Customer Specific Main Processing Configuration5VALID_TOValid-To Date of Classnvarchar80
135TFMCA_RM_RCATRisk Category in Risk Profile6VALID_TORisk Profile is Valid Tonvarchar80
136TFMCA_RM_RCPEWeighting Percentage Settings for Risk Category5VALID_TOValid to for Risk Category Weighting Percentagenvarchar80
137TFMCA_RM_RPBPRBusiness Parnter Role Assignment to Risk Profile5VALID_TORisk Profile is Valid Tonvarchar80
138TFMCA_RM_RPFBTRisk Profile Assignment to Form Bundle Types5VALID_TORisk Profile is Valid Tonvarchar80
139TFMCA_RM_WPERValidity Periods for Weighting Percentage for Risk Profile4VALID_TOValid to for Risk Category Weighting Percentagenvarchar80
140TISSR_RATING_HBHistorie des Wertpapier-Ratings8VALID_TODatum bis Feld vom Typ DATSnvarchar80
141TLRC_FICLASSFinancial Instrument Classification used in Report Type5VALID_TOEnd Datenvarchar80
142TLRC_TARO_ALLIDTrade Repository: Allowed ID Categories5VALID_TOEnd Datenvarchar80
143TLRC_TARO_FICLASTrade Repository: Allowed Product Classification5VALID_TOEnd Datenvarchar80
144TLRT_TRADE_IDTrade Identifier for Financial Transactions8VALID_TOValid To Date of External Trade IDnvarchar80
145VCH_COMPIL_HEADVCH compilation header5VALID_TOValid-to datenvarchar80
146VCH_COMPIL_ITEMSVCH compilation items8VALID_TOValid-to datenvarchar80
147ZPPMC_CPL_C_RESPPrice table for CO resources4VALID_TOResource price valid tonvarchar80
148ZQUOTAB1Quotation details6VALID_TOField of type DATSnvarchar80
149T7PIQAGR_BLGRD_RBlind Grade Number Range Validity3VALID_TOValidity of the Blind Grade Number Rangenvarchar80
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
150CRMCHKMSG_LOCALCustomizing: System local priorities6VALID_TOValid to datenvarchar80
151CRMCHKMSG_REMOTEOUTDATED - TO BE DELETED - ACCESS STRONGLY DISCOURAGED3VALID_TOnvarchar80
152SATC_AC_RESULTHTransaction data: 'Display Load' header16VALID_TOExpires on .. timestampdecimal150
153SATC_AC_USERCustomizing: Personalization of online check5VALID_TOValid To Datenvarchar80
154SATC_SAP_MAPPINGMovement data: ATC IDs <> legacy format ID (reporting)4VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPAddress ManagementBusiness Address
155ADR10Printer (Business Address Services)12VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
156ADR10SShadow Table: Printer (Business Address Services)13VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
157ADR10S2Shadow Table 2: Printer (Business Address Services)13VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
158ADR13Pager (Business Address Services)17VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
159ADR13SShadow Table: Pager (Business Address Services)18VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
160ADR13S2Shadow Table 2: Pager (Business Address Services)18VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
161ADR2Telephone Numbers (Business Address Services)17VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
162ADR2SShadow Table: Telephone Numbers (Business Address Services)18VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
163ADR2S2Shadow Table 2: Telephone Nos (Business Address Services)18VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
164ADR3Fax Numbers (Business Address Services)18VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
165ADR3SShadow table: Fax numbers (Business Address Services)19VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
166ADR3S2Shadow Table 2: Fax Numbers (Business Address Services)19VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
167ADR4Teletex Numbers (Business Address Services)13VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
168ADR4SShadow Table: Teletex Numbers (Business Address Services)14VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
169ADR4S2Shadow Table 2: Teletex Numbers (Business Address Services)14VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
170ADR5Telex Numbers (Business Address Services)13VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
171ADR5SShadow Table: Fax Numbers (Business Address Services)14VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
172ADR5S2Shadow Table 2: Telex Numbers (Business Address Services)14VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
173ADR6E-Mail Addresses (Business Address Services)16VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
174ADR6SShadow Table: SMTP Numbers (Business Address Services)17VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
175ADR6S2Shadow Table 2: SMTP Numbers (Business Address Services)17VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
176ADR7Remote Mail Addresses (SAP - SAP - Communication; BAS)16VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
177ADR7SShadow Table: RML Addresses (Business Address Services)17VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
178ADR7S2Shadow Table 2: RML Addresses (Business Address Services)17VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
179ADR8X.400 Numbers (Business Address Services)38VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
180ADR8SShadow Table: X.400 Numbers (Business Address Services)39VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
181ADR8S2Shadow Table 2: X.400 Numbers (Business Address Services)39VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
182ADR9RFC Destinations (Business Address Services)13VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
183ADR9SShadow Table: RFC Destinations (Business Address Services)14VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
184ADR9S2Shadow Table 2: RFC Destination (Business Address Services)14VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
185ADRUTable for Communication Usages7VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
186ADRUSShadow Table: Communication Usages (BAS)8VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
187ADRUS2Shadow Table_2: Communication Usages (BAS)8VALID_TOCommunication Data: Valid To (YYYYMMDDHHMMSS)nvarchar140
TOPAdvertising Management
188JJTPCBundle8VALID_TOSales Release (To)nvarchar80
189JJTUPSELL_BEIS-M/AM: Upselling Proposals Booking Unit Assignment6VALID_TOIS-M: Validity End for Upselling Proposalnvarchar80
TOPAuthentication and SSO
190SAML2_ARTIFACTStorage Table for SMAL2 Artifacts7VALID_TOValidity of an SAML2 Assertiondecimal150
191SAML2_ASSERTStorage Table for SAML2 Assertions4VALID_TOValidity of an SAML2 Assertiondecimal150
192SAML2_ENTITYSAML2 Entity Table12VALID_TOEntity Valid Todecimal150
193SAML2_REQUESTStorage Table for SAML2 Requests and RelayState5VALID_TOValidity of an SAML2 Requestdecimal150
TOPAuto-ID Infrastructure
194AIN_PROD_TGRAIGRAI-Global Returnable Asset Identifier4VALID_TOValid To (Time Stamp)decimal150
195AIN_PROD_TGRAIHGRAI-Global Returnable Asset Identifier3VALID_TOValid To (Time Stamp)decimal150
TOPBalanced Scorecard
196UMB_CO102General Objectives: Measure Label5VALID_TOEnd of Validity Periodnvarchar70
197UMB_HI110Scorecard Aggregation Hierarchy5VALID_TOEnd of Validity Periodnvarchar70
198UMB_SC113Scorecard: Perspective Assignment (Time-Dependent)5VALID_TOEnd of Validity Periodnvarchar70
199UMB_SC120Scorecard: Strategy Assignment (Time-Dependent)5VALID_TOEnd of Validity Periodnvarchar70
200UMB_SC140Scorecard: Objective Assignment (Time-Dependent)6VALID_TOEnd of Validity Periodnvarchar70
201UMB_SC142Scorecard: Cause-Effect Chain9VALID_TOEnd of Validity Periodnvarchar70
202UMB_SC150Scorecard: Objective Assignment (Time-Dependent)5VALID_TOEnd of Validity Periodnvarchar70
203UMB_SC160Scorecard: Measure Assignment (Time-Dependent)5VALID_TOEnd of Validity Periodnvarchar70
204UMB_SC162Objective: Measure Assignment (Time-Dependent)6VALID_TOEnd of Validity Periodnvarchar70
205UMB_SC170Scorecard: Weights for Status Calculation8VALID_TOEnd of Validity Periodnvarchar70
206UMB_SC182Objectives: Initiative Assignment (Time-Dependent)6VALID_TOEnd of Validity Periodnvarchar70
207UMB_SC183Scorecard: Assignment of General Initiatives to Objectives6VALID_TOEnd of Validity Periodnvarchar70
208UMB_SC300Owner Variable5VALID_TOEnd of Validity Periodnvarchar70
209UMB_SC301Selection of Scorecard Elements6VALID_TOEnd of Validity Periodnvarchar70
210UMB_WIZARD102Default Settings for Each User. Used by BSC Wizard4VALID_TOEnd of Validity Periodnvarchar70
TOPBank
211SEPA_MANDATE_LCHSEPA Administration: Global Locks (History)6VALID_TOMandate Management: Lock Valid To Datenvarchar80
212SEPA_MANDATE_LCKSEPA Mandate Management: Global Locks5VALID_TOMandate Management: Lock Valid To Datenvarchar80
TOPBank Customer Accounts
213BCA_US_BKK44ACurrent account master data: Amount-dependent blocks9VALID_TOValid to (for amount-dependent blocks)nvarchar80
214BKK_PRENOTEPrenotes9VALID_TOValid Tonvarchar80
TOPBasic functions
215COMM_IL_PRDBP_HHistorical Data for Relationship Type Partner3VALID_TOValid To (Time Stamp)decimal150
TOPBills of Material
216STKOBOM Header29VALID_TOValid-to datenvarchar80
217STPOBOM item123VALID_TOValid-to datenvarchar80
TOPBRFplus - ABAP-Based Business Rules
218FDT_CC_0000FDT: Generated programs for FDT customizing objects3VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
219FDT_CC_0000SFDT: Generated programs for FDT system objects2VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
220FDT_EXPR_2604FDT: Flow Rules9VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
221FDT_EXPR_2604AFDT: Flow Rules9VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
222FDT_EXPR_2604SFDT: Flow Rules8VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
223FDT_EXPR_2604TFDT: Flow Rules8VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
224FDT_RLST_1000FDT: RuleSet - Rules7VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
225FDT_RLST_1000AFDT: RuleSet - Rules7VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
226FDT_RLST_1000SFDT: RuleSet - Rules6VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
227FDT_RLST_1000TFDT: RuleSet - Rules6VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPBusiness Analytics
228UABSCEBATIMPTable to store SCE variants, PDCE, Ehp415VALID_TOValid tonvarchar80
TOPBusiness Application Support
229TCURUSuperuser for Expiring Currencies6VALID_TOTonvarchar80
TOPBusiness Package for Manager Self-Service FI
230FCOM_WHERE_USEDUsage of Master Data Objects11VALID_TOValid To Datenvarchar80
TOPBusiness Process Engine
231BRR_ACTIVEActivation Data for a Business Rule3VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
232BRR_ACTIVE_CActivation Data for a Client-Dependent Business Rule4VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPBusiness Rule Framework
233TBRF210BRF: Assignment of Event, Expression, Action28VALID_TOBRF Rule Valid Todecimal150
234TBRF211Obsolete - BRF: Assignment of Event, Expression, Action28VALID_TOBRF Rule Valid Todecimal150
235TBRF310BRF: Rule Set/Event/Expression/Action Assignment24VALID_TOBRF Rule Valid Todecimal150
TOPCentral Part of Product Master
236COMC_MINITP_RELMini-Template Grouping Without Differentiation Key (REL)5VALID_TOValidity End (UCT Time Stamp Short Form, YYYYMMDDhhmmss)decimal150
237COMC_MINITP_RELHHistory for Table COMC_MINITP_REL3VALID_TOValidity End (UCT Time Stamp Short Form, YYYYMMDDhhmmss)decimal150
238COMM_ATTR_ALIASAttribute Alias7VALID_TOValid To (Time Stamp)decimal150
239COMM_ATTR_ALIASHAttribute Alias5VALID_TOValid To (Time Stamp)decimal150
240COMM_CATEGORYCategory8VALID_TOValid To (Time Stamp)decimal150
241COMM_CATEGORYDELCategories To Be Deleted (Temporary) in Download8VALID_TOValid To (Time Stamp)decimal150
242COMM_CATEGORYHCategory: History3VALID_TOValid To (Time Stamp)decimal150
243COMM_CATEGORYTCategory Description7VALID_TOValid To (Time Stamp)decimal150
244COMM_CATEGORYTHCategory Description: History4VALID_TOValid To (Time Stamp)decimal150
245COMM_CATFRGRCategory Set-Type Assignment6VALID_TOValid To (Time Stamp)decimal150
246COMM_CATFRGRHAssignment Category - Set Type: History4VALID_TOValid To (Time Stamp)decimal150
247COMM_HIERARCHYHierarchy10VALID_TOValid To (Time Stamp)decimal150
248COMM_HIERARCHYHHierarchy: History3VALID_TOValid To (Time Stamp)decimal150
249COMM_HIERARCHYTHierarchy Description7VALID_TOValid To (Time Stamp)decimal150
250COMM_HIERARCHYTHHierarchy Description: History4VALID_TOValid To (Time Stamp)decimal150
251COMM_IL_ACCESS_HHistorical Data of Relationship Type Accessories3VALID_TOValid To (Time Stamp)decimal150
252COMM_IL_PRDCPN_HHistorical Data of Relationship Type Customers3VALID_TOValid To (Time Stamp)decimal150
253COMM_IL_PRDCTP_HHistorical Data of Relationship Type Content Provider3VALID_TOValid To (Time Stamp)decimal150
254COMM_IL_PRDMPN_HHistorical Data of Relationship Type Manufacturer3VALID_TOValid To (Time Stamp)decimal150
255COMM_IL_PRDMRK_HMarketing Material History3VALID_TOValid To (Time Stamp)decimal150
256COMM_IL_PRDVND_HHistorical Data of Relationship Type Vendors3VALID_TOValid To (Time Stamp)decimal150
257COMM_IL_PROREF_HHistorical Data of Relationship Type Reference Product3VALID_TOValid To (Time Stamp)decimal150
258COMM_IL_SERVI_HHistorical Data of Relationship Type Services3VALID_TOValid To (Time Stamp)decimal150
259COMM_IL_SPARE_HHistorical Data of Relationship Type Spare Parts3VALID_TOValid To (Time Stamp)decimal150
260COMM_IPRODUCTInactive Product11VALID_TOValid To (Time Stamp)decimal150
261COMM_PRCATProduct Category16VALID_TOValid To (Time Stamp)decimal150
262COMM_PRCATFRGRAssignment Product Category - Set Type9VALID_TOValid To (Time Stamp)decimal150
263COMM_PRCATFRGRHProduct Category - Set Type Assignment: History4VALID_TOValid To (Time Stamp)decimal150
264COMM_PRCATHProduct Category: History3VALID_TOValid To (Time Stamp)decimal150
265COMM_PRCAT_ILProduct Category - Relationship Type Assignment7VALID_TOValid To (Time Stamp)decimal150
266COMM_PRCAT_ILHProduct Category - Relationship Type Assignment: History5VALID_TOValid To (Time Stamp)decimal150
267COMM_PRFREEATTRFree Attributes for a Product5VALID_TOValid To (Time Stamp)decimal150
268COMM_PRFREEATTRHFree Attributes for a Product - History4VALID_TOValid To (Time Stamp)decimal150
269COMM_PRODUCTProduct11VALID_TOValid To (Time Stamp)decimal150
270COMM_PRODUCTHProduct History3VALID_TOValid To (Time Stamp)decimal150
271COMM_PROD_VARAssignment of Product Variants to Configurable Product7VALID_TOValid To (Time Stamp)decimal150
272COMM_PROD_VARHHistory: Assignment of Variants to Configurable Product3VALID_TOValid To (Time Stamp)decimal150
273COMM_PRPRDCATRProduct - Product Category Assignment7VALID_TOValid To (Time Stamp)decimal150
274COMM_PRPRDCATRHProduct - Product Category Assignment: History4VALID_TOValid To (Time Stamp)decimal150
275COMM_PRSHTEXTProduct Description7VALID_TOValid To (Time Stamp)decimal150
276COMM_PRSHTEXTHProduct Description (History)4VALID_TOValid To (Time Stamp)decimal150
277COMM_PRVIEWProduct View5VALID_TOValid To (Time Stamp)decimal150
278COMM_PRVIEWHProduct View - History3VALID_TOValid To (Time Stamp)decimal150
279COMM_PRVIEWTProduct View Description6VALID_TOValid To (Time Stamp)decimal150
280COMM_PRVIEWTHProduct View Description - History4VALID_TOValid To (Time Stamp)decimal150
281COMM_PR_FRG_REGProduct-Set Assignment (Gen. Link-Handler)10VALID_TOValid To (Time Stamp)decimal150
282COMM_PR_FRG_REGHProduct-Set Assignment History (Gen. Link-Handler)5VALID_TOValid To (Time Stamp)decimal150
283COMM_PR_FRG_RELProduct - Set - Assignment8VALID_TOValid To (Time Stamp)decimal150
284COMM_PR_FRG_RELHProduct - Set - Assignment History4VALID_TOValid To (Time Stamp)decimal150
285COMM_PR_GTINGTIN - Global Trade Item Number10VALID_TOValid To (Time Stamp)decimal150
286COMM_PR_GTINHGTIN - Global Trade Item Number History4VALID_TOValid To (Time Stamp)decimal150
287COMM_PR_PUR_1Purchasing4VALID_TOValid To (Time Stamp)decimal150
288COMM_PR_PUR_1HPurchasing3VALID_TOValid To (Time Stamp)decimal150
289COMM_PR_UNITProduct Unit of Measurement19VALID_TOValid To (Time Stamp)decimal150
290COMM_PR_UNITHProduct Unit of Measurement History4VALID_TOValid To (Time Stamp)decimal150
291COMM_SCHEMENumbering Scheme6VALID_TOValid To (Time Stamp)decimal150
292COMM_SETTPH_TEMPTemplate XXXX (History)3VALID_TOValid To (Time Stamp)decimal150
293COMM_SETTP_TEMPTemplate XXXX4VALID_TOValid To (Time Stamp)decimal150
294COM_COMMERCIALBusiness data4VALID_TOValid To (Time Stamp)decimal150
295COM_COMMERCIALHBusiness data3VALID_TOValid To (Time Stamp)decimal150
296CRMM_PR_TAXProduct Sales Tax11VALID_TOValid To (Time Stamp)decimal150
297CRMM_PR_TAXHProduct Sales Tax - History3VALID_TOValid To (Time Stamp)decimal150
298PRREFPermitted Object Categories5VALID_TOValid To (Time Stamp)decimal150
299PRREFHPermitted Object Categories3VALID_TOValid To (Time Stamp)decimal150
TOPClaims Management
300ICLCLAUSEClauses11VALID_TOValidity End of Clausedecimal150
301ICSCLAUSEClauses (Shadow Table)11VALID_TOValidity End of Clausedecimal150
302TICL346Office Integration: Additional Template Attributes6VALID_TODocument Template for Office Integration: Valid Tonvarchar80
303TICL943Rules in Claims Management System18VALID_TOEnd of Validity of BRFplus Rule in Claims Management Systemdecimal150
304TICL944Rules in Rule Sets in Claims Management System18VALID_TOEnd of Validity of BRFplus Rule in Claims Management Systemdecimal150
305TICL963BRF/ICLE: Rules in Events22VALID_TOEnd of Validity of BRFplus Rule in Claims Management Systemdecimal150
306TICL964BRF/ICLE: Rule Sets: Rules in Events17VALID_TOEnd of Validity of BRFplus Rule in Claims Management Systemdecimal150
TOPClassification System New
307CHARACTERTEXTDML Text Object11VALID_TOValid To (Time Stamp)decimal150
308CHARACTERTEXTHDML Text Object3VALID_TOValid To (Time Stamp)decimal150
309CME_ST_CHARATRCharacteristic: Global Attributes4VALID_TOValid To (Time Stamp)decimal150
310CME_ST_CHARATRHCharacteristic: Global Attributes3VALID_TOValid To (Time Stamp)decimal150
311CME_ST_FORMATCME Data Type: Format Details4VALID_TOValid To (Time Stamp)decimal150
312CME_ST_FORMAT1CME-Datentyp: Formatangaben4VALID_TOGültig bis (Zeitstempel)decimal150
313CME_ST_FORMATHCME Data Type: Format Details3VALID_TOValid To (Time Stamp)decimal150
314CME_ST_ISO_AT1CME Characteristic: ISO Attributes4VALID_TOValid To (Time Stamp)decimal150
315CME_ST_ISO_AT1HCME Characteristic: ISO Attributes3VALID_TOValid To (Time Stamp)decimal150
316CME_ST_ISO_ATACME Characteristic: ISO Attributes4VALID_TOValid To (Time Stamp)decimal150
317CME_ST_ISO_ATAHCME Characteristic: ISO Attributes3VALID_TOValid To (Time Stamp)decimal150
318CME_ST_ISO_ATBCME Characteristic: ISO Attributes5VALID_TOValid To (Time Stamp)decimal150
319CME_ST_ISO_ATBHCME Characteristic: ISO Attributes3VALID_TOValid To (Time Stamp)decimal150
320CME_ST_R3_ATTRCME Characteristic: R/3 Attributes4VALID_TOValid To (Time Stamp)decimal150
321CME_ST_R3_ATTRHCME Characteristic: R/3 Attributes3VALID_TOValid To (Time Stamp)decimal150
322CME_ST_R3_DEPCME Characteristic: Object Dependencies for R/3 Characterstc5VALID_TOValid To (Time Stamp)decimal150
323CME_ST_R3_DEPHCME Characteristic: Object Dependencies for R/3 Characterstc3VALID_TOValid To (Time Stamp)decimal150
324CME_ST_REFCharacteristic: Data Reference7VALID_TOValid To (Time Stamp)decimal150
325CME_ST_REFHCharacteristic: Data Reference3VALID_TOValid To (Time Stamp)decimal150
326CME_ST_VALUECME Data Type: Values9VALID_TOValid To (Time Stamp)decimal150
327CME_ST_VALUEHCME Data Type: Values3VALID_TOValid To (Time Stamp)decimal150
328CME_ST_VAL_TXTDML Text Object11VALID_TOValid To (Time Stamp)decimal150
329CME_ST_VAL_TXTHDML Text Object3VALID_TOValid To (Time Stamp)decimal150
330COMM_IL_DSCOPE_HChange Graph for History Table3VALID_TOValid To (Time Stamp)decimal150
331COMM_IL_DTYPE_HChange Graph for History Table3VALID_TOValid To (Time Stamp)decimal150
332COMM_IL_SCPCHR_HChange Graph for History Table3VALID_TOValid To (Time Stamp)decimal150
333DEFSCOPETEXTDML Text Object11VALID_TOValid To (Time Stamp)decimal150
334DEFSCOPETEXTHDML Text Object3VALID_TOValid To (Time Stamp)decimal150
335DTYPETEXTDML Text Object11VALID_TOValid To (Time Stamp)decimal150
336DTYPETEXTHDML Text Object3VALID_TOValid To (Time Stamp)decimal150
TOPClinical System
337N1ALCONFIGAppLog: Configuration8VALID_TOAppLog: End of Validity of Configurationnvarchar80
338N1ALPROFILEAppLog: Profile8VALID_TOAppLog: End of Validity of Profilenvarchar80
339N1CONNBPPROXYRegistered Proxy OU5VALID_TOIS-H: Valid-To Date of Recordnvarchar80
340N2GL_GUIDELINEpathways Treatment Pathway18VALID_TOEnd of Validity of Treatment Pathwaynvarchar80
341N2HIT_EN_OBHL: Assignment: Hit List Entry -> Assigned Object8VALID_TOField of type DATSnvarchar80
342TN2CLIM_CATALOGClinical Measurements Catalog Assignment6VALID_TOEntry Valid tonvarchar80
TOPCollaborative Cross Applications
343/POA/D_CLM_DPLMDeployment19VALID_TOSystem Datenvarchar80
TOPCollateral Management System
344CMS_RBL_SYNCRBL Sync Data13VALID_TODate until which the Risk stands Validnvarchar150
345CMS_RELRelationship details9VALID_TODate until which the relationship stands validnvarchar150
TOPCommand and Support Relationships
346/ISDFPS/FORCMDAttributes of Task Organization7VALID_TOEnd Timenvarchar60
347/ISDFPS/FORMNTAttributes of Maintenance Relationships7VALID_TOEnd Timenvarchar60
348/ISDFPS/FOROTHAttributes of Additional Relationships7VALID_TOEnd Timenvarchar60
349/ISDFPS/FORSUPAttributes of Supply Relationships7VALID_TOEnd Timenvarchar60
350/ISDFPS/ORCMDTask Organizations13VALID_TOEnd Timenvarchar60
351/ISDFPS/ORMNTMaintenance Relationships13VALID_TOEnd Timenvarchar60
352/ISDFPS/OROTHAdditional Relationships13VALID_TOEnd Timenvarchar60
353/ISDFPS/ORSUPSupply Relationships13VALID_TOEnd Timenvarchar60
354/ISDFPS/ORTOBTechnical Object Relationships (Maintenance)13VALID_TOEnd Timenvarchar60
TOPCommunication Services Mail, Fax, SMS, Telephony
355SRIRSCENBCOM Internal Router: Scenario Header Data6VALID_TOEnd of Validity Period of a Scenarionvarchar80
356SRSCENARIORouting Scenario: Definition5VALID_TOEnd of Validity Period of a Scenarionvarchar80
TOPContract Accounts Receivable and Payable
357IST_TDATATelco Object Data for Contract A/R & A/P16VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPCorporate Performance Monitor
358UMV_TR106Value Driver Tree: Responsible Person5VALID_TOEnd of Validity Periodnvarchar70
359UMV_TR227Value Driver Tree: Responsible Persons for Measures6VALID_TOEnd of Validity Periodnvarchar70
TOPCross-Application Components
360FRE_DB_ABI_HEADHeader table for DIF occurrence9VALID_TOValid To Datenvarchar80
361FRE_DIF_NO_SITESBEF Occurrences for Number of Supplied Plants6VALID_TOValid To Datenvarchar80
362FRE_IF_CONTRACTInterface Table for Contracts Data22VALID_TOTime Stamp at End of Validity Perioddecimal150
TOPData Basis
363RSODSO_CONTEXTControl of Runtime Measurements7VALID_TOEnd of Allowed Time Intervalnvarchar60
TOPEngineering Change Management
364COMM_IL_ECMCHG_HChange Graph for History Table3VALID_TOValid To (Time Stamp)decimal150
TOPFinancial Supply Chain Management
365TBNK_RULE_SELOPRule select options18VALID_TOValid to date for rulenvarchar80
TOPForce Element
366/ISDFPS/FORCEMAuthorized Materials15VALID_TOValid tonvarchar80
367/ISDFPS/FORCEPMaterial Packages9VALID_TOValid tonvarchar80
368/ISDFPS/FORTOBAttributes of Relationship to Technical Objects7VALID_TOEnd Timenvarchar60
TOPGeneric eSOA Tools
369BSSOA_PROPConfiguration table for SOA checks4VALID_TOField of type DATSnvarchar80
TOPGoods Receipt Process
370BORRTTSRoute schedule header (new)8VALID_TOValid To Datenvarchar80
TOPGRC Risk Management
371GRRMANALYSISAnalysis Table7VALID_TOValid Tonvarchar80
372GRRMRISKRESPONSEtable for risks related to response8VALID_TOResponse Valid Tonvarchar80
373GRRMSCENARIOCLSFScenario Classification6VALID_TOValid Tonvarchar80
TOPGroup Hierarchy
374BUT_HIER_NODE_BPBusiness Partner Hierarchy Group - Bus. Partner Assignment5VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
375BUT_HIER_STRUCTBusiness Partner Hierarchy Group - Hierarchy Relationship4VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPHandheld Connectivity
376/DSD/PR_HEADMDSD Promotion - Promotion Header5VALID_TOValid To Datenvarchar80
TOPIndustry Solution Catch Weight Management
377CON_FIN_CKOMPUAllowance for Price Update5VALID_TOUpper Date Limit for "Valid from" Date of Cost Estimatenvarchar80
TOPIntegration Customer Relationship Management
378ESALES_UTILPRODUtility products10VALID_TOEnd Date of Product Availabilitynvarchar80
TOPIntercompany Data Exchange
379ECERTIFDeregulation: certification8VALID_TODate at Which a Time Slice Expiresnvarchar80
TOPLoans Management
380TDPR_PRODVVersion of a Prodcut, Master Data8VALID_TOEffective tonvarchar80
381VDSTOP_VDARL_AAssign Stop to Loan7VALID_TOStop Valid tonvarchar80
TOPMaintenance Orders
382/MRSS/D_ADDRESSStores Primary/Secondary address22VALID_TOEnd Datenvarchar80
383/MRSS/D_ALERTSAlerts7VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
384/MRSS/D_PN_CAPACapacity Rule Definition for Planning Nodes5VALID_TOTimestamp (with conv. routine)decimal150
385/MRSS/D_RSBUFADMResource Buffering Admin Data4VALID_TODatenvarchar80
386/MRSS/D_SQP_ESTREmployee Profile - Structured Qualifications10VALID_TOValid tonvarchar80
387/MRSS/D_SQP_EUSTEmployee Profile : Unstructured Qualifications8VALID_TOValid tonvarchar80
TOPMaintenance Processing
388/MRSS/D_BAS_REQQRequired Qualifications for Demands13VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
389/MRSS/D_RES_QUALResource Qualifications11VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
390/MRSS/D_RES_ZIPAPostal Code Areas of Resource5VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMarket Risk Analyzer
391TCCT_CCURVE_FUTCommodity Curve Futures Style Master Data5VALID_TOValid Till Datenvarchar80
TOPMaster Data
392CMS_ACGApproved Coverage Gap Details6VALID_TODate until which the Coverage Gap Approval stands Validnvarchar150
393CMS_ACG_PROPOSALApproved Coverage Gap: Proposal Details7VALID_TODate until which the Coverage Gap Approval stands Validnvarchar150
394CMS_AST_DOCAsset Documents9VALID_TODate until which the Document stands validnvarchar150
395CMS_CAGCollateral Agreement Details12VALID_TOCollateral Agreement Document Valid-to Datenvarchar150
396CMS_CAG_DOCCollateral Agreement Documents9VALID_TODate until which the Document stands validnvarchar150
397CMS_CAG_PORCollateral Agreement Portion details17VALID_TODate until which Collateral Agreement Portion Stands Validnvarchar80
398CMS_CAG_RBLCollateral Agreement - Receivable Link Details7VALID_TOCollateral Agreement - Receivable Link Valid-to Datenvarchar150
399CMS_CAG_SASpecial Arrangements9VALID_TODate from which Special Arrangement Stands Validnvarchar80
400CMS_OMS_DOC_LNKDocuments Link9VALID_TODate until which the Document stands validnvarchar150
401FMMEASUREFM Funded Program Master Data5VALID_TOFM: Valid to datenvarchar80
402GMGRGrant Master7VALID_TOValid-to Datenvarchar80
403GMGRELATEDGM Grant relationships7VALID_TOValid Untilnvarchar80
TOPMaster Data Framework
404DML_LH_FRG_REGProduct-Set Assignment (Gen. Link-Handler)10VALID_TOValid To (Time Stamp)decimal150
405DML_LH_FRG_REGHProduct-Set Assignment History (Gen. Link-Handler)5VALID_TOValid To (Time Stamp)decimal150
406DML_ST_TEXTDML Text Object11VALID_TOValid To (Time Stamp)decimal150
407DML_ST_TEXTHDML Text Object3VALID_TOValid To (Time Stamp)decimal150
TOPMaterial Master
408WER_TEST_ARTICLESubset of articles used for testing4VALID_TODatenvarchar80
409WGDS_PROC_APP_CApplication used in a process7VALID_TOLast Change Date of Notification Messagenvarchar80
410WGDS_PROC_EVT_CRule engine's Events called during a process7VALID_TOLast Change Date of Notification Messagenvarchar80
411WRF_HIER_NODESHierarchy Node17VALID_TOValid Tonvarchar80
412WRF_HIER_OBJObjects of a Hierarchy13VALID_TOValid Tonvarchar80
TOPMedia Product Sales and Distribution
413JKSDSQPEVENTEvents in Quantity Planning6VALID_TOTo Datenvarchar80
414JKSEINTERRUPTIS-M: Suspensions6VALID_TOIS-M: Suspension Tonvarchar80
TOPNetWeaver Enterprise Search
415ESH_TAU_CL_PClassification Test: Property6VALID_TOValid To Timestampdecimal150
416ESH_TAU_CL_PDTClassification Test: Prop. Datatype6VALID_TOValid To Timestampdecimal150
417ESH_TAU_CL_PVPDClassification Test: Property Value Assignm. to EPM Product8VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
418ESH_TST_CLS_ASIGES Test Object Class Assignment6VALID_TOValid To Timestampdecimal150
419ESH_TST_DATATYPEES Test Object Data Type6VALID_TOValid To Timestampdecimal150
420ESH_TST_PROP_VALES Test Object Material - Property valuation8VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPNon Profit Organizations
421T7UNOBJASObject of assistance (local copy of NPO table)12VALID_TOValid Tonvarchar80
TOPObjects
422COM_TA_MANUFACManufacturer Information4VALID_TOValid To (Time Stamp)decimal150
423COM_TA_MANUFACHManufacturer Information3VALID_TOValid To (Time Stamp)decimal150
424COM_TA_R3_IDR3 Identification4VALID_TOValid To (Time Stamp)decimal150
425COM_TA_R3_IDHR3 Identification3VALID_TOValid To (Time Stamp)decimal150
TOPOLAP Technology
426RSRHIEDIR_OLAPOLAP Relevant Information for the Hierarchies34VALID_TOValid-to datenvarchar80
TOPPatient Transport Service
427N1TRANSi.s.h.med: Transport Medium5VALID_TOValid To Datenvarchar80
TOPPayment Cards
428PCA_BLOCKBlock Card Master6VALID_TODate Valid to: UTC Time Stamp in Short Form YYYYMMDDhhmmssdecimal150
429PCA_MASTERPayment Card Master: General Data3VALID_TODate Valid to: UTC Time Stamp in Short Form YYYYMMDDhhmmssdecimal150
TOPPortfolio Management
430/RPM/IT_VER_CTRLItem Version Controller Table16VALID_TODatenvarchar80
TOPProduct Cost Planning
431TOOL_COSTCosts for Prod.Resource/Tool4VALID_TOValid tonvarchar80
TOPProduct definition
432FIPR_PRODVVersion of a Prodcut, Master Data8VALID_TOValid tonvarchar80
TOPProduction Allocation
433GHO_ALLOC_OVROBSOLETE - GHO Allocation Theoratical Override12VALID_TOValid To Timestampdecimal150
434GHO_CHM_ANL_HChemical analysis header data9VALID_TOValid To Timestampdecimal150
435GHO_COM_WC_HCommingled Well Completion Header7VALID_TOValid To Timestampdecimal150
436GHO_MRH_RULE_HMeasurement Retrieval Hierarchy Rules Header7VALID_TOValid To Timestampdecimal150
437GHO_NODERULE_HNode Allocation Rules Header8VALID_TOValid To Timestampdecimal150
438GHO_NODE_DS_SP_HNode Down Stream Split header table8VALID_TOValid To Timestampdecimal150
439GHO_NODE_RULE_HOBSOLETE - Node Allocation Rules Header8VALID_TOValid To Timestampdecimal150
440GHO_NWRULE_HNetwork Allocation Rules Header7VALID_TOValid To Timestampdecimal150
441GHO_NW_RULE_HOBSOLETE - Production Flow Network Allocation Rules Header7VALID_TOValid To Timestampdecimal150
442GHO_NW_UOM_RULEOBSOLETE - UoM Rule for Network8VALID_TOValid To Timestampdecimal150
443GHO_PQCURVE_HPQ Curve Details Header9VALID_TOValid To Timestampdecimal150
444GHO_REP_MATReproduced Material details table7VALID_TOValid To Timestampdecimal150
445GHO_RULE_LOG_HAllocation Rule Log Header10VALID_TOValid To Timestampdecimal150
446GHO_SIMU_DS_SP_HSimulation: Node Down Stream Split rules header9VALID_TOValid To Timestampdecimal150
447GHO_SIMU_NDRHSimulation: Node Allocation Rules Header9VALID_TOValid To Timestampdecimal150
448GHO_SIMU_NWRHSimulation: Network Allocation Rules Header8VALID_TOValid To Timestampdecimal150
449GHO_SIMU_REP_MATSimulation: Reproduced Material details table8VALID_TOValid To Timestampdecimal150
450GHO_SIMU_TOR_HSimulation: Theoretical Override Header11VALID_TOValid To Timestampdecimal150
451GHO_SIMU_UOMRHSimulation: Network UoM Rule Header10VALID_TOValid To Timestampdecimal150
452GHO_SIMU_WCOM_HSimulation: Commingled Well Completion Header8VALID_TOValid To Timestampdecimal150
453GHO_SIMU_WC_OVRSimulation: Well Completion Override Details Table8VALID_TOValid To Timestampdecimal150
454GHO_THEO_OVR_HAllocation Theoretical Override Header10VALID_TOValid To Timestampdecimal150
455GHO_UOM_RULE_HNetwork UoM Rule Header9VALID_TOValid To Timestampdecimal150
456GHO_WC_OVRWell Completion Override Details Table7VALID_TOValid To Timestampdecimal150
457GHO_WC_RULE_LOGLog table for Well Completion Override, Reproduce material10VALID_TOValid To Timestampdecimal150
TOPProject Management
458CGPL_VRSN_HDRProject Planning: Version Headers7VALID_TODate, Until Which a Version Can Be Usednvarchar80
TOPPublic Sector Contract Accounts Receivable and Payable
459DFACTSOBJNR to Facts8VALID_TOValid To Datedecimal150
460DFMCA_BRF860BRF: Check Relationship18VALID_TOBRF: Expressionnvarchar200
461DFMCA_BRF870BRF: Create/Update Relationship18VALID_TOBRF: Expressionnvarchar200
462DFMCA_CORELData Table for Relationship13VALID_TORelationship Valid tonvarchar80
463TFMCA_FPF_RULEFPF: Processing Rule for a Form Bundle Type9VALID_TOValid to Datenvarchar80
464TFMCA_PT_TAXCONDCustomizing for Tax Conditions (Property Tax)4VALID_TOValid To Datenvarchar80
465TFMCA_PT_TAXRATECustomizing of Tax Rates (Property Tax)5VALID_TOValid To Datenvarchar80
466TFMCA_TF_FORMCustomizing Table for Table Forms5VALID_TOValid Tonvarchar80
TOPReceivable
467CMS_RBLReceivable Details18VALID_TODate until which the Risk stands Validnvarchar150
TOPRecipe Development
468/PLMB/RCP_RECIPERecipes22VALID_TOValid-To Date of a Recipenvarchar80
TOPRegulatory reporting for insurance companies
469TISSR_COLL_PL_HCollateral-Pool Historie7VALID_TODatum bis Feld vom Typ DATSnvarchar80
470TISSR_EXIT_FEE_HHistorische Darstellung der Exit Fees7VALID_TODatum bis Feld vom Typ DATSnvarchar80
471TISSR_RATING_HHistorie des Wertpapier-Ratings7VALID_TODatum bis Feld vom Typ DATSnvarchar80
TOPResourcen Management
472RMSLA_HDHTime-Dependent Header Data of Label Set13VALID_TOLabeling in PLM Web UI: Valid-To Datenvarchar80
TOPSales
473SLS_TMPL_ITEMSales: Template Item6VALID_TOSales template item valid-to datenvarchar80
TOPSAP Business Partner
474BUT0TPSAP BP: Template Assignments4VALID_TOValidity End of a Template Assignment to the BPdecimal150
475BUT_FRG0011Business Partner: Tax Classification6VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
476CRMM_BUT_FRG0061Business Partner Business Hours Interval4VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSAP Business Workflow
477SWF_TRC_HEADTrace: Catalog16VALID_TOTime: End of Trace Validitydecimal150
TOPSAP Healthcare - Industry-Specific Components for Hospitals
478N2DWSWL_PATTTask Template11VALID_TOTask Template Valid Tonvarchar80
479N2DWSWL_PATT1Task Template / Changes11VALID_TOTask Template Valid Tonvarchar80
480N2DWSWL_PROFProfile Template10VALID_TOProfile Template Valid Tonvarchar80
481N2DWSWL_PROF1Profile Template / Changes10VALID_TOProfile Template Valid Tonvarchar80
482N2DWSWL_WSSituation Template9VALID_TOSituation Template Valid Tonvarchar80
483N2DWSWL_WS1Situation Template / Changes9VALID_TOSituation Template Valid Tonvarchar80
TOPSAP Utilities
484EADZ_QDQuantity Determination Procedure3VALID_TODate at Which a Time Slice Expiresnvarchar80
485EFRANCHDATA_INIndia: Master data for Franchisee4VALID_TOTonvarchar80
486EFRANCH_GRID_INAssign Franchisee to Grid for India5VALID_TOTonvarchar80
TOPSecurities
487CMS_SEC_ACC_DOCLink between securities account and Documents is stored here9VALID_TODate until which the Document stands validnvarchar150
TOPSecurity
488STRUSTCERTPublic Key Certificates7VALID_TODatenvarchar80
TOPService Station Retailing
489OIRBPBLPBLLink Table Location-Loc(Competitor assgnmnt)(IS-OIL,SSR)5VALID_TOValid to datenvarchar80
490OIRCT685_HSSR Pricing - Condition type definition5VALID_TOValid to datenvarchar80
TOPSet Types and Attributes
491COMM_ATTR_DB_TMHTemplate for Database Tables of Multi-Value Attributes3VALID_TOValid To (Time Stamp)decimal150
492COMM_EXTENSIONHExtension Table History (Template)3VALID_TOValid To (Time Stamp)decimal150
493COMT_EXT_TEMPTemplate for Extension Tables5VALID_TOValid To (Time Stamp)decimal150
494COMT_EXT_TEMPHTemplate for Extension Tables History3VALID_TOValid To (Time Stamp)decimal150
495COMT_EXT_TEMP_DBTemplate for Extension Tables5VALID_TOValid To (Time Stamp)decimal150
496COMT_SETTMaster Data of Set Type <SETTYPE_ID>4VALID_TOValid To (Time Stamp)decimal150
497COMT_SETT_HHistory of Set Type <SETTYPE_ID>3VALID_TOValid To (Time Stamp)decimal150
498COMT_SETT_MLMaster Data of Set Type <SETTYPE_ID>5VALID_TOValid To (Time Stamp)decimal150
499COMT_SETT_ML_HHistory of Set Type <SETTYPE_ID>3VALID_TOValid To (Time Stamp)decimal150
500COMT_SETT_XMaster Data of Set Type <SETTYPE_ID>4VALID_TOValid To (Time Stamp)decimal150
501COMT_SETT_XMLMaster Data of Set Type <SETTYPE_ID>5VALID_TOValid To (Time Stamp)decimal150
502COMT_SETT_XML_HHistory of Set Type <SETTYPE_ID>3VALID_TOValid To (Time Stamp)decimal150
503COMT_SETT_X_HHistory of Set Type <SETTYPE_ID>3VALID_TOValid To (Time Stamp)decimal150
504COMT_TEMPLATESet Type Template4VALID_TOValid To (Time Stamp)decimal150
505COMT_TEMPLATEHSet Type History Template3VALID_TOValid To (Time Stamp)decimal150
506COMT_TEMP_MRSet Type Template4VALID_TOValid To (Time Stamp)decimal150
507COMT_TEMP_MRHSet Type History Template3VALID_TOValid To (Time Stamp)decimal150
508COMT_TEMP_MR_DBSet Type Template for Multi-Value Set Types5VALID_TOValid To (Time Stamp)decimal150
TOPSingapore
509T5RSOP_PLANStock Option Plan3VALID_TOValidity To Datenvarchar80
510T5RSOP_P_SCHEMEStock Option Scheme Assignment to Plan4VALID_TOValidity To Datenvarchar80
511T5RSOP_SCHEMEStock Option Scheme3VALID_TOValidity To Datenvarchar80
512T5RSOP_SCH_ESOWStock Option Scheme for ESOW3VALID_TOValidity To Datenvarchar80
TOPStructures Workbench
513/ISDFPS/EQUIPLNMaterials Planned for Force Element (Serialized)8VALID_TOValid tonvarchar80
514/ISDFPS/MATPLNMaterials Planned for Force Element9VALID_TOValid tonvarchar80
515/ISDFPS/USRFDPUser Settings for Structures Workbench9VALID_TOEnd Timenvarchar60
TOPTaxes
516TTXMlist of tax laws4VALID_TODate until tax law is valid.nvarchar80
517TTXMTTlist of tax laws (description)5VALID_TODate until tax law is valid.nvarchar80
518TTXXtable to determine which tax law is used7VALID_TOValidity end date of the condition recordnvarchar80
TOPTemplates
519COMC_MINITP_DATAMini-Template Data for Set Types (Generic Store)10VALID_TOValidity End (UCT Time Stamp Short Form, YYYYMMDDhhmmss)decimal150
520COMC_MINITP_DATHMini-Template Data History for Set Types (Generic Store)7VALID_TOValidity End (UCT Time Stamp Short Form, YYYYMMDDhhmmss)decimal150
521COMC_MINITP_DATSShadow Table Mini-Template Data for Set Types (Generic)10VALID_TOValidity End (UCT Time Stamp Short Form, YYYYMMDDhhmmss)decimal150
522COMC_MINITP_REGWrapping of Several Mini-Templates by a Key GUID (REG)6VALID_TOValidity End (UCT Time Stamp Short Form, YYYYMMDDhhmmss)decimal150
523COMC_MINITP_REGHHistory for Table COMC_MINITP_REG4VALID_TOValidity End (UCT Time Stamp Short Form, YYYYMMDDhhmmss)decimal150
TOPTransaction Tax Engine
524TTEC_TAXCODETax Code5VALID_TOValid To Datenvarchar80
525TTEC_TAXCODE_3Assign TTE Entities to Tax Code6VALID_TOValid To Datenvarchar80
526TTEM_TAXCODEMapping: Tax Code6VALID_TOValid To Datenvarchar80
TOPTransportation and Distribution
527OIGDLTD Driver's license data6VALID_TOTD driver's license: valid to datenvarchar80
TOPTravel Expenses
528T706STrip Schema38VALID_TOEnd Datenvarchar80
TOPTreasury and Risk Management
529TREAT_ASSIGNMENTTreasury: TREA Assignment12VALID_TOField of type DATSnvarchar80
TOPUse AP-MD-BP Components
530BUT000BP: General data I88VALID_TOValidity End BUT000 BP Datadecimal150
531BUT000_TDBP: General Data I, Shadow Table Time Dependency3VALID_TOValidity End BUT000 BP Datadecimal150
532BUT000_TDSBP: General Data I, Shadow Table Time Dependency4VALID_TOValidity End BUT000 BP Datadecimal150
533BUT021_FSTime-Dependent Address Usages3VALID_TOValidity End of a Business Partner Address Usagedecimal150
534BUT021_FSSShadow Table: Time-Dependent Address Usages4VALID_TOValidity End of a Business Partner Address Usagedecimal150
535BUT100BP: Roles6VALID_TOValidity End of a BP Roledecimal150
TOPWorkforce Management Core
536/SAPAPO/LRPRESOKey and Descriptive Data for a Resource14VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
537/SAPAPO/LRPRQPROQualifications Profile13VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
538/SAPAPO/LRPRTSATAttributes for a Requirement's Time Data9VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
539/SAPAPO/LRPRWTSAAssociation Table Between WDTIME and TIMESPEC for Reqmts5VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
540/SAPAPO/LRPSQPROQualifications Profile9VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
541/SAPAPO/LRPSTSATAttributes for Resource's Time Data9VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
542/SAPAPO/LRPSWTSAAssociation Table Between WDTIME and TIMESPEC for Resources5VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
543/SAPAPO/LRPTSATTObsolete: Attributes for Time Data9VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
544/SAPAPO/TSTRESOKey and Descriptive Data for a Resource14VALID_TOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
545WFD_ATS_020Starting Location5VALID_TOLocation End Datedecimal150
546WFD_ATS_030Service Area5VALID_TOService Area End Datedecimal150
547WFD_ATS_040Job Function5VALID_TOJob Function End Datedecimal150
548WFD_ATS_050Availability template link8VALID_TOTemplate End Datedecimal150