ZF2INVPI - Grouping of position data
Column name | Profil | Status | Column definition | Column description | Technical term | Example |
|---|---|---|---|---|---|---|
| PIKEY | x | VARCHAR(15) | Internal pagination number (i-effect Spalte) | Internal invoice number | ||
| Grouping of general position specifications (required) | ||||||
| PIREF | x | required | DECIMAL(5, 0) | Positionnumber | Identification of the invoice item | |
| PILISTCO | x | optional | VARCHAR(15) | Type of the LinePosition | Type of invoice item (code) | |
| PILISTRECO | x | optional | VARCHAR(15) | Under type of the Line Position | Subtype of invoice item | |
| Detailed information on free text for the item (optional) | ||||||
Note table ZF2INVTX. | ||||||
| Artikelinformationen (erforderlich) | ||||||
| PIPPPGIC | x | optional | VARCHAR(35) | Global identifier of the Product | Global identifier of the product | |
| PIPPPSID | x | required if PIPPPGIC is filled | CHAR(5) | Type of global article number | Type of global article number | |
| PIPPPSAII | x | optional | VARCHAR(35) | Product number of the Seller | Seller's part number | |
| PIPPPBAII | x | optional | VARCHAR(35) | Product number of the Buyer | Item number of the buyer | |
| PIPPPNT | x | required | VARCHAR(255) | Product name | Article description | |
| PIPPPDT | x | optional | VARCHAR(255) | Product description | Article description | |
| Article attribut (optional) | ||||||
| Note table ZF2INVPP. | ||||||
| Detailed information on product classification (optional) | ||||||
| Note table ZF2INVPC. | ||||||
| Detailed information on product origin (optional) | ||||||
| PIPPPOTC | x | required | CHAR(2) | Origin Trade Country | Article country of origin | |
| Detailinformationen zu enthaltenen Produkten (optional) | ||||||
| Note table ZF2INVIP. | ||||||
| Detailinformationen zum Preis (required) | ||||||
| Detailangaben zur zugehörigen Bestellung (optional) | ||||||
| PIDOIIO | x | optional | VARCHAR(35) | Order number | Order number | |
| PIDOLIO | x | optional | INTEGER | Order position | Order item | |
| PIDOIDTO | x | optional | DATE '0001-01-01' | Order date | Order date | |
| Details of the associated contract (optional) | ||||||
| PICOIIC | x | optional | VARCHAR(35) | Contract number | Contract number | |
| PICOLIC | x | optional | INTEGER | Contract position | Contract item | |
| PICOIDTC | x | optional | DATE '0001-01-01' | Contract date | Contract date | |
| Details of an additional document reference (optional) | ||||||
Note table ZF2INVDR. | ||||||
| Detailed information on the gross price of the article (optional) | ||||||
| PIGPCA | x | required | DECIMAL(15, 4) | Gross price | Gross price of the article | |
| PIGPBQ | x | optional | INTEGER | Price base amount | Base quantity at item price | 1, 10, 100 |
| PIGPBQU | x | required if PIGPBQ is available | CHAR(5) | Type of Price base amount | Code for the unit of measurement of the base quantity at item price | LTR = Liter (1 dm3) MTQ = Cubic meters KGM = Kilogram MTR = Meter PCE = piece TNE = Ton |
| Detailed information on surcharges and discounts (optional) | ||||||
| Note table ZF2INVAC. | ||||||
| Detailed information on the net price of the article (required) | ||||||
| PINPCA | x | required | DECIMAL(15, 4) | Net price | Net price of the article | |
| PINPBQ | x | optional | INTEGER | Price base amount | Base quantity at item price | 1, 10, 100 |
| PINPBQU | x | required wenn PINPBQ vorhanden ist. | CHAR(5) | Type of Price base amount | Code for the unit of measurement of the base quantity at item price | LTR = Liter (1 dm3) MTQ = Cubic meters KGM = Kilogram MTR = Meter PCE = piece TNE = Ton |
| Included tax for B2C (optional) | ||||||
| PITAXA | x | required | DECIMAL(15, 2) | Tax amount calculated | Included tax for B2C | |
| PITAXT | x | required | CHAR(5) | Type of Tax | Included tax for B2C | |
| PITAXFT | x | optional | VARCHAR(255) | Reason for tax exemption | Included tax for B2C | |
| PITAXCAT | x | required | CHAR(2) | Tax category | Included tax for B2C | |
| PITAXFTC | x | optional | CHAR(5) | Reason for tax exemption (CODE) | Code for the reason for exemption from turnover tax | |
| PITAXPER | x | required | DECIMAL(6, 2) | Tax rate | Included tax for B2C | |
| UltimateCustomerOrderReferencedDocument (optional) | ||||||
| Note table ZF2INVUDR. | ||||||
| Grouping of delivery details from item level (optional) | ||||||
| PIDPTDBQ | x | required | DECIMAL(15, 4) | Amount, calculated | Quantity invoiced | |
| PIDPTDBQU | x | required | CHAR(5) | Unit of measurement | Unit of measurement code for the quantity invoiced | LTR = Liter (1 dm3) MTQ = Cubic meters KGM = Kilogram MTR = Meter PCE = piece TNE = Ton |
| PIDPTDCFQ | x | optional | DECIMAL(15, 4) | Amount, not calculated | Quantity, without calculation | |
| PIDPTDCFQU | x | required if, PIDPTDCFQ is available | CHAR(5) | Unit of measurement | Unit of measurement | C62 |
| PIDPTDPQ | x | optional | INTEGER | Number of packages | Number of packages | |
| PIDPTDPQU | x | required if, PIDPTDPQ is available | CHAR(5) | Unit of measurement | Unit of measurement | BX |
| Detailed information on the different ship-to party (optional) | ||||||
| PIWRDID | x | optional | VARCHAR(35) | Identifier of the were recipients | Identification of the ship-to party | |
| PIWRDGLN | x | optional | VARCHAR(35) | Global identifier of the were recipients | Global identifier of the consignee | |
| PIWRDGLNT | x | required if PIWRDGLN is filled | CHAR(5) | Type of global identifier | Type of global identification number | |
| PIWRDREC | x | required | VARCHAR(255) | Company/Name of the were recipients | Name/name of the consignee | |
| Details of the organization (optional) | ||||||
| PIWCOMRN | x | optional | VARCHAR(35) | Identifier of the Organization | Commercial register number | |
| PIWCOMRNT | x | optional | VARCHAR(10) | Type of number | Type of number | |
| PIWTRBUSIN | x | optional | VARCHAR(50) | Trading Business name | Trade name | |
| Detailed information on the contact person of the ship-to party (optional) | ||||||
| PIWRDCN | x | abhängig | VARCHAR(50) | Contact Name of the were recipients | Name of contact person | |
| PIWRDDN | x | abhängig | VARCHAR(50) | Department name of the were recipients | Department of the contact person | |
| Detailed information on the telephone number of the contact person (optional) | ||||||
| PIWRDTEL | x | required | VARCHAR(50) | Phone number of the were recipients | Telephone number of the contact person | |
| Detailed information on the fax number of the contact person (optional) | ||||||
| PIWRDFAX | x | required | VARCHAR(50) | Fax number of the were recipients | Fax number of the contact person | |
| Detailed information on the email address of the contact person (optional) | ||||||
| PIWRDMAIL | x | required | VARCHAR(200) | Mail adress of the were recipients | email address | |
| Detailed information on the address of the ship-to party (optional) | ||||||
| PIWRDPLZ | x | optional | VARCHAR(10) | ZIP Code of the were recipients | Postcode | |
| PIWRDAD1 | x | optional | VARCHAR(50) | Adress line 1 of the were recipients | Address line 1 | |
| PIWRDAD2 | x | optional | VARCHAR(50) | Adress line 2 of the were recipients | Address line 2 | |
| PIWRDAD3 | x | optional | VARCHAR(50) | Adress line 3 of the were recipients | Address line 3 | |
| PIWRDCITY | x | optional | VARCHAR(50) | City of the were recipients | City | |
| PIWRDLC | x | required | CHAR(4) | Country ISO of the were recipients | Country (code) | |
PIWRDCSDN | x | optional | VARCHAR(25) | Country federal state | Federal state | |
| Electronic address details (optional) | ||||||
PIWURIID | x | required | VARCHAR(55) | Eletronic address | Electronic address | |
PIWURIIDT | x | required | VARCHAR(10) | Eletronic address type | Type of electronic address | |
| Detailed information on tax details of the ship-to party (optional) | ||||||
| PIWRDSNR | x | optional | VARCHAR(35) | Taxnumber of the were recipients | Tax number | |
| PIWRDASNR | x | optional | VARCHAR(35) | USTid of the were recipients | Value added tax identification number | |
| Detailed information on the different final recipient (optional) | ||||||
| PIFRDID | x | optional | VARCHAR(35) | Identifier of the final recipient | Identification of the final recipient | |
| PIFRDGLN | x | optional | VARCHAR(35) | Global identifier of the final recipient | Global identifier of the final recipient (GLN) | |
| PIFRDGLNT | x | required if PIFRDGLN is filled | CHAR(5) | Type of global identifier | Type of global identification number | |
| PIFRDREC | x | required | VARCHAR(255) | Company/Name of the final recipient | Name/name of the final recipient | |
| Details of the organization (optional) | ||||||
PIFRROID | x | optional | VARCHAR(35) | Identifier of the Organization | Commercial register number | |
PIFRROIDT | x | optional | VARCHAR(10) | Type of number | Type of number | |
PIFRROTRBN | x | optional | VARCHAR(50) | Trading Business name | Trade name | |
Detailed information on the contact person of the final recipient (optional) | ||||||
| PIFRDCN | x | optional | VARCHAR(50) | Contact Name of the final recipient | Name of contact person | |
| PIFRDDN | x | optional | VARCHAR(50) | Department name of the final recipient | Department of the contact person | |
| Detailed information on the telephone number of the contact person (optional) | ||||||
| PIFRDTEL | x | required | VARCHAR(50) | Phone number of the final recipient | Telephone number of the contact person | |
| Detailed information on the fax number of the contact person (optional) | ||||||
| PIFRDFAX | x | required | VARCHAR(50) | Fax number of the final recipient | Fax number | |
| Detailed information on the email address of the contact person (optional) | ||||||
| PIFRDMAIL | x | required | VARCHAR(200) | Postanschrift des Endempfängers | email address | |
| Detailed information on the address of the final recipient (optional) | ||||||
| PIFRDPLZ | x | optional | VARCHAR(10) | ZIP Code of the final recipient | Postcode | |
| PIFRDAD1 | x | optional | VARCHAR(50) | Adress line 1 of the final recipient | Address line 1 | |
| PIFRDAD2 | x | optional | VARCHAR(50) | Adress line 2 of the final recipient | Address line 2 | |
| PIFRDAD3 | x | optional | VARCHAR(50) | Adress line 3 of the final recipient | Address line 3 | |
| PIFRDCITY | x | optional | VARCHAR(50) | City of the final recipient | City | |
| PIFRDLC | x | required | CHAR(4) | Country ISO of the final recipient | Country (code) | |
| PIFRDCSDN | x | optional | VARCHAR(25) | Country federal state | Federal state | |
| Electronic address details (optional) | ||||||
| PIFRURIID | x | required | VARCHAR(55) | Eletronic address | Electronic address | |
| PIFRURIIDT | x | required | VARCHAR(10) | Eletronic address type | Type of electronic address | |
| Detailed information on tax data of the final recipient (optional) | ||||||
| PIFRDSNR | x | optional | VARCHAR(35) | Taxnumber of the final recipient | Tax number | |
| PIFRDASNR | x | optional | VARCHAR(35) | USTid of the final recipient | Value added tax identification number | |
| Detailed information on the actual delivery (optional) | ||||||
| PIDELTD | x | required | DATE '0001-01-01' | Actual Delivery Time | Actual delivery date | |
| Detailed information on the corresponding shipping notification (optional) | ||||||
| PIDANR | x | optional | VARCHAR(35) | Despatch advice number | Shipping notification number | |
| PIDALI | x | optional | INTEGER | Despatch advice position | Shipping notification | |
| PIDALD | x | optional | DATE '0001-01-01' | Date of Despatch advice | Shipping notification date | |
| Detailed information on the corresponding final backflush (optional) | ||||||
| PIGRII | x | optional | VARCHAR(35) | Good receipt number | Goods receipt number | |
| PIGRDLI | x | optional | INTEGER | Good receipt positon | Goods receipt item | |
| PIGRIDC | x | optional | DATE '0001-01-01' | Good receipt date | Goods receipt date | |
| Detailed information on the corresponding delivery note (optional) | ||||||
| PIDNDII | x | optional | VARCHAR(35) | Delivery Note number | Delivery note number | |
| PIDNDLI | x | optional | INTEGER | Delivery Note position | Delivery note item | |
| PIDNIDC | x | optional | DATE '0001-01-01' | Date of Delivery Note | Delivery note date | |
| Grouping of data for settlement at item level (required) | ||||||
| Sales tax information at the invoice item level (required) | ||||||
Note table ZF2INVTI. | ||||||
| Detailed information on the accounting period (optional) | ||||||
| PIAPSDT | x | optional | VARCHAR(15) | Beginning of the accounting period | Beginning of the financial period | |
| PIAPSDTF | x | required if PIAPSDT is filled. | CHAR(3) | Date Format | Date, Format | |
| PIAPEDT | x | required | VARCHAR(15) | End of the accounting period | End of the financial period | |
| PIAPEDTF | x | required if PIAPEDT is filled. | CHAR(3) | Date Format | Date, Format | |
| Budget billing amounts at invoice item level (optional) | ||||||
| Note table ZF2INVAC. | ||||||
| Detailed information on item totals (required) | ||||||
| PIPSTA | x | required | DECIMAL(15, 2) | Total amount of position | Total item amount | |
| PIPSTACA | x | optional | DECIMAL(15, 2) | Total amount of position increases and reductions | Total amount of item markups and markdowns | |
| Object identification at invoice item level (optional) | ||||||
| Note table ZF2INVDR. | ||||||
| Detailed information on the booking reference (optional) | ||||||
| Note table ZF2INVBR. | ||||||