| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
API OSPP / / Special Prices | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
OSPP - Special Prices Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
OSPP.ItemCode AS 'Item No.',
OSPP.CardCode AS 'BP Code',
OSPP.Price AS 'Special Price',
OSPP.Currency AS 'Price Currency',
OSPP.Discount AS 'Discount in %',
OSPP.ListNum AS 'Price List No.',
OSPP.AutoUpdt AS 'Auto Update',
OSPP.EXPAND AS 'Item Details',
OSPP.UserSign AS 'User Signature',
OSPP.SrcPrice AS 'Source Price',
OSPP.LogInstanc AS 'Log Instance',
OSPP.UserSign2 AS 'Updating User',
OSPP.CreateDate AS 'Creation Date',
OSPP.UpdateDate AS 'Update Date'
FROM OSPP AS OSPP Related informationSpecial Prices SpecialPrices Object· Table: OSPP Represents a discount for a specific item in a specific price list. The discount can apply to a specific business partner or for all business partners.
Specific Partners: To view discounts for specific business partners, select Inventory -- OSPP SQL Table Business Partner OCRD SQL Table Items OITM SQL Table Price Lists OPLN SQL Table Users OUSR SQL Table |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |