SAP Basic Functions Tables
Are you looking for the right table related to SAP Basic Functions Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Basic Functions (SD-BF) module.
Top 10 tables in Basic Functions
| Table | Description |
|---|---|
| TTSEGEVTYT | Time Segment Text for Event Type |
| TVSA | SD Documents: Processing Groups |
| KNMTA | Additional Customer-Material in CMIR |
| GOALC_BO_S | GOAL: Business Object |
| QTVB | Product Allocation: Allocation used by Customer Order |
| AIC_VBRK | Archiving SD_VBRK: Customizing for Index (secondary) |
| KNMTK | Customer-Material Info Record Header Table |
| CFG_SD_CUSTMAT | C-Table for eCATT /SMB15/VD51_O001_231 |
| GOALC_MAPPING_C | GOAL: Mapping |
| TTSEGLOCA | Time Segment Location Time |
List of tables in Basic Functions
| Table | Description |
|---|---|
| TTSEGEVTYT | Time Segment Text for Event Type |
| TVSA | SD Documents: Processing Groups |
| KNMTA | Additional Customer-Material in CMIR |
| GOALC_BO_S | GOAL: Business Object |
| QTVB | Product Allocation: Allocation used by Customer Order |
| AIC_VBRK | Archiving SD_VBRK: Customizing for Index (secondary) |
| KNMTK | Customer-Material Info Record Header Table |
| CFG_SD_CUSTMAT | C-Table for eCATT /SMB15/VD51_O001_231 |
| GOALC_MAPPING_C | GOAL: Mapping |
| TTSEGLOCA | Time Segment Location Time |
| GOALC_BO_ENT_C | GOAL: Business Object entity |
| KOND3 | Conditions: Campaign Determination - Data Part |
| FPLA | Billing Plan |
| GOALC_ENHANCE_ID | GOAL: Enhancement ID |
| ARCID_CUST_VBRK | Archiving SD_VBRK: Customizing for Index (secondary) |
| GOALC_ATTR_C | GOAL: Attribute |
| TTSEGPROJT | Time Segment Text for Project |
| GOALC_CHILD_C | GOAL: Child |
| ARCID_P_VBRK | Archiving SD_VBRK: Index table (primary) |
| TVP2T | Contact person attribute 2: Texts |
| GOALC_BO_C | GOAL: Business Object |
| TTSEGLOCAT | Time Segment Text for Location Time |
| TVP3 | Contact Person: Attribute 3 |
| TVGMO | View Control: Exceptions for Move-Corresponding |
| QTCH | Product Allocation: Feature Directory |
| VBPA3 | Tax Numbers for One-Time Customers |
| TVP6 | Contact Person: Attribute 6 |
| T190H | Product Allocation: Planning Structure for this Step |
| TVGVI | View Control: View Definition |
| THIOZ | Customer Hierarchies: Allowed Organizational Assignments |
| TTSEGTPLV | Time Segment for Template Views |
| T190OT | Product Allocation: Text for Product Allocation Object |
| THIT | Customer Hierarchy Types |
| VZLOG | Log Analysis of x/y Tables |
| TVP7T | Contact person attribute 7: Texts |
| TVSFT | SD: Statistics Groups for Doc Types/Item Categories: Texts |
| TVP2 | Contact Person: Attribute 2 |
| GOALC_ACTION_S | GOAL: Action |
| GOALC_ATTR_S | GOAL: Attribute |
| THIZU | Customer Hierarchy: Allowed Account Group Assignments |
| TVP5T | Contact person attribute 5: Texts |
| GOALC_BO_ENT_S | GOAL: Business Object entity |
| VBBS | Sales Requirement Totals Record |
| TTSEGTPLH | Time Segment Template Header |
| FPLTPO | Billing Plan: Dates |
| TTSEGTPLHT | Time Segment Text for Template Header |
| TFPLB | Billing Plan Type: Description |
| TVBR | Contact Person: Frequency of Visits |
| ARCID_S_VBRK | Archiving SD_VBRK: Index table (secondary) |
| VBKPA | SD index: Sales activities by partner function |
| T190S | Product Allocation: Definition Procedure |
| VBSK | Collective Processing for a Sales Document Header |
| KNMT | Customer-Material Info Record Data Table |
| TTSEGMAPP | Time Segment: Map to Times |
| SDPROTCALT | SD Monitor: Value Table for Protocol Callers |
| TVP3T | Contact person attribute 3: Texts |
| TVKWZ | Org.Unit: Allowed Plants per Sales Organization |
| SDSOL_TYPE_S | Sales Object Linkage Type Definition - SAP Values |
| TTSEGVERTT | Texts for Time Segment Version Types |
| TVP4T | Contact person attribute 4: Texts |
| TSEGE | Time Segment Events |
| GOALC_CHILD_S | GOAL: Child |
| TVARK | Archiving Control for Sales Activities in Sales Support |
| THITT | Texts for Customer Hierarchy Types |
| TVV2T | Customer group 2: Description |
| VBKOF | SD index: Open sales activities by partner function |
| TVV1 | Customer Group 1 |
| TVTBT | Sales Documents: Order Reasons: Texts |
| T459T | Availability Check: Requirement and Planning Types: Texts |
| VBSS | Collective Processing: Sales Documents |
| TCMI | Table for customer material info |
| TTSEGEVTY | Time Segment for Event Type |
| TVGZU | View Control: Special Table Access |
| T190ST | Product Allocation: Definition |
| VBFA_STATUS | VBFA reconstruction status: nodes that have been processed |
| T190O | Product Allocation: Definition of Product Allocation Object |
| TPACHECKASSIGN | Checking Module Assignments in SD Partner Processing |
| KNVH | Customer Hierarchies |
| TVSAT | SD document processing groups: Texts |
| GOALD_TRACE | GOAL: Trace |
| TTSEGOBJE | Time Segment Object for Date Header |
| TVP4 | Contact Person: Attribute 4 |
| SDPROTCAL | SD Monitor: Value Table for Protocol Callers |
| TVBRT | Contact person: Frequency of visits: Texts |
| TSEGEADR | Time Segment Address for Event |
| TVV2 | Customer Group 2 |
| TVARN | Selection parameters for archiving in sales and distribution |
| TVP0 | Contact Person: Attribute 10 |
| FPLAPO | Billing Plan |
| TTSEGTPLD | Time Segment: Default Template for Object |
| TD4ADRC | Test Double for Addresses (Business Address Services) |
| TTSEGPROJ | Time Segment Project |
| GOALC_ACTION_C | GOAL: Action |
| TTBD | Directory of text module for documents |
| VFPLT | Billing Plan: Dates |
| PAYSP_HL | Payment Service Provider Data |
| TTSEGTIMET | Time Segment Text for Time |
| TFPLT | Date Type for Billing Plan Type |
| VBPA | Sales Document: Partner |
| TTSEGVERT | Time Segment Version Types |
| VBFA | Sales Document Flow |
| GOALC_EXT_DATA_S | GOAL: External Data |
| TVKGT | Sales Documents: Reasons for Cancellation: Texts |
| TVLZ | Validity Period Category |
| TPACHECKRELATION | Dependency Graph for Check Modules in SD Partner Processing |
| SLS_C_PAYSP_PTS | Payment Service Provider Payment Transaction Status |
| TVP9T | Contact person attribute 9: Texts |
| TTSEGTPLE | Time Segment Event Template |
| GOALC_EXT_DATA_C | GOAL: External Data |
| VBBE | Sales Requirements: Individual Records |
| VBUP | Sales Document: Item Status |
| TTSEGDURAT | Text for Logical Duration in Time Segment |
| TVLZT | Validity Period Category: Texts |
| TTSEGTPLR | Time Segment Template for Application Relationship |
| TSEGH | Time Segment Header |
| TFPLA | Billing Plan Type |
| ARCID_VBRK | Archiving SD_VBRK: Index Table |
| FPLT | Billing Plan: Dates |
| TVSF | SD: Statistics Groups for Document Types and Item Categories |
| TTSEGOBJET | Time Segment Object for Date Header |
| SDPROTTYPT | Value table for SD protocol types: Texts |
| SDSOL_TYPE_TXT_C | Description for Sales Object Linkage |
| TVCPT | Sales docs: Texts for modules from TVCPA,TVCPF,TVCPL,TTXVR |
| T180 | Screen Sequence Control: Transaction Default Values |
| TVBST | SD Documents: Processing Status: Texts |
| TVP0T | Contact person attribute 10: Texts |
| TFPLU | Date Type in Billing Plan: Description |
| VBPA2 | Sales document: Partner (used several times) |
| CMPB_ASGN | Campaign Assignment |
| TSEGWS01 | WS Application-specific Additional Data for Date Segment |
| TVTB | Billing Plan: Date Description |
| TVP5 | Contact Person: Attribute 5 |
| T190HT | Product Allocation: Text for Planning Hierarchy |
| TVV1T | Customer group 1: Description |
| VFPLA | Billing Plan |
| SDPROTTYP | Value Table for SD Log Types |
| TVP6T | Contact person attribute 6: Texts |
| GOALC_MAPPING_S | GOAL: Mapping |
| SDSOL_TYPE_C | Sales Object Linkage Type Definition |
| VBUK | Sales Document: Header Status and Administrative Data |
| TVP7 | Contact Person: Attribute 7 |
| TNLS | Nielsen ID |
| TTSEGTIME | Time Segment Time |
| SDSOL | Sales Object Linkage |
| TNLST | Description of Nielsen Indicators |
| TVP8T | Contact person attribute 8:Texts |
| TSEGR | Time Segment Relationships Between Events |
| TTBDT | Texts: Directory of function modules for documents |
| TTSEGTPLVT | Time Segment Texts for Template Views |
| T190 | Product Allocation: Controlling |
| TVPG | Partner Function Groups |
| UTSEGDATA | Time Segment Data Container Template |
| TVP9 | Contact Person: Attribute 9 |
| VEDAPO | Contract Data |
| SDSOL_TYPE_TXT_S | Description for Sales Object Linkage |
| TTSTRSD | Working Times in SD/WS |
| TTSEGDURA | Logical Duration of Time Segment |
| T190V | Product allocations: Consumption period in an info structure |
| TVKG | Sales Documents: Reasons for Cancellation |
| TPAFILTER | Filter Table for Displaying Partner Subscription 1000 (V09C) |
| TPACHECK | Checking Table Directory for Check Modules of SD Partner |
| TVP8 | Contact Person: Attribute 8 |