SAP ABAP Table JFRPVB (Reference Structure for XJFRP/YJFRP)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
Table Category | INTTAB | Structure |
Structure | JFRPVB | Table Relationship Diagram |
Short Description | Reference Structure for XJFRP/YJFRP |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | IS-M/SD: Billing Document - Item Data | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | VBELN | ISPVBELN | ISPVBELN | CHAR | 10 | 0 | IS-M/SD: Billing Document | JFRK | |
4 | POSNR | ISPPOSNR | ISPPOSNR | NUMC | 6 | 0 | IS-M: Billing Item | * | |
5 | FKIMG | FKIMG | MENG13 | QUAN | 13 | 3 | Actual billed quantity | ||
6 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
7 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
8 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
9 | PRSDT | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
10 | FBUDA | FBUDA | DATUM | DATS | 8 | 0 | Date When Services Rendered | ||
11 | KURSK | KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
12 | NETWR | NETWR_FP | WERTV8 | CURR | 15 | 2 | Net value of the billing item in document currency | ||
13 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
14 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
15 | POSPA | ISPPOSPA | ISPPOSNR | NUMC | 6 | 0 | IS-M: Item Number of Partner Segment | JFRP | |
16 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
17 | ALAND | ALAND | LAND1 | CHAR | 3 | 0 | Departure country (country from which the goods are sent) | T005 | |
18 | WKREG | WKREG | REGIO | CHAR | 3 | 0 | Region in which plant is located | T005S | |
19 | WKCOU | WKCOU | CHAR3 | CHAR | 3 | 0 | County in which plant is located | ||
20 | WKCTY | WKCTY | CHAR4 | CHAR | 4 | 0 | City in which plant is located | ||
21 | TAXM1 | TAXM1 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
22 | TAXM2 | TAXM2 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
23 | TAXM3 | TAXM3 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
24 | TAXM4 | TAXM4 | TAXKM | CHAR | 1 | 0 | Tax Classification 4 Material | * | |
25 | TAXM5 | TAXM5 | TAXKM | CHAR | 1 | 0 | Tax classification 5 for material | * | |
26 | TAXM6 | TAXM6 | TAXKM | CHAR | 1 | 0 | Tax classification 6 for material | * | |
27 | TAXM7 | TAXM7 | TAXKM | CHAR | 1 | 0 | Tax classification 7 for material | * | |
28 | TAXM8 | TAXM8 | TAXKM | CHAR | 1 | 0 | Tax Classification 8 Material | * | |
29 | TAXM9 | TAXM9 | TAXKM | CHAR | 1 | 0 | Tax Classification 9 Material | * | |
30 | SKTOF | SKTOF | XFELD | CHAR | 1 | 0 | Cash discount indicator | ||
31 | SKFBP | SKFBP | WERTV7 | CURR | 13 | 2 | Amount eligible for cash discount in document currency | ||
32 | SPARA | SPART_AK | SPART | CHAR | 2 | 0 | Division for order header | TSPA | |
33 | SHKZG | SHKZG_VA | XFELD | CHAR | 1 | 0 | Returns Item | ||
34 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
35 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
36 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
37 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
38 | WAVWR | WAVWR | WERTV7 | CURR | 13 | 2 | Cost in document currency | ||
39 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
40 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
41 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
42 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
43 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
44 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
45 | STCUR | STCUR_AP | KURRF | DEC | 9 | 5 | Exchange rate for statistics (Exch.rate at time of creation) | ||
46 | UVPRS | UVPRS | XFELD | CHAR | 1 | 0 | Incomplete with respect to pricing | ||
47 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
48 | .INCLUDE | 0 | 0 | IS-M/SD: Item Data for Billing | |||||
49 | ISPAUART | AUART_ISP | AUART_ISP | CHAR | 4 | 0 | IS-M/SD: Sales Document Types | TJAK | |
50 | ISPAUAGRP | ISPAUAGRP | JAUARTGRP | CHAR | 1 | 0 | IS-M: Sales Document Type Grouping for Sales Order | ||
51 | ISPKOSTL_L | ISPKOSTL_L | KOSTL | CHAR | 10 | 0 | IS-M: Cost Center to be Charged | * | |
52 | ISPDRERZ | DRERZ | DRERZ | CHAR | 8 | 0 | Publication | JDTDRER | |
53 | ISPPVA | PVA | PVA | CHAR | 8 | 0 | Edition | JDTPVA | |
54 | ISPBEZ | BEZUGSTYP_JE_PVA | BEZUGSTYP_JE_PVA | CHAR | 2 | 0 | Mix Type | JDTBEZTYP | |
55 | ISPLIFART | LIEFERART | LIEFERART | CHAR | 2 | 0 | Delivery Type | TJV01 | |
56 | ISPDRUCK | ISPDRUCK | WERKS | CHAR | 4 | 0 | IS-M: Plant (Printing Works) | T001W | |
57 | ISPGUTSCH | ISPGUTSCH | GUTSCHEIN | NUMC | 8 | 0 | IS-M: Coupon Number | ||
58 | ISPXLOGO | XLOGO | XFELD | CHAR | 1 | 0 | Print Logo | ||
59 | ISPPVAKNTG | ISPPVAKNTG | KTGRM | CHAR | 2 | 0 | IS-M: Account Assignment Grouping for Edition | TVKM | |
60 | ISPPVAKONG | ISPPVAKONG | KONDM | CHAR | 2 | 0 | IS-M: Edition Condition Grouping | T178 | |
61 | ISPPVABONG | ISPPVABONG | BONUS | CHAR | 2 | 0 | IS-M: Bonus Grouping for Edition | TVBO | |
62 | ISPFKPER | FKPER | FKPER | CHAR | 2 | 0 | Billing Frequency | TJK01 | |
63 | ISPPERFK | PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | TFACD | |
64 | ISPZAHLW | JZAHLW | JZAHLW | CHAR | 1 | 0 | Billing method | ||
65 | ISPPOSEX | POSEX_ISP | POSEX_ISP | NUMC | 6 | 0 | External Item Number (Purchase Order Item) | ||
66 | ISPJPERIOD | JPERIOD | XFELD | CHAR | 1 | 0 | IS-M: Periodic settlement | ||
67 | ISPVBELN | AVNR | AVNR | CHAR | 10 | 0 | IS-M/SD: Publishing Sales Order | JKAK | |
68 | ISPPOSNR | APNR | APNR | NUMC | 6 | 0 | Sales Order Item | JKAP | |
69 | ISPETENR | JAENR | AENR | NUMC | 4 | 0 | Sales Order Schedule Line | JKEP | |
70 | ISPETEEX | ETEEX_ISP | ETEEX | NUMC | 6 | 0 | IS-M: External Schedule Line Number | ||
71 | ISPETART | ETART_ISP | ETART_ISP | CHAR | 2 | 0 | Schedule Line Type for Internal Sales Order Schedule Line | TJEP | |
72 | ISPETMENGE | ETMENGE | MENGGPOS | QUAN | 10 | 0 | IS-M: Sales Order Schedule Line Quantity | ||
73 | ISPETMEINS | ETMEINS | MEINS | UNIT | 3 | 0 | IS-M: Sales Unit for Sales Order | T006 | |
74 | ISPETVOR | ISPETVOR | VORZEI | CHAR | 1 | 0 | IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order | ||
75 | ISPKPOSN | KPOSN | NUM6 | NUMC | 6 | 0 | Condition Item Number | ||
76 | ISPPRBAS | ISPPRBAS | PRBAS_ISP | CHAR | 1 | 0 | IS-M: Price Basis | ||
77 | ISPPRSPER | ISPPRSPER | PRSPER | CHAR | 2 | 0 | IS-M: Price Frequency | TJK03 | |
78 | ISPBZPERF | ISPBZPERF | BEZPER | CHAR | 5 | 0 | IS-M: Service Type for Billing | TJD09 | |
79 | ISPPRSMLT | ISPPRSMLT | PRSMLT | DEC | 5 | 0 | IS-M: Numerator in Conversion Factor for Frequencies | ||
80 | ISPPRSDIV | ISPPRSDIV | PRSDIV | DEC | 5 | 0 | IS-M: Denominator for Frequency Conversion Factor | ||
81 | ISPAEART | ISPAEART | AEART_JSDK | CHAR | 1 | 0 | IS-M: Order Change Type | ||
82 | ISPANZET | ISPANZET | ANZET | DEC | 5 | 0 | IS-M: Number of Publication Dates | ||
83 | ISPERSDAT | ERSCHDAT | DATUM | DATS | 8 | 0 | Publication Date | ||
84 | ISPWRBAKT | WERBEAKT | WERBEAKT | CHAR | 8 | 0 | Sales Promotion | TJWAK | |
85 | ISPFAKVON | FAKVON | DATUM | DATS | 8 | 0 | IS-M: Billing Period From | ||
86 | ISPFAKBIS | FAKBIS | DATUM | DATS | 8 | 0 | IS-M: Billing Period To | ||
87 | ISPKONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | T188 | |
88 | ISPKDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | T151 | |
89 | ISPPOART | POART_ISP | POART_ISP | CHAR | 2 | 0 | Internal Item Type for Sales Order | TJAP | |
90 | ISPPRSANTZ | PRSANTZ | ISPWERT8 | DEC | 8 | 0 | IS-M: Numerator for proportional prices | ||
91 | ISPPRSANTN | PRSANTN | ISPWERT8 | DEC | 8 | 0 | IS-M: Denominator for proportional prices | ||
92 | ISPPRSANZP | PRSANZP | ISPWERT8 | DEC | 8 | 0 | IS-M: Number of periods in billing period | ||
93 | ISPBRTWR_P | ISPBRTWR | WERTV8 | CURR | 15 | 2 | IS-M: Gross Value in Document Currency | ||
94 | ISPPRBAS_V | PRBAS_VK | PRBAS_ISP | CHAR | 1 | 0 | Price Basis for Shipping Costs | ||
95 | ISPLAGRP_V | LANDGRP_VK | LANDGRP_VK | CHAR | 2 | 0 | Country grouping for shipping costs | TJG92 | |
96 | ISPXFKKOMP | XFKKOMP | XFELD | CHAR | 1 | 0 | Indicator: Perform Billing in Full for Billing Period | ||
97 | ISPXFKENDE | XFKENDE | XFELD | CHAR | 1 | 0 | Indicator: Billing at end of calculation | ||
98 | ISPSFPOS | XSEPFKPOS | XFELD | CHAR | 1 | 0 | Separate billing document for order item | ||
99 | ISPXKOMPP | XKOMPP | XFELD | CHAR | 1 | 0 | IS-M: Full period (billing) | ||
100 | ISPVERSDAT | VRSNDDATUM | DATUM | DATS | 8 | 0 | IS-M: Shipping Date | ||
101 | ISPLANDE | LANDE_ISP | LAND1 | CHAR | 3 | 0 | Current country being supplied | * | |
102 | ISPRKAUFNR | J_RK_AUFNR | J_RK_AUFNR | CHAR | 8 | 0 | Order Number of RK Order for Account Assignment | ||
103 | ISPRKPOSNR | J_RK_POSNR | J_RK_POSNR | NUMC | 2 | 0 | Item Number of RK Order for Account Assignment | ||
104 | ISPCOAUFNR | J_CO_AUFNR | AUFNR | CHAR | 12 | 0 | Order number of internal CO order for account assignment | AUFK | |
105 | ISPVAUSGB | VAUSGB | VAUSGB | CHAR | 10 | 0 | Issue | JDTVAUSGB | |
106 | ISPXFKBALF | XFKBASLIEF | XFELD | CHAR | 1 | 0 | IS-M: Billing based on delivery | ||
107 | ISPXFKBAAU | XFKBASAUFT | XFELD | CHAR | 1 | 0 | IS-M: Billing based on order | ||
108 | ISPVKBURZU | VKBURZUS | VKBUR | CHAR | 4 | 0 | Sales office responsible | * | |
109 | ISPXSTABGR | JXMWSTABGR | XFELD | CHAR | 1 | 0 | VAT to be accrued proportionally for payment in billing | ||
110 | ISPXIMMAT | XIMMATRIK | XFELD | CHAR | 1 | 0 | Indicator: Proof of matriculation provided | ||
111 | ISPIMMATD | IMMATDAT | DATUM | DATS | 8 | 0 | Matriculation Certificate Valid To | ||
112 | ISPXFKRUEK | XFKRUECK | XFELD | CHAR | 1 | 0 | IS-M: Retroactive Billing of Period Already Billed | ||
113 | ISPIVWKN | IVWKN | IVWKN | CHAR | 8 | 0 | Circulation Audit Report Category ID | * | |
114 | ISPXIVW | XIVW | XFELD | CHAR | 1 | 0 | Indicator: Relevant for audit report | ||
115 | ISPJKPAVRG | JKPAVONREG | DATUM | DATS | 8 | 0 | Normal Start of Address Validity for Retro.Order Items | ||
116 | ISPJKPABRG | JKPABISREG | DATUM | DATS | 8 | 0 | End of Address Validity if End of Billing Delayed | ||
117 | XNEGOPTION | XNEGOPTION | XFELD | CHAR | 1 | 0 | IS-M: Item with Automatic Transformation to Chargeable | ||
118 | IVWDATUM | IVWDATUM | DATUM | DATS | 8 | 0 | Date of Audit Report for Returns | ||
119 | CAMPAIGN | ISM_MARKETING_CAMPAIGN | ISM_MARKETING_CAMPAIGN | RAW | 16 | 0 | IS-M: Marketing Campaign | ||
120 | ISPBDPER | BDPER | DATUM | DATS | 8 | 0 | IS-M: Basic Date for Billing Frequency | ||
121 | FKPERVON | FKPERVON | DATUM | DATS | 8 | 0 | IS-M: Initial Date of Full Billing Period | ||
122 | FKPERBIS | FKPERBIS | DATUM | DATS | 8 | 0 | IS-M: Closing Date of Full Billing Period | ||
123 | ISPZSKLS | JZSKLS | JZSKLS | CHAR | 1 | 0 | Time slice classification for sales order | ||
124 | ISPWRBART | WERBEART | WERBEART | CHAR | 4 | 0 | Sales Source | TJWAR | |
125 | POSNR_UR | APNR_UR | APNR | NUMC | 6 | 0 | Original Item in Publishing Sales Order | * | |
126 | CYCLENR | CYCLENR | CYCLENR | NUMC | 3 | 0 | IS-M/SD: Billing Cycle Number | * | |
127 | FAKNRRUECK | ISPFAKNRRUECK | ISPVBELN | CHAR | 10 | 0 | IS-M: Recalculated Billing Document | * | |
128 | XFIXED | XINDEXFIXED | XFELD | CHAR | 1 | 0 | Indicator: Billing Index Fixed and Cannot be Deleted | ||
129 | RCODE | RATE_CODE | RATE_CODE | CHAR | 4 | 0 | IS-M/SD: Rate Code | * | |
130 | XAUTO_REN | XAUTO_REN | XFELD | CHAR | 1 | 0 | IS-M/SD: Customer Requests Automatic Renewal | ||
131 | STBFREI | JSTBFREI | JSTBFREI | CHAR | 2 | 0 | Type of Tax Exemption | TJFSB | |
132 | XNFAK | ISPXNFAK | XFELD | CHAR | 1 | 0 | IS-M: Indicator - Repeat Billing After Reversal | ||
133 | DELIVSPLIT | DELIVSPLIT | DELIVSPLIT | CHAR | 8 | 0 | IS-M/SD: Alternating Address Element | TJD23 | |
134 | DELIVSPLITGRP | DELIVSPLITGRP | DELIVSPLITGRP | CHAR | 10 | 0 | IS-M/SD: Address Alternation Group | TJD63 | |
135 | POSNR_MAIN | APNR_MAIN | APNR | NUMC | 6 | 0 | IS-M/SD: Main Item in Sales Order | JKAP | |
136 | POSNR_SUB | APNR_SUB | APNR | NUMC | 6 | 0 | IS-M/SD: Sub-Item in Sales Order | JKAP | |
137 | .INCLUDE | 0 | 0 | IS-M/SD: Field String for Weekdays | |||||
138 | X_MONTAG | X_MONTAG | XFELD | CHAR | 1 | 0 | IS-M: Monday | ||
139 | X_DIENSTAG | X_DIENSTAG | XFELD | CHAR | 1 | 0 | IS-M: Tuesday | ||
140 | X_MITTWOCH | X_MITTWOCH | XFELD | CHAR | 1 | 0 | IS-M: Wednesday | ||
141 | X_DONNETAG | X_DONNETAG | XFELD | CHAR | 1 | 0 | IS-M: Thursday | ||
142 | X_FREITAG | X_FREITAG | XFELD | CHAR | 1 | 0 | IS-M: Friday | ||
143 | X_SAMSTAG | X_SAMSTAG | XFELD | CHAR | 1 | 0 | IS-M: Saturday | ||
144 | X_SONNTAG | X_SONNTAG | XFELD | CHAR | 1 | 0 | IS-M: Sunday | ||
145 | VBELN_FROM | AVNR | AVNR | CHAR | 10 | 0 | IS-M/SD: Publishing Sales Order | * | |
146 | POSNR_UR_FROM | APNR | APNR | NUMC | 6 | 0 | Sales Order Item | * | |
147 | CYCLENR_FROM | CYCLENR | CYCLENR | NUMC | 3 | 0 | IS-M/SD: Billing Cycle Number | * | |
148 | XPRICEALTER | XPRICEALTERNATION | XFELD | CHAR | 1 | 0 | Indicator: Generated Index for Price Change | ||
149 | REFUNDTYPE | REFUNDTYPE | REFUNDTYPE | CHAR | 2 | 0 | IS-M/SD: Refund Type | TJK19 | |
150 | XAUTO_ACCEPT | XAUTO_ACCEPT | XFELD | CHAR | 1 | 0 | IS-M/SD: Indicator - Accept Cycle Without Payment | ||
151 | BONUSTYPE | JBONUSTYPE | JBONUSTYPE | CHAR | 2 | 0 | IS-M/SD: Bonus Type | ||
152 | UPDKZ | UPDKZ_D | UPDKZ | CHAR | 1 | 0 | Update indicator | ||
153 | SELKZ | SELKZ | SELKZ | CHAR | 1 | 0 | Selection flag | ||
154 | DICHTINDEX | DICHTINDEX | SYST_LONG | INT4 | 10 | 0 | IS-M: Index for Setting Up (Summarized) Billing Flow | ||
155 | XPRICEJKEP | XFELD | XFELD | CHAR | 1 | 0 | Checkbox |
Foreign Keys
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |