SAP Table
T163P Release Creation Profile
SAP table T163P has 3 primary key fields being MANDT,WERKS,ABUEB.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T163P columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||
| KeyWERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |||||||||||
| KeyABUEB | Release Creation Profile | CHAR | 4 | 0 | ABUEB | ||||||||||||
| RUSKZ | Backlog and/or immediate requirement exist(s) | CHAR | 1 | 0 | RUSKZ | ||||||||||||
|
|||||||||||||||||
| FRUSA | JIT: Show Backlog and Immediate Requirement | CHAR | 1 | 0 | FRUSA | ||||||||||||
| LRUSA | FRC Delivery Schedule: Show Backlog and Imm. Requirement | CHAR | 1 | 0 | LRUSA | ||||||||||||
| FABHO | JIT deliv. schedule horizon (SA release horizon) in workdays | NUMC | 3 | 0 | FABHO | ||||||||||||
| LABHO | Forecast delivery schedule horizon in workdays | NUMC | 3 | 0 | LABHO | ||||||||||||
| FKAGG | JIT Delivery Schedule Creation Without Aggregation | NUMC | 3 | 0 | FKAGG | ||||||||||||
| LKAGG | Forecast Delivery Schedule Creation Without Aggregation | NUMC | 3 | 0 | LKAGG | ||||||||||||
| FTAGG | JIT Delivery Schedule Creation with Daily Aggregation | NUMC | 3 | 0 | FTAGG | ||||||||||||
| LTAGG | Forecast Delivery Schedule Creation with Daily Aggregation | NUMC | 3 | 0 | LTAGG | ||||||||||||
| FPAGG | Creation of JIT Schedules with Aggreg. Acc. to Planning Cal. | NUMC | 3 | 0 | FPAGG | ||||||||||||
| FKALA | Planning Calendar for Aggregation | CHAR | 3 | 0 | FKALA | ||||||||||||
| LPAGG | Creation of FRC Schedules with Aggreg. Acc. to Planning Cal. | NUMC | 3 | 0 | LPAGG | ||||||||||||
| LKALA | Planning Calendar for Aggregation | CHAR | 3 | 0 | LKALA | ||||||||||||
| LWAGG | Forecast Delivery Schedule Creation with Weekly Aggregation | NUMC | 3 | 0 | LWAGG | ||||||||||||
| LMAGG | Forecast Schedule Creation with Monthly Aggregation | NUMC | 3 | 0 | LMAGG | ||||||||||||
| FKUEB | No periodic transmission of JIT delivery schedules | CHAR | 1 | 0 | FKUEB | ||||||||||||
| LKUEB | No periodic transmission of forecast delivery schedules | CHAR | 1 | 0 | LKUEB | ||||||||||||
| FTUEB | Periodic transmission of JIT delivery schedules (daily) | CHAR | 1 | 0 | FTUEB | ||||||||||||
| LTUEB | Periodic transmission of forecast delivery schedules (daily) | CHAR | 1 | 0 | LTUEB | ||||||||||||
| FPUEB | Periodic transm. of JIT schedules acc. to planning calendar | CHAR | 1 | 0 | FPUEB | ||||||||||||
| FKALU | Planning calendar for periodic transmission | CHAR | 3 | 0 | FKALU | ||||||||||||
| LPUEB | Periodic transm. of FRC schedules acc. to planning calendar | CHAR | 1 | 0 | LPUEB | ||||||||||||
| LKALU | Planning calendar for periodic transmission | CHAR | 3 | 0 | LKALU | ||||||||||||
| FWUEB | Periodic transmission of JIT delivery schedules (weekly) | CHAR | 1 | 0 | FWUEB | ||||||||||||
| LWUEB | Periodic transmission of forecast deliv. schedules (weekly) | CHAR | 1 | 0 | LWUEB | ||||||||||||
| LMUEB | Periodic transmission of forecast deliv. schedules (monthly) | CHAR | 1 | 0 | LMUEB | ||||||||||||
| LPLT1 | Length of Checking Period 1 for FRC Schedules in Workdays | NUMC | 3 | 0 | LPLT1 | ||||||||||||
| LPLT2 | Length of Checking Period 2 for FRC Schedules in Workdays | NUMC | 3 | 0 | LPLT2 | ||||||||||||
| LPLT3 | Length of Checking Period 3 for FRC Schedules in Workdays | NUMC | 3 | 0 | LPLT3 | ||||||||||||
| FPLT1 | Length of Checking Period 1 for JIT Schedules in Workdays | NUMC | 3 | 0 | FPLT1 | ||||||||||||
| FPLT2 | Length of Checking Period 2 for JIT Schedules in Workdays | NUMC | 3 | 0 | FPLT2 | ||||||||||||
| FPLT3 | Length of Checking Period 3 for JIT Schedules in Workdays | NUMC | 3 | 0 | FPLT3 | ||||||||||||
| LOTO1 | Upper Tolerance Limit for FRC Schedules in Checking Period 1 | NUMC | 3 | 0 | LOTO1 | ||||||||||||
| LOTO2 | Upper Tolerance Limit for FRC Schedules in Checking Period 2 | NUMC | 3 | 0 | LOTO2 | ||||||||||||
| LOTO3 | Upper Tolerance Limit for FRC Schedules in Checking Period 3 | NUMC | 3 | 0 | LOTO3 | ||||||||||||
| FOTO1 | Upper Tolerance Limit for JIT Schedules in Checking Period 1 | NUMC | 3 | 0 | FOTO1 | ||||||||||||
| FOTO2 | Upper Tolerance Limit for JIT Schedules in Checking Period 2 | NUMC | 3 | 0 | FOTO2 | ||||||||||||
| FOTO3 | Upper Tolerance Limit for JIT Schedules in Checking Period 3 | NUMC | 3 | 0 | FOTO3 | ||||||||||||
| LUTO1 | Lower Tolerance Limit for FRC Schedules in Checking Period 1 | NUMC | 3 | 0 | LUTO1 | ||||||||||||
| LUTO2 | Lower Tolerance Limit for FRC Schedules in Checking Period 2 | NUMC | 3 | 0 | LUTO2 | ||||||||||||
| LUTO3 | Lower Tolerance Limit for FRC Schedules in Checking Period 3 | NUMC | 3 | 0 | LUTO3 | ||||||||||||
| FUTO1 | Lower Tolerance Limit for JIT Schedules in Checking Period 1 | NUMC | 3 | 0 | FUTO1 | ||||||||||||
| FUTO2 | Lower Tolerance Limit for JIT Schedules in Checking Period 2 | NUMC | 3 | 0 | FUTO2 | ||||||||||||
| FUTO3 | Lower Tolerance Limit for JIT Schedules in Checking Period 3 | NUMC | 3 | 0 | FUTO3 | ||||||||||||
| LPRA1 | Type of Check for Forecast Delivery Schedules in Period 1 | CHAR | 1 | 0 | LPRA1 | ||||||||||||
| LPRA2 | Type of Check for Forecast Delivery Schedules in Period 2 | CHAR | 1 | 0 | LPRA2 | ||||||||||||
| LPRA3 | Type of Check for Forecast Delivery Schedules in Period 3 | CHAR | 1 | 0 | LPRA3 | ||||||||||||
| FPRA1 | Type of Check for JIT Delivery Schedules in Period 1 | CHAR | 1 | 0 | FPRA1 | ||||||||||||
| FPRA2 | Type of Check for JIT Delivery Schedules in Period 2 | CHAR | 1 | 0 | FPRA2 | ||||||||||||
| FPRA3 | Type of Check for JIT Delivery Schedules in Period 3 | CHAR | 1 | 0 | FPRA3 | ||||||||||||
| LRUEC | Backlog in FRC Delivery Schedules is Transmission-Relevant | CHAR | 1 | 0 | LRUECK | ||||||||||||
| FRUEC | Backlog in JIT Delivery Schedules is Transmission-Relevant | CHAR | 1 | 0 | FRUECK | ||||||||||||
| FAEODT | Creation Strategy for JIT Del. Sched.: Changed or Next Date | CHAR | 1 | 0 | FAEODT | ||||||||||||
| FAEN | Creation Strategy for JIT Delivery Schedule: Changed Only | CHAR | 1 | 0 | FAEN | ||||||||||||
| FDT | Creation Strategy for JIT Delivery Schedule: Next Date Only | CHAR | 1 | 0 | FDT | ||||||||||||
| FAEUDT | Creation Strategy for JIT Del. Sched.: Changed and Next Date | CHAR | 1 | 0 | FAEUDT | ||||||||||||
| FNO | JIT: No Past Dates/Times | CHAR | 1 | 0 | FNO | ||||||||||||
| LAEODT | Creation Strategy for FRC Schedule: Changed or Next Date | CHAR | 1 | 0 | LAEODT | ||||||||||||
| LAEN | Creation Strategy for Forecast Deliv. Schedule: Changed Only | CHAR | 1 | 0 | LAEN | ||||||||||||
| LDT | Creation Strategy for FRC Schedule: Next Date Only | CHAR | 1 | 0 | LDT | ||||||||||||
| LAEUDT | Creation Strategy for FRC Schedule: Changed and Next Date | CHAR | 1 | 0 | LAEUDT | ||||||||||||
| LNO | FRC: No Past Dates/Times | CHAR | 1 | 0 | LNO | ||||||||||||
| FPRHO | Checking Horizon for JIT Schedule | NUMC | 3 | 0 | FPRHO | ||||||||||||
| LPRHO | Checking Horizon for Forecast Delivery Schedule | NUMC | 3 | 0 | LPRHO | ||||||||||||
| IFAB | JIT: Internet Release | CHAR | 1 | 0 | IFAB | ||||||||||||
| ILAB | FRC: Internet Release | CHAR | 1 | 0 | ILAB | ||||||||||||
| FBEST | JIT: Acknowledgment of Internet Release by Supplier | CHAR | 1 | 0 | FBEST | ||||||||||||
| LBEST | FRC: Acknowledgment of Internet Release by Supplier | CHAR | 1 | 0 | LBEST | ||||||||||||
| LAGGR | FRC: Aggregation | CHAR | 1 | 0 | LAGGR | ||||||||||||
|
|||||||||||||||||
| FRSVZ | JIT: Bring Forward Backlog and Immediate Requirement | CHAR | 1 | 0 | FRSVZ | ||||||||||||
| LRSVZ | FRC: Bring Forward Backlog and Immediate Requirement | CHAR | 1 | 0 | LRSVZ | ||||||||||||
| FVWE | JIT: Activate Number of GRs/Deliveries Greater Than 1 | CHAR | 1 | 0 | FVWE | ||||||||||||
| LWE | FRC: Activate No. of GRs/Inbound Deliveries Greater Than 1 | CHAR | 1 | 0 | LWE | ||||||||||||
| FZWEFZ | JIT: 2nd Cumulative Received Quantity (2nd CRQ) | CHAR | 1 | 0 | FZWEFZ | ||||||||||||
| LZWEFZ | FRC: 2nd Cumulative Received Quantity (2nd CRQ) | CHAR | 1 | 0 | LZWEFZ | ||||||||||||
| FAASN | JIT: No. of Inbound Deliveries | NUMC | 1 | 0 | FAASN | ||||||||||||
| LAASN | FRC: Number of Deliveries | NUMC | 1 | 0 | LAASN | ||||||||||||
| FAWE | JIT: No. of Last Goods Receipts Against SA Release | NUMC | 1 | 0 | FAWE | ||||||||||||
| LAWE | FRC: Number of Last GRs Against SA Release | NUMC | 1 | 0 | LAWE | ||||||||||||
| FSORT1 | Sort Criterion for Last GRs/Shipping Notifications | CHAR | 30 | 0 | LGR_ASN_SORT | ||||||||||||
| LSORT1 | Sort Criterion for Last GRs/Shipping Notifications | CHAR | 30 | 0 | LGR_ASN_SORT | ||||||||||||
| FSORT2 | Sort Criterion for Last GRs/Shipping Notifications | CHAR | 30 | 0 | LGR_ASN_SORT | ||||||||||||
| LSORT2 | Sort Criterion for Last GRs/Shipping Notifications | CHAR | 30 | 0 | LGR_ASN_SORT | ||||||||||||
| FSORT3 | Sort Criterion for Last GRs/Shipping Notifications | CHAR | 30 | 0 | LGR_ASN_SORT | ||||||||||||
| LSORT3 | Sort Criterion for Last GRs/Shipping Notifications | CHAR | 30 | 0 | LGR_ASN_SORT | ||||||||||||
| FBMAIL | JIT: Workflow for Acknowledgment of Release by Vendor | CHAR | 1 | 0 | FBMAIL | ||||||||||||
| LBMAIL | FRC: Workflow in Case of Acknowledgment of Release by Vendor | CHAR | 1 | 0 | LBMAIL | ||||||||||||
| FLMAIL | JIT: Mail to Vendor on Generation of Internet Release | CHAR | 1 | 0 | FLMAIL | ||||||||||||
| LLMAIL | FRC: Mail to Vendor on Creation of an Internet Release | CHAR | 1 | 0 | LLMAIL | ||||||||||||
| FPAGE2 | Automotive Print with Smart Forms: Print More Than One Page | CHAR | 1 | 0 | FPAGE2 | ||||||||||||
| FLASTDEL | Automotive Print with Smart Forms: Print Last Deliveries | CHAR | 1 | 0 | FLASTDEL | ||||||||||||
| FCHANGES | Automotive Print with Smart Forms: Print Change Statuses | CHAR | 1 | 0 | FCHANGES | ||||||||||||
| FPACKING | Automotive Print with Smart Forms: Print Packing Info | CHAR | 1 | 0 | FPACKING | ||||||||||||
| FFOLLOWM | Automotive Print with Smart Forms: Print Follow-Up Material | CHAR | 1 | 0 | FFOLLOWM | ||||||||||||
| FSUBCON | Automotive Print with Smart Form: Print Subcontr. Components | CHAR | 1 | 0 | FSUBCON | ||||||||||||
| LSTOPPLT1 | Length of Checking Period 1 for FRC Schedules in Workdays | NUMC | 3 | 0 | LPLT1 | ||||||||||||
| LSTOPPLT2 | Length of Checking Period 2 for FRC Schedules in Workdays | NUMC | 3 | 0 | LPLT2 | ||||||||||||
| LSTOPPLT3 | Length of Checking Period 3 for FRC Schedules in Workdays | NUMC | 3 | 0 | LPLT3 | ||||||||||||
| FSTOPPLT1 | Length of Checking Period 1 for JIT Schedules in Workdays | NUMC | 3 | 0 | FPLT1 | ||||||||||||
| FSTOPPLT2 | Length of Checking Period 2 for JIT Schedules in Workdays | NUMC | 3 | 0 | FPLT2 | ||||||||||||
| FSTOPPLT3 | Length of Checking Period 3 for JIT Schedules in Workdays | NUMC | 3 | 0 | FPLT3 | ||||||||||||
| LSTOPOTO1 | Upper Tolerance Limit for Checking Period 1 | NUMC | 3 | 0 | ISA_ESCR1 | ||||||||||||
| LSTOPOTO2 | Upper Tolerance Limit for Checking Period 2 | NUMC | 3 | 0 | ISA_ESCR2 | ||||||||||||
| LSTOPOTO3 | Upper Tolerance Limit for Checking Period 3 | NUMC | 3 | 0 | ISA_ESCR3 | ||||||||||||
| FSTOPOTO1 | Upper Tolerance Limit for Checking Period 1 | NUMC | 3 | 0 | ISA_ESCR1 | ||||||||||||
| FSTOPOTO2 | Upper Tolerance Limit for Checking Period 2 | NUMC | 3 | 0 | ISA_ESCR2 | ||||||||||||
| FSTOPOTO3 | Upper Tolerance Limit for Checking Period 3 | NUMC | 3 | 0 | ISA_ESCR3 | ||||||||||||
| LSTOPUTO1 | Lower Tolerance Limit for Checking Period 1 | NUMC | 3 | 0 | ISA_ESCR4 | ||||||||||||
| LSTOPUTO2 | Lower Tolerance Limit for Checking Period 2 | NUMC | 3 | 0 | ISA_ESCR5 | ||||||||||||
| LSTOPUTO3 | Lower Tolerance Limit for Checking Period 3 | NUMC | 3 | 0 | ISA_ESCR6 | ||||||||||||
| FSTOPUTO1 | Lower Tolerance Limit for Checking Period 1 | NUMC | 3 | 0 | ISA_ESCR4 | ||||||||||||
| FSTOPUTO2 | Lower Tolerance Limit for Checking Period 2 | NUMC | 3 | 0 | ISA_ESCR5 | ||||||||||||
| FSTOPUTO3 | Lower Tolerance Limit for Checking Period 3 | NUMC | 3 | 0 | ISA_ESCR6 | ||||||||||||
| LSTOPPRA1 | Type of Check for Forecast Delivery Schedules in Period 1 | CHAR | 1 | 0 | LPRA1 | ||||||||||||
| LSTOPPRA2 | Type of Check for Forecast Delivery Schedules in Period 2 | CHAR | 1 | 0 | LPRA2 | ||||||||||||
| LSTOPPRA3 | Type of Check for Forecast Delivery Schedules in Period 3 | CHAR | 1 | 0 | LPRA3 | ||||||||||||
| FSTOPPRA1 | Type of Check for JIT Delivery Schedules in Period 1 | CHAR | 1 | 0 | FPRA1 | ||||||||||||
| FSTOPPRA2 | Type of Check for JIT Delivery Schedules in Period 2 | CHAR | 1 | 0 | FPRA2 | ||||||||||||
| FSTOPPRA3 | Type of Check for JIT Delivery Schedules in Period 3 | CHAR | 1 | 0 | FPRA3 | ||||||||||||
| FABREV | JIT Delivery Schedule: Change in Revision Level | CHAR | 1 | 0 | FABREV | ||||||||||||
| LABREV | Forecast Delivery Schedule: Change of Revision Level | CHAR | 1 | 0 | LABREV | ||||||||||||
| FANACHF | JIT Delivery Schedule: Follow-Up Material | CHAR | 1 | 0 | FANACHF | ||||||||||||
| LANACHF | Forecast Delivery Schedule: Follow-up Material | CHAR | 1 | 0 | LANACHF | ||||||||||||
| FSTOPPRHO | Checking Horizon for JIT Schedule | NUMC | 3 | 0 | FPRHO | ||||||||||||
| LSTOPPRHO | Checking Horizon for Forecast Delivery Schedule | NUMC | 3 | 0 | LPRHO | ||||||||||||