U_16053 SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
U_16053 is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The U_16053 table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include VBELN (Sales Document), KUNNR (Sold-to party), ERDAT (Date on Which Record Was Created), ERZET (Entry time).. 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: Not classified
SAP U_16053 table view 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KUNNR | Sold-to party | KUNAG | CHAR | 10 | KNA1 | ALPHA | KUNNR | VAG | |
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
TRVOG | Transaction group | TRVOG | CHAR | 1 | TRVOG | VTV | |||
AUART | Sales Document Type | AUART | CHAR | 4 | TVAK | AUART | AUART | AAT | |
AUGRU | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | TVAU | AUGRU | |||
GWLDT | Warranty Date | GWLDT | DATS | 8 | DATUM | ||||
LIFSK | Delivery block (document header) | LIFSK | CHAR | 2 | TVLS | LIFSP | |||
FAKSK | Billing block in SD document | FAKSK | CHAR | 2 | TVFS | FAKSP | |||
NETWR | Net Value of the Sales Order in Document Currency | NETWR_AK | CURR | 15(2) | WERTV8 | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
GSKST | Business area from cost center | GSKST | CHAR | 4 | TGSB | GSBER | |||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
VDATU | Requested delivery date | EDATU_VBAK | DATS | 8 | DATUM | ||||
VPRGR | Proposed date type | PRGRS_VBAK | CHAR | 1 | PRGRS | ||||
AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | XFELD | ||||
VBKLA | Original system with release and transaction control | VBKLA | CHAR | 9 | CHAR9 | ||||
VBKLT | SD document indicator | VBKLT | CHAR | 1 | VBKLT | ||||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | T683 | KALSM | |||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | TVSB | VSBED | |||
FKARA | Proposed billing type for an order-related billing document | FKARA | CHAR | 4 | TVFK | FKART | |||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | BSTNK | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | T176 | BSARK | |||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
BSTZD | Purchase order number supplement | BSTZD | CHAR | 4 | BSTZD | ||||
IHREZ | Your Reference | IHREZ | CHAR | 12 | TEXT12 | ||||
BNAME | Name of orderer | BNAME_V | CHAR | 35 | NAME | ||||
TELF1 | Telephone Number | TELF1_VP | CHAR | 16 | TELF1 | ||||
MAHZA | Number of contacts from the customer | MAHZA | DEC | 3 | PACK2 | ||||
MAHDT | Last customer contact date | MAHDT | DATS | 8 | DATUM | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | ALPHA | STAFO | MCF | ||
STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
KVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | TVV1 | KVGR1 | |||
KVGR2 | Customer group 2 | KVGR2 | CHAR | 3 | TVV2 | KVGR2 | |||
KVGR3 | Customer group 3 | KVGR3 | CHAR | 3 | TVV3 | KVGR3 | |||
KVGR4 | Customer group 4 | KVGR4 | CHAR | 3 | TVV4 | KVGR4 | |||
KVGR5 | Customer group 5 | KVGR5 | CHAR | 3 | TVV5 | KVGR5 | |||
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
KNKLI | Customer's account number with credit limit reference | KNKLI | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
GRUPP | Customer Credit Group | GRUPP_CM | CHAR | 4 | GRUPP_CM | ||||
SBGRP | Credit representative group for credit management | SBGRP_CM | CHAR | 3 | T024B | SBGRP_CM | KBG | ||
CTLPC | Credit management: Risk category | CTLPC_CM | CHAR | 3 | T691A | CTLPC_CM | |||
CMWAE | Currency key of credit control area | WAERS_CM | CUKY | 5 | TCURC | WAERS | |||
CMFRE | Release date of the document determined by credit management | CMFRE | DATS | 8 | DATUM | ||||
CMNUP | Date of next credit check of document | CMNUP | DATS | 8 | DATUM | ||||
CMNGV | Next date | CMNGV | DATS | 8 | DATUM | ||||
AMTBL | Released credit value of the document | AMTBL_CM | CURR | 15(2) | WERTV8 | ||||
HITYP_PR | Hierarchy type for pricing | HITYP_PR | CHAR | 1 | THIT | HITYP | |||
OBJNR | Object number at header level | OBJKO | CHAR | 22 | ONR00 | J_OBJNR | |||
BUKRS_VF | Company code to be billed | BUKRS_VF | CHAR | 4 | T001 | BUKRS | BUK | ||
TAXK1 | Alternative tax classification | TAXK1_AK | CHAR | 1 | TAXKD | ||||
TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | TAXKD | ||||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | TAXKD | ||||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | TAXKD | ||||
TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | TAXKD | ||||
TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | TAXKD | ||||
TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | TAXKD | ||||
TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | TAXKD | ||||
TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | TAXKD | ||||
XBLNR | Reference Document Number | XBLNR_V1 | CHAR | 16 | XBLNR1 | ||||
ZUONR | Assignment number | ORDNR_V | CHAR | 18 | ZUONR | ||||
VGTYP | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | VBUK | ALPHA | VBELN | ||
KALSM_CH | Search procedure for batch determination | KALSMA_CH | CHAR | 6 | T683 | KALSM | |||
AGRZR | Accrual period for order-related billing docs.to be accrued | AGRZR | NUMC | 2 | NUM2 | ||||
KONDA | Price group (customer) | KONDA | CHAR | 2 | T188 | KONDA | VKA | ||
KDGRP | Customer group | KDGRP | CHAR | 2 | T151 | KDGRP | VKD | ||
BZIRK | Sales district | BZIRK | CHAR | 6 | T171 | BZIRK | BZI | ||
PLTYP | Price list type | PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | XFELD | ||||
PERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | TFACD | WFCID | |||
PERRL | Invoice list schedule (calendar identification) | PERRL | CHAR | 2 | TFACD | WFCID | |||
MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | T042Z | ZLSCH | |||
KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | TVKT | KTGRD | |||
KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
STCUR | Exchange rate for statistics | STCUR | DEC | 9(5) | EXCRT | KURRF | |||
MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP |
Key field | Non-key field |
How do I retrieve data from SAP table U_16053 using ABAP code
The following ABAP code Example will allow you to do a basic selection on U_16053 to SELECT all data from the tableDATA: WA_U_16053 TYPE U_16053.
SELECT SINGLE *
FROM U_16053
INTO CORRESPONDING FIELDS OF WA_U_16053
WHERE...
How to access SAP table U_16053
Within an ECC or HANA version of SAP you can also view further information about U_16053 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