OIFSPBLT
Physical Business Location TypeBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel OIFSPBLT.
SAP-tabel OIFSPBLT heeft 2 primaire sleutelvelden: MANDT,PBLTYP.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
OIFSPBLT velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |
|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Sleutel PBLTYP | Business Location Type (IS-Oil MRN) | CHAR | 4 | 0 | OIF_PBLTYP | ||
| NUMRI | ID for Internal Number Range | CHAR | 2 | 0 | OIF_NUMRI | ||
| NUMRE | ID for External Number Range | CHAR | 2 | 0 | OIF_NUMRE | ||
| FLAG1 | Indicator 1 | CHAR | 1 | 0 | OIF_SFLAG1 | ||
| FLAG2 | Indicator 2 | CHAR | 1 | 0 | OIF_SFLAG2 | ||
| FLAG3 | Indicator 3 | CHAR | 1 | 0 | OIF_SFLAG3 | ||
| FLAG4 | Indicator 4 | CHAR | 1 | 0 | OIF_SFLAG4 | ||
| ERDAT | Date Record Created on (Date) | DATS | 8 | 0 | OIF_ERDAT | ||
| ERZEIT | Time Record Created at (Time) | TIMS | 6 | 0 | OIF_ERZEIT | ||
| ERNAM | User who Created Record | CHAR | 12 | 0 | OIF_ERNAM | ||
| AEDAT | Date Record Changed on (Date) | DATS | 8 | 0 | OIF_AEDAT | ||
| AEZEIT | Time when Record Was Changed | TIMS | 6 | 0 | OIF_AEZEIT | ||
| AENAM | User who Changed Record | CHAR | 12 | 0 | OIF_AENAM | ||
| FLAG_COMP | Competitor location (flag) | CHAR | 1 | 0 | OIRB_FLAG_COMP | ||
| PLANIND | Planning location flag | CHAR | 1 | 0 | OIJ_PLANIN | ||
| REFIND | OIL-TSW: Refinery indicator | CHAR | 1 | 0 | OIJ_REFIND | ||
| ODINDO | OIL-TSW: Location is origin flag | CHAR | 1 | 0 | OIJ_ODINDO | ||
| ODINDD | OIL-TSW: Location destination flag | CHAR | 1 | 0 | OIJ_ODINDD |
OIFSPBLT relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| OIFSPBLT | MANDT | T000 | Clients | MANDT |