VPSOSEGD SAP () Structure details
Description:
Structure field list including key, data, relationships and ABAP select examples
VPSOSEGD 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 "" 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_VPSOSEGD TYPE VPSOSEGD.
The VPSOSEGD table consists of various fields, each holding specific information or linking keys about data available in SAP. These include MANDT (Client), LOTKZ (Lot Number for Documents), BUKRS (Company Code), ITABKEY (Internal key of internal table).. 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 VPSOSEGD 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 |
MANDT | Client | MANDT | CLNT | 3 | PSOKPF | MANDT | |||
LOTKZ | Lot Number for Documents | LOTKZ | CHAR | 10 | ALPHA | LOTKZ | LOT | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
ITABKEY | Internal key of internal table | FM_ITABKEY | NUMC | 10 | FM_ITABKEY | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BZKEY | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
AUSBK | Source Company Code | AUSBK | CHAR | 4 | Assigned to domain | BUKRS | |||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
BSCHL | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ | |||
UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1 | UMSKS | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
DMBE2 | Amount in Second Local Currency | DMBE2 | CURR | 13(2) | WERT7 | ||||
DMBE3 | Amount in Third Local Currency | DMBE3 | CURR | 13(2) | WERT7 | ||||
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
HWMET | Method with Which the Local Currency Amount Was Determined | HWMET | CHAR | 1 | HWMET | ||||
MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
MWST2 | Tax Amount in Second Local Currency | MWST2 | CURR | 13(2) | WERT7 | ||||
MWST3 | Tax Amount in Third Local Currency | MWST3 | CURR | 13(2) | WERT7 | ||||
WMWST | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
HWBAS | Tax Base Amount in Local Currency | HWBAS | CURR | 13(2) | WERT7 | ||||
FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR | 13(2) | WERT7 | ||||
MWART | Tax Type | MWART | CHAR | 1 | MWART | ||||
KURSR | Hedged Exchange Rate | KURSR | DEC | 9(5) | KURSP | ||||
GBETR | Hedged Amount in Foreign Currency | GBETR | CURR | 13(2) | WERT7 | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
ZINKZ | Exempted from interest calculation | DZINKZ | CHAR | 2 | ZINKZ | ||||
FDLEV | Planning level | FDLEV | CHAR | 2 | Assigned to domain | FDLEV | FFE | ||
FDGRP | Planning Group | FDGRP | CHAR | 10 | Assigned to domain | ALPHA | FDGRP | FFG | |
FDWBT | Planning amount in document currency | FDWBT | CURR | 13(2) | WERTV7 | ||||
FDTAG | Planning date | FDTAG | DATS | 8 | DATUM | FDT | |||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
VNAME | Joint Venture | JV_NAME | CHAR | 6 | Assigned to domain | ALPHA | JV_NAME | JVV | |
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | Assigned to domain | ALPHA | JV_EGROUP | GJE | |
BTYPE | Payroll Type | JV_BILIND | CHAR | 2 | Assigned to domain | ALPHA | JV_BILIND | ||
XUMSW | Indicator: Sales-related item ? | XUMSW | CHAR | 1 | XFELD | ||||
XCPDD | Indicator: Address and bank data set individually | XCPDD | CHAR | 1 | XFELD | ||||
XZEMP | Indicator: Alternative payee in document allowed ? | XZEMP | CHAR | 1 | XFELD | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
HZUON | Assignment Number for Special G/L Accounts | HZUON | CHAR | 18 | ZUONR | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
XSKFB | Indicator: Calculate amounts qualifying for cash discount ? | XSKFB | CHAR | 1 | XFELD | ||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
SKNTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | Assigned to domain | ZLSCH | |||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | Assigned to domain | ZAHLS | SPE | ||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | Assigned to domain | LZBKZ | |||
LANDL | Supplying Country | LANDL | CHAR | 3 | Assigned to domain | LAND1 | |||
DIEKZ | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | DIEKZ | ||||
VRSKZ | Insurance indicator | VRSKZ | CHAR | 1 | CHAR1 | ||||
VRSDT | Insurance date | VRSDT | DATS | 8 | DATUM | ||||
BLNBT | Base Amount for Determining the Preference Amount | BLNBT | CURR | 13(2) | WERT7 | ||||
BLNKZ | Subsidy indicator for determining the reduction rates | BLNKZ | CHAR | 2 | Assigned to domain | BLNKZ | |||
BLNPZ | Preference Percentage Rate | BLNPZ | DEC | 7(2) | PRZ52 | ||||
MSCHL | Dunning key | MSCHL | CHAR | 1 | Assigned to domain | MSCHL | |||
MANSP | Dunning block | MANSP | CHAR | 1 | Assigned to domain | MANSP | |||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
XHKOM | Indicator: G/L account assigned manually ? | XHKOM | CHAR | 1 | XFELD | ||||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
VBEWA | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
SWAER | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
ANFBN | Document Number of the Bill of Exchange Payment Request | ANFBN | CHAR | 10 | ALPHA | BELNR | |||
ANFBJ | Fiscal Year of the Bill of Exchange Payment Request Document | ANFBJ | NUMC | 4 | GJAHR | GJAHR | |||
ANFBU | Company Code in Which Bill of Exch.Payment Request Is Posted | ANFBU | CHAR | 4 | T001 | BUKRS | |||
ANFAE | Bill of Exchange Payment Request Due Date | ANFAE | DATS | 8 | DATUM | ||||
EGMLD | Reporting Country for Delivery of Goods within the EU | EGMLD_BSEZ | CHAR | 3 | Assigned to domain | LAND1 | |||
XEGMD | EC reporting country deleted | XEGMD | CHAR | 1 | XFELD | ||||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XZANF | Indicator: Payment demand | XZANF | CHAR | 1 | XFELD | ||||
XFDIS | Indicator: Cash Management activated? | XFDIS | CHAR | 1 | XFELD | ||||
RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | T053R | RSTGR | |||
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | Assigned to domain | DTWSX | |||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
IDXSP | Inflation Index | J_1AINDXSP | CHAR | 5 | J_1AINFT20 | J_1AINDXP | |||
CHWRB | Document Parking: Amount not Modifiable | CHWRB | CHAR | 1 | CHAR1 | ||||
KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND | ||||
VBKPFWAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
VBKPFHWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
VBKPFHWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 5 | Assigned to domain | WAERS | |||
VBKPFHWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 5 | Assigned to domain | WAERS |
Key field | Non-key field |
How do I retrieve data from SAP structure VPSOSEGD using ABAP code?
As VPSOSEGD 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 VPSOSEGD as there is no data to select.How to access SAP table VPSOSEGD
Within an ECC or HANA version of SAP you can also view further information about VPSOSEGD 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