| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID_SPLAUDR | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | No | | /SAPSLL/GUID_16 | |
| 3 | GUID_SPLAUD | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/GUID_16 | |
| 4 | LAUNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | /SAPSLL/LAUNR | Allow NULL? |
| 5 | GUID_PRTN | Primary Key of Business Partner | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/PRTN_GUID_16 | |
| 6 | GRVSY | Logical System Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TCOGVS | /SAPSLL/GRVSY | Allow NULL? |
| 7 | BPTYP | Business Partner Category in Feeder System | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/BPTYP | Allow NULL? |
| 8 | BPVSY | External Business Partner Number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/BPVSY | Allow NULL? |
| 9 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 10 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | /SAPSLL/LAND1 | Allow NULL? |
| 11 | MOBJT | Type of Main Object | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/MOBJT | Allow NULL? |
| 12 | GUID_MOBJ | Primary Key of Main Object | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/MOBJ_GUID_16 | |
| 13 | POBJT | Type of Preceding Object | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/POBJT | Allow NULL? |
| 14 | GUID_POBJ | Primary Key of Preceding Object | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/POBJ_GUID_16 | |
| 15 | GUID_CORPAR | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/GUID_16 | |
| 16 | QALREF | Type of Reference Number | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TCO200 | /SAPSLL/QALREF | Allow NULL? |
| 17 | REFNO | Reference Number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/REFNO | Allow NULL? |
| 18 | REFDT | Date of Reference Object | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPSLL/REFDT | Allow NULL? |
| 19 | ORGLOGSYS | Logical System of Original Object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TBDLS | /SAPSLL/ORGLOGSYS | Allow NULL? |
| 20 | OBJTP | Object Type of Reference Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/OBJTP | Allow NULL? |
| 21 | ITVSY | External Document Item ID from Feeder System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/ITVSY | Allow NULL? |
| 22 | PAFCT | Partner Function | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TPAFCT | /SAPSLL/PAFCT | Allow NULL? |
| 23 | CORDER | Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/CUORNO | Allow NULL? |
| 24 | COYEAR | Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /SAPSLL/NRYEAR | Allow NULL? |
| 25 | CUHDA | Document Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | /SAPSLL/CUHDA | Allow NULL? |
| 26 | GUID_FTORG | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/GUID_16 | |
| 27 | SPLAMLO | Separation into Business Areas: Logistics | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/SPLAMLO | Allow NULL? |
| 28 | SPLAMFI | Separation into Business Areas: Financial Accounting | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/SPLAMFI | Allow NULL? |
| 29 | SPLAMHR | Business Separation of Human Resources - Employees | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/SPLAMHR | Allow NULL? |
| 30 | SPLAMHR1 | Business Separation of Human Resources - Applicants | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/SPLAMHR1 | Allow NULL? |