INVOICE_S_PRT_ITEM_DETAIL SAP (Items Detail for PDF Print) Structure details
Description: Items Detail for PDF Print
Related tables to INVOICE_S_PRT_ITEM_DETAIL
Access table INVOICE_S_PRT_ITEM_DETAIL
Structure field list including key, data, relationships and ABAP select examples
INVOICE_S_PRT_ITEM_DETAIL 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 "Items Detail for PDF Print" 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_INVOICE_S_PRT_ITEM_DETAIL TYPE INVOICE_S_PRT_ITEM_DETAIL.
The INVOICE_S_PRT_ITEM_DETAIL table consists of various fields, each holding specific information or linking keys about Items Detail for PDF Print data available in SAP. These include POSNR (Item number of the SD document), POSEX (Item Number of the Underlying Purchase Order), POSPA (Item number in the partner segment), MATNR (Material Number).. 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 (Deep)
SAP INVOICE_S_PRT_ITEM_DETAIL 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 |
VBDPR | 0 | ||||||||
POSNR | Item number of the SD document | POSNR | NUMC | 6 | POSNR | ||||
POSEX | Item Number of the Underlying Purchase Order | POSEX | CHAR | 6 | ALPHA | POSEX | |||
POSPA | Item number in the partner segment | POSPA | NUMC | 6 | POSNR | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MATN1 | MATNR | MAT | S_MAT1 | |
MATWA | Material entered | MATWA | CHAR | 18 | MATN1 | MATNR | MAT | ||
IDNKD | Material Number Used by Customer | MATNR_KU | CHAR | 35 | IDNEX | ||||
ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
BRGEW | Gross weight | BRGEW_15 | QUAN | 15(3) | MENG15 | ||||
NTGEW | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | CUNIT | MEINS | |||
VOLUM | Volume | VOLUM_15 | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | CUNIT | MEINS | |||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | WAERS | FWS | |||
NETPR | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
KURSK_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KMEIN | Condition unit | KMEIN | UNIT | 3 | CUNIT | MEINS | |||
FKIMG | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | CUNIT | MEINS | |||
KUNWE | Ship-to party | KUNWE | CHAR | 10 | ALPHA | KUNNR | |||
ANRED_WE | Title | ANRED | CHAR | 15 | TEXT15 | ||||
ADRNR_WE | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
ADRNP_WE | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
ADDRESS_TYPE_WE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
NAME1_WE | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2_WE | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3_WE | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4_WE | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
STRAS_WE | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH_WE | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PFORT_WE | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
PSTL2_WE | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
LAND1_WE | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
SPRAS_WE | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
PSTLZ_WE | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT01_WE | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02_WE | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
REGIO_WE | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
TDNAME | Name | TDOBNAME | CHAR | 70 | TDOBNAME | ||||
VBELN_VL | Delivery | VBELN_VL | CHAR | 10 | ALPHA | VBELN | VL | ||
POSNR_VL | Delivery Item | POSNR_VL | NUMC | 6 | POSNR | ||||
ABLAD | Unloading Point | ABLAD | CHAR | 25 | TEXT25 | ||||
LFDAT | Delivery date | LFDAT | DATS | 8 | DATUM | ||||
LEDAT | Delivery Creation Date | LEDAT | DATS | 8 | DATUM | ||||
VBELN_VAUF | Order | VBELN_VAUF | CHAR | 10 | ALPHA | VBELN | AUF | ||
POSNR_VAUF | Sales Document Item | POSNR_VA | NUMC | 6 | POSNR | APO | |||
VGTYP_VAUF | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
AUDAT | Sales order date | AUDAT_VAUF | DATS | 8 | DATUM | ||||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | ALPHA | VBELN | |||
VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | POSNR | ||||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | BSTNK | ||||
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 | ||||
VKBUR | Sales Office | VKBUR | CHAR | 4 | VKBUR | VKB | |||
VSART | Shipping type | VERSART | CHAR | 2 | VERSART | ||||
VSART_BEZ | Description of the Shipping Type | VERSARTBEZ | CHAR | 20 | TEXT20 | ||||
SKFBP | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
UEPOS | Higher-level item in bill of material structures | UEPOS | NUMC | 6 | POSNR | ||||
CUOBJ | Configuration | CUOBJ_VA | NUMC | 18 | CUOBJ | ||||
CUOBJ_CH | Internal object number of the batch classification | CUOBJ_CH | NUMC | 18 | CUOBJ | ||||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | CHARG | CHA | |||
PMATN | Pricing Reference Material | PMATN | CHAR | 18 | MATN1 | MATNR | MAT | ||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | UMBSZ | ||||
UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | UMBSN | ||||
VBELN_VAG | Sales and Distribution Document Number | VBELN | CHAR | 10 | ALPHA | VBELN | AUN | ||
POSNR_VAG | Item number of the SD document | POSNR | NUMC | 6 | POSNR | ||||
AGDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
VBELN_VKT | Sales and Distribution Document Number | VBELN | CHAR | 10 | ALPHA | VBELN | AUN | ||
POSNR_VKT | Item number of the SD document | POSNR | NUMC | 6 | POSNR | ||||
KTDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
VBELN_VG2 | Sales and Distribution Document Number | VBELN | CHAR | 10 | ALPHA | VBELN | AUN | ||
POSNR_VG2 | Item number of the SD document | POSNR | NUMC | 6 | POSNR | ||||
G2DAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
VGTYP | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
SUGRD | Reason for material substitution | SUGRD | CHAR | 4 | SUGRD | VDG | |||
SUDRU | Original entry will be printed | SUDRU | CHAR | 1 | XFELD | ||||
FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | FPLNR | ||||
FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | NUMC | 6 | FPLTR | ||||
VBELV | Originating document | VBELV | CHAR | 10 | ALPHA | VBELN | |||
POSNV | Originating item | POSNV | NUMC | 6 | POSNR | ||||
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | EXNUM | ||||
EXPOS | Internal item number for foreign trade data in MM and SD | EXPOS | NUMC | 6 | EXPOS | ||||
STAWN | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | STAWN | ||||
EXPRF | Export/Import Procedure for Foreign Trade | EXPRF | CHAR | 8 | EXPRF | ||||
EXART | Business Transaction Type for Foreign Trade | EXART | CHAR | 2 | EXART | EXA | |||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | LAND1 | LND | |||
HERKR | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | REGIO | ||||
GRWRT | Statistical value for foreign trade | GRWRT | CURR | 13(2) | GRWRT | ||||
HERTI | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
HERTA | Departure country (country from which the goods are sent) | ALAND | CHAR | 3 | LAND1 | VAL | |||
STXT1 | Description of commodity code - First line | STXT1 | CHAR | 40 | CHAR40 | ||||
STXT2 | Description of commodity code - Second line | STXT2 | CHAR | 40 | CHAR40 | ||||
STXT3 | Description of commodity code - Third line | STXT3 | CHAR | 40 | CHAR40 | ||||
STXT4 | Description of commodity code - Fourth line | STXT4 | CHAR | 40 | CHAR40 | ||||
STXT5 | Description of commodity code - Fifth line | STXT5 | CHAR | 40 | CHAR40 | ||||
STXT6 | Description of commodity code - Sixth line | STXT6 | CHAR | 40 | CHAR40 | ||||
STXT7 | Description of commodity code - Seventh line | STXT7 | CHAR | 40 | CHAR40 | ||||
BEMAS | Supplementary unit | BEMEH | UNIT | 3 | CUNIT | MEINS | |||
PREFE | Preference indicator in export/import | PREFE | CHAR | 1 | PREFE | ||||
BOLNR | Bill of lading | BOLNR | CHAR | 35 | CHAR35 | ||||
TRATY | Means-of-Transport Type | TRATY | CHAR | 4 | TRATY | ||||
TRAID | Means of Transport ID | TRAID | CHAR | 20 | TRAID | ||||
HERBL | State of manufacture | HERBL | CHAR | 2 | HERBL | ||||
BMGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
MOWNR | CAP: Number of CAP products list | MOWNR | CHAR | 12 | MOWNR | ||||
GPNUM | Production statistics: PRODCOM number for foreign trade | GPNUM | CHAR | 9 | GPNUM | ||||
CASNR | CAS number for pharmaceutical products in foreign trade | CASNR | CHAR | 15 | CASNR | ||||
STEUC | Control code for consumption taxes in foreign trade | STEUC | CHAR | 16 | STEUC | ||||
WZOLL | Customs val. in doc.currency in imp.procg for foreign trade | WZOLL | CURR | 13(2) | GRWRT | ||||
VERLD | Country of dispatch for Foreign Trade | VERLD | CHAR | 3 | LAND1 | ||||
HANLD | Trading country for foreign trade | HANLD | CHAR | 3 | LAND1 | ||||
TEXT1 | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
TEXT2 | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
TEXT3 | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
COKON | Customs quota code for import processing in foreign trade | COKON | CHAR | 6 | COKON | ||||
COPHA | Pharmaceutical products code (Foreign Trade) | COPHA | CHAR | 6 | COPHA | ||||
COADI | Anti-dumping code for import processing in foreign trade | COADI | CHAR | 6 | COADI | ||||
PRONU | Invoice: Number of invoice document for import processing | PRONU | CHAR | 25 | PRONU | ||||
PRODA | Invoice: Date of invoice document for import processing | PRODA | DATS | 8 | DATUM | ||||
VORPA | Preliminary document: Document type for foreign trade procg | VORPA | CHAR | 10 | VORPA | ||||
VORNU | Preliminary document: No. of preliminary doc.f.import procg | VORNU | CHAR | 25 | CHAR25 | ||||
VORDA | Preliminary document: Date of preliminary doc.f.import procg | VORDA | DATS | 8 | DATUM | ||||
BEHOE | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | BEHOE | ||||
KENNU | Preliminary document: Customs office/ID number for import | KENNU | CHAR | 6 | CHAR06 | ||||
VOISO | Prelim. doc.: ISO code of ctry issuing the preliminary doc. | VOISO | CHAR | 2 | INTCA | ||||
PREFA | Preference: Preference type for foreign trade | PREFA | CHAR | 10 | PREFA | ||||
PREFN | Preference: Official number of preference document - Import | PREFN | CHAR | 25 | CHAR25 | ||||
PREDU | Preference: Date of preference document for import procg | PREDU | DATS | 8 | DATUM | ||||
PRISO | Preference: ISO code of country issuing the preference doc. | PRISO | CHAR | 2 | INTCA | ||||
PRHOE | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | BEHOE | ||||
PRUEL | Preference: Validity date of preference document for import | PRUEL | DATS | 8 | DATUM | ||||
NACAR | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | NACAR | ||||
NACNU | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACDA | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAISO | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHOE | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | BEHOE | ||||
NAUEL | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA2 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | NACAR | ||||
NACN2 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD2 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS2 | Preference: ISO code of country issuing the preference doc. | PRISO | CHAR | 2 | INTCA | ||||
NAHO2 | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | BEHOE | ||||
NAUE2 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA3 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | NACAR | ||||
NACN3 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD3 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS3 | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHO3 | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | BEHOE | ||||
NAUE3 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA4 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | NACAR | ||||
NACN4 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD4 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS4 | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHO4 | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | BEHOE | ||||
NAUE4 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA5 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | NACAR | ||||
NACN5 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD5 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS5 | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHO5 | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | BEHOE | ||||
NAUE5 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
EXDAR | Export document: Export document type for foreign trade | EXDAR | CHAR | 10 | VORPA | ||||
EXDAA | Export document: Official number of export document | EXDAA | CHAR | 25 | CHAR25 | ||||
EXDAB | Export document: Valid-to number of export document | EXDAB | CHAR | 25 | CHAR25 | ||||
EXDTA | T document: Type of T document for foreign trade | EXDTA | CHAR | 10 | VORPA | ||||
EXDT2 | T document: Official number of T document for foreign trade | EXDT2 | CHAR | 25 | CHAR25 | ||||
EXDTB | T doc.: Official no. for next page of T doc. f.foreign trade | EXDTB | CHAR | 25 | CHAR25 | ||||
EXDPA | Preference: Preference type for foreign trade | EXDPA | CHAR | 10 | PREFA | ||||
EXPRE | Preference: Official number of preference document - Export | EXPRE | CHAR | 25 | CHAR25 | ||||
EXDT5 | CAP: Official number of T5 document for foreign trade | EXDT5 | CHAR | 25 | CHAR25 | ||||
COIMP | Code number for import processing in foreign trade | COIMP | CHAR | 17 | STAWN | COI | |||
GBNUM | Foreign Trade:Customs declaration list no. for Foreign Trade | GB_NR | CHAR | 20 | CHAR20 | ||||
REGNR | Registration number for import processing in foreign trade | RG_NR | CHAR | 20 | CHAR20 | ||||
PRENC | Exemption certificate: Indicator for legal control | PRENC | CHAR | 1 | PRENC | ||||
PRENO | Exemption certificate number for legal control | PRENN | CHAR | 8 | PRENN | ||||
PREND | Exemption certificate: Issue date of exemption certificate | PREND | DATS | 8 | PREND | ||||
WKREG | Region in which plant is located | WKREG | CHAR | 3 | REGIO | ||||
IMPMA | Second unit of measurement | IMPMA | UNIT | 3 | CUNIT | MEINS | |||
IMGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1 | XFELD | ||||
UECHA | Higher-Level Item of Batch Split Item | UECHA | NUMC | 6 | POSNR | ||||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | ALPHA | KOSTL | KOS | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | KONPR | PS_POSNR | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | ALPHA | PRCTR | PRC | PRCTR_EMPTY | |
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | ALPHA | PRCTR | PPC | ||
GSBER | Business Area | GSBER | CHAR | 4 | GSBER | GSB | |||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | GSBER | GSB | |||
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | BSARK | ||||
BSTKD_E | Ship-to Party's Purchase Order Number | BSTKD_E | CHAR | 35 | BSTKD | ||||
BSTDK_E | Ship-to party's PO date | BSTDK_E | DATS | 8 | DATUM | ||||
BSARK_E | Ship-to party purchase order type | BSARK_E | CHAR | 4 | BSARK | ||||
IHREZ_E | Ship-to party character | IHREZ_E | CHAR | 12 | TEXT12 | ||||
POSEX_E | Item Number of the Underlying Purchase Order | POSEX_E | CHAR | 6 | ALPHA | POSEX | |||
VBKLT | SD document indicator | VBKLT | CHAR | 1 | VBKLT | ||||
SHKZG | Returns item | SHKZG_VF | CHAR | 1 | SHKZG_VF | ||||
AUTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
FAREG | Rule in billing plan/invoice plan | FAREG | CHAR | 1 | FAREG | ||||
MWSBP | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
PSTYV | Sales document item category | PSTYV | CHAR | 4 | PSTYV | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TXJCD | TXJ | |||
VKAUS | Usage Indicator | ABRVW | CHAR | 3 | ABRVW | ||||
STEUCL | Control code for consumption taxes in foreign trade | STEUC | CHAR | 16 | STEUC | ||||
J_1ARFZ | Reason for zero VAT | J_1ARFZVAT | CHAR | 1 | J_1ARFZVAT | ||||
KBETRL | Rate (condition amount or percentage) where no scale exists | KBETR_KOND | CURR | 11(2) | WERTV6 | ||||
MATNR_VG2 | Material Number | MATNR | CHAR | 18 | MATN1 | MATNR | MAT | S_MAT1 | |
FKIMG_VG2 | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
VRKME_VG2 | Sales unit | VRKME | UNIT | 3 | CUNIT | MEINS | |||
NETWR_VG2 | Net value of the billing item in document currency | NETWR_FP | CURR | 15(2) | WERTV8 | ||||
MWSBP_VG2 | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
BRTWR_VG2 | Gross value of the billing item in document currency | BRTWR_FP | CURR | 15(2) | WERTV8 | ||||
NETPR_VG2 | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
MWSPR_VG2 | Rate (condition amount or percentage) | KBETR | CURR | 11(2) | WERTV6 | ||||
J_1ARFZ_VG2 | Reason for zero VAT | J_1ARFZVAT | CHAR | 1 | J_1ARFZVAT | ||||
XBLNR_VL | Reference Document Number | XBLNR_LIKP | CHAR | 25 | XBLNR_LIKP | ||||
LIFNR_CONSIGNOR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | ALPHA | LIFNR | LIF | KRED_C | |
NETPRL | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
MWSKL | Tax on sales/purchases code | MWSKZ | CHAR | 2 | MWSKZ | ||||
BRTWR | Gross value of the billing item in document currency | BRTWR_FP | CURR | 15(2) | WERTV8 | ||||
KOWRR | Statistical values | KOWRR | CHAR | 1 | KOWRR | ||||
FKLMG | Billing quantity in stockkeeping unit | FKLMG | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | CUNIT | MEINS | |||
WERKS | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
PRCTR_IV | Profit Center | PRCTR | CHAR | 10 | ALPHA | PRCTR | PRC | PRCTR_EMPTY | |
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
MSR_ID | Process Identification Number | MSR_PROCESS_ID | CHAR | 10 | ALPHA | MSR_PROCESS_ID | |||
MSR_ITEM | Item Number | MSR_PROCESS_ITEM | NUMC | 6 | MSR_PROCESS_ITEM | ||||
RMA_CUSTOMER | Customer RMA Number | MSR_CRMA_NR | CHAR | 20 | MSR_RMA_NR | ||||
MSR_RET_REASON | Return Reason | MSR_RETURNS_REASON | CHAR | 3 | MSR_RETURNS_REASON | ||||
MSR_RET_REASON_TEXT | Return Reason Description | MSR_RET_REASON_TEXT | CHAR | 60 | TEXT60 | ||||
MSR_MAT_RECEIVED | Material Received | MSR_MATERIAL_RECEIVED | CHAR | 1 | XFELD | ||||
MSR_FU_CODE | Follow-Up Activity Code | MSR_FU_CODE | CHAR | 4 | MSR_FU_CODE | ||||
MSR_FU_CODE_TEXT | Follow-Up Activity Description | MSR_FU_CODE_TEXT | CHAR | 60 | TEXT60 | ||||
MSR_FORW_VENDOR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | ALPHA | LIFNR | LIF | KRED_C | |
MSR_FWV_TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
MSR_FWV_ADDRNUM | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
MSR_FWV_NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_NAME3 | Name 3 | AD_NAME3 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_NAME4 | Name 4 | AD_NAME4 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
MSR_FWV_PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
MSR_FWV_PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
MSR_FWV_CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
MSR_FWV_COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
MSR_FWV_LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
MSR_FWV_POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
MSR_FWV_CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
MSR_FWV_CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
MSR_FWV_REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
RMA_VENDOR | Vendor RMA Number | MSR_VRMA_NR | CHAR | 20 | MSR_RMA_NR | ||||
MSR_INSP_CODE | Inspection Code | MSR_INSPECTION_CODE | CHAR | 4 | QCODE | ||||
MSR_INSP_CODE_TX | Inspection Comment | MSR_INSPECTION_COMMENT | CHAR | 40 | MSR_INSPECTION_COMMENT | ||||
MSR_REFUND_CODE | Returns Refund Code | MSR_RETURNS_REFUND_CODE | CHAR | 3 | MSR_RETURNS_REFUND_CODE | ||||
MSR_REFUND_CODE_TEXT | Refund Code Description | MSR_REFUND_CODE_TEXT | CHAR | 60 | TEXT60 | ||||
MSR_FORW_PLANT1 | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
MSR_PLANT1_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
MSR_FORW_PLANT2 | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
MSR_PLANT2_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
MSR_FORW_PLANT3 | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
MSR_PLANT3_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
MSR_SPLIT | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
VBELN_VF_REVERSED | Reversed Billing Document | VBELN_VF_REVERSED | CHAR | 10 | ALPHA | VBELN | |||
POSNR_VF_REVERSED | Reversed Billing Item | POSNR_VF_REVERSED | NUMC | 6 | POSNR | ||||
POSNR_VF_PARTNER | Partner Billing Item | POSNR_VF_PARTNER | NUMC | 6 | POSNR | ||||
.INCLU--AP | 0 | ||||||||
/BEV1/EMMVGR1 | Material group 1 | MVGR1 | CHAR | 3 | MVGR1 | ||||
/BEV1/EMMVGR2 | Material group 2 | MVGR2 | CHAR | 3 | MVGR2 | ||||
/BEV1/EMMVGR3 | Material group 3 | MVGR3 | CHAR | 3 | MVGR3 | ||||
/BEV1/EMMVGR4 | Material group 4 | MVGR4 | CHAR | 3 | MVGR4 | ||||
/BEV1/EMMVGR5 | Material group 5 | MVGR5 | CHAR | 3 | MVGR5 | ||||
/BEV1/EMNEUPOS | Item number of the SD document | POSNR | NUMC | 6 | POSNR | ||||
/BEV1/EMPRODH | Product hierarchy | PRODH_D | CHAR | 18 | PRODH | VPR | |||
.INCLU--AP | 0 | ||||||||
BUMP | Specifies bump items, design item 8; Golden Gate | BUMP | CHAR | 1 | BUMP | ||||
STKEY | Origin of the bill of material | STKEY | CHAR | 1 | STKEY | ||||
CONDITIONS | 0 | ||||||||
CONFIGURATION | 0 | ||||||||
VGTYP_TEXT | Short Text for Fixed Values | VAL_TEXT | CHAR | 60 | DDTEXT | ||||
EX_CONDITIONS | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
EX_CONFIGURATION | Checkbox | XFELD | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP structure INVOICE_S_PRT_ITEM_DETAIL using ABAP code?
As INVOICE_S_PRT_ITEM_DETAIL 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 INVOICE_S_PRT_ITEM_DETAIL as there is no data to select.How to access SAP table INVOICE_S_PRT_ITEM_DETAIL
Within an ECC or HANA version of SAP you can also view further information about INVOICE_S_PRT_ITEM_DETAIL 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