| 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 | KEYR1 | Returns Lot | nvarchar | 12 | 0 | CHAR | (N' ') | No | | KEYR1_KK | Allow NULL? |
| 3 | KEYR2 | Search term for returns lot | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | KEYR2_KK | Allow NULL? |
| 4 | APPLK | Application area | char | 1 | 0 | CHAR | (N' ') | Yes | | APPLK_KK | Allow NULL? |
| 5 | HERKF | Document Origin Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK001 | HERKF_KK | Allow NULL? |
| 6 | FIKEY | Reconciliation Key for General Ledger | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | FIKEY_KK | Allow NULL? |
| 7 | RLSKO | Bank clearing account for returns | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TFK012 | RLSKO_KK | Allow NULL? |
| 8 | GEAKO | Charges expense account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GEAKO_KK | Allow NULL? |
| 9 | GEEKO | Charges revenue account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GEEKO_KK | Allow NULL? |
| 10 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 11 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 12 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR_RL_KK | Allow NULL? |
| 13 | BLART | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK003 | BLART_KK | Allow NULL? |
| 14 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 15 | KURSF | Exchange rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSF | |
| 16 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_KK | Allow NULL? |
| 17 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 18 | VALUT | Value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALUT | Allow NULL? |
| 19 | XEIPH | Create Line Item in General Ledger | char | 1 | 0 | CHAR | (N' ') | Yes | | XEIPH_KK | Allow NULL? |
| 20 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK001A | AUGRD_KK | Allow NULL? |
| 21 | SELT1 | Default Value for Selection Category | char | 1 | 0 | CHAR | (N' ') | Yes | TFK004 | SELTV_KK | Allow NULL? |
| 22 | ANZPO | Number of items | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | ANZPO_KK | Allow NULL? |
| 23 | SUMMS | Total debit postings | decimal | 15 | 2 | CURR | ((0)) | Yes | | SUMMS | |
| 24 | SUMMH | Total credit postings | decimal | 15 | 2 | CURR | ((0)) | Yes | | SUMMH | |
| 25 | SUMWA | Currency Key for the Totals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | SUMWA_KK | Allow NULL? |
| 26 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 27 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 28 | ERTIM | Time at which the object was created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERTIM_KK | Allow NULL? |
| 29 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AENAM | Allow NULL? |
| 30 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 31 | AETIM | Time at Which the Object Was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AETIM_KK | Allow NULL? |
| 32 | STARS | Status of the returns lot | char | 1 | 0 | CHAR | (N' ') | Yes | | STARS_KK | Allow NULL? |
| 33 | XSTEB | Bank Charges Include Tax | char | 1 | 0 | CHAR | (N' ') | Yes | | XSTEB_KK | Allow NULL? |
| 34 | XRLSB | Returns Amounts Include Bank Charges | char | 1 | 0 | CHAR | (N' ') | Yes | | XRLSB_KK | Allow NULL? |
| 35 | SKZB1 | Tax Code: Bank Charge 1 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | SKZB1_KK | Allow NULL? |
| 36 | SKZB2 | Tax Code from Bank 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | SKZB2_KK | Allow NULL? |
| 37 | SKZV1 | Tax Code: Returns Charge 1 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | SKZV1_KK | Allow NULL? |
| 38 | SKZV2 | Tax Code for Return Fees 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | SKZV2_KK | Allow NULL? |
| 39 | BANKL | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | BANKS | Allow NULL? |
| 40 | BANKK | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | BNKA | BANKK | Allow NULL? |
| 41 | BANKN | Bank account number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | BANKN | Allow NULL? |
| 42 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012 | HBKID | Allow NULL? |
| 43 | HKTID | ID for account details | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012K | HKTID | Allow NULL? |
| 44 | JOBNAME | Background job name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCJOB | Allow NULL? |
| 45 | XCALCGEB | Calculate Charges Automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | XRLSCALCGEB_KK | Allow NULL? |
| 46 | XACCEPTCHARGES | Returns: Accepting Charges over Tolerance Limit | char | 1 | 0 | CHAR | (N' ') | Yes | | XACCEPTCHARGES_KK | Allow NULL? |
| 47 | FLAGS | Status marker | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | FLAGPOOL32 | Allow NULL? |
| 48 | RLMOD | Returns Posting Type | char | 1 | 0 | CHAR | (N' ') | Yes | | RLMOD_KK | Allow NULL? |
| 49 | KSUMS | Specified Debit Total | decimal | 15 | 2 | CURR | ((0)) | Yes | | KTSUS_KK | |
| 50 | KSUMH | Specified Credit Total | decimal | 15 | 2 | CURR | ((0)) | Yes | | KTSUH_KK | |
| 51 | KSUMP | Specified Number of Items | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KSUMP_KK | Allow NULL? |
| 52 | XERWR | Enhanced Returns Processing | char | 1 | 0 | CHAR | (N' ') | Yes | | XERWR_KK | Allow NULL? |
| 53 | RLGRD | Return reason | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | RLGRD_KK | Allow NULL? |
