MBDAT in LIPS
Mat.Avail.Date (DE: MatBereitstell)
MBDAT is a field in SAP table LIPS (SD document: Delivery: Item data). It represents "Mat.Avail.Date". Data element: MBDAT. Available in 10 CDS view(s) as ProductAvailabilityDate, RequestedDeliveryDate, RequestedDate.
Business Meaning
| Description (EN) | Mat.Avail.Date |
|---|---|
| Beschreibung (DE) | MatBereitstell |
| Data Element | MBDAT |
| Key Field | No |
CDS Views & Technical Names (10)
LIPS.MBDAT is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
ProductAvailabilityDate
(10 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_SupDmndAllDocGdsIssdDeliv | direct | BASIC | View for Goods Issued Deliveries | |
| I_SupDmndAllDocRetDeliv | direct | BASIC | View for Return Deliveries | |
| I_SupDmndAllDocGdsIssdDelivC | via 2 level | COMPOSITE | Cube View for Goods Issued Deliveries | |
| I_SupDmndAllDocRetDelivAssgC | via 2 level | COMPOSITE | Cube View for Return Deliveries Assignment Details | |
| I_SupDmndAllDocRetDelivC | via 2 level | COMPOSITE | Cube View for Return Deliveries Details | |
| P_SupDmndAllDocRetDelivAssgmt | via 2 level | COMPOSITE | ||
| C_SupDmndAllDocGdsIssdDelivQ | via 3 levels | CONSUMPTION | Query View for Goods Issued Delivery | |
| C_SupDmndAllDocRetDelivAssgQ | via 3 levels | CONSUMPTION | Query View for Return Deliveries Assignment Details | |
| C_SupDmndAllDocRetDelivQ | via 3 levels | CONSUMPTION | Query View for Return Deliveries Details | |
| C_SupDmndOvwPgGdsIssdDelivQ | via 3 levels | CONSUMPTION | Query View for Goods Issued Delivery |
RequestedDeliveryDate
(10 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_SupDmndAllDocGdsIssdDeliv | direct | BASIC | View for Goods Issued Deliveries | |
| I_SupDmndAllDocRetDeliv | direct | BASIC | View for Return Deliveries | |
| I_SupDmndAllDocGdsIssdDelivC | via 2 level | COMPOSITE | Cube View for Goods Issued Deliveries | |
| I_SupDmndAllDocRetDelivAssgC | via 2 level | COMPOSITE | Cube View for Return Deliveries Assignment Details | |
| I_SupDmndAllDocRetDelivC | via 2 level | COMPOSITE | Cube View for Return Deliveries Details | |
| P_SupDmndAllDocRetDelivAssgmt | via 2 level | COMPOSITE | ||
| C_SupDmndAllDocGdsIssdDelivQ | via 3 levels | CONSUMPTION | Query View for Goods Issued Delivery | |
| C_SupDmndAllDocRetDelivAssgQ | via 3 levels | CONSUMPTION | Query View for Return Deliveries Assignment Details | |
| C_SupDmndAllDocRetDelivQ | via 3 levels | CONSUMPTION | Query View for Return Deliveries Details | |
| C_SupDmndOvwPgGdsIssdDelivQ | via 3 levels | CONSUMPTION | Query View for Goods Issued Delivery |
RequestedDate
(4 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_SupDmndAllDocGdsIssdDeliv | direct | BASIC | View for Goods Issued Deliveries | |
| I_SupDmndAllDocGdsIssdDelivC | via 2 level | COMPOSITE | Cube View for Goods Issued Deliveries | |
| C_SupDmndAllDocGdsIssdDelivQ | via 3 levels | CONSUMPTION | Query View for Goods Issued Delivery | |
| C_SupDmndOvwPgGdsIssdDelivQ | via 3 levels | CONSUMPTION | Query View for Goods Issued Delivery |
SupplyDeliveryDate
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_SupDmndAllDocRetDeliv | direct | BASIC | View for Return Deliveries | |
| P_SupDmndAllDocRetDelivAssgmt | via 2 level | COMPOSITE |
Other Tables with Field MBDAT (8)
| Table | Data Element | Key | Description |
|---|---|---|---|
| ATP_EKUB | MBDAT | Generated Table for View | |
| ATP_VBBE | MBDAT | Generated Table for View | |
| EKET | MBDAT | Scheduling Agreement Schedule Lines | |
| MMPUR_ANA_EKET | MBDAT | Analytical Data for Schedule Lines | |
| MMPUR_ANAEXTEKET | MBDAT | Consoludated Table for Central PO, Item, Scheduleline | |
| MMPUR_EXT_EKET | MBDAT | Scheduling Agreement Schedule Lines | |
| VBBE | MBDAT | Sales Requirements: Individual Records | |
| VBEP | MBDAT | Sales Document: Schedule Line Data |
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