| 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 | VSNMR | Number or description of a version | nvarchar | 12 | 0 | CHAR | (N' ') | No | | VSNMR | Allow NULL? |
| 3 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FPLNR | Allow NULL? |
| 4 | FPTYP | Billing plan category | char | 1 | 0 | CHAR | (N' ') | No | | FPTYP_FP | Allow NULL? |
| 5 | FPART | Billing/Invoicing Plan Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | FPART | Allow NULL? |
| 6 | SORTL | Sort field | nvarchar | 10 | 0 | CHAR | (N' ') | No | | SORTL | Allow NULL? |
| 7 | BEDAT | Start date for billing plan/invoice plan | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEDAT_FP | Allow NULL? |
| 8 | ENDAT | End date billing plan/invoice plan | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDAT_FP | Allow NULL? |
| 9 | HORIZ | Rule for Determining Horizon in Billing/Invoicing Plan | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | HORIZ_FP | Allow NULL? |
| 10 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VBELN | Allow NULL? |
| 11 | BEDAR | Rule for Origin of Start Date of Billing/Invoicing Plan | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | BEDAT_FPK | Allow NULL? |
| 12 | ENDAR | Rule for Origin of End Date for Billing/Invoicing Plan | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | ENDAT_FPK | Allow NULL? |
| 13 | PERIO | Rule for Origin of Next Billing/Invoice Date | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERIO_FP | Allow NULL? |
| 14 | FPLAE | Length of a standard period in the billing plan | nvarchar | 3 | 0 | NUMC | (N'000') | No | | FPLAE | Allow NULL? |
| 15 | RFPLN | Standard Billing/Invoicing Plan Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | RFPLN_D | Allow NULL? |
| 16 | LODAT | Dates from | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | TADAT | Allow NULL? |
| 17 | AUTTE | Billing/Invoice Creation in Advance | char | 1 | 0 | CHAR | (N' ') | No | | AUTTE | Allow NULL? |
| 18 | LODAR | Rule for Origin of Start Dates | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | LODAR | Allow NULL? |
| 19 | PERAF | Rule for Determination of a Deviating Billing/Invoice Date | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERAF_FP | Allow NULL? |
| 20 | FAKCA | Calendar for Defining Days Relevant to Billing/Invoicing | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | FAKCA | Allow NULL? |
| 21 | TNDAT | Dates to | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | TBDAT | Allow NULL? |
| 22 | TNDAR | Rule for Origin of End Dates | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | TBDAR | Allow NULL? |
| 23 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | CO_AUFPL | Allow NULL? |
| 24 | APLZL | General counter for order | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | CO_APLZL | Allow NULL? |
| 25 | RSNUM | Number of Reservation/Dependent Requirement | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | RSNUM | Allow NULL? |
| 26 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RSPOS | Allow NULL? |
| 27 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EBELN | Allow NULL? |
| 28 | FPLTU | Item unlimited in value | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | FPLTU | Allow NULL? |
| 29 | AUST1 | Payment cards: Status regarding requirements | char | 1 | 0 | CHAR | (N' ') | Yes | | AUST1_CC | Allow NULL? |
| 30 | AUST2 | Payment cards: Totals status - Call external system | char | 1 | 0 | CHAR | (N' ') | Yes | | AUST2_CC | Allow NULL? |
| 31 | AUST3 | Payment cards: Overall status - Responses from ext. system | char | 1 | 0 | CHAR | (N' ') | Yes | | AUST3_CC | Allow NULL? |
| 32 | AUST4 | Payment cards: Reserve | char | 1 | 0 | CHAR | (N' ') | Yes | | AUST4_CC | Allow NULL? |
| 33 | AUST5 | Payment cards: Authorization block | char | 1 | 0 | CHAR | (N' ') | Yes | | AUST5_CC | Allow NULL? |
| 34 | BASISWRT | Target value | decimal | 15 | 2 | CURR | ((0)) | Yes | | BASISWRT | |
| 35 | PSPNR | WBS Element | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_POSNR | Allow NULL? |
| 36 | AUTKOR | Automatic creation of correction dates in billing plan | char | 1 | 0 | CHAR | (N' ') | Yes | | AUTKOR | Allow NULL? |
