| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GUID_SPLAUDR | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 3 | GUID_SPLAUD | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 4 | LAUNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | GUID_PRTN | Primary Key of Business Partner | varbinary | 16 | 0 | | | | |
| 6 | GRVSY | Logical System Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | BPTYP | Business Partner Category in Feeder System | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | BPVSY | External Business Partner Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 9 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | LAND1 | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | MOBJT | Type of Main Object | char | 1 | 0 | | | | Allow NULL? |
| 12 | GUID_MOBJ | Primary Key of Main Object | varbinary | 16 | 0 | | | | |
| 13 | POBJT | Type of Preceding Object | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | GUID_POBJ | Primary Key of Preceding Object | varbinary | 16 | 0 | | | | |
| 15 | GUID_CORPAR | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 16 | QALREF | Type of Reference Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | REFNO | Reference Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 18 | REFDT | Date of Reference Object | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | ORGLOGSYS | Logical System of Original Object | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | OBJTP | Object Type of Reference Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | ITVSY | External Document Item ID from Feeder System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | PAFCT | Partner Function | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | CORDER | Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | COYEAR | Document Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | CUHDA | Document Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | GUID_FTORG | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 27 | SPLAMLO | Separation into Business Areas: Logistics | char | 1 | 0 | | | | Allow NULL? |
| 28 | SPLAMFI | Separation into Business Areas: Financial Accounting | char | 1 | 0 | | | | Allow NULL? |
| 29 | SPLAMHR | Business Separation of Human Resources - Employees | char | 1 | 0 | | | | Allow NULL? |
| 30 | SPLAMHR1 | Business Separation of Human Resources - Applicants | char | 1 | 0 | | | | Allow NULL? |