CRMT_COMPL_DELIVERY_R3 SAP (Delivery from R/3:Corresponds Exactly to R/3 LIPOV Structure) Structure details
Description: Delivery from R/3:Corresponds Exactly to R/3 LIPOV Structure
Related tables to CRMT_COMPL_DELIVERY_R3
Access table CRMT_COMPL_DELIVERY_R3
Structure field list including key, data, relationships and ABAP select examples
CRMT_COMPL_DELIVERY_R3 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Delivery from R/3:Corresponds Exactly to R/3 LIPOV Structure" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CRMT_COMPL_DELIVERY_R3 TYPE CRMT_COMPL_DELIVERY_R3.
The CRMT_COMPL_DELIVERY_R3 table consists of various fields, each holding specific information or linking keys about Delivery from R/3:Corresponds Exactly to R/3 LIPOV Structure data available in SAP. These include POSNR (Delivery Item), SELKZ (Selection indicator for list screens), MARK (Text of length 132), ARKTX (Short text for sales order item).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CRMT_COMPL_DELIVERY_R3 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
VBELN | Delivery | VBELN_VL | CHAR | 10 | ALPHA | VBELN | VL | ||
POSNR | Delivery Item | POSNR_VL | NUMC | 6 | POSNR | ||||
SELKZ | Selection indicator for list screens | SELKZ_LIST | CHAR | 1 | SELKZ | ||||
MARK | Text of length 132 | CHAR_132 | CHAR | 132 | |||||
ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MATN1 | MATNR | MAT | S_MAT1 | |
S_MTART | Material Type | MTART | CHAR | 4 | Assigned to domain | MTART | MTA | ||
LADGR | Loading Group | LADGR | CHAR | 4 | Assigned to domain | LADGR | |||
LFART | Delivery Type | LFART | CHAR | 4 | Assigned to domain | LFART | ALT | ||
LPRIO | Delivery Priority | CRMT_DLV_PRIO | NUMC | 2 | Assigned to domain | CRM_DLV_PRIO | CRM_DELIVERY_PRIORITY | ||
VSTEL | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | VSTEL | VST | |||
LSTEL | Loading Point | LSTEL | CHAR | 2 | Assigned to domain | LSTEL | |||
BEROT | Picked items location | BEROT | CHAR | 20 | BEROT | ||||
LFDAT | Delivery date | LFDAT | DATS | 8 | DATUM | ||||
LFUHR | Time of delivery | LFUHR | TIMS | 6 | LFUHR | ||||
LDDAT | Loading Date | LDDAT | DATS | 8 | DATUM | ||||
S_LDUHR | Loading Time (Local Time Relating to a Shipping Point) | LDUHR | TIMS | 6 | TIME_SHIPP | ||||
WADAT | Goods Issue Date | WADAT | DATS | 8 | DATUM | ||||
S_WAUHR | Time of Goods Issue (Local, Relating to a Plant) | WAUHR | TIMS | 6 | TIME_PLANT | ||||
TDDAT | Transportation Planning Date | TDDAT_D | DATS | 8 | DATUM | ||||
S_TDUHR | Transp. Planning Time (Local, Relating to a Shipping Point) | TDUHR | TIMS | 6 | TIME_SHIPP | ||||
KODAT | Picking Date | KODAT | DATS | 8 | DATUM | ||||
S_KOUHR | Picking time (local time, with reference to a plant) | CRMT_KOUHR | TIMS | 6 | TIME_PLANT | ||||
MBDAT | Material Staging/Availability Date | MBDAT | DATS | 8 | DATUM | ||||
ROUTE | Route | ROUTE | CHAR | 6 | ROUTE | ||||
LFIMG | Actual quantity delivered (in sales units) | LFIMG | QUAN | 13(3) | MENG13 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
S_LGMNG | Actual quantity delivered in stockkeeping units | LGMNG | QUAN | 13(3) | MENG13 | ||||
S_MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BRGEW | Total Weight | GSGEW | QUAN | 15(3) | MENG15 | ||||
NTGEW | Net Weight | CRMT_NET_WEIGHT | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VOLUM | Volume | VOLUM_15 | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ANZPK | 5 Character Numeric NUMC | NUMC5 | NUMC | 5 | NUM5 | ||||
VBEAK | Decimal Number, Length 6 Without Decimal Places | SWFP6_0DEC | DEC | 6 | |||||
VBEAF | dec5 | CRMT_DEC5 | DEC | 5 | DEC5 | ||||
VBEAV | dec5 | CRMT_DEC5 | DEC | 5 | DEC5 | ||||
PIKMG | Quantity field, length 13, with +/- sign | MENGV13 | QUAN | 13(3) | MENGV13 | ||||
UMVKZ | dec5 | CRMT_DEC5 | DEC | 5 | DEC5 | ||||
UMVKN | dec5 | CRMT_DEC5 | DEC | 5 | DEC5 | ||||
FAKSP | Block | FAKSP | CHAR | 2 | Assigned to domain | FAKSP | |||
KUNNR | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
NAME_WE | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
ORT01_WE | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
KUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
NAME_AG | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
ORT01_AG | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
SPDNR | Forwarding agent | SPDNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
NAME_SP | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
ORT01_SP | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
NAME_LI | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
ORT01_LI | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
PARVW | Partner Function | PARVW | CHAR | 2 | Assigned to domain | PARVW | PARVW | PAR | |
PARTN | Partner number (KUNNR, LIFNR, or PERNR) | KUNDE_D | CHAR | 10 | ALPHA | KUNDE | |||
NAME_PA | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
ORT01_PA | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | SPART | SPA | C_SPART | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
LIFEX | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
EXIDV | External Handling Unit Identification | EXIDV | CHAR | 20 | ALPHA | EXIDV | HU_IDENT_ALLG | ||
TRATY | Means-of-Transport Type | TRATY | CHAR | 4 | Assigned to domain | TRATY | |||
TRAID | Means of Transport ID | TRAID | CHAR | 20 | TRAID | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
KOSTA | Picking status/Putaway status | KOSTA | CHAR | 1 | STATV | ||||
LVSTA | Status of warehouse management activities | LVSTA | CHAR | 1 | STATV | ||||
WBSTA | Goods movement status | WBSTA | CHAR | 1 | STATV | ||||
KOSTK | Overall picking / putaway status | KOSTK | CHAR | 1 | STATV | ||||
LVSTK | Overall status of warehouse management activities | LVSTK | CHAR | 1 | STATV | ||||
KOQUK | Status of pick confirmation | KOQUK | CHAR | 1 | STATV | ||||
WBSTK | Total goods movement status | WBSTK | CHAR | 1 | STATV | ||||
BESTK | Confirmation status | BESTK | CHAR | 1 | STATV | ||||
S_IMWRK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | LGORT | LAG | |||
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | Assigned to domain | LGNUM | LGN | ||
LGTYP | Storage Type | LGTYP | CHAR | 3 | Assigned to domain | LGTYP | LGT | H_T301 | |
LGPLA | Storage Bin | LGPLA | CHAR | 10 | Assigned to domain | LGPLA | LGP | LAG1 | |
KZDLG | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
LGPBE | Storage Bin | LGPBE | CHAR | 10 | CHAR10 | ||||
S_LGTOR | 3-Byte field | CHAR3 | CHAR | 3 | CHAR3 | ||||
S_LGBZO | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
ACTIV | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
KOMAU | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
KOMAUART | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
KZFME | ID: Leading unit of measure for completing a transaction | KZFME | CHAR | 1 | KZFME | ||||
COLOR | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | CHAR | 4 | CHAR4 | ||||
PROC_STATUS | Processing Status | BEA_PROCESS_STATUS | CHAR | 1 | BEA_PROCESS_STATUS | ||||
HUPOS | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
SELMETH | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ANZPOS | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
S_PSTYV | Delivery item category | PSTYV_VL | CHAR | 4 | PSTYV | ||||
S_VGTYP | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
S_VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | ALPHA | VBELN | |||
S_VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | POSNR | ||||
S_CHARG | Batch Number | CHARG_D | CHAR | 10 | CHARG | CHA | |||
S_SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
S_BESTQ | Stock Category in the Warehouse Management System | BESTQ | CHAR | 1 | BESTQ | ||||
S_SONUM | Special Stock Number | LVS_SONUM | CHAR | 16 | ALPHA | LVS_SONUM | |||
S_BWLVS | Movement Type for Warehouse Management | BWLVS | NUMC | 3 | Assigned to domain | BWLVS | BWL | ||
S_BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | Assigned to domain | BWART | BWA | ||
S_AKTNR | COUPON | WAKTION | CHAR | 10 | ALPHA | WAKTION | WAK | ||
COUNTER | Internal Counter | CRMT_APO_COUNTER | INT4 | 10 | CRM_APO_COUNTER | ||||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | ALPHA | VBELN | |||
VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | POSNR |
Key field | Non-key field |
How do I retrieve data from SAP structure CRMT_COMPL_DELIVERY_R3 using ABAP code?
As CRMT_COMPL_DELIVERY_R3 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMT_COMPL_DELIVERY_R3 as there is no data to select.How to access SAP table CRMT_COMPL_DELIVERY_R3
Within an ECC or HANA version of SAP you can also view further information about CRMT_COMPL_DELIVERY_R3 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects