Skip to main content
Skip table of contents

ZF2INVPI - Grouping of position details


Column name

In use?StatusColumn definitionColumn descriptionTechnical termExample
PIKEYx
VARCHAR(15)

Internal pagination number (i-effect Spalte)

Internal invoice number
Grouping of general position specifications (required)
PIREFxrequiredDECIMAL(5, 0)PositionnumberIdentification of the invoice item
PILISTCO
optionalVARCHAR(15)Typ der LinePositionType of invoice item (code)
PILISTRECO
optionalVARCHAR(15)Unter Typ der LinienpositionSubtype of invoice item
Detailed information on free text for the item (optional)

Note table ZF2INVTX.

Article information (required)
PIPPPGICxoptionalVARCHAR(35)Global identifier of the ProductGlobal identifier of the product
PIPPPSIDxrequired wenn PIPPPGIC gef├╝llt ist.CHAR(5)Type of global article numberType of global article number
PIPPPSAII

VARCHAR(35)Product number of the SellerSeller's part number
PIPPPBAII

VARCHAR(35)Product number of the BuyerItem number of the buyer
PIPPPNTxrequiredVARCHAR(255)Product nameArticle description
PIPPPDT

VARCHAR(255)Product descriptionArticle description
Article attribute (optional) (from COMFORT)
Note table ZF2INVPP.
Detailed information on product classification (optional) (from COMFORT)
Note table ZF2INVPC.
Detailed information on product origin (optional)
PIPPPOTC

CHAR(2)Origin Trade CountryArticle country of origin
Detailed information on included products (optional) (EXTENDED only)
Note table ZF2INVIP.
Detailed information about the price (required)
Details of the associated order (optional) (from COMFORT)
PIDOIIO

VARCHAR(35)Order numberOrder number
PIDOLIO

INTEGEROrder positionOrder item
PIDOIDTO

DATE '0001-01-01'Order dateOrder date
Details of the associated contract (optional) (EXTENDED only)
PICOIIC

VARCHAR(35)Contract numberContract number
PICOLIC

INTEGERContract positionContract item
PICOIDTC

DATE '0001-01-01'Contract dateContract date
Details of an additional document reference (optional) (EXTENDED only)

Note table ZFINVDR.

Detailed information on the gross price of the article (optional)
PIGPCA

DECIMAL(15, 4)Gross priceGross price of the article
PIGPBQxoptionalINTEGERPrice base amountBase quantity at item price1, 10, 100
PIGPBQUxrequired wenn PIGPBQ vorhanden ist.CHAR(5)Type of Price base amountCode for the unit of measurement of the base quantity at item price

LTR = Litre (1 dm3)

MTQ = cubic meter

KGM = kilogram

MTR = meter PCE = piece

TNE = tonne

Detailed information on surcharges and discounts (optional) (from COMFORT)
Note table ZF2INVAC.
Detailed information on the net price of the article (required)
PINPCAxrequiredDECIMAL(15, 4)Net priceNet price of the article
PINPBQxoptionalINTEGERPrice base amountBase quantity at item price1, 10, 100
PINPBQUxrequired wenn PINPBQ vorhanden ist.CHAR(5)Type of Price base amountCode for the unit of measurement of the base quantity at item price

LTR = Litre (1 dm3)

MTQ = cubic meter

KGM = kilogram

MTR = meter PCE = piece

TNE = tonne

Included tax for B2C (optional) (EXTENDED only)
PITAXA

DECIMAL(15, 2)Tax amount calculatedIncluded tax for B2C
PITAXT

CHAR(5)Type of TaxIncluded tax for B2C
PITAXFT

VARCHAR(255)Reason for tax exemptionIncluded tax for B2C
PITAXCAT

CHAR(2)Tax categoryIncluded tax for B2C
PITAXFTC

CHAR(5)Reason for tax exemption (CODE)Code for the reason for exemption from turnover tax
PITAXPER

DECIMAL(6, 2)Tax rateIncluded tax for B2C
UltimateCustomerOrderReferencedDocument (extended only) (optional)
Note table ZF2INVUDR.
Grouping of delivery details from item level (optional)
PIDPTDBQxrequiredDECIMAL(15, 4)Amount, calculatedQuantity invoiced
PIDPTDBQUxrequiredCHAR(5)Unit of measurementUnit of measurement code for the quantity invoiced

LTR = Liter (1 dm3)

MTQ = Cubic meters

KGM = Kilogram

MTR = Meter PCE = piece

TNE = ton

PIDPTDCFQ

DECIMAL(15, 4)Amount, not calculatedQuantity, without calculation
PIDPTDCFQU

CHAR(5)Unit of measurementUnit of measurementC62
PIDPTDPQ

INTEGERNumber of packagesNumber of packages
PIDPTDPQU

CHAR(5)Unit of measurementUnit of measurementBX
Detailed information on the alternative ship-to party (optional) (EXTENDED only)
PIWRDID

VARCHAR(35)Identifier of the were recipientsIdentification of the ship-to party
PIWRDGLN

VARCHAR(35)Global identifier of the were recipientsGlobal identifier of the consignee
PIWRDGLNT

CHAR(5)Type of global identifierType of global identification number
PIWRDREC

VARCHAR(255)Company/Name of the were recipientsName/name of the consignee
Details of the organization (optional)
PIWCOMRN

VARCHAR(35)Identifier of the OrganizationCommercial register number
PIWCOMRNT

VARCHAR(10)Type of numberType of number
PIWTRBUSIN

VARCHAR(50)Trading Business nameTrade name
Detailed information on the contact person of the ship-to party (optional)
PIWRDCN

VARCHAR(50)Contact Name of the were recipientsName of contact person
PIWRDDN

VARCHAR(50)Department name of the were recipientsDepartment of the contact person
Detailed information on the telephone number of the contact person (optional)
PIWRDTEL

VARCHAR(50)Phone number of the were recipientsTelephone number of the contact person
Detailed information on the fax number of the contact person (optional)
PIWRDFAX

VARCHAR(50)Fax number of the were recipientsFax number of the contact person
Detailed information on the email address of the contact person (optional)
PIWRDMAIL

VARCHAR(200)Mail adress of the were recipientsemail address
Detailed information on the address of the ship-to party (optional)
PIWRDPLZ

VARCHAR(10)ZIP Code of the were recipientsPostcode
PIWRDAD1

VARCHAR(50)Adress line 1 of the were recipientsAddress line 1
PIWRDAD2

VARCHAR(50)Adress line 2 of the were recipientsAddress line 2
PIWRDAD3

VARCHAR(50)Adress line 3 of the were recipientsAddress line 3
PIWRDCITY

VARCHAR(50)City of the were recipientsCity
PIWRDLC

CHAR(4)Country ISO of the were recipientsCountry (code)

PIWRDCSDN



VARCHAR(25)

Country federal state

Federal state


Details zur elektronischen Adresse (optional)

PIWURIID



VARCHAR(55)Eletronic addressElectronic address

PIWURIIDT



VARCHAR(10)Eletronic address typeType of electronic address
Detailed information on tax details of the ship-to party (optional)
PIWRDSNR

VARCHAR(35)Taxnumber of the were recipientsTax number
PIWRDASNR

VARCHAR(35)USTid of the were recipientsValue added tax identification number
Detailed information on the different final recipient (optional)
PIFRDID

VARCHAR(35)Identifier of the final recipientIdentification of the final recipient
PIFRDGLN

VARCHAR(35)Global identifier of the final recipientGlobal identifier of the final recipient (GLN)
PIFRDGLNT

CHAR(5)Type of global identifierType of global identification number
PIFRDREC

VARCHAR(255)Company/Name of the final recipientName/name of the final recipient
Details of the organization (optional)

PIFRROID



VARCHAR(35)Identifier of the OrganizationCommercial register number

PIFRROIDT



VARCHAR(10)Type of numberType of number

PIFRROTRBN



VARCHAR(50)Trading Business nameTrade name

Detailed information on the contact person of the final recipient (optional)

PIFRDCN

VARCHAR(50)Contact Name of the final recipientName of contact person
PIFRDDN

VARCHAR(50)Department name of the final recipientDepartment of the contact person
Detailed information on the telephone number of the contact person (optional)
PIFRDTEL

VARCHAR(50)Phone number of the final recipientTelephone number of the contact person
Detailed information on the fax number of the contact person (optional)
PIFRDFAX

VARCHAR(50)Fax number of the final recipientFax number
Detailed information on the email address of the contact person (optional)
PIFRDMAIL

VARCHAR(200)Mail adress of the final recipientemail address
Detailed information on the address of the final recipient (recommended)
PIFRDPLZ

VARCHAR(10)ZIP Code of the final recipientPostcode
PIFRDAD1

VARCHAR(50)Adress line 1 of the final recipientAddress line 1
PIFRDAD2

VARCHAR(50)Adress line 2 of the final recipientAddress line 2
PIFRDAD3

VARCHAR(50)Adress line 3 of the final recipientAddress line 3
PIFRDCITY

VARCHAR(50)City of the final recipientCity
PIFRDLC

CHAR(4)Country ISO of the final recipientCountry (code)
PIFRDCSDN

VARCHAR(25)Country federal stateFederal state
Electronic address details (optional)
PIFRURIID

VARCHAR(55)Eletronic addressElectronic address
PIFRURIIDT

VARCHAR(10)Eletronic address typeType of electronic address
Detailed information on tax data of the final recipient (optional)
PIFRDSNR

VARCHAR(35)Taxnumber of the final recipientTax number
PIFRDASNR

VARCHAR(35)USTid of the final recipientValue added tax identification number
Detailed information on the actual delivery (optional)
PIDELTD

DATE '0001-01-01'Actual Delivery TimeActual delivery date
Detailed information on the corresponding shipping notification (optional)
PIDANR

VARCHAR(35)Despatch advice numberShipping notification number
PIDALI

INTEGERDespatch advice positionShipping notification
PIDALD

DATE '0001-01-01'Date of Despatch adviceShipping notification date
Detailed information on the corresponding final backflush (optional)
PIGRII

VARCHAR(35)Good receipt numberGoods receipt number
PIGRDLI

INTEGERGood receipt positonGoods receipt item
PIGRIDC

DATE '0001-01-01'Good receipt dateGoods receipt date
Detailed information on the corresponding delivery note (optional)
PIDNDII

VARCHAR(35)Delivery Note numberDelivery note number
PIDNDLI

INTEGERDelivery Note positionDelivery note item
PIDNIDC

DATE '0001-01-01'Date of Delivery NoteDelivery 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) (from COMFORT)
PIAPSDT

CHAR(15)Beginning of the accounting periodBeginning of the financial period
PIAPSDTF

VARCHAR(3)Date FormatDate, Format
PIAPEDT

CHAR(15)End of the accounting periodEnd of the financial period
PIAPEDTF

VARCHAR(3)Date FormatDate, Format
Budget billing amounts at invoice item level (optional)
Note table ZF2INVAC.
Detailed information on item totals (required)
PIPSTA

DECIMAL(15, 2)Total amount of positionTotal item amount
PIPSTACA

DECIMAL(15, 2)Total amount of position increases and reductionsTotal amount of item markups and markdowns
Object ID at invoice item level (optional) (from COMFORT)
Note table ZF2INVDR.
Detailed information on the booking reference (optional) (from COMFORT)
Note table ZF2INVBR.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.