| 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 | PBDID | Planned independent requirements identification | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | | PBDID | Allow NULL? |
| 3 | PBDNR | Requirements Plan Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | PBDNR | Allow NULL? |
| 4 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 5 | BERID | MRP Area | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BERID | Allow NULL? |
| 6 | VERSB | Version number for independent requirements | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VERSB | Allow NULL? |
| 7 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 8 | BEDAE | Requirements type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BEDAE | Allow NULL? |
| 9 | BDZEI | Independent requirements pointer | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | BDZEI | Allow NULL? |
| 10 | ZUVKZ | Consumption indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | DZUVKZ | Allow NULL? |
| 11 | VERVS | Indicator: Version Active | char | 1 | 0 | CHAR | (N' ') | Yes | | VERVS | Allow NULL? |
| 12 | VERKZ | Consumption indicator for planning requirements | char | 1 | 0 | CHAR | (N' ') | Yes | | VERVP | Allow NULL? |
| 13 | ZUOKR | Criterion for allocation | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | DZUOKR | Allow NULL? |
| 14 | PLNKZ | Planning Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PLNKZ | Allow NULL? |
| 15 | TXTKZ | Indicator: long text exists | char | 1 | 0 | CHAR | (N' ') | Yes | | TXTKZ | Allow NULL? |
| 16 | LOEVR | Deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVR | Allow NULL? |
| 17 | UEBKZ | Indicator: data copied | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBKZ | Allow NULL? |
| 18 | DATLP | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |
| 19 | UHRLP | Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UZEIT | Allow NULL? |
| 20 | AGGPB | Aggregation indicator for planned independent requirements | char | 1 | 0 | CHAR | (N' ') | Yes | * | AGGPB | Allow NULL? |
| 21 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | PLSCN | Allow NULL? |
| 22 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VRSIO | Allow NULL? |
| 23 | MCINF | Name of information structure | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | MCINF | Allow NULL? |
| 24 | STFNA | Field name in the generated DDIC structure | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | STFNA | Allow NULL? |
| 25 | OPLKZ | With no MRP | char | 1 | 0 | CHAR | (N' ') | Yes | | OPLKZ | Allow NULL? |
| 26 | MCINC | Name of info structure - characteristic values | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | MCINC | Allow NULL? |
| 27 | VRSIC | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VRSIO | Allow NULL? |
| 28 | KNTTP | Account Assignment Category | char | 1 | 0 | CHAR | (N' ') | Yes | * | KNTTP | Allow NULL? |
| 29 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | SOBKZ | Allow NULL? |
| 30 | KZVBR | Consumption Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | KZVBR | Allow NULL? |
| 31 | PSPEL | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_PSP_PNR | Allow NULL? |
| 32 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 33 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KDAUF | Allow NULL? |
| 34 | PROFILID | Name of planning profile | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | PROFILID | Allow NULL? |
| 35 | KZBWS | Valuation of Special Stock | char | 1 | 0 | CHAR | (N' ') | Yes | | KZBWS | Allow NULL? |
| 36 | PBDNR_EXT | External Requirements Plan ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PBDNR_EXT | Allow NULL? |
| 37 | SGT_RCAT | Requirement Segment | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SGT_RCAT | Allow NULL? |
