/SAPAPO/TPSRC - Contracts: External Procurement
Contracts: External Procurement information is stored in SAP table /SAPAPO/TPSRC.
It is part of development package /SAPAPO/PUR_SRC in software component SCM-BAS-MD-PUR. This development package consists of objects that can be grouped under "Sources of Supply".
It is part of development package /SAPAPO/PUR_SRC in software component SCM-BAS-MD-PUR. This development package consists of objects that can be grouped under "Sources of Supply".
Fields for table /SAPAPO/TPSRC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | /SAPAPO/MANDT | CLNT | 6 | |
| BZQID | GUID External Procurement Table | X | /SAPAPO/BZQID | CHAR | 44 | |
| LOGSY | Logical System | /SAPAPO/LOGSRCSYS | CHAR | 20 | ||
| TDSRC | Source of Supply Cat. (Contract, Sched. Agmt, Info Record) | /SAPAPO/DOC_SRC | CHAR | 2 | ||
| EBELN | Purchasing Document Number | /SAPAPO/EBELN | CHAR | 24 | ||
| EBELP | Purchasing Document Item | /SAPAPO/EBELP | NUMC | 12 | ||
| EKORG | Purchasing Organization | /SAPAPO/EKORG | CHAR | 8 | ||
| MATID | Internal Number (UID) for Product | /SAPAPO/MATID | CHAR | 44 | ||
| LOCFR | Internal Location Number for Customer, Supplier, or Plant | /SAPAPO/LOCID | CHAR | 44 | ||
| LOCTO | Internal Location Number for Customer, Supplier, or Plant | /SAPAPO/LOCID | CHAR | 44 | ||
| VALFR | Time Stamp at Start of Validity Period | /SAPAPO/SCC_VALFROMTSTMP | DEC | 8 | ||
| VALTO | Time Stamp at End of Validity Period | /SAPAPO/SCC_VALTOTSTMP | DEC | 8 | ||
| CONSI | Indicator: Consignment (0,1) | /SAPAPO/CONSI | CHAR | 2 | ||
| SUBCO | Indicator: Subcontracting (0,1) | /SAPAPO/SUBCO | CHAR | 2 | ||
| SPEC_STOCK_LOGSY | Logical System in Which Product Allocation Was Generated | /SAPAPO/CIFLOGSYSK | CHAR | 20 | ||
| SP_STK_IND | Special Stock Indicator | /SAPAPO/SOBKZ | CHAR | 2 | ||
| SPEC_STOCK | Key for Special Stock Segment | /SAPAPO/SSKEY | CHAR | 32 | ||
| ABUEB | Creation Profile for Scheduling Agreement Releases | /SAPAPO/ERPRO | CHAR | 8 | /SAPAPO/TPSRC_CP | |
| CSINT | GUID for Price Validity Interval | /SAPAPO/SNPCSINT | CHAR | 44 | /SAPAPO/SNP16 | |
| APOMS | Scheduling Agreement Processing Control | /SAPAPO/APOMS | CHAR | 2 | ||
| BZQ_ACTIVE | Procurement Relationship Active | /SAPAPO/BZQ_ACTIVE | CHAR | 2 | ||
| ADDRNUMBER | Address Number | AD_ADDRNUM | CHAR | 20 | ||
| PLIFZ | Planned Delivery Time | /SAPAPO/PWB_PLIFZ | DEC | 6 | ||
| BSTME | Order Unit (Purchasing) | /SAPAPO/BSTME | UNIT | 6 | ||
| MEINS | Base Unit of Measure | /SAPAPO/MEINS | UNIT | 6 | ||
| UMREZ | Numerator for Conversion to Base Units of Measure | /SAPAPO/UMREZ | DEC | 3 | ||
| UMREN | Denominator for conversion to base units of measure | /SAPAPO/UMREN | DEC | 3 | ||
| LCREL | Determines when LC Is Updated | /SAPAPO/LCREL | NUMC | 4 | ||
| FABKZ | Scheduling Agreement with Forecast/Planning Deliv. Schedules | /SAPAPO/FABKZ | CHAR | 2 | ||
| WEBRL | Internet Release | /SAPAPO/WEBRL | CHAR | 2 | ||
| IDNLF | Material Number Used by Vendor | /SAPAPO/IDNLF | CHAR | 80 | ||
| LGBZO | Staging Area for Warehouse Number (Unloading Zone) | /SAPAPO/LGBZO | CHAR | 20 | ||
| CFPROF | Confirmation Profile in Procurement Scheduling Agreement | /SAPAPO/CMDS_MM_CFPROF | CHAR | 8 | /SAPAPO/TPSRC_CB | |
| PROCESS | Process for Scheduling Agreements | /SAPAPO/CMDS_MM_PROCESS | CHAR | 4 | ||
| ABDAT | Reconciliation Date for Agreed Cumulative Quantity | /SAPAPO/ABDAT | DATS | 16 | ||
| ABFTZ | Agreed Cumulative Quantity | /SAPAPO/ABFTZ | QUAN | 7 | ||
| ETFZ1 | Firm Zone (Go-Ahead for Production) | /SAPAPO/ETFZ1 | DEC | 2 | ||
| ETFZ2 | Trade-Off Zone (Go-Ahead for Materials Procurement) | /SAPAPO/ETFZ2 | DEC | 2 | ||
| PLANT_DP | Plant-Dependent Source of Supply in OLTP System | /SAPAPO/PLANT_DP | CHAR | 2 | ||
| SHIP_LOCTO | Ship-To Location (GUID) | /SAPAPO/SHIP_LOCTO | CHAR | 44 | ||
| USE_PLIFZ | Indicator: "Take Planned Delivery Time Into Account" | /SAPAPO/PLIFZFLG | CHAR | 2 | ||
| VARPUOM | Variable Purchase Order Unit Active | /SAPAPO/VARPUOM | CHAR | 2 | ||
| MEASGRSUP | Unit of Measure Group | /SAPAPO/MEASGRSUP | CHAR | 8 | ||
| EKGRP | Purchasing Group | /SAPAPO/EKGRP | CHAR | 6 | ||
| PROCESS_TYPE_ICH | Process Type SAP SNC | /SAPAPO/PROCESS_TYPE_ICH | CHAR | 4 | ||
| .INCLUDE | CI_TPSRC | 0 | ||||
| SOURCE_LIST | Checkbox field | /SAPAPO/XFELD | CHAR | 2 | ||
| PRORD | Rounding Profile | /SAPAPO/RDPRO | CHAR | 20 | ||
| PROCYC | Profile of a Procurement Cycle | /SAPAPO/PROCYC | CHAR | 20 | ||
| CQ_ABFTZ_CHG | Checkbox field | /SAPAPO/XFELD | CHAR | 2 | ||
| CQ_CTRLTYPE | Control Category for Cumulative Quantities | /SAPAPO/CQ_CONTROL_TYPE | CHAR | 2 | ||
| CQ_RESRFDAT | Field is obsolete and can be replaced in table /SAPAPO/TPSRC | /SAPAPO/CQ_RESET_REF_DATE | DATS | 16 | ||
| CQ_RESPLDAT | Field is obsolete and can be replaced in /SAPAPO/TPSRC | /SAPAPO/CQ_RESET_PLAN_DATE | DATS | 16 | ||
| CQ_RESPLDAT_CHG | Field is obsolete and can be replaced | /SAPAPO/CQ_RESPLDAT_CHG | CHAR | 2 | ||
| CQ_NOCQ | Checkbox field | /SAPAPO/XFELD | CHAR | 2 | ||
| KUNNR | Customer Number of Plant | /SAPAPO/CUSTNR | CHAR | 20 | ||
| UEBTO | Tolerance Limit for Overdelivery | /SAPAPO/UEBTO | DEC | 2 | ||
| UNTTO | Tolerance Limit for Underdelivery | /SAPAPO/UNTTO | DEC | 2 | ||
| SETUP_COST | Fixed Costs | /SAPAPO/FIXCOST | DEC | 8 | ||
| .INCLUDE | FIN | /SAPAPO/TPSRC_FI | 0 | |||
| INCO1 | Incoterms (Part 1) | /SAPAPO/INCO1_PUR | CHAR | 6 | ||
| INCO2 | Incoterms (Part 2) | /SAPAPO/INCO2_PUR | CHAR | 56 | ||
| WAERS | Currency key | /SAPAPO/WAERS | CUKY | 10 | * | |
| WEBRE | Indicator: GR-Based Invoice Verification | /SAPAPO/WEBRE | CHAR | 2 | ||
| XERSY | Evaluated Receipt Settlement (ERS) | /SAPAPO/XERSY | CHAR | 2 | ||
| SKTOF | Item Does Not Qualify for Cash Discount | /SAPAPO/SKTOF | CHAR | 2 | ||
| REPOS | Invoice Receipt Indicator | /SAPAPO/REPOS_PUR | CHAR | 2 | ||
| NETPR | Net Price in Purchasing Document (in Document Currency) | /SAPAPO/NETPR | CURR | 6 | ||
| PEINH | Price Unit | /SAPAPO/PEINH_PUR | DEC | 3 | ||
| BPRME | Purchase Order Price Unit | /SAPAPO/BBPRM | UNIT | 6 | * | |
| BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | /SAPAPO/BPUMZ_PUR | DEC | 3 | ||
| BPUMN | Denominator for Conv. of Order Price Unit into Base Unit | /SAPAPO/BPUMN_PUR | DEC | 3 | ||
| LIFRE | External Number for Location (Customer, Vendor or Plant) | /SAPAPO/LOC_ALIAS | CHAR | 40 | ||
| TXJCD | Jurisdiction Code for Tax Calculation | /SAPAPO/TXJCD_PUR | CHAR | 30 | ||
| EREKZ | Final Invoice Indicator | /SAPAPO/EREKZ_PUR | CHAR | 2 | ||
| MWSKZ | Tax Code | /SAPAPO/MWSKZ | CHAR | 4 | ||
| UEBTK | Indicator: Unlimited Overdelivery Allowed | /SAPAPO/UEBTK_PUR | CHAR | 2 |