M_DEBI_BO
Generated Table for View
M_DEBI_BO is an SAP database table in S/4HANA. Generated Table for View. It contains 12 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| SHSM_M_DEBI_BO | view | from |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | sortl | SORTL | Search term | |||
| KEY | pstlz | PSTLZ | Postal Code | |||
| KEY | mcod3 | MCDD3 | City | |||
| KEY | mcod1 | MCDD1 | Name | |||
| KEY | kunnr | KUNNR | Customer | |||
| KEY | vkorg | VKORG | Sales Org. | |||
| KEY | vtweg | VTWEG | Distr. Channel | |||
| KEY | spart | SPART | Division | |||
| vkbur | VKBUR | Sales Office | ||||
| vkgrp | VKGRP | Sales Group | ||||
| bokre | BOKRE | Rebate |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE M_DEBI_BO (
MANDT, -- Client [MANDT]
SORTL, -- Search term [SORTL]
PSTLZ, -- Postal Code [PSTLZ]
MCOD3, -- City [MCDD3]
MCOD1, -- Name [MCDD1]
KUNNR, -- Customer [KUNNR]
VKORG, -- Sales Org. [VKORG]
VTWEG, -- Distr. Channel [VTWEG]
SPART, -- Division [SPART]
VKBUR, -- Sales Office [VKBUR]
VKGRP, -- Sales Group [VKGRP]
BOKRE, -- Rebate [BOKRE]
PRIMARY KEY (MANDT, SORTL, PSTLZ, MCOD3, MCOD1, KUNNR, VKORG, VTWEG, SPART)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA