PPS_EBAN_EXT
PPS: EBAN Extensions - Table
PPS_EBAN_EXT is an SAP database table in S/4HANA. PPS: EBAN Extensions - Table. It contains 27 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PPS_PurReqnHdrExtensionBasic | view_entity | from | BASIC | PPS Fields on PR Header Basic |
| I_PPS_PurReqnItmExtensionBasic | view_entity | from | BASIC | PPS Fields on PR Item Basic |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | banfn | BANFN | Purchase Req. | |||
| KEY | bnfpo | BNFPO | Requisn. item | |||
| pps_perop_beg | PPS_E_PEROP_START_DATE | PeROP Start Date | ||||
| pps_perop_end | PPS_E_PEROP_END_DATE | PeROP End Date | ||||
| pps_config_item_no | PPS_E_CONFIG_ITEM_NO | Config. Itm. No. | ||||
| acc_asngmt_smt_num | CHAR60 | Logical System | ||||
| unfunded | BOOLEAN | Boolean Variable (X = True, - = False, Space = Unknown) | ||||
| pps_itm_cmpltn_sts | PPS_E_PR_CMPLTN_STATUS | Completion Status | ||||
| optionalitem | PPS_E_OPT_ITM | Optional Item | ||||
| exerperiodstartdate | PPS_E_OPT_EXEC_PER_START_DATE | Exe Start Date | ||||
| exerperiodenddate | PPS_E_OPT_EXEC_PER_END_DATE | Execution End Date | ||||
| pps_estimated_delivery_date | PPS_E_ESTIMATED_DELIVERY_DATE | Estimated Deliv Date | ||||
| responsible_purchaser | PPS_E_RESPONSIBLE_PURCHASER | Resp. Purchaser | ||||
| pps_itm_srcg_typ | PPS_E_PPR_SRCG_TYPE | Sourcing Type | ||||
| pps_itm_procg_status | PPS_E_PR_PROCESSING_STATUS | Processing Status | ||||
| pps_itm_approval_date | DATUM | Date | ||||
| pps_item_status | PPS_E_ITEM_STATUS | Item Status | ||||
| pps_itm_smart_number | PPS_E_SMT_SMART_NUMBER | Smart Number | ||||
| pps_itm_is_smart_number_manual | XFELD | Checkbox | ||||
| future_pstng_date | PPS_E_FUTURE_BUDAT | Future Posting Date | ||||
| pps_perop_beg_hdr | PPS_E_PEROP_START_DATE | PeROP Start Date | ||||
| pps_perop_end_hdr | PPS_E_PEROP_END_DATE | PeROP End Date | ||||
| classification | PPS_E_CLASSIFICATION | Classification | ||||
| pps_hdr_status | PPS_E_HDR_STATUS | Status | ||||
| pps_hdr_smart_number | PPS_E_SMT_SMART_NUMBER | Smart Number | ||||
| pps_hdr_is_smart_number_manual | XFELD | Checkbox |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- PPS: EBAN Extensions - Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_EBAN_EXT (
MANDT, -- Client [MANDT]
BANFN, -- Purchase Req. [BANFN]
BNFPO, -- Requisn. item [BNFPO]
PPS_PEROP_BEG, -- PeROP Start Date [PPS_E_PEROP_START_DATE]
PPS_PEROP_END, -- PeROP End Date [PPS_E_PEROP_END_DATE]
PPS_CONFIG_ITEM_NO, -- Config. Itm. No. [PPS_E_CONFIG_ITEM_NO]
ACC_ASNGMT_SMT_NUM, -- Logical System [CHAR60]
UNFUNDED, -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
PPS_ITM_CMPLTN_STS, -- Completion Status [PPS_E_PR_CMPLTN_STATUS]
OPTIONALITEM, -- Optional Item [PPS_E_OPT_ITM]
EXERPERIODSTARTDATE, -- Exe Start Date [PPS_E_OPT_EXEC_PER_START_DATE]
EXERPERIODENDDATE, -- Execution End Date [PPS_E_OPT_EXEC_PER_END_DATE]
PPS_ESTIMATED_DELIVERY_DATE, -- Estimated Deliv Date [PPS_E_ESTIMATED_DELIVERY_DATE]
RESPONSIBLE_PURCHASER, -- Resp. Purchaser [PPS_E_RESPONSIBLE_PURCHASER]
PPS_ITM_SRCG_TYP, -- Sourcing Type [PPS_E_PPR_SRCG_TYPE]
PPS_ITM_PROCG_STATUS, -- Processing Status [PPS_E_PR_PROCESSING_STATUS]
PPS_ITM_APPROVAL_DATE, -- Date [DATUM]
PPS_ITEM_STATUS, -- Item Status [PPS_E_ITEM_STATUS]
PPS_ITM_SMART_NUMBER, -- Smart Number [PPS_E_SMT_SMART_NUMBER]
PPS_ITM_IS_SMART_NUMBER_MANUAL, -- Checkbox [XFELD]
FUTURE_PSTNG_DATE, -- Future Posting Date [PPS_E_FUTURE_BUDAT]
PPS_PEROP_BEG_HDR, -- PeROP Start Date [PPS_E_PEROP_START_DATE]
PPS_PEROP_END_HDR, -- PeROP End Date [PPS_E_PEROP_END_DATE]
CLASSIFICATION, -- Classification [PPS_E_CLASSIFICATION]
PPS_HDR_STATUS, -- Status [PPS_E_HDR_STATUS]
PPS_HDR_SMART_NUMBER, -- Smart Number [PPS_E_SMT_SMART_NUMBER]
PPS_HDR_IS_SMART_NUMBER_MANUAL, -- Checkbox [XFELD]
PRIMARY KEY (MANDT, BANFN, BNFPO)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA