| 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 | T000 | MANDT | Allow NULL? |
| 2 | ABSTA | Settlement Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | /BEV1/RSABSTART | Allow NULL? |
| 3 | DIFBELF | Create Difference Documents Driver | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSDIFBELF | Allow NULL? |
| 4 | BELAUART | Order Type Debit Note Document | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVAK | /BEV1/RSBELAUART | Allow NULL? |
| 5 | BELPOSTYP | Order Item Category Debit Driver | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | /BEV1/RSBELPOSTYP | Allow NULL? |
| 6 | ENTAUART | Order Type Credit Note Document | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVAK | /BEV1/RSENTAUART | Allow NULL? |
| 7 | ENTPOSTYP | Order Item Category Credit Driver | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | /BEV1/RSENTPOSTYP | Allow NULL? |
| 8 | DIFBELI | Create Difference Documents Collection | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSDIFBELI | Allow NULL? |
| 9 | INKBAUART | Order Type for Debit Document from Collection Difference | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVAK | /BEV1/RSINKBAUART | Allow NULL? |
| 10 | INKEAUART | Order Type for Credit Document from Collection Difference | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVAK | /BEV1/RSINKEAUART | Allow NULL? |
| 11 | INKMATNR | Collection Material | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | /BEV1/RSINKMATNR | Allow NULL? |
| 12 | DIFFABS | Absolute Difference in Currency for Diff. Doc. Collection | decimal | 15 | 2 | CURR | ((0)) | Yes | | /BEV1/RSDIFFABS | |
| 13 | DIFFWHG | Currency for Difference Limit for Difference Doc. Collection | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | /BEV1/RSDIFFWHG | Allow NULL? |
| 14 | DIFFPROZ | Difference Percent Re. Order Value (Diff. Doc. Collection) | decimal | 4 | 1 | DEC | ((0)) | Yes | | /BEV1/RSDIFFPROZ | |
| 15 | INKFI | Collection Posting FI | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSINKFI | Allow NULL? |
| 16 | DFTBUDAT | Pre-Allocation Posting Date for Collection Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSDFTBUDAT | Allow NULL? |
| 17 | INKTXT | Text ID Collection Descr. (Route Settlement Collec. Posting) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TTXID | /BEV1/RSINKTXT | Allow NULL? |
| 18 | INKZU | Text ID Collection Assignment (Route Settlement Cllctn Post) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TTXID | /BEV1/RSINKZU | Allow NULL? |
| 19 | LFERST | Create Delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSLFERST | Allow NULL? |
| 20 | WAUSG | Post Goods Issue | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSWAUSG | Allow NULL? |
| 21 | FSPERRE | Cancel Billing Block | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSFSPERRE | Allow NULL? |
| 22 | PRSHDOC | Print Shipping Papers | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSPRSHDOC | Allow NULL? |
| 23 | QUICKEX | Quick Exchange Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSQUICKEX | Allow NULL? |
| 24 | INKZUO | Collection Assignment Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSINKZUO | Allow NULL? |
| 25 | COPYRLS | Copying of Returns Loading Note Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSCOPYRLS | Allow NULL? |
| 26 | ERFRET | Entry Returns Document Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSERFRET | Allow NULL? |
| 27 | ABSLGGRP | Settlement for Empties Groups | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSABSLGGRP | Allow NULL? |
| 28 | ABSPOP | Dialog Box for Tour Completion | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RSABSPOP | Allow NULL? |