|
|
DTW Administration / Setup / Financials / Tax / Tax Groups / Goods Shipment
API Vat Groups / Goods Shipment
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | VarChar | 1 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Name | nVarChar | 50 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OGSP.Code AS 'Code',
OGSP.Name AS 'Name',
OGSP.UserSign AS 'User Signature'
FROM OGSP AS OGSP
Related information
Goods Shipment GoodsShipment Property· Table: OGSP
Sets or returns the goods shipment indicator, which appears in the EU Sales Report.
This property is applicable when TriangularDeal is not set.
Field name: GoddsShip.
Length: 1 numeric character.
· Table: OVTG 
Parent: Vat Groups VatGroups Object· Table: OVTG OGSP SQL Table
Users OUSR SQL Table
VatGroups
Property
GoodsShipment
Enumeration
Method
Object
VatGroups_Lines VTG1
Property
AcquisitionReverse
DTW DB
AcquisitionTax
DTW DB
Category
DTW DB
Code
DTW DB
Correction
DTW DB
DeferredTaxAcc
DTW DB
EqualizationTaxAccount
DTW DB
EU
DTW DB
GoodsShipment
DTW DB
Name
DTW DB
NonDeduct
DTW DB
NonDeductAcc
DTW DB
ServiceSupply
DTW DB
TaxAccount
DTW DB
TriangularDeal
DTW DB
VatCorrection
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates